ExponentialMovAvg Example - Teradata Vantage

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

Input

The input table is company1_stock, as in the CumulativeMovAvg Example.

SQL Call

SELECT * FROM ExponentialMovAvg (
  ON company1_stock PARTITION BY name ORDER BY period
  USING
  TargetColumns ('stockprice')
  StartRows (10)
  IncludeFirst ('true')
) AS dt ORDER BY period;

Output