How to Backtest A Trading Strategy in Excel

This video shows how anybody can test their own trading strategies using Excel. I demonstrate how to use historic price data and to calculate technical indicators. Then I show how to input the trading logic and look at the results. Read the accompanying article for more information: http://bit.ly/1ZGzKMj Full subtitles are available on this video. Click on Subtitles to view. How to Develop a Trading Strategy is the subject of my eBook, available in the Amazon Kindle Store: http://amzn.to/1OccZJE Follow me on twitter: http://bit.ly/19etSBO Facebook: http://on.fb.me/1715mCE Or Google+ http://bit.ly/1zRkAWi www.tradinformed.com

Comments

1. hi nice video ..... please make some videos on calculating real volatility ...........
2. where can i download your template?
3. Hi mark, thanks for your vid.pols if you have already mentioned it - but whats your trading timeframes with this strategy please? also you mentioned a 43 percent success rate, is there anything you would adapt to this or do you consider that sometimes manual entry and exit might be considered in waves timeframes markets?
4. Hi Mark, I'm interested in testing a non-discretionary SMA crossover stratergy in excel. Do you have a e-book/excell template that will allow me to do so?
   
   Thanks
5. Hello Mark,
   
   Great video. Was very helpful. Can you make a video on the logics for the other fields marked under the long and Short Section in the excel ?
6. where do you get your historical data? Looking for data for commodities and currencies.