Tag Archives: Back Test

Use Excel to Backtest a Trading Strategy using an ATR Stop-loss

This post continues the series of video articles about how to use Microsoft Excel to backtest trading strategies.  In this post I show how to calculate a stop-loss using the ATR and then how to backtest the trading strategy. For the previous video articles see, An Easy Way to use Excel to Backtest a Trading Strategy – Part […]

An Easy Way to use Excel to Backtest a Trading Strategy – Part 2

Renko Capital Graph

Continuing on from the previous article about how to use excel to backtest a trading strategy. For further information about backtesting trading strategies in Excel see the next article in this series: Use Excel to Backtest a Trading Strategy using an ATR Stop-loss. Formulas Used Gross Profit =sumif(range,”>0″) Gross Loss =sumif(range,”<0″) Net Profit =sum(range) Number of […]

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

This site uses cookies, find out more: