Spreadsheet Backtesting
- Thread starter kut2k2
- Start date
Nobody? 
Well maybe I can get some answers to some general questions ...
As indicated, I am using an EOD system. Assuming a next-day market entry after a buy signal is generated, should I assume the average fill will be, say, one-third of (O + H + L)? Something else?
Assuming I can enter a trailing stop at the same time I enter my buy order, should I assume the stop gets hit on average at, say, half of (stop + L)? Something else?
Is there an extra charge for updating the trailing stop on a daily basis, or is there a fixed roundtrip fee per trade?
Please advise. Thanks.
Well maybe I can get some answers to some general questions ...
As indicated, I am using an EOD system. Assuming a next-day market entry after a buy signal is generated, should I assume the average fill will be, say, one-third of (O + H + L)? Something else?
Assuming I can enter a trailing stop at the same time I enter my buy order, should I assume the stop gets hit on average at, say, half of (stop + L)? Something else?
Is there an extra charge for updating the trailing stop on a daily basis, or is there a fixed roundtrip fee per trade?
Please advise. Thanks.
It's going to be inaccurate anyway. There's something called slippage. Nobody gets filled exactly at the open, unless they have some connections. I don't. And if a market order I put in early doesn't get filled until the close, I'll be mightily pissed, as anyone should be.
Can someone else answer these questions? I'm just trying to do a reasonably realistic backtest, that's all. Thanks.
Hi, AusTrader
Thanks for your offer. I'm just trying to set up a realistic backtest on a spreadsheet. If I can enter at the open, that's great, but I didn't want to just make that assumption in my test. I have an indicator that can be used stop-and-reversal fashion but that strikes me as somewhat impractical, so I'm also trying to incorporate a trailing stop. Can you in particular answer the questions I asked about trailing stops? I may have more questions later but those are the main ones I'm concerned about now, especially the one about updating the trailing stop daily.
The problem with using EOD data is that it has been adjusted, is different from intraday day, and hence is not tradeable.
There all sorts of gap systems, yesterday's close > today's open etc that work wonderfully on daily EOD data, but fail miserably in the real world. In fact there are lots of systems that are marketed as profitable but have only been tested on EOD data. When you try them on intraday data they are terrible.
You will only get a system to work well on daily data if it is long term and hence your average trade is large. And even then you have to be careful.
There all sorts of gap systems, yesterday's close > today's open etc that work wonderfully on daily EOD data, but fail miserably in the real world. In fact there are lots of systems that are marketed as profitable but have only been tested on EOD data. When you try them on intraday data they are terrible.
You will only get a system to work well on daily data if it is long term and hence your average trade is large. And even then you have to be careful.
If you are trading NYSE, there is no slippage, you get the open no problem, and if you are exiting the close, you get the close. If you are entering on the close, SS might be a problem. (and you don't need connections to get this!) I also believe that you can trade NASDAQ stocks and get the open and closing print. (through AMEX, but have never traded amex before) As for your model, factor in an amount that will include slippage and commissions and you will have an accurate idea of how it performed historically. (Adjust your slippage based upon the liquidity of a stock)
Think for a few minutes about what you are trying to accomplish
and you might be able to get the answers yourself. It is easy enough to set up three scenarios, best case, worst case, and most likely.