MACD Calculator for Excel
How to Calculate MACD in Excel
Learn how to calculate and plot MACD in Excel, and start making better trading decisions.
The Moving Average Convergence Divergence (or MACD) indicator is a powerful momentum-based trading indicator.
This article is the first of a two-part series. This part offers a step-by-step guide to calculating and charting MACD in Excel. The second part explores how market technicians use MACD to make better trading decisions.
An MACD chart consists of three elements. The first is the difference between the 12-day and 26-day exponential moving average (EMA) of the closing price; this is the MACD line. The second is the EMA of the difference; this is the signal line. The third is simply the MCAD minus the signal, and is known as the histogram.