Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Spreadsheet for tracking bets

  • 18-10-2011 10:23pm
    #1
    [Deleted User]
    Posts: 0 ✭


    Has anyone done a spreadsheet in Excel for tracking your bets. Just something not too complicated, like the bet, odds, stake, result, p/l...etc. Would be handy for discipline. Looked on google but all American ones that are very complicated!


Comments

  • #2
    [Deleted User]
    Posts: 0 ✭ [Deleted User]


    Sorry, dunno why that cross face is in the title!


  • #3
    seklly
    Registered Users, Registered Users 2 Posts: 773 ✭✭✭seklly


    I've made an Excel spreadsheet for tracking bets. It should (hopefully) be self-explanatory but i'll give you a few pointers for if you try it.

    Firstly, all white fields are user defined and used in calculations. Begin by entering your 'Start Bank'. Then for each bet enter your 'Back Odds' and 'Certainty', this will calculate your 'Stake' and potential 'Profit'. there's also a 'Comm%' column to enter your commision percentage for the bet (useful for Betfair)

    Certainty is a percentage and it's recommended to keep this low for good bankroll management i.e. 1 = 1 point and 10 = 10 points.

    I've also set it to up the stakes every time you increase your bankroll by your starting bank.
    e.g. if you start with a bank of €100, 5 point bets are €5. Then if (when!) your bank increases above €200, 5 point bets will now be €10 etc.

    There's a column labelled 'R' which stands for result. When the bet is settled you need to either put a 'W' or 'L' in there, obviously for a win or a loss! There are also condions in there so you'll get green for wins and red for losses so hopefully you'll see lots of green!!

    I've filled out 14 fake bets to show how it works. To start from scratch just delete the entries in the 'R' column. this is getting pretty long-winded so here's a link: Spreadsheet

    I haven't tested it fully so if you get any mistakes or need help let me know. Anyone that wants can give it a try. Let me know how you get on or if it's useful.


Advertisement