Exponential Moving Average

An exponential (or exponentially weighted) moving average is calculated by applying a percentage of today's closing price to yesterday's moving average value.

For example, to calculate a 9% exponential moving average of IBM: First, we would take today's closing price and multiply it by 9%. We would then add this product to the value of yesterday's moving average multiplied by 91% (100% - 9% = 91%).

Exponential Moving Average(Parameters)

1. Range. Any range of data, e.g. array of Close, Low prices, Volume, etc.
2. Output range. The cell reference for the range of output data.
3. Period. Number of values used for calculation.

Exponential Moving Average(Syntax)

ExpMvAvg(RANGE;PERIOD;DIRECTION)

Example
=ExpMvAvg(A1:A13;13;0)

Exponential Moving Averages Difference

The Exponential Moving Average Difference is the difference of two Exponential Moving Averages calculated on PERIOD1 and PERIOD2 time periods.

Exponential Moving Averages Difference(Parameters)

1. Range. Any range of data, e.g. array of Close, Low prices, Volume, etc.
2. Output range. The cell reference for the range of output data.
3. Period1. Number of values used for calculation for the first Moving Average.
4. Period2. Number of values used for calculation for the second Moving Average.