Moving Average Difference

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

Syntax:

MovAvgDiff
MovAvgDiff()
MovAvgDiff(“Period1”, ”Period2”)
MovAvgDiff(“OutPutStartCell”, “Period1”, ”Period2”)

Inputs:

'Close' column values

Parameters:

• Period1 (default=12)
• Period2 (default=26)
• OutPutStartCell (default=the next blank column in the worksheet)

Examples:

MovAvgDiff
MovAvgDiff ()
MovAvgDiff(“12”, ”26”)
MovAvgDiff(12, 26)
MovAvgDiff(“G2”, “12”, ”26”)
MovAvgDiff(G2, 12, 26)