You can get historical stock quotes using this bulk stock data downloader spreadsheet.įor the worked example below, we use daily close prices for Apple (ticker: AAPL) from 19 th Feb 2013 to 22 nd May 2013 dates are in Column A and prices in Column C. Step 1: Get historical daily close prices You can download the complete spreadsheet at the bottom of this article. In the following step-by-step guide, we’ll calculate the MACD of Apple, giving you all the tools you need to recreate the chart above. Other nuances will be explored in the next article in this series.ĭeveloped by Gerald Appel in the 1970s, MACD is now widely used by traders to generate forecast price trends, and generate buy and sell signals. when the histogram goes from positive negative). A sell signal, however, is generated when a falling MACD crosses over the signal line (i.e. when the histogram goes from negative to positive).

The chart below, for example, is the MACD and signal line for Apple between two dates.Ī buy signal is generated when a rising MACD crosses over the the signal line (i.e. The third is simply the MCAD minus the signal, and is known as the histogram. The second is the EMA of the difference this is the signal line. 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 part explores how market technicians use MACD to make better trading decisions.Īn MACD chart consists of three elements. This part offers a step-by-step guide to calculating and charting MACD in Excel. This article is the first of a two-part series. The Moving Average Convergence Divergence (or MACD) indicator is a powerful momentum-based trading indicator. Learn how to calculate and plot MACD in Excel, and start making better trading decisions.

How to plot a graph in excel mac