MACD Indicator

The Moving Average Convergence/Divergence indicator (MACD) 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).

MACD Indicator(Parameters)

1. Range. Any range of data, e.g. array of Close, Low prices, Volume, etc.
2. Output range. The cell reference for the range of output data.