stevehopwoodforex.com
https://www.stevehopwoodforex.com/phpBB3/
Print view

Trend Trading EA with Automated Loss Recovery
https://www.stevehopwoodforex.com/phpBB3/viewtopic.php?t=3719
Page 7 of 14
Author:  SpiderX [ Thu Jul 17, 2014 10:29 pm ]
Post subject:  Trend Trading EA with Automated Loss Recovery

Dewey McG » Fri Jul 18, 2014 6:14 am wrote:
Sorry to take so long--schedule has been crazy. The trade logic seems fine--it's the lot sizes. The calculations are a tad off, so the additional ALR trades are slightly smaller than they should be
Can you check that this matches lot calculation in spread sheet 2.2 with your set ?

Cheers
Author:  Dewey McG [ Fri Jul 18, 2014 12:38 am ]
Post subject:  Trend Trading EA with Automated Loss Recovery

SpiderX » Thu Jul 17, 2014 6:29 pm wrote:
Dewey McG » Fri Jul 18, 2014 6:14 am wrote:
Sorry to take so long--schedule has been crazy. The trade logic seems fine--it's the lot sizes. The calculations are a tad off, so the additional ALR trades are slightly smaller than they should be
Can you check that this matches lot calculation in spread sheet 2.2 with your set ?

Cheers
2.2--which I don't understand because the settings are different than mine, has a series of .1, .14, .1. .14... If the EA matched that it would be .25, .35, .25... Instead it was .25, .34, .21
Author:  SpiderX [ Fri Jul 18, 2014 12:49 am ]
Post subject:  Trend Trading EA with Automated Loss Recovery

Dewey McG » Fri Jul 18, 2014 8:38 am wrote:
2.2--which I don't understand because the settings are different than mine, has a series of .1, .14, .1. .14... If the EA matched that it would be .25, .35, .25... Instead it was .25, .34, .21
Hi Dewey,

Can you check the following spreadsheet ?
http://www.stevehopwoodforex.com/phpBB3 ... =50#p95946

Input your settings in, the lot sizes taken by the EA should be the same as the ones in the new spreadsheet, which adjusts for Min Lot.
If the lot sizes are different from the spreadsheet, then it is an EA calculation mistake.

If lot sizes are same, then the next things to check:
-are orders filled exactly at the entryprices and sl, tp or is there a small difference ?

if the orders are filled exactly, then the final possibility...
-are the formulas in the spreadsheet correct ?

Cheers
Author:  Dewey McG [ Fri Jul 18, 2014 2:26 am ]
Post subject:  Trend Trading EA with Automated Loss Recovery

SpiderX » Thu Jul 17, 2014 8:49 pm wrote:
Hi Dewey,

Can you check the following spreadsheet ?
http://www.stevehopwoodforex.com/phpBB3 ... =50#p95946

Input your settings in, the lot sizes taken by the EA should be the same as the ones in the new spreadsheet, which adjusts for Min Lot.
If the lot sizes are different from the spreadsheet, then it is an EA calculation mistake.

If lot sizes are same, then the next things to check:
-are orders filled exactly at the entryprices and sl, tp or is there a small difference ?

if the orders are filled exactly, then the final possibility...
-are the formulas in the spreadsheet correct ?

Cheers
OK, this is going to take a while--will be the weekend probably before I have an answer
Author:  SpiderX [ Fri Jul 18, 2014 2:28 am ]
Post subject:  Trend Trading EA with Automated Loss Recovery

Hi Dewey,

Got the answer after looking again.

For first 2 orders
buyprice: 190.368 close: 188.368 pips:-200 lot:(0.25) pipx lot: -50
sellprice: 189.868 close: 188.426 pips:144.2 lot:(0.34) pipx lot: 49.028

Overall: -0.972 pip.lot

Second order didnt close at the tp.

If it closed at tp:

pips:-200 lot:(0.25) pipxlot: -50
pips:150 lot:(0.34) pipxlot: 51

Overall : +1 pip.lot

Calculation should be correct.
Issue is that recovery trades did not close at tp, maybe that is something that has to be accounted for.

Cheers
Author:  Dewey McG [ Fri Jul 18, 2014 2:34 am ]
Post subject:  Trend Trading EA with Automated Loss Recovery

I am seeing that your version of the calculator does not match up with mine. The inputs are the same but the numbers for lot sizes are not
Author:  SpiderX [ Fri Jul 18, 2014 2:37 am ]
Post subject:  Trend Trading EA with Automated Loss Recovery

Dewey McG » Fri Jul 18, 2014 10:34 am wrote:I am seeing that your version of the calculator does not match up with mine. The inputs are the same but the numbers for lot sizes are not

Hi Dewey,

Maybe you can counter check the formula...but i account for min lot step, which is more realistic...because EA cant take odd lots.
As a result, all the lot sizes are different.
The change to your excel code was only to step up the size to the next lot step.
It was a simple change in the formula. you can verify if any mistake was made in my spreadsheet with regards to this.

cheers
Author:  Dewey McG [ Fri Jul 18, 2014 2:40 am ]
Post subject:  Trend Trading EA with Automated Loss Recovery

SpiderX » Thu Jul 17, 2014 10:37 pm wrote:
Hi Dewey,

Maybe you can counter check the formula...but i account for min lot step, which is more realistic...because EA cant take odd lots.
As a result, all the lot sizes are different.
The change to your excel code was only to step up the size to the next lot step.
It was a simple change in the formula. you can verify if any mistake was made in my spreadsheet with regards to this.

cheers
I will--but that is the time consuming chart. Need to head to bed now, but will look over this over the next couple days unless it hits me very quickly--which I suspect it won't
Author:  SpiderX [ Fri Jul 18, 2014 2:43 am ]
Post subject:  Trend Trading EA with Automated Loss Recovery

Dewey McG » Fri Jul 18, 2014 10:40 am wrote:
I will--but that is the time consuming chart. Need to head to bed now, but will look over this over the next couple days unless it hits me very quickly--which I suspect it won't
Actually you can try the changes for yourself...all i added was a CEILING( xxxxxx , MIN_LOTSTEP) to each lot size in the sheet.
That is all.
For Target profit, we may need to convert it a Pip Profit per lot to rectify the issue that we see above, so we give a buffer for some slippage and trade being closed away from tp.
My opinion is that lot sizes are calculated correct, issue is due to trade not being closed at tp.

Cheers
Author:  Dewey McG [ Fri Jul 18, 2014 9:50 am ]
Post subject:  Trend Trading EA with Automated Loss Recovery

SpiderX » Thu Jul 17, 2014 10:43 pm wrote:
Actually you can try the changes for yourself...all i added was a CEILING( xxxxxx , MIN_LOTSTEP) to each lot size in the sheet.
That is all.
For Target profit, we may need to convert it a Pip Profit per lot to rectify the issue that we see above, so we give a buffer for some slippage and trade being closed away from tp.
My opinion is that lot sizes are calculated correct, issue is due to trade not being closed at tp.

Cheers
Can you explain exactly what the CEILING function does?

Thanks
All times are UTC Page 7 of 14