Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
I've been backtesting my strategies on Excel and I'm trying to find a way to incorporate stop losses into all of my strategies. Is there a way to do this on Excel?
Can you help answer these questions from other members on NexusFi?
I've been using OHLC data on a daily chart. Been thinking about incorporating four hour charts as well (if that's even possible). I want to be able to do this for five years of data if possible.
I assumed you'd be using profit targets and/or adjusting your stop level intraday (trailing stop, for example). If so, you'd have the following problem:
The larger your time slice (24 hours, in your case), the less reliable your results will be. For example, imagine a daily OHLC bar consisting of the respective values: 100, 110, 90, 100. You are long. You had a stop in place at 95, and a profit target in place at 105. Problem: which hit first, the stop, or the target?
However,
If you are only utilizing and testing the stop-loss, then I don't see a problem and this is very doable in Excel with daily bars.