MovingAverage Function Example | Teradata Vantage - Example: Weighted Moving Average - Teradata Vantage

This example computes the weighted moving average for the price of stock.

MovingAverage SQL Call for Weighted Moving Average

SELECT * FROM MovingAverage (
  ON company1_stock PARTITION BY name ORDER BY period
  USING
  MAvgType ('W')
  TargetColumns ('stockprice')
  WindowSize (10)
  IncludeFirst ('true')
) AS dt ORDER BY id;

MovingAverage Output for Weighted Moving Average