Background - Aster Analytics

Teradata AsterĀ® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

A weighted average has multiplying factors that give different weights to different data points. Mathematically, the moving average is the convolution of the data points with a moving average function. In technical analysis, a weighted moving average (WMA) has the specific meaning of weights that decrease arithmetically. In an n-day WMA, the most recent data point has weight n, the second most recent data point has weight (n - 1), and so on, until the weight is zero.

Where n is the number of old values to be considered for calculating the new weighted moving average:

TotalM+1 = TotalM + PM+1 - PM-n+1 NumeratorM+1 = NumeratorM + n*pM+1 - TotalM WMAVGM+1 = NumeratorM+1/(n(n+1)/2)