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
FreeSpreadsheet 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.
Any cells in the spreadsheet with a coloured
background are calculated for you, so don't change anything in these cells
or you will wreck the sums.
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.
You will notice that across to the right I keep
track of my net deposits with each book, and current net profit
This is a crucial part of the spreadsheet. Here you calculate
your stakes for all your arbs and trading bets.
Regular 2-way bets
1st Odds
2nd Odds
Margin
Input Odds:
1.900
2.200
1.95%
Input Stake:
500
431.82
Stake in euros
725.85
626.87
Stake in
dollars
921.70
796.01
Return:
950.00
950.00
Profit from this arbitrage:
18.18
18.18
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
Input Exchange Commission Rate
4.75%
Betfair Odds
2nd Odds
Odds after %
Input Odds:
1.900
2.200
1.163
Input Stake:
500
422.10
stake in euros
725.85
612.77
Net Margin
stake in
dollars
921.70
778.10
Return:
928.63
928.63
0.71%
Gross Margin
Profit from
this arbitrage:
6.52
6.52
1.95%
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.
Lay-Back Conversion
LAY
BACK
Liability
Backers stake
4.500
1.286
400
114.29
stake is as shown under 'your liability' for the lay bet
put 'back' odds
into cell h6
put backers stake into
Betfair odds
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.
3-Way Trades
Actual odds
Adjusted odds
Stake
Target Return
400
Selection 1
2.04
2.08
192.23
Selection 2
2.56
3.12
128.07
Selection 3
7.8
10.14
39.45
Total stake
359.76
Profit (£)
40.24
Profit (%)
10.06
This is the formula for doing trades or arbs where
there are 3 outcomes, these typically crop-up in football (home, away or
draw), and for my Test Match Cricket system. For my test match
cricket system, you put wait till the match is in-play and put the odds
for the three outcomes into the actual odds column, enter your target
return, and then place your bets at the adjusted odds price, and the
stake shown.
There is also a section for regular 3-way arbs, the
principle is similar to that shown above, but contains no odds adjustment as
for the cricket system.
A classic account of
the first season for FC United of Manchester
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.
