No announcement yet.

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

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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. Download link:

  • #2

    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...


    • #3
      There is the same thing at just click on the link below