Hi Guys,
I've been working on an Excel spreadsheet for analysing traders performance on ZuluTrade's trade signals. On ZuluTrade you can download all of a traders historical data - to let you perform a more thorough / in depth analysis on your own. To that end, I have been working on the attached excel spreadsheet, most of the columns and calculations are pretty self explanatory. The main thing I have been working on is the optimal take profit for many traders dependant on their currency pairs traded. For traders who do basket trading, I have often isolated some of their trades for less than efficient pairs that either they or an EA does poorly on.
Then either removing those currency pairs or choosing a more optimal take profit - usually ~2 pips from the average high calculated using this excel sheet. Doing so typically has resulted in approximately 10 - 20% higher ROI for basket traders, around 5 - 15% for traders with medium diversity of currency pairs and 5 - 10% for mostly single currency pair traders. In the case of my guinea pig / trader whom I was working the data (High Profit Factor https://www.zulutrade.com/trader/22549)
when using the period of ALL I ended up with 15.9% higher ROI than with no TP or SL, as attached. Additionally, I got an average of .74 pips as opposed to .56 when left blank. On all my traders I allow their max trades at 3 and max trades per currency as 2 - to minimise over-investment in one trader and currency pair. I am hopeful that ZuluTrade implements a global maximum of traders per currency pair eventually......
Most of my valuation is average pips per hour - if it's <.1 - <.2 then I often ban that currency pair (attached). When put to all my traders you can see a fairly high rise in overall ROI, and the average pips per trade is .530 from .436 without TP, and far less trades executed.
Anyway, please have a look over the spreadsheet, let me know any reccomendations, further significant stats for consideration. We are not yet confident in what the optimal stop loss should be. Any help in this area in particular would be much appreciated.
We look forward to using this system with real money but at the moment we are just running it on a demo acct. So use it at your own risk and do your own due diligence.
Regards
n.b. If you wish to put this for another trader, simply copy column O -> CC from this spreadsheet and paste into column O into any exported trader history. I have also included the same spreadsheet calculations for the current no.1 trader, Hihoforex.
Document Downloads:
http://www.speedyshare.com/2nQmY/dow...Forum-post.zip
I've been working on an Excel spreadsheet for analysing traders performance on ZuluTrade's trade signals. On ZuluTrade you can download all of a traders historical data - to let you perform a more thorough / in depth analysis on your own. To that end, I have been working on the attached excel spreadsheet, most of the columns and calculations are pretty self explanatory. The main thing I have been working on is the optimal take profit for many traders dependant on their currency pairs traded. For traders who do basket trading, I have often isolated some of their trades for less than efficient pairs that either they or an EA does poorly on.
Then either removing those currency pairs or choosing a more optimal take profit - usually ~2 pips from the average high calculated using this excel sheet. Doing so typically has resulted in approximately 10 - 20% higher ROI for basket traders, around 5 - 15% for traders with medium diversity of currency pairs and 5 - 10% for mostly single currency pair traders. In the case of my guinea pig / trader whom I was working the data (High Profit Factor https://www.zulutrade.com/trader/22549)
when using the period of ALL I ended up with 15.9% higher ROI than with no TP or SL, as attached. Additionally, I got an average of .74 pips as opposed to .56 when left blank. On all my traders I allow their max trades at 3 and max trades per currency as 2 - to minimise over-investment in one trader and currency pair. I am hopeful that ZuluTrade implements a global maximum of traders per currency pair eventually......
Most of my valuation is average pips per hour - if it's <.1 - <.2 then I often ban that currency pair (attached). When put to all my traders you can see a fairly high rise in overall ROI, and the average pips per trade is .530 from .436 without TP, and far less trades executed.
Anyway, please have a look over the spreadsheet, let me know any reccomendations, further significant stats for consideration. We are not yet confident in what the optimal stop loss should be. Any help in this area in particular would be much appreciated.
We look forward to using this system with real money but at the moment we are just running it on a demo acct. So use it at your own risk and do your own due diligence.
Regards
n.b. If you wish to put this for another trader, simply copy column O -> CC from this spreadsheet and paste into column O into any exported trader history. I have also included the same spreadsheet calculations for the current no.1 trader, Hihoforex.
Document Downloads:
http://www.speedyshare.com/2nQmY/dow...Forum-post.zip
just saw your excel work ....pretty good pretty good!