Hello,
I'd like to know if someone can help me with a very basic formula, Excel or just the explanation so I can make it in Excel.
I use http://www.babypips.com/tools/forex-...sitionsize.php but I'd like to have this in Excel.
Here's my situation:
I'd like to risk 2% of my account, so if my stop loss gets hit, I only lose 2%
For each trade I have a number of pips I set for my SL.
For example, I have this scenario:
- I have $1000
- I'd like to risk 2%
- My SL is of 30 pips.
What would be the lot size (or units, I use Oanda) that I must use?
What I'm looking for is an Excel sheet in which I type the money I have, the risk I'd like and the SL in pips, and it gives me the size I must risk.
I see http://www.forexfactory.com/showthre...67#post1803967 but I'd like something simpler, that one I didn't understand.
Thanks in advance.
I'd like to know if someone can help me with a very basic formula, Excel or just the explanation so I can make it in Excel.
I use http://www.babypips.com/tools/forex-...sitionsize.php but I'd like to have this in Excel.
Here's my situation:
I'd like to risk 2% of my account, so if my stop loss gets hit, I only lose 2%
For each trade I have a number of pips I set for my SL.
For example, I have this scenario:
- I have $1000
- I'd like to risk 2%
- My SL is of 30 pips.
What would be the lot size (or units, I use Oanda) that I must use?
What I'm looking for is an Excel sheet in which I type the money I have, the risk I'd like and the SL in pips, and it gives me the size I must risk.
I see http://www.forexfactory.com/showthre...67#post1803967 but I'd like something simpler, that one I didn't understand.
Thanks in advance.
Hard work and patience.