Tag Archives: MACD Indicator

How to Backtest a MACD Trading Strategy using Excel

Learn How to Backtest Your Trading Strategies Using Excel Do you want to improve your trading skills and profitability?  If so, one of the best ways is to learn how to test your own trading strategies. Tradinformed Backtest Models are built in an Excel spreadsheet. They are a way for anyone to test their strategies […]

How to Calculate and use the MACD Indicator in Microsoft Excel


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”,””),””)