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

This example computes an exponential moving average for the price of stock.

MovingAverage SQL Call for Exponential Moving Average

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

MovingAverage Output for Exponential Moving Average