Hello Everybody !!
I was closely reading this thread, and in last one week I made this excel backtest.
It is based od data from my broker FXCM (extracted from Marketscope 2.0) from 2003 - until this month.
I made test for EUR/JPY, GBP/JPY, AUD/USD and EUR/USD.
The best results are for GBP/JPY. This pair produced double amount of pips comparing to any other pair. This is impressive.
Explanation of excel:
I added modification to enter long/short on yesterday high/low +/- X
X is a number. You can enter X in field F2474. New results are then calculated automatically.
Added field G2474 to enter your own STOP loss. Currently it is 50. I found that best results are with SL 40-60. New results are then calculated automatically.
Column J - go long - number of pips produced if price action broke yesterdays high +/-X
Column K - go short - number of pips produced if price action broke yesterdays low +/-X
Column M and N - copy/paste of column J and K with added STOP LOSS (you enter in field G2474)
Column R and S - just copy/paste of column M and N
TOTAL PIPS in 10 YeaRS : FIELD N2474
Below is little table with calculation of PIPS by every year 2003-2012 and by month 2009- 06.2012
Negative monthly PIPS are automatically colored in red.
Sorry, this excel is maybe confusing to you, but i have no time to make it to look tip-top.
Also, the results that I got here look very impressive.
If you have any questions, please ask.
This was hard manual work in excel, and I hope there is no mistake. So, we should have a working programmed EA to backtest this strategy and give us confirmation of this excel.
I don’t like and use Metatrader platform, so I cannot test MQ4 files some of you provided.
I see, here are some people aslo at FXCM. Does anyone of you know how to programm in LUA?? Strategies for Marketscope 2.0 platform are written in LUA.
If you have someone to program this is LUA, then I can provide all details, logic and rules.