Keeping A Betting Record: The Spreadsheet That Turns A Hobby Into A Process
Available in US
I kept no records for my first two years of betting on horses. None. I had a vague sense that I was “about even,” which is what every recreational punter says when they have not done the maths. When I finally sat down and reconstructed six months of transactions from my betting account statements, the result was sobering: a 14% loss on turnover, disguised by a handful of memorable winners that stuck in my memory while the losers quietly vanished. That afternoon I opened a spreadsheet, typed in column headers, and started writing down every bet. It is the single most useful thing I have ever done for my betting.
Why Write It Down At All
The case for record-keeping is not about discipline for its own sake. It is about replacing narrative with data. Human memory is spectacularly bad at tracking probabilistic outcomes. We remember the 20/1 winner and forget the twenty losers that preceded it. We remember the “sure thing” that got beaten and forget the three times a similar “sure thing” won at short odds. Without a written record, your assessment of your own performance is fiction.
Horse racing betting in the UK generates enormous sums – the gross gambling yield from remote betting on racing alone was £766.7 million in the 2024-25 financial year. That money flows from punters to bookmakers, and the aggregate flow only runs one way. To have any chance of sitting on the profitable side, you need to know – not believe, not feel, but know – whether your approach is working. A spreadsheet gives you that knowledge. Everything else is storytelling.
The Essential Columns
Over six years of iteration, I have settled on a set of columns that capture everything I need without turning data entry into a chore. The temptation is to track too much – saddle-cloth number, weight carried, going, trainer, jockey, course, draw, wind direction. If you record all of that, you will stop recording within a fortnight because it takes longer to log the bet than it took to find it.
My columns are: date, course, race time, horse name, bet type (win, each-way, forecast, etc.), odds taken, stake, returns, and profit/loss. That is nine columns. A tenth – a short notes field – captures anything unusual: “dropped in class,” “first run on soft,” “market drifter.” The notes field is optional on any given bet, but over time it becomes the most valuable column because it lets you search for patterns. When I filter for every bet I tagged “first run on soft” and see a strike rate ten points higher than my overall average, I have found something actionable.
The bet type column matters more than you might think. Separating win bets from each-way bets, singles from multiples, and level-stakes plays from variable stakes lets you see which categories are profitable and which are draining the bank. I discovered after about 300 logged bets that my each-way selections were consistently profitable while my win-only bets on short-priced horses were a steady leak. Without the record, I would never have spotted the pattern.
Key Metrics To Track
Three numbers tell you almost everything about your betting performance: strike rate, return on investment, and yield. Strike rate is the percentage of bets that win. It is the simplest metric and the least informative on its own, because a 40% strike rate at average odds of evens produces a loss while a 15% strike rate at 8/1 produces a healthy profit. Strike rate without context is vanity.
Return on investment – ROI – is your total profit or loss divided by your total stakes, expressed as a percentage. An ROI of +5% means you have made 5p profit for every £1 staked. Over a large sample, even a small positive ROI is significant. Customer funds held across UK betting operators were £1.0 billion at the last count, down 6.9% year-on-year, and the vast majority of that money belongs to losing accounts. If your ROI is positive over 500-plus bets, you are in a small minority.
Yield is similar to ROI but expressed per bet rather than per pound staked. It accounts for varying stake sizes, which matters if you are not betting at level stakes. A high yield with low turnover might feel good but will not generate meaningful profit. A modest yield with high turnover will. The interplay between the two is where real understanding lives.
I also track my P&L as a running cumulative chart. This visual is more useful than any single number because it shows the shape of your performance over time – the drawdowns, the recoveries, the plateaus. A steadily rising line with shallow dips suggests a genuine edge. A jagged, trendless scatter suggests randomness. You cannot see the shape in a table of numbers. You need the chart.
The Weekly Review
Every Sunday evening I spend fifteen minutes reviewing the week’s bets. Not analysing each one in forensic detail – just scanning for obvious patterns. Did I follow my staking plan? Were there any bets I placed on impulse, without proper research? Were there races I studied and decided not to bet, and if so, what happened? That last category is surprisingly instructive. Tracking the bets you chose not to place reveals whether your selection filter is too tight, too loose, or about right.
The weekly review also catches data-entry errors before they compound. A mistyped odds value or a missing result can distort your running totals, and the longer you leave it, the harder it is to trace. Fixing errors in real time keeps the record clean and your metrics trustworthy. If you cannot trust the data, you cannot trust the conclusions drawn from it, and the entire exercise collapses.
Honest Categorisation And What It Reveals
The most uncomfortable part of record-keeping is categorising bets that you know, in hindsight, you should not have placed. I tag these as “impulse” in my notes column. An impulse bet is anything I placed without following my normal process – a last-race flutter at Kempton because I was bored, a Telegram tip I followed without checking the form, a double I constructed because two horses “felt” right. Over a full year, my impulse bets show a negative ROI of around 22%. My process bets – the ones where I did the work – sit at a modest positive. The difference is not subtle. It is the difference between being a profitable punter and a losing one.
Honest categorisation also extends to separating luck from judgement. A winning bet is not automatically a good bet, and a losing bet is not automatically a bad one. If I backed a horse at 6/1 that I assessed as a 4/1 chance and it won, the bet was poor value even though it returned a profit. If I backed a 10/1 shot that I assessed as 6/1 and it lost, the bet was good value despite the result. The spreadsheet cannot tell you this on its own – you need the notes and the tissue prices alongside the outcomes. But once you have all three, the picture of your betting becomes clearer than any gut feeling could ever provide.
Articles
Prepared by the Furlongcraft editorial staff.
