Backtesting a SuperTrend Trading Strategy using Excel

This video sets out a trading strategy using the SuperTrend technical indicator. It then shows how this indicator can be calculated using Excel. Then it shows the results of the trading strategy over a long period of time and does a step through analysis of future time periods. If you would like to run this analysis yourself, you can now buy the spreadsheet that is shown in this video here: http://wp.me/P32qmZ-OP If you want to see the formulas used in this video, the accompanying article is posted: http://wp.me/p32qmZ-Fu My new ebook course on building backtest models in Excel is now available in the Amazon Kindle Store: http://amzn.to/15NDaw4 Subscribe to this channel: http://goo.gl/S3Wnrv Follow me on Social Media! Twitter: http://bit.ly/19etSBO Facebook: http://on.fb.me/1715mCE Or Google+ http://bit.ly/1zRkAWi https://www.tradinformed.com

Comments

1. Love the ebook a great place to get started for the traders who wants to back test - love to see more downloads for variances of the system. 
   Q: Mark is super trend available in the eBook - cant seem to find it?
   Q: At 7 min and 43 sec I see Max Drawdown at 38% how so, as the stop loss is set at 1% (would the stop loss not close out position at the Stop loss point of 1%?)
2. Nice video. Can we also use Solver in excel, to find the best value instead of putting in various scenarios? 
3. SIR, WILL YOU PLEASE EXPLAIN A LITTLEBIT DEEPER.THANK YOU SIR. my mail id is terrymani99@gmail.com