eTrader Zone       

This page contains the formula for MACD and you can download the formula in Excel file.

Moving Average Convergence Divergence is a trend following momentum indicator, it is a relationship between two moving averages. The most common calculation is to use 26-days exponential moving average, 12-days exponential moving average and 9-days EMA of MACD

Moving Average Convergence Divergene (MACD)

Formula:

MACD = 12-Day EMA - 26-Day EMA
Signal Line = 9-Day EMA of MACD

EMA is Exponential Moving Average

Login or Register to download this Excel Spreadsheet