NBA Prop Bet Record Keeping for UK Bettors
Available in US
The Ledger That Tells You Who You Really Are
A bettor without a ledger is a bettor who believes whatever story his memory wants to tell him. The hot streak gets remembered; the cold streak gets explained away. The lucky win gets credited to skill; the unlucky loss gets credited to variance. Without a record, the bettor cannot tell which version is true, and the operator on the other side of the bet has no such confusion.
I kept a haphazard ledger for my first three years of betting and then I started keeping a real one. The difference was immediate and uncomfortable. Bets I had remembered as borderline value plays turned out to have been priced 4-5% against me. Markets I thought I was winning at were actually breakeven, and one I thought was breakeven was paying me a steady 3% over months. The ledger reorganised my approach within a fortnight.
The Nine Columns That Capture What Matters
Most bet logs fail because they are too elaborate. A 20-column spreadsheet gets abandoned by week three. A 9-column log gets kept all year. The columns I have settled on after seasons of trial: date, sport, market, line, stake, price, projected probability, closing price, settlement.
Date and sport are obvious housekeeping. Market identifies the specific bet type — points over, threes over, PRA over, and so on. Line is the threshold number. Stake is the amount risked. Price is the odds at placement. Projected probability is the bettor’s own pre-bet estimate of true win likelihood. Closing price is the price the line settled at just before tip. Settlement is win, loss, or void.
The projected probability column is the one most bettors skip and the one that delivers the most value over time. Filling it in forces an articulation of edge before placement. A bet I cannot project a probability for is a bet I should not place. The discipline of writing the number down catches half of the bad bets in the act of selection.
Closing-Line Value as the Honest Mirror
Win rate is what most bettors track. Win rate is the wrong primary metric. A 55% win rate at -110 is hugely profitable; a 55% win rate at -150 is breakeven. The price at the moment of betting is what matters, and the cleanest way to track whether you are betting good prices is closing-line value.
CLV measures the gap between the price you got and the price the same market closed at. A bettor who consistently beats the closing line is, by definition, identifying value the broader market eventually agrees with. The 2025-26 NBA prop-tracking model that logs closing-line win rates of 55.7% on points, 63.2% on threes, 69.9% on blocks, 61.9% on steals, and 54.7% on PRA is essentially reporting a CLV-style outcome — the percentage of bets that beat the closing line.
Tracking CLV requires the closing-price column in the log. Most retail bettors do not log it because the data is not visible at the time of betting. The fix is mechanical: take a screenshot of the operator’s pre-tip price 5-10 minutes before tip-off, then update the log post-game. The workflow adds about 30 seconds per bet. It is the single most valuable 30 seconds in the bettor’s process.
Segmenting the Log by Market and Confidence
The aggregate ledger tells you whether you are winning or losing overall. The segmented ledger tells you why. By breaking down results by market type, by confidence level, and by game state, the bettor can identify which patterns are profitable and which are bleeding.
My segmentation has six dimensions: market (points, threes, rebounds, etc), confidence band (low, medium, high), spread bucket (close, moderate, blowout-risk), back-to-back status, time of season (early, mid, late), and operator. The cross-tabulation surfaces patterns the aggregate would hide. A 49% raw win rate that hides a 58% win rate on high-confidence picks and a 42% win rate on low-confidence picks tells two very different stories about how to allocate future bet volume.
The cross-tabulation also reveals operator-specific patterns. A bettor losing at one operator and winning at another is paying for slow execution or wide vig at the losing operator. The corrective is to shift volume away from the losing operator and toward the winning one. For the broader frame on cross-operator comparison, see my walkthrough of prop line shopping.
Monthly Reviews and the Reset Discipline
The bet log is only useful if it is read. The bettor who logs every bet but never reviews the ledger is keeping data without extracting signal. The monthly review is the discipline that converts ledger into improvement.
My monthly review takes about 30 minutes. I tabulate CLV by market segment, identify the worst-performing patterns, and write a one-sentence diagnosis for each. The diagnosis matters more than the number – “lost CLV on assists overs because I was anchoring to season-long usage when teams had reshuffled rotations” is actionable in a way that “down 1.2% on assists” is not.
The review surfaces patterns the bettor would otherwise not notice. A 30-day losing streak on a specific market type usually has a single root cause that is identifiable in the monthly diagnosis. Without the review, the streak feels like variance. With the review, it usually traces to a specific structural mistake the bettor has been making consistently.
Logging Voided Bets and the Free-Bet Conversion
Voided bets are easy to forget. The stake is returned, the bet is cancelled, and the bettor moves on. The void is informational, though — a voided bet means the bookmaker disagreed with the bet’s settlement basis, or a player was ruled out, or some condition for the bet was not met. Logging voids alongside settled bets gives a complete picture of the bettor’s engagement with each market.
Free-bet conversions deserve their own column or tag. A £20 free bet placed at +200 produces £40 of returned stake on a winning settlement, but the bettor only collected £40, not the £60 a £20 cash bet would have collected. The free-bet conversion rate — the percentage of free-bet face value the bettor actually walks away with — is typically 60-80%. A bettor who routinely uses 4/1 free bets converts roughly 75-80% of face value. A bettor placing free bets at evens converts about 50%.
The 40% Remote Gaming Duty taking effect on 1 April 2026 has tightened the free-bet economy. UK consumers face up to 90% pass-through of the increase in the form of worse promos, reduced bonus stakes, and stricter wagering requirements. The free-bet conversion rate that worked in 2024 is producing slightly worse net returns in 2026, and the bettor’s log captures the exact extent of the squeeze. The IBIA’s Khalid Ali has noted that higher alert volumes in mature markets often reflect stronger detection rather than higher inherent risk, but the operator-side response to all these regulatory pressures has been to shrink margins on promos. The bettor’s log is where the squeeze becomes visible.
The Tax and Compliance Angle for UK Bettors
UK bettors do not pay personal tax on gambling winnings, so the log does not need to support tax filings in the way that some other jurisdictions require. The log does, however, support the operator-side checks that UK bettors increasingly encounter.
The BGC Code on Customer Checks triggers a risk review at £5,000 net deposits in a rolling 30-day period, with enhanced due diligence from £25,000 a year. The UKGC’s own financial vulnerability check threshold sits at £150 net deposit per 30-day rolling period. A bettor who has a clean log of bets, stakes, and outcomes is in a stronger position to respond to an operator’s affordability or source-of-funds query than one who cannot account for his betting history.
The log also helps with self-monitoring against the UK’s responsible gambling framework. A bettor who can see his stake aggregating into uncomfortable territory across operators has the data to take corrective action before an operator flags him. The log is a safety net as much as a profit instrument.
Why the Spreadsheet Beats the App Every Time
Several mobile apps offer to track bets automatically. I have tried most of them. None of them captures the projected-probability discipline that a manual log enforces. The app logs what happened. The spreadsheet records what the bettor expected to happen, which is the variable that produces learning.
The friction of writing the projection in is the feature, not the bug. The bettor who spends 20 seconds on each bet writing down his projection has placed a smaller volume of higher-quality bets. The bettor who taps “place bet” in an app with no friction places a higher volume of lower-quality bets. The volume difference is real and it works against the lower-friction bettor.
My recommendation for new bettors is to keep a simple Google Sheets or Excel file. Nine columns. One row per bet. Add the bet within five minutes of placement; update the closing price and settlement after the game. The file lives on a phone, a laptop, a tablet — wherever the bettor is when betting. Total maintenance: 60-90 seconds per bet. Total payoff: the difference between a bettor who reaches year three with edge documented and one who reaches year three with a head full of unverified beliefs.
Articles
Published by the HoopMargin team.
