MovingAverage Function Example | Teradata Vantage - Example: Modified Moving Average - Analytics Database

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

MovingAverage SQL Call for Modified Moving Average

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

MovingAverage Output for Modified Moving Average