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

Syntax:

ExpMovAvg
ExpMovAvg()
ExpMovAvg(“Period”)
ExpMovAvg(“OutPutStartCell”,”Period”)

Inputs:

'Close' column values

Parameters:

• Period (default=14)
• OutPutStartCell (default=the next blank column in the worksheet)

Examples:

ExpMovAvg
ExpMovAvg()
ExpMovAvg(“14”)
ExpMovAvg(14)
ExpMovAvg(“G2”,”14”)
ExpMovAvg(“G2”, 14)
ExpMovAvg(G2,”14”)
ExpMovAvg(G2, 14)