Free Sports Betting and Trading Spreadsheet

I recommend that you use my Trading Spreadsheet to Calculate your Stakes, and keep track of all your bets.  It is essential to maintain control and discipline over your betting and trading.  This way you can see which systems work for you, and which don't, you can see where your money is tied up waiting for events to take place or be settled.  Click to email me and I will send you a free copy  Below the different worksheets in the Free Spreadsheet are explained.  This is all real data from bets I have placed.  The spreadsheet can be used for Trading, Betting and Arbitraging, and also for keeping track of system performance.  Use it wisely to keep track of all your Sports Betting Numbers.

BET TRACKER

This workbook contains your list of current and recent bets, and your balance with each of your books.  I couldn't keep track of my days betting without it.  After each bet is placed I enter the details in the 'current bets' area, listing both books (if it's an arb), selection at each book, expected profit and kick-off time.  Once the event is finished I will change the kick-off time to 'done' to denote the bet is settled.

At the end of the days betting I will then settle up all my accounts.  I use Microsoft Money, with each book set up as a current account, then I enter the total profit/loss for the day at that book into the account for that book, you can also use this to keep track of transfers to/from your actual bank account and  

Moving down the worksheet is the area listing my current available funds with each book, this can quite often be very little or even zero if there are a number of unsettled bets with that book.  Money management is one of the skills of betting and trading, and you need to know where all your money is at any given time.  If you build up a large pot in one book, and another is running down, this is the time to transfer funds from one book to another, either via your bank account or Moneybookers.  This is one of the advantages of Moneybookers, in that it can make these transfers within hours, if you already have funds in Moneybookers, then you can move that to another book in minutes, so I normally maintain some funds at Moneybookers.

FORMULAS

This is a crucial part of the spreadsheet.  Here you calculate your stakes for all your arbs and trading bets.

Regular 2-way bets

This part of the worksheet is the basic one used for calculating arbs between two books.  It's simple to use, enter the odds at each book in the odds columns, then the stake at book 1, in cell B7, everything else is calculated for you, stake at book 2, % Profit (margin) - note this is on your combined stake at both books.

2-Way Bets with Exchanges

With exchanges the sums are complicated by the exchanges' commission.  Here you enter your commission rate (note this will decrease if your staking is high enough), and apart from that it's basically the same as the 2-way exchange part of the sheet.  You need to keep an eye on the net margin, this takes commission into account.  Notice how in this example your profit is reduced by approx 66 % because of the commission.  Don't worry too much about this as the odds will often be so much better at Betfair that it more than makes up for the commission loss.  Keep an eye on your commission rate, some Betfair markets use a reduced commission rate to entice you into new markets, if so you should put this into the spreadsheet for those events, but do not forget to put it back to your standard commission rate afterwards, otherwise you could end up with a -ve % margin - not a good idea.

This is the back-lay conversion sums.  You need this specifically for my <4 goal system, but possibly also for other trades, and arbs.  This shows a real bet from the <4 goal system.  The odds to lay are 4.5, this equates to a back odds of 1.286.  Your liability is £400 (i.e. what you would lose if there are 4 or more goals), and the backers stake is £114.29, i.e. what you win if there are less than 4 goals.

A classic account of the first season for FC United of Manchester

CRICKET WORKSHEET

This worksheet contains the results from two of my systems.  I will explain these in some detail so you understand the staking progression.

ONE DAY SYSTEM - I call this the ODI system for short, but I also use it for English domestic cricket (but not the National League - teams do not take this competition seriously).  My early results for this system are shown below.

CRICKET TEST MATCH SYSTEM

The test match system was developed using the same principals as my ODI system, the difference being that there are now three possible outcomes - home, away and draw.  Early results for this system (as shown in the spreadsheet) are shown below.

<4 GOAL SYSTEM

Early results for this system are shown in the spreadsheet and repeated here:-