How to Calculate and use the MACD Indicator in Microsoft Excel

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.
YouTube video

Formulas Used:

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

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.