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

ice911

Trader
Sep 23, 2020
32
1
24
47
ok ive got it
this is the formula
=E9*$G$1/(100000*$J$1+(1000/$F$4)*1000*$M$2*$G$1) and the result is 2.089
 

Attachments

  • usdjpy forex fury table.xls
    45.5 KB · Views: 2

ice911

Trader
Sep 23, 2020
32
1
24
47
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
32
1
24
47
hi have change the setting of my excel
now it works
the formula is
=E9*$G$1/(100000*$J$1+(1000/$F$4)*$M$2*$G$1)
 

Attachments

  • usdjpy forex fury table.xls
    73.5 KB · Views: 2
  • 👍
Reactions: Enivid

ice911

Trader
Sep 23, 2020
32
1
24
47
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

  • Classeur2.xls
    64.5 KB · Views: 2

Enivid

Administrator
Staff member
Nov 30, 2008
16,844
984
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
32
1
24
47
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
16,844
984
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.
 

ice911

Trader
Sep 23, 2020
32
1
24
47
hi
your formula work great
can you add sheet for gbpusd audusd nzdusd

thanks a lot
 

Attachments

  • Classeur2.xls
    69 KB · Views: 2