Results 1 to 9 of 9
  1. #1
    Rookie Member

    My Risk/Money Management Spreadsheet !!!

    Hey there to all fellow traders!

    So for the last 2 months, I have been going through the school on Binary Options, I have opened a Demo account, I have also done some paper trades using the data from a BO Broker which I am most likely to deposit with (ranked near the top by our BOTS Pros) and I have been playing around with a risk/money management spreadsheet. I have just recently finished my final exams for my BA Accountancy degree, hence the love for spreadsheets haha, and I am now looking forward to my long summer of learning and absorbing knowledge about the trading world. What am I looking for here? Well, after spending hours and hours creating nested IF statements, balancing formula and adjusting my risk etc I have created a spreadsheet for my daily trading. I have attached a screenshot of it below and I would appreciate any comments regarding the set up or things which I have not taken into account which are important.

    The green area is where I place my trade information ie. trade value (D3-M3), ITM/OTM(D4-M4), and the brokers win % or refund % (D5-M5) depending on whether its ITM/OTM

    I have two rows below the data entry which determines whether I should continue trading or not based on my winning percentage for that day:
    The 'Bets on/off' row shows bright red and says 'leka dux (Afrikaans for 'sleep tight') when wins are less than 65% as shown on Tuesday (G14)
    This row also shows numbers when I have an open trade(G9-I9)- these numbers are the percentage of my balance which is in an open trade- Under the Advised Trade column (N9) it will show up red when I attempt to place a new trade which exceeds my 2% open trades policy.
    These rows will show 'no trade' where no trade has been entered into.

    The 80 Plus row (D10-M10) tells me whether I am above or below 80% win ratio and therefore shows me 'bets on' for above 80% or 'Mooi Kyk' (Afrikaans for look carefully) when it is below

    I have set my max risk at 2%, that includes where more than 1 trade has been entered (monetary value shown on the top right under Advised Trade-N3)
    I have set my max daily profits at 5% (Also in Advised trade column-N2) It shows "target met" when daily profit= 5% of opening balance is reached as it does on Wednesday(N20)

    I will obviously use my own discretion when to stop trading, I dont have to wait for the 'Target Met' or 'Leka Dux' alerts, these are just to show a red alert I suppose. I also usually allow myself at least 2 trades a day before strictly obeying the red flags because if I lose my first trade everyday I wont make any money.

    I hope I have described the spreadsheet as simply as possible and I will welcome any questions or advice with an open mind. And hopefully I have posted in the correct forum. I have now also attached the spreadsheet, below the picture so people can play around with it.

    Click image for larger version. 

Views:	145 
Size:	108.4 KB 
ID:	1643
    Last edited by Shroomz90; 05-12-2014 at 08:53 PM.

  2. #2
    Active Member supertrader's Avatar
    Hei mate,

    That is impressive work. Congratulation for it and thanks for sharing your file with us! I will try to adapt your spreadsheet and check my trading results with it too. I am sure with such an instrument the results will improve dramatically. It allow real time performance checking which is of crucial importance for every trader! Wish you a lot of success and keep presenting your work here. We all greatly appreciate it

  3. #3
    Rookie Member
    Hey Super,

    Thanks very much! It took plenty of time and hard work and probably still requires a few tweeks but overall I am quite happy with it. Let me know how you get on with using it in your trading and if you have any questions about the formula's don't hesitate to ask.

  4. #4
    Specialist Member pinoyoptions's Avatar
    Nice work on excel data keep it up mate, that's a good start of trading seriously.

  5. #5
    Junior Member Ahmad's Avatar
    Great! i would try to play around with this.

    is there anyone would like to share theirs spreadsheet?

  6. #6
    Moderator Kolyo's Avatar
    That is fantastic. Exactly what we need to do in order to greatly improve and test our results! You have done amazing job and I wish you to move even further and become profitable soon!
    "The goal of a successful trader is to make the best trades. Money is secondary." - Alexander Elder

  7. #7
    Junior Member smoki's Avatar
    Congratulations! Must not have been easy revision of the paper
    Will try it

  8. #8
    Junior Member NerdRN's Avatar
    Great to have a plan and stick to it - takes emotion and greed/desperation out of the picture.


  9. #9
    Legendry Member Michael Hodges's Avatar
    Quote Originally Posted by NerdRN View Post
    Great to have a plan and stick to it - takes emotion and greed/desperation out of the picture.

    it really does, it helps you relax and enjoy the mechanics of trading without pressure.

  10. Thanks adj009 thanked this post

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts