Calculating maximum position size based on stop-loss and stop-out level

ice911

Trader
Sep 23, 2020
27
1
19
46
i think its a problem of configuration in my excel file
because when i divide 1000/105.493 (ask usdjpy) i have got the pip rice 9.47
but when i do like this 1000/$F$4 i have got 0.009479302 so i multiply by 1000 to get 9.47

0.​
 

ice911

Trader
Sep 23, 2020
27
1
19
46
hi thank you for your help
the trade i have made was the same as the formula
but is it normal that for a 2000$ trade i have a 19.8 lot size in F8
it seem to big?
 

Attachments

Enivid

Administrator
Staff member
Nov 30, 2008
15,991
803
144
Odessa
www.earnforex.com
hi thank you for your help
the trade i have made was the same as the formula
but is it normal that for a 2000$ trade i have a 19.8 lot size in F8
it seem to big?
Sorry, but to me that formula doesn't make much sense. What are you even trying to calculate there? And what are the inputs you use?
 

ice911

Trader
Sep 23, 2020
27
1
19
46
ok i think i ve found the problem
its a system setting problem
it was , and change to .
now i ve got for 2000$ E8 2.397 lot size F8
 

Enivid

Administrator
Staff member
Nov 30, 2008
15,991
803
144
Odessa
www.earnforex.com
It worked for me just by recalculating the the F8 cell without changing anything.

However, what is the point of such calculations? It appears that each trade risks the entire account to just win some minor profit.

By the way, don't forget to recalculate your H column (profit), because it is using the wrong position size. E.g., the first profit should be 109.36, not 905.35.