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.