Background - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
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)