Trading Information

How to Calculate and use the MACD Indicator in Microsoft Excel

Posted on by Mark Ursell

Last Updated on July 9, 2020 by Mark Ursell

This video article describes how you can calculate the MACD Indicator in Microsoft Excel.  I believe the MACD is a particularly useful indicator on the weekly chart and can help to create a long-term trading strategy.

Formulas Used:

EMA Factor =2/(periods+1) EMA =((current + previous average)*EMA Factor) + previous average Trade Entry =IF(L39>0,IF(L38<0,”trade”,””),””)

Other Articles You Might Like

Mark Ursell

My name is Mark Ursell, and I am an individual trader and investor. I am continually working on developing new trading strategies and improving my existing strategies. I have developed a series of Excel backtest models, and you can learn more about them on this site.

2 thoughts on “How to Calculate and use the MACD Indicator in Microsoft Excel”

  1. Igor says:

    Dear Mark,
    is it please possible to download your examples in excel?
    Thank you and best regards
    Igor

    • Tradinformed says:

      Hi Igor, I haven’t got the spreadsheets available for download yet. But there is no reason why I can’t do this. I will give it some thought and post them in a useful form. I am also working on a course on excel for traders which I will let people know about when it is ready.

Comments are closed.