Simple Lot Size Calculator using Excel (Only 3 Inputs!)

Hi traders,

Finally, something I can contribute. I took some time off trading and prepared this, when in actual fact, this should be one of the first things I focused on.

Follow the steps:
First, enter your equity.
Second, enter the percentage you are willing to risk.
Lastly, enter the number of pips you are willing to hold the trade.

Please refer to the picture attached.


The blue boxes will automatically calculated.
You only need to enter inputs in the yellow boxes.

Please inform me if anything is amiss.

Once traders know the potential loss amount, and be comfortable with it. Then they can stretch how many pips it would take to reach that lost amount, understanding their risk better and more confident on taking the loss or even set a hard stop loss.

I am sure this is available before I created it.. But just didn't seem to find it...

i've tried this, not as user friendly and direct as I want. It's too much info.

but i appreciate the post. thank you.

Thanks,

This too might help in case your interested in on chart position sizing http://www.forexfactory.com/showthread.php?t=281772

please i want to Download LOT CALCULATOR APPS. PLEASE HELP ME WITH THIS....

Thank you for the calculated example. You're a good man if you do it and share with us your knowledge. I have alredy download. Thank you!

Thank you very much, this helps a LOT! Great Job!