Weighted Moving Average Formula (Chart Controls)
The weighted moving average formula is a moving average of data that gives more weight to the more recent data in the period and less weight to the older data in the period. This formula smoothes a data series. This makes analyzing volatile data easier.
.gif "Sample plot of the weighted moving average")
Formula Details
Syntax
Chart.DataManipulator.FinancialFormula(
FinancialFormula.WeightedMovingAverage,
"Period",
"Price",
"WMA")
Parameters
This formula takes one required parameter.
- Period
Period for calculating the weighted moving average.
Input Values
This formula takes one input Y value.
- Price
Price for which the weighted moving average is calculated.
Output Value
This formula outputs two Y values.
- WMA
Weighted moving average.
Remarks
The Line chart type is a convenient chart type to display the formula output.
Example
The following example takes input from Series1's second Y value (Series1:Y2) and outputs a 20-day weighted moving average on Series2's first Y value (Series2:Y).
Chart1.DataManipulator.FinancialFormula (FinancialFormula.WeightedMovingAverage, "20", "Series1:Y2", "Series2:Y")
Chart1.DataManipulator.FinancialFormula (FinancialFormula.WeightedMovingAverage, "20", "Series1:Y2", "Series2:Y");
See Also
Reference
Exponential Moving Average Formula
Simple Moving Average Formula
Triangular Moving Average Formula
System.Windows.Forms.DataVisualization.Charting
System.Web.UI.DataVisualization.Charting