Re: Trading only one hour in a day !!!!!
I have taken the OHLC data from the sheet provided by ravalsb's and created backtesting sheet (sharing quite a few hours of my effort here).
Here is the output for 70-30% setup.
[/URL]
[/IMG]
The system has +ive expectancy which is the very first thing we should have in any system. I have even removed top 2 best performing trades and seen that system still gives +ive result.
In layman's term, if we execute 70 trades with defined rules, then on an average we can expect to make 18 points per trade.
Limitation of this system is that I have ignored Risk mgmt rules at this stage.
By changing the values in colored cells with 70-30/ 80-20/ 90-10, you can see the change in statistical result of the strategy. Observe how number of trades, % win loss ratio, Average wins, average loss, system expectancy etc change. This gives fair idea about what to expect. I have also included a field to take care of slippage by few points. E.g. when I am placing a buy order at market open then I might not get open price..but a price which is 5 points higher then the OPEN. (I assumed that I will get worse price i.e. when buying I will get price higher then mkt price, and while selling I will price lower then mkt)
On second sheet, I have also given 1 line explanation of various output parameters. In case of doubt, please raise the point here.
Cells in blue text contains formula. This sheet can be used to testing any new system. You just need to enter the data in Entry / Stoploss/Exit columns and basic statistics will be in front of you.
(Note - if you find any error then plz let me know so that I can correct it).
Happy Backtesting and profitable trading.