How to Calculate a Trailing Stop Loss using Excel

Video showing how a trailing stop-loss can be calculated in excel and used to backtest a trading strategy. This type of trailing stop is called the Chandelier Exit by Chuck LeBeau and Alexander Elder. You can now purchase this and other trading spreadsheets via my website: http://wp.me/P32qmZ-OP Read the accompanying article for more information and the formulas: http://wp.me/p32qmZ-I0 My new ebook course on building backtest models in Excel is now available in the Amazon Kindle Store: http://amzn.to/15NDaw4 Follow me on twitter: https://twitter.com/Tradinformed Or Google+ https://plus.google.com/+MarkUrsell/ www.tradinformed.com

Comments

1. question, how do you calculate your gains on investment over time in this situation to know what you initial investment made overtime.?
2. This is excellent, very helpful. You move rather quickly through the logic functions, but that just means I'll have to get up to speed. Thanks for posting.
3. Using excel to build a trading strategy is difficult. Using excel to analyze a real trading strategy in futures market almost impossible. Too many data points, and excel is too slow to manage. But still,  It is a good video because not much video teach people how to use excel for testing a strategy.....