How to Calculate MACD in Excel


MACD, short for moving average convergence/divergence, is a trading indicator used in technical analysis of stock prices, created by Gerald Appel in the late s.

Chartists looking for less sensitivity may consider lengthening the moving averages. Follow the 3 simple steps highlighted in yellow to run your first scan. A bearish centerline crossover occurs when the MACD moves below the zero line to turn negative. Volatility in the underlying security can also increase the number of crossovers. The reason was the lack of the modern trading platforms which show the changing prices every moment.


Signal line crossovers are the most common MACD signals. The signal line is a 9-day EMA of the MACD Line. As a moving average of the indicator, it trails the MACD and makes it easier to spot MACD turns.

An example of a price filter would be to buy if the MACD line breaks above the signal line and then remains above it for three days.

As with any filtering strategy, this reduces the probability of false signals but increases the frequency of missed profit. A MACD crossover of the signal line indicates that the direction of the acceleration is changing. The MACD line crossing zero suggests that the average velocity is changing direction.

From Wikipedia, the free encyclopedia. This article includes a list of references , but its sources remain unclear because it has insufficient inline citations. Please help to improve this article by introducing more precise citations. December Learn how and when to remove this template message.

This section is empty. You can help by adding to it. Financial Times Prentice Hall. Own Mountain Trading Company.

Retrieved 29 June Technical Analysis of the Financial Markets. Breakout Dead cat bounce Dow theory Elliott wave principle Market trend. Hikkake pattern Morning star Three black crows Three white soldiers. Average directional index A. Coppock curve Ulcer index. Retrieved from " https: Articles lacking in-text citations from December All articles lacking in-text citations Articles to be expanded from June All articles to be expanded Articles with empty sections from June All articles with empty sections Articles using small message boxes.

Views Read Edit View history. This page was last edited on 1 November , at By using this site, you agree to the Terms of Use and Privacy Policy.

You now have all the data you need! I also referenced your other work to get real time price data My application is forex constantly updated. Hi Samir, many thanks for this excellent spreadsheet. Please tell me how to use the chart function in Excel to make my chart look like the one in this article. When I open your tutorial the numbers all look like they are supposed to but when I type in the formula or even cut and paste the numbers all become identical.

I looked at the calculations in the cells and they are the same as you had in the tutorial sheet. What could I be doing wrong? I tried using the same spreadsheet against live closing price data. On comparing the final values of MACD and Signal the results are different when computed by yahoo finance or morning star http: This spreadsheet and Yahoo are different.

Hello Samir thank you for sharing the information. I have two questions i guess. Sy Harding tweaked this system even further by anticipating the six-month cycle. While chartists do not really know when a MACD signal will trigger, we can figure out when the six-month cycle will trigger.

It is, after all, like clockwork. Knowing that the six-month cycle will turn bearish in May, traders can use the whole month of April to anticipate a sell signal in MACD.

Similarly, traders can use the whole month of October to anticipate a buy signal. This requires a lot more discretion and intuition though. Taking a signal in April or October seems acceptable, but what about signals in late March or late September? SPY bottomed in early July and formed a higher low in August. These signals were well before the bullish six-month cycle started, but traders would have faced an overbought market if they had waited until October.

Chartists can also consider using weekly charts and weekly MACD. However, only the signal line crossovers would work because the centerline crosses are too infrequent. There were some good signals, some bad signals, and some non-signals.