A Simple Way to Optimise a Trading Strategy using Excel

This video demonstrates how to easily optimise a trading strategy by testing a number of variables. Once we have built a backtest model we can then get excel to quickly test a number of different scenarios and then present a convenient summary of the results. The spreadsheet tests a MACD trading strategy using weekly historical data of the S&P 500. My new ebook course on building backtest models in Excel is now available in the Amazon Kindle Store: http://amzn.to/15NDaw4 See the full article for tips on optimisation best practice: http://wp.me/p32qmZ-xA Follow me on twitter: https://twitter.com/Tradinformed www.tradinformed.com

Comments

1. I use excel for a lot of calculations to do with my trading, such as backtesting strategies, keeping accounts and storing data. If you see my website I use MT4 for trading currencies and I also use spreadbetting sites to trade stocks and indices.
2. Hi mark, Do you use Excel to do your trading? thanks~