Learn

The Honest Ledger: how to track sports bets so the record tells the truth

How to track sports bets so the record tells the truth comes down to four columns next to your wins and losses: units, the price you took, the closing price and the sample size. The Honest Ledger is a ready-made sheet with those columns, because a win-loss count alone can hide a losing habit for years. 21+. Nothing is guaranteed.

Updated October 21, 2026 · 5 min read

This is the sheet from the Honest Ledger video. It has the same four columns in the same order, what goes in each, the formulas to add, and how to read the sheet without fooling yourself.

Who it is for: anyone who keeps some kind of record of their bets, even a notes app, and wants it to answer one question honestly: am I getting good prices, or am I just counting wins? You need each bet's stake, odds, the closing odds and the result.

Why wins and losses are not enough

Action Network looked at every NFL favourite against the spread since 2005: 1,859 wins, 1,860 losses and 111 pushes, a loss of 78.5 units to the juice. That is a dead-even record that still lost money, because the price was -110 and break-even at that price is about 52.4 percent. A ledger that only counts wins would call that a break-even strategy. It was a losing one.

The four columns

  1. Units. Every stake in units, not dollars.
  2. Price. The exact odds you took.
  3. Close. The final line before the game.
  4. Sample. A running count of how many bets the record is based on.

Column 1, units

Pick a unit, for example a hypothetical hundred dollars, and write every stake as a number of units. A 2-unit bet is twice your normal size and shows up that way. In dollars, a few big bets can swing the total and hide what the normal-sized bets are doing. In units, every row means the same thing next month as it does today.

Formula to add: profit in units. For a win at a minus price, stake times 100 divided by the odds. For a win at a plus price, stake times the odds divided by 100. For a loss, minus the stake.

Column 2, price

Write the exact odds, not "about -110". The price decides your break-even. At -110 you need 110 divided by 210, about 52.38 percent, just to break even, which is why an even record at that price loses money.

Formula to add: implied probability. For a minus price, the odds over the odds plus 100. For a plus price, 100 over the odds plus 100.

Column 3, close

Write the final line before the game starts, from one reference book. Action Network gives the simple version: if you bet the Patriots -3 and the line closes -3.5, you beat the closing line, and it says beating the close is usually a sign of a long-term winning bettor. For moneylines, the fuller version takes the margin out of the closing price first. SharpAPI's documentation gives one formula, CLV percent = (closing no-vig probability x entry decimal odds - 1) x 100.

Formula to add: a simple yes or no, "beat the close", and if you can, the CLV percent.

Column 4, sample

Keep a running count. It sounds trivial, but it is the column that stops you drawing conclusions too early. The Spread suggests tracking CLV across at least 200 to 300 bets before drawing conclusions, and treats an average CLV of around 2 percent over a large sample as a positive sign.

The win-loss record needs even more patience. Over 100 bets at -110, the typical swing around break-even is about 5 percentage points either way, from the standard error of a proportion, so a record anywhere from about 47 to 57 percent is ordinary. A hypothetical 55-45 run, which is +5 units at $100 a unit, sits inside that range.

The sheet

Copy this. The first rows are demo bets, not real ones.

Date Bet Units Price Implied Close Beat close? Result Profit (u) Bets so far
demo Hawks -3 1.0 -110 52.38% -3.5 yes W +0.91 1
demo Owls +4 1.0 -105 51.22% +3.5 yes L -1.00 2
demo Bears over 44 0.5 -110 52.38% 43.5 no W +0.45 3

Add two summary cells at the top: total profit in units, and the share of bets that beat the close. Watch the second one first.

How to read it

  • Under 100 bets. Read nothing into the record. Look at whether your prices beat the close.
  • 100 to 300 bets. The beat-the-close share starts to mean something. The record still swings a lot.
  • 300 bets and up. Average CLV and the profit in units both start to carry information.

Researchers who built a strategy from closing-odds probabilities showed that closing prices carry enough information to find mispriced bets, which is why the close column is the one that tells you the most, the soonest.

What to watch out for

  • Logging only the bets you remember. Log every bet, especially the bad ones.
  • Changing the unit mid-season. Write the date you changed it, or start a new sheet.
  • The wrong close. A line from the morning is not the close. Use the last price before the game.
  • Mixing markets. Sides, totals and props can live in one sheet, but filter by market when you read it.

How to tell it worked

You will know the ledger is honest when a hot week stops feeling like proof and a cold week stops feeling like a disaster, because you are looking at the close column first. For the calculator version of the close column, see the CLV calculator and closing line value explained.

21+. For informational purposes only. Nothing is guaranteed. If you or someone you know has a gambling problem, call 1-800-GAMBLER.

Questions people ask

What should I track for every sports bet?

The stake in units, the exact price you took, the closing line, the result and a running count of bets. Those columns tell you more than a win-loss record.

Why track bets in units instead of dollars?

So a few big bets do not hide what your normal-sized bets are doing, and so the record means the same thing when your bankroll changes.

How many bets before my record means something?

The Spread suggests 200 to 300 bets before drawing conclusions from CLV. The win-loss record needs longer, because it swings by about five points either way over 100 bets.

If I beat the close, will I make money?

Not on every bet, and not over every stretch either. Beating the close is a sign of good prices, but nothing is guaranteed.

Sources

  1. Closing line value definition and importance, Action Network
  2. CLV platforms, The Spread
  3. Closing Line Value (CLV), SharpAPI docs
  4. Binomial proportion confidence interval, Wikipedia
  5. Beating the bookies with their own numbers, arXiv