Bet Record Spreadsheet
All punters with a professional attitude to their
betting should keep an accurate record of their bets.
Here you can download a free spreadsheet you can use to do just
This spreadsheet was supplied by RSUK subscriber Chris who thought
others may find it useful.
Enter your odds, results etc and the spreadsheet will keep a
running count of your profits, profit on turnover etc.
There are a few other bells and whistles thrown in as well for
good measure such as an ARB calculator and a dutching calculator.
Please note that not being the creator of this spreadsheet I
am unable to answer detailed questions on its workings.
You should find it pretty self explanatory however and easy to
use after reading through the notes Chris has provided below.
He has also provided his contact details should you wish to get
Many thanks to Chris for making this available to viewers here.
Requires Microsoft Excel on your PC to operate.
Notes on Use:
This sheet will only be of value to those using a rolling, ratchet
style, Level stake or percentage bank.
First thing to do is to add the Paste Values button to your Excel
toolbar (makes it much easier than using a menu everytime!)
THE ALL BETS SHEET: Tracks details of all your bets YTD
Enter your starting bank into cell C1
Enter the number of points in your bank in cell C2. If you use
a percentage bank then just convert it to points eg a 5% rolling
bank = 100/5= 20 points etc etc
When a bet has been settled in the "Daily sheet", just
select its details (i.e. the data in columns A to M), copy it,
switch to the "All bets sheet" and use PASTE VALUES
to paste it into the next blank row (normal paste wont work).
All the stats/profit stuff will then automatically calculate,
as will the new point value. Easiest thing to do is add the Paste
Values button to your toolbar, rather than use the menu. You can
do the copy/paste on one bet at a time as they are settled, or
as a block at the end of the day....
"DAILY SHEET": Used to record your daily bets.
1) Enter the data into columns A to H (and J if you want to record
Note - for a win bet, type 'win' in column D, for eachway type
If you take an early price and enter it in column F, profit will
be calculated using it rather than the sp fig you enter. I like
to keep both so you can see your results @SP as well...
2) When you enter an ew bet, it automatically knows that the
total stake is double what you entered (as happens betting ew
online). So in the example in the sheet it knows that £17
ew is a total stake of £34, and calculates profit/loss accordingly.
3) Enter the result in column I in the form: 1,2,3,4. If the
horse is unplaced, type unpl. The sheet then calculates profit/loss.
4) Cell E18 shows your current point value (it feeds in from
the all bets sheet)
The other stuff on the daily sheet:
Doubles calculator to work out if it's worth doing one. Fairly
Your current point value feeds into cell C24 automatically. The
calculator assumes you only want to stake 1 point in total regardless
of the bet being win or ew.
Enter the odds of each horse and the place factors for the race
(i.e 1/5 or 1/4)
When you enter the results it calculates your profit and ROI.
I like to use it BEFORE placing the bet to see if the return
is worth the risk.
When the bet is settled it's easiest to just enter its data into
the all bets sheet manually.
The betfair calculator:
If you use betfair this will shows the minimum price you need
to take in betfair to equal the current bookie price. It accounts
for comission and the fact that they use decimals (ie on betfair
a price of 6/1 is shown as 7.00). Just enter the current bookie
price in cell l24 and cell l25 gives you the price to look for
on betfair. I find this very useful in fast changing live markets.
Enter the price you take on betfair in Cell M27 and M28 shows
the true price (i.e minus commision). Use this price to enter
the bet into the main part of the daily sheet as normal to settle
DUTCHING SHEET - is what it says!!!
BOOKIE SUMMARY SHEET: Tracks the deposits/withdrawls, current
balance and profit and loss for your accounts
Enter the names of your bookies in columns A and F
Enter the starting balance of each account in column G
As you make deposits/withdrawals, enter them into columns H and
As bets are entered into the all bets sheet, the balances and
P/L figs for each account are automatically calculated.
LOSS RECOVERY SHEET: If you use any loss recovery systems (and
have balls like an elephant) this will calculate your stake for
each bet as the previous one loses! Just put the required daily
profit in cell C18, then the odds of the first bet in cell D2
and away you go....!! DOH!!!!!
Best thing to do is try adding data to each sheet and see what
happens. Cells with calculations in are protected so you wont
delete/change them by accident!!
I'd be interested in hearing of any staking plans you'd like
to see added.
Any questions please mail me on : firstname.lastname@example.org