Memory lies, especially about losers. A simple spreadsheet, a few honest columns and one comparison against the closing price will tell you more about your betting than a year of results.
Ask most punters how they are doing and the answer is “about level” or “a bit up”. Ask them to prove it and the conversation ends. It is not dishonesty; it is how memory works. Winners are vivid and losers fade, the near-misses feel like they should have counted, and the £20 that went on a whim at the end of a bad Saturday was somehow never a real bet. A record fixes all of that, and it is the difference between having a hobby and having a method.
What to record
A spreadsheet is more than enough. One row per bet, with these columns:
- Date and sport.
- Selection and market (match odds, outright, each-way, in-play and so on).
- Bookmaker or exchange.
- Price taken, in decimals.
- Stake, in units rather than pounds.
- Result and profit or loss, in units.
- Closing price: the last price available before the event started, ideally the exchange price.
- A short reason. One line on why you had the bet. Painful to read back, priceless in aggregate.
Record every bet, including the ones you are embarrassed by. The ones you are tempted to leave out are the ones the record exists to catch.
The numbers that matter
Return on investment (ROI) is profit divided by total stakes. Up 34 units on 400 unit-stakes is an ROI of 8.5%, which for a recreational bettor is excellent. ROI lets you compare a month of £10 bets with a month of £50 bets, and compare yourself with anyone else.
Strike rate is how often you win. On its own it means nothing: a 70% strike rate at 1.30 is losing money and a 20% strike rate at 6.00 is making it. Strike rate matters only alongside average odds, and mostly as a sanity check that your losing runs are within normal variance.
Closing line value (CLV) is the one that separates process from luck. Compare the price you took with the closing price. If you backed at 3.50 and it closed at 3.00, the market moved towards you: you beat the close. Do that on average across hundreds of bets and you almost certainly have an edge, even during a losing run. Consistently take worse than the close and, however good this month looks, the money will leave eventually. Results take a thousand bets to mean much; CLV starts telling the truth after a hundred.
What the record will show you
After a few months, sort and filter. You will find things you did not expect. Perhaps you are profitable on the sport you know and quietly losing on the one you dabble in. Perhaps the pre-match bets are fine and every in-play bet placed after 10pm is a disaster. Perhaps the each-way doubles that feel like fun cost you more than everything else combined. Perhaps your “strong” bets, the ones you staked up on, do worse than your standard ones, which is the most common finding of all and the one nobody believes until they see it in their own numbers.
Each of those is a decision you can now make with evidence. Drop the losing category. Stop the late in-play bets. Go back to level stakes. The record does not make you a better judge; it stops you paying for the judgements you are bad at.
Keeping yourself honest
A few rules that make records work:
- Enter the bet before the event starts, not after. Retrospective records drift.
- Never delete a row. If you want to test a stricter version of your method, add a column and filter, so the original stays intact.
- Review monthly, judge quarterly. A month is noise. A quarter is a hint. A year is evidence.
- Share the honest version. If you post tips on the forum, the record you keep should be the record you would be happy for other members to see, losers and all. Our Forum Rules ask exactly that.
It takes a minute a bet. It is the cheapest edge in gambling.
Please gamble responsibly and only stake what you can afford to lose. See our Responsible Gambling page.
