Tag Archives: MACD Indicator

Trading Strategies

How to Backtest a MACD Trading Strategy using Excel

Posted on by Mark Ursell
01
Jul

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 […]

Continue reading →
Trading Information

How to Calculate and use the MACD Indicator in Microsoft Excel

Posted on by Mark Ursell
MACD on the EURUSD
27
Jun

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

Continue reading →