Three bets a week for a year is about 150 rows, and that’s where memory stops being reliable. The CasinoCalcs betting tracker template below is a free Excel file: type the odds, stake and result, and it fills in the return, profit, running bank, ROI and strike rate. Five example bets are already in it so you can see how it works before you clear them. There are two more sheets as well: a lay bet calculator for matched betting and a value bet sheet with Kelly stakes.
Betting tracker template: what’s in the file
The Bets sheet has one row per bet: date, sport, event, selection, bet type, bookmaker, decimal odds, stake and result. The result is a drop-down (Won, Lost, Void, Half won, Half lost, Pending), so there’s no typo to break a formula. Return, profit, running profit and bank work themselves out. Pending bets stay out of the totals until you settle them.
The Summary sheet pulls it together: total staked, returned, profit, ROI, strike rate, average odds and the biggest win. Underneath, a table splits profit and ROI by sport. Type your own sports into the yellow cells and the numbers follow.
| Cell | Formula, in words |
|---|---|
| Return | Won: stake × odds. Void: stake. Half won: half the stake × odds + half the stake. Half lost: half the stake. |
| Profit | Return − stake |
| ROI | Profit ÷ total staked |
| Strike rate | Winning bets ÷ settled bets |
Using it in Google Sheets
Download the file, open Google Sheets, then choose File, Import, Upload. Pick “Replace spreadsheet” or “Insert new sheet”. The drop-downs and formulas carry over. On a phone, the Google Sheets app opens the .xlsx straight from your downloads.
Fractional odds? Convert them first: 6/4 is 2.50, evens is 2.00. The odds converter does any price. For each way bets, use two rows, one for the win part and one for the place part, each with half the stake.
The lay and value bet sheets
The matched betting file works out the lay stake, liability and profit for a qualifying bet or a free bet, with or without the stake returned, and has an offer log with a running total. It’s the same maths as the lay calculator, just in a sheet you can keep.
The value bet file takes your own estimate of a chance and the bookmaker’s odds and shows the edge and a Kelly stake. Green edges are value, red ones aren’t. Most people stake a quarter of full Kelly, which is the default, because their own estimates are never perfect. The Kelly criterion calculator explains why.
Rather not use a spreadsheet? The online bet tracker does the same job in the browser, and the betting ROI calculator checks your numbers from totals alone.
A tracker is the most honest friend a bettor has. If the totals worry you, that’s worth listening to. BeGambleAware.org is free and confidential.