Linear Weighted Moving Average

A weighted moving average is also designed to put more weight on recent data and less weight on past data. A weighted moving average is calculated by multiplying each of the previous day's data by a weight. The following table shows how a 5-day weighted moving average iscalculated.

Day No.	Weight	* Price	= Weighted Price
1	1	25	25
2	2	26	52
3	3	28	84
4	4	25	100
5	5	29	145
Totals	15	133	= 27.067

Note how the 5-day weighted moving average gives five times more weight to today's price (i.e., 5*29) than to the price five days ago (i.e., 1*25).

Syntax:

LinearWeightedMovAvg
LinearWeightedMovAvg()
LinearWeightedMovAvg(“Period”)
LinearWeightedMovAvg(“OutPutStartCell”,”Period”)

Inputs:

'Close' column values

Parameters:

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

Examples:

LinearWeightedMovAvg
LinearWeightedMovAvg()
LinearWeightedMovAvg(“14”)
LinearWeightedMovAvg(14)
LinearWeightedMovAvg(“G2”,”14”)
LinearWeightedMovAvg(“G2”, 14)
LinearWeightedMovAvg(G2,”14”)
LinearWeightedMovAvg(G2, 14)