MACD

The MACD (Moving Average Convergence/Divergence indicator) is calculated by subtracting the value of a 0.075 (26-period) exponential moving average from a 0.15 (12-period) exponential moving average.

Most analysts say that the MACD indicator is "the difference between 12-day and 26-day exponential moving averages." However, the indicator is really the difference between 0.15 and 0.075 exponential moving averages (whereas, when expressed in decimal form, the 12- and 26-day exponential moving averages are actually 0.153846 and 0.076923 exponential moving averages).

Syntax:

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

Inputs:

'Close' column values

Parameters:

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

Examples:

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