Our process · 8 min read

Tracking your own betting performance

Win rate is not enough. The minimum spreadsheet that distinguishes "lucky" from "actually has an edge".

Why memory is not enough

The single most expensive habit in punting is what some sharp bettors call “survivor bias of one”: you remember your wins crisply, you remember a few of the unlucky losses, and you fail to remember most of the bad bets you made on a Tuesday afternoon five months ago. Without a record, you cannot tell whether you are a 49% or a 53% bettor — and the difference is the difference between losing and winning. Tracking every bet honestly is the precondition for any other piece of self-improvement in betting.

The minimum viable spreadsheet

Eight columns get you most of the way to a useful tracker. They can live in a Google Sheet, a Notion database, an Airtable, or a paper notebook — the format does not matter; the consistency does.

1. Date placed (with time, ideally — sharper than just date).
2. Sport (AFL, MLB, NRL, NBA, WNBA, Football, NHL, etc.)
3. Market (line, total, head-to-head, prop name).
4. Selection (the team / outcome / player you backed).
5. Stake (in dollars, not units — units obscure mistakes).
6. Odds taken (decimal, the price at the moment you placed).
7. Closing odds (filled in after kick-off — the bookmaker's last quoted price for the same market/selection).
8. Result (won, lost, void).

Two derived columns make the analysis trivial:

• P/L: if won, stake × (odds taken − 1). If lost, −stake. If void, 0.
• CLV %: (1/closing odds − 1/odds taken) / (1/odds taken) × 100. (See closing-line value.)

What to look at, week by week

• Number of bets, total staked, total P/L. The headline scoreboard.
• Average closing-line value. The honest scoreboard.
• P/L by sport, market, and bookmaker. Which slices are pulling their weight; which are dead weight.
• Average odds taken vs average closing odds. If the gap is positive, you are beating the market on average.
• Bet count by day-of-week and time-of-day. Most punters lose more on impulse-bet windows (late evenings, after losses, mid-game while watching). The data tells you which.

Three slices to watch carefully

Slice 1: bets placed under tilt

Add a column for “was this an impulse bet?” — flagged honestly at the time of placement. Common signals: bet within 30 min of a previous loss, bet outside your normal hours, bet larger than your unit. Most punters will see the impulse-bet column post a much worse P/L and CLV than the rest of the book. That alone is the case for deleting impulse bets from your future.

Slice 2: bets on bookmaker promos

Bonus-bet returns and odds boosts deserve their own column. The advertised value is often eaten by the small print. Tracking promo bets separately keeps your “real bet” numbers honest. (See promo traps.)

Slice 3: bets on multis and SGMs

Multi-leg bets carry hidden margin. They almost always look profitable in the short run if you happen to win one big multi; the long-run drag is severe. Track multis separately from straight bets so the latter doesn't carry the former's loss.

Sample-size sanity checks

Two questions to answer before drawing any conclusion from your data:

1. How many bets is this? Under 100, your win rate is dominated by variance. Under 50, you almost certainly cannot tell whether you have an edge.
2. What is your average CLV? CLV stabilises faster than win rate. If you have 250 bets and your average CLV is +1.5%, you have meaningful evidence of edge. If your average CLV is around zero, the wins you are posting are noise.

What honest tracking changes

Three predictable shifts for punters who start tracking and stick with it for a month:

• The total number of bets falls. Most punters discover that 10-20% of their bets are impulse picks that are responsible for most of the loss.
• The average stake stabilises. Just writing the stake down beside the rest of the bets on the row tends to embarrass punters out of staking 5x their unit on a hunch.
• Bets in low-value markets (multis, novelties, in-play) drop sharply. Hard to keep backing 110%-margin markets when you can see the line item.

How to use the data without micromanaging

Two failure modes once you have data:

• Over-reading short streaks. Three losing days does not mean the system is broken. Three winning days does not mean you have figured it out. Treat monthly numbers as noise, quarterly as signal, annual as truth.
• Tweaking process during drawdown. Resist the urge to change your rules mid-drawdown. Make the call when you are flat or up; make it based on CLV, not P/L; and write down the version of the process you switched to and why.

A note on tax and reporting

In Australia, gambling winnings for individuals are generally not assessable income for tax purposes; this article is not tax advice and the rules can change. Keeping records is helpful regardless of the tax treatment, especially if you ever start betting seriously or operating in a way (e.g. business-like, professional volume) that could change your tax position. If in doubt, talk to an accountant who knows AU gambling-tax case law (Brajkovich, Babka, etc.).

The single most underrated investment in punting is a tracking spreadsheet you actually keep up to date. Everything else — system selection, stake size, bet selection — is downstream of being honest about what you have actually been doing.

Educational content only — not personal financial advice. Sports are uncertain and any bet can lose. Past results do not predict future results. 18+. Gamble responsibly. Responsible gambling resources.