Disliked
it is not what i was asking for but thank you anyways.
No problem. I thought I read you knew how to use excel, so you need this number. Okay then.
To determine price per lot, I use:
=ROUNDDOWN(((C324*D324*1000)+4),2)
C is the formula I gave you.
D is the percent margin required to open a position
+4 is my catastrophic stop loss = 40 pips
,2 is my decimals
Then to find the lot size, I use:
=ROUNDDOWN(((B324/((C324*D324*1000)+4))/100),2)
B is your account.
This is configured in micro lots, so just alter the 1000 or 100 if you need too. The number 324 just represents Dec 8.
For example
Column A is date 12/8/2016
Column B is account size $50,000
Column C is ='MT4'|BID!EURUSD
Column D is margin percent of 2
Column E is =ROUNDDOWN(((B324/((C310*D324*1000)+4))/100),2)
this is number of lots you can trade
Column F is =ROUNDDOWN(((C324*D324*1000)+4),2)
this is cost of each micro lot with stop loss included
AAAAAAAA BBBBBB CCCC D EEEEE FFFF
12/8/2016 $50,000 1.061 2 19.83 25.21
You can name the columns A-F whatever you want. Ignore how I had to write these things. For some reason the editor won't let me make columns.
I do not have a margin call, so if you do, then you will need to divide the percentage from your account in your calculation, so you are only counting the money available for trading.
You cannot be extraordinary by being normal