1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'General Forex Talk' started by Admiral-Chief-General, Jun 2, 2016.

  1. Admiral-Chief-General

    Joined:
    Nov 21, 2012
    Messages:
    20
    Likes Received:
    5
    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.
    [​IMG]



    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: bit.ly/lottoenter
     
    FxMaster and Pharaoh like this.
  2. Pharaoh

    Pharaoh Colonel

    Joined:
    Oct 3, 2007
    Messages:
    19,679
    Likes Received:
    2,229
    Nice. I personally think it's great that it tells people their Expected Loss. That's something traders MUST keep in mind to learn proper risk management.
     
  3. mjones

    mjones Recruit

    Joined:
    May 7, 2016
    Messages:
    9
    Likes Received:
    0
    Very nice...I'll give it a try. Thanks for sharing
     
    #3 mjones, Jun 2, 2016
    Lasted edited by : Jun 3, 2016
  4. Admiral-Chief-General

    Joined:
    Nov 21, 2012
    Messages:
    20
    Likes Received:
    5
    Thanks pharoah, appreciate that.

    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 aamount, 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...
     
  5. EuroTrader

    EuroTrader Sergeant Major

    Joined:
    Aug 31, 2015
    Messages:
    1,019
    Likes Received:
    36
    Whenever we make some or the other mistakes in our trades then the amount of losses we get will keep on increasing and that will also lead us into more risks. The best thing is that a trader should know how to control them :)
     
  6. FxMaster

    FxMaster Lt. Colonel

    Joined:
    Oct 17, 2011
    Messages:
    7,464
    Likes Received:
    856
    Great Job mate :)
     
  7. tommy87

    tommy87 Recruit

    Joined:
    May 20, 2016
    Messages:
    1
    Likes Received:
    0
    Thank you sooo much!!!! needed this in my life
     
    #7 tommy87, Jun 16, 2016
    Lasted edited by : Jun 16, 2016
  8. JeremySultan1

    JeremySultan1 FiboGroup Multi

    Joined:
    Jun 25, 2016
    Messages:
    53
    Likes Received:
    3
    very very usefull information! Thanks a lot! it's really genious!!!
     
  9. bigdolly

    bigdolly Sergeant Major

    Joined:
    Oct 21, 2013
    Messages:
    802
    Likes Received:
    54
    You can also add automatic lot increment as our profit goes up (or lot reduction as our deposit shrinks after losses). If SL and TP is fixed and tight it will be quite efficient management of your positions.
     
  10. EuroTrader

    EuroTrader Sergeant Major

    Joined:
    Aug 31, 2015
    Messages:
    1,019
    Likes Received:
    36
    It is our trading that needs to be managed correctly so that we are getting a good as well as reliable income from our trading. Correct Stop loss settings will also prevent us from getting bigger losses :)
     

Share This Page