Handicapping

How to Track Sports Bets: What to Log, a Sample Sheet and What to Look For

4 min read
How to track sports bets: log every bet, the odds and the closing line

To track sports bets, write down every bet the moment you place it: the date, sport, the bet itself, the odds, your stake, and later the result and the closing line. A spreadsheet or a bet tracking app both work. What matters is that you log every bet, including the ones you'd rather forget, and then look at the numbers every few weeks.

Almost every bettor thinks they're doing better than they are. Memory keeps the big wins and quietly drops the Tuesday night MLB losses. A bet tracker fixes that, and honest bet tracking is the only way to find out what you're actually good at. It's also the step most people skip in the handicapping process.

What to record for every bet

Keep it to what you'll actually fill in. These columns cover almost everything:

  • Date, sport and league
  • The bet (team or player, side, line) and the bet type: spread, moneyline, total, player prop, parlay
  • Odds you took, and the sportsbook if you use more than one
  • Stake, in dollars and in units
  • Result and profit or loss
  • Closing line, taken just before the game starts
  • A few words on why you made the bet

The last two are the ones people skip, and they're the most useful later. The closing line tells you whether you got a good price, and the note tells you whether a particular kind of reasoning keeps working or keeps costing you.

A sample bet tracker

Here's what five bets look like in a simple sheet. One unit is $10, and the favorites are bet to win about one unit.

BetOddsStakeResultProfitClosed at
NFL: Bills -3-110$11.00Win+$10.00-3.5
NBA: Over 221.5-110$11.00Loss-$11.00223.5
MLB: Dodgers moneyline-150$15.00Win+$10.00-160
NHL: Rangers moneyline+120$10.00Loss-$10.00+125
NFL: Under 47.5-105$10.50Win+$10.0046.5

Total staked: $57.50. Profit: $9.00, or 0.9 units. That's a return on investment of 15.7% ($9 ÷ $57.50). Nice, and also meaningless after five bets. Look at the last column instead. Four of the five bets got a better number than the line closed at: the Bills closed at -3.5 after you took -3, the Dodgers went from -150 to -160, and the over and under both moved your way. Only the Rangers bet got a worse price. That's the early signal worth watching, more than the wins and losses.

To work out profit in a spreadsheet, with the stake in column D and the odds in column E, use =IF(E2>0, D2*E2/100, D2*100/ABS(E2)) for a win and =-D2 for a loss. A push is zero.

Spreadsheet or bet tracking app?

A spreadsheet is free, works with any sportsbook and does exactly what you tell it. You can add a column for closing line value, a tab for each sport, or a chart of your bankroll. The downside is manual entry. If you place a dozen bets on a Saturday, typing them all in gets old fast, and the bets you skip are usually the bad ones.

Bet tracking apps handle more of it for you. Several, like Action Network and Pikkit, can sync with some sportsbook accounts and pull your betting history in automatically, then break your results down by sport, bet type and book. The cons of bet trackers are mostly about fit: syncing doesn't cover every sportsbook, the best analytics often sit behind a paid tier, and few apps record the closing line the way you'd want. Before you pick one, check which sportsbooks it supports and whether you can export your data. The best bet tracking app is simply the one you'll still be using in March.

Our advice: if you bet with one or two books and want it easy, use an app to track your bets. If you're serious about handicapping and want to track CLV, keep a spreadsheet too, even a simple one.

What to look for once you have a few hundred bets

The point of tracking isn't the running total. It's the breakdown. Sort your bets by sport, by bet type and by odds range, and look at units won and ROI for each group. Most bettors find one or two areas where they win, and one where they lose steadily without noticing. A lot of people learn they're decent on NFL spreads and badly underwater on NBA player props, or that every parlay they've ever made adds up to a big loss. Stop betting the leaky part and your overall number can change quickly.

Then check the closing line. If your bets regularly beat it, your handicapping is probably sound even during a losing month. If they regularly don't, a winning month is likely luck. We explain why in our guide to beating the closing number, and how to read your returns properly in our ROI guide.

Use it to manage your bankroll

A tracker also keeps your bet sizes honest. Log your bankroll at the start of each month and keep units at a steady slice of it, so a bad week shows up as a few units lost rather than a panic. If your stakes start creeping up after losses, the sheet will show it before your bank account does. For sizing bets by edge, there's the Kelly formula, though flat units are easier to read when you're starting out.

Let a contest track it for you

If you'd like to practice handicapping without logging anything, play free. On SportsPlays every bet is graded and recorded for you on real lines, and your results sit in the public rankings. It's a clean way to build a record before putting money on your opinions.

SportsPlays is for players 21 and over. If betting ever stops being fun, call or text 1-800-GAMBLER for free, confidential help.

FAQ

Is a spreadsheet or an app better for tracking bets?
An app is faster, especially one that syncs with your sportsbook accounts. A spreadsheet is free, works with any book and lets you add your own columns, like the closing line or why you made the bet. Plenty of bettors use both.
Is there a free bet tracker?
Yes. A spreadsheet in Google Sheets or Excel costs nothing, and several bet tracking apps have a free version. Free handicapping contests also keep your record for you automatically.
Should I track parlays and props separately?
Yes. Give every bet type its own label so you can see your results on each. Parlays in particular can hide a lot of losses inside a few big wins.

Build a streak today

15 in a row = $100 · 21 in a row = $1,500 · Free to play.

Join free

More from Handicapping