Export (0) Print
Expand All

Moving Averages

This section lists the moving average formulas.

In This Section

Exponential Moving Average Formula (Chart Controls)
A moving average that gives more weight to the more recent data in the period and less weight to the older data in the period. This formula produces a moving average that follows the market trend much more quickly than the Weighted Moving Average Formula.

Simple Moving Average Formula (Chart Controls)
Takes the average of data over a period of time, and migrates the period across the data series one data point at a time. This formula smoothes a data series and makes analyzing volatile data easier.

Triangular Moving Average Formula (Chart Controls)
Takes a simple moving average of data and applies a simple moving average on the first moving average. It is a lagging indicator, and is always behind the price. The triangular moving average gives the most weight to the middle portion of the data.

Triple Exponential Moving Average Formula (Chart Controls)
Useful for eliminating short and insignificant cycles in the data. It smoothes the data three times using the Exponential Moving Average Formula, and then calculates the rate of change in the moving average based on the result for the previous day.

Weighted Moving Average Formula (Chart Controls)
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.

See Also




Build Date:

2012-08-02
Show:
© 2014 Microsoft