Exponential Moving Average Factor

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%).

Syntax:

ExpMovAvgFactor
ExpMovAvgFactor()
ExpMovAvgFactor(“Factor”)
ExpMovAvgFactor(“OutPutStartCell”, ”Factor”)

Inputs:

'Close' column values

Parameters:

• Factor (default=0.15)
• OutPutStartCell (default=the next blank column in the worksheet)

Examples:

ExpMovAvgFactor
ExpMovAvgFactor()
ExpMovAvgFactor(“0.15”)
ExpMovAvgFactor(0.15)
ExpMovAvgFactor(“G2”,”0.15”)
ExpMovAvgFactor(“G2”, 0.15)
ExpMovAvgFactor(G2,”0.15”)
ExpMovAvgFactor(G2, 0.15)