Moving Average

A moving average is a method of calculating the average value of a security's price, or indicator, over a period of time. The term "moving" implies, and rightly so, that the average changes or moves. When calculating a moving average, a mathematical analysis of the security's average value over a predetermined time period is made. As the security's price changes over time, its average price moves up or down.

BulkQuotesXL Pro calculates three different types of moving averages: simple (also referred to as arithmetic), exponential and weighted.

The only significant difference between the various types of moving averages is the weight assigned to the most recent data. Simple moving averages apply equal weight to the prices. Exponential and weighted averages apply more weight to recent prices. Triangular averages apply more weight to prices in the middle of the time period. And variable moving averages change the weighting based on the volatility of prices.

Syntax:

MovAvg
MovAvg()
MovAvg(“Period”)
MovAvg(“OutPutStartCell”,”Period”)

Inputs:

'Close' column values

Parameters:

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

Examples:

MovAvg
MovAvg()
MovAvg(“14”)
MovAvg(14)
MovAvg(“G2”,”14”)
MovAvg(“G2”, 14)
MovAvg(G2,”14”)
MovAvg(G2, 14)