Skip to content
CURRENT
-7 → -6 (+1) over 24 captures ATL @ GB spread -7 → -6 house House backtest last 10: 6–4 · 90-day all-market 55.3% (n=8163) · 20h ago Wire Seahawks plan to have Sam Darnold back at practice Wednesday Wire Cardinals CB Will Johnson (neck) could miss rest of season Wire Rams WR Puka Nacua (hip) inactive for 'MNF' vs. Giants
Access: Anonymous access. Content follows.
receipts-weekly

How to Track Your Bets: The Spreadsheet Every Bettor Needs

Read the price, role, and market first Track your sports bets the right way. Learn the columns every betting log needs, how to compute CLV, ROI, and units, and the mistakes most trackers make.

6 sections

Shark Snip Editorial

House byline of the Shark Snip analytics desk — numbers sourced from the data pipeline, not vibes.

Key takeaways (from article sections)

  • Capture the ticket before the game starts
  • Use fields that make bad data obvious
  • Report records with their denominator attached
  • Closing-line review is a data-quality exercise first
  • Separate process review from bankroll emotion
  • Build for correction, not decoration

A betting log is not a scrapbook of wins. It is the audit trail that tells you what you actually bet, what price you accepted, why you accepted it, and whether the thesis survived contact with the market. Skip any of those fields and the review becomes a story you tell yourself after the result is known.

Capture the ticket before the game starts

The accepted ticket is the primary record. Save the event, market, selection, line, price, sportsbook, execution timestamp, stake, and settlement terms exactly as shown. A spread is not interchangeable with a moneyline. Regulation-only settlement is not the same contract as full-game settlement. A listed pitcher, starting goalie, or player-participation rule can change whether a wager stands.

Record the thesis separately from the ticket. Name the model, manual angle, or source that produced the decision. Keep the note short enough that you can audit it later: injury assumption, weather input, lineup expectation, or price discrepancy. “Felt good” is not a thesis. It is a confession that the row cannot teach you much.

The structure in the closing-line-value guide starts with this discipline. You cannot compare execution with the close when the original execution price is missing or reconstructed.

Use fields that make bad data obvious

A clean spreadsheet separates facts from derived fields. Facts come from the ticket or settlement record. Derived fields come from formulas you can inspect. Do not type a result into several places and hope they stay synchronized.

  • Ticket fields: event, market, selection, line, price, book, accepted time, stake, and ticket identifier.
  • Context fields: sport, competition, model or thesis, expected lineup, and any rule that affects settlement.
  • Market fields: closing line, closing price, close timestamp, and the source used for that close.
  • Settlement fields: open, won, lost, pushed, voided, or disputed, plus the official settlement timestamp.

Those settlement states should be mutually exclusive. A disputed ticket is not a loss just because cash has not arrived. A void is not a push. An open wager does not belong in a graded record. Illegal states become much harder to create when each row has one explicit status.

Report records with their denominator attached

The honest result line for ATS picks contains wins, losses, win rate, window, and graded sample size. Pushes and voids sit beside the record instead of disappearing into the denominator. The window can be a named season, a date range, or another fixed period, but it cannot be “recent” unless recent is defined before the results are read.

Do not convert that record into a universal claim. A short winning run can be real and still say almost nothing about the next wager. Break the log into categories only when the category was recorded at bet time. Slicing after the fact until one corner looks good is not discovery; it is a search for flattering noise.

When there are no settled rows, say so: no graded picks yet for the selected window. That empty state is more useful than a demo table because it preserves the difference between the product’s history and a sales example.

Closing-line review is a data-quality exercise first

Closing-line value can help separate price capture from final-score luck, but only under matching definitions. Compare the same market, side, settlement rule, and price format. A close copied from another book may be useful context, but label it as a different source. A stale screenshot is not a close merely because it was taken later.

Review misses before celebrating beats. If the close is absent, mark it unavailable. If several books disagree, record the source or a documented consensus method. If the line moved because the market was repriced after a roster change, note whether your ticket preceded the information. The point is to preserve what happened, not to force every row into one metric.

Separate process review from bankroll emotion

After settlement, verify the row and stop. Do not let one win excuse a bad price or one loss erase a sound process. The broader review belongs on a fixed schedule with enough rows to inspect recurring behavior: late entries, missing injury checks, duplicated markets, correlated exposure, or bets placed outside the model’s stated scope.

That review should connect to bankroll management basics, but the ledger and the bankroll are not the same thing. The ledger records what happened. The bankroll policy decides what exposure was allowed. Mixing them encourages retrospective excuses.

Build for correction, not decoration

A useful tracker makes edits visible. Keep the original ticket evidence, note corrections, and avoid overwriting a settled row without an audit note. If a book changes settlement, preserve both states and the reason. If you discover a data-entry error, correct the field and record the correction rather than quietly rewriting history.

You can compare current selections on the picks page and review model output on the desk, but the log still needs to stand on its own. The test is simple: months later, can another person reconstruct the decision from the row without asking what you meant?

Track to make yourself harder to fool. A complete row can expose a bad habit. An incomplete row can only preserve a mood.

NFL ATS cover-margin distribution

Bars count completed NFL schedule rows by closing-spread cover margin using the repository canonical home-margin grading convention.

Model calibration from graded predictions

Calibration points render only when a verified source binds prediction probabilities to settled outcomes for the same observations.

blog.receipts source receipts_summary · prediction_results window graded receipt window Data as of 2026-09-21T04:04:00.968457+00:00 n=2480
Receiptsas_of 2026-09-21T04:04:00.968457+00:00 · all-market graded rows n=2480
ATS spread win rate50.3% · n=1436 723-713-35 ATS spread
Units · secondary-173.27
Vig-laden ROI · secondary-7.1%
CLV · secondary-11.3%

Frequently asked questions

What belongs in a betting log?
Capture the event, market, selection, line, price, book, execution time, stake, closing line, settlement status, result, model or thesis, and a note for anything unusual. The accepted ticket is the source of truth. Never reconstruct a missing price from memory.
How should I report a betting record?
For ATS results, show wins and losses, the resulting win rate, the exact date or season window, and the graded sample size. Pushes and voids should be disclosed separately. A record without a window and sample size is advertising, not analysis.
What should the tracker show before any bets are graded?
An honest empty state: no graded picks yet for the selected window. Do not seed the table with demo wins, estimated closes, or sample profit. Empty is accurate and gives the next real row a clean starting point.
Why record the closing line?
The close lets you compare the price you accepted with the market’s later consensus. That comparison can diagnose execution quality, but only when the market, line type, book rules, and timestamps match.
How often should I review the log?
Review after settlement for data quality and on a fixed larger window for strategy. Daily review catches bad rows; longer-window review keeps one result from rewriting the thesis.

Build a free model in 60 seconds →

Go →
5m read time
2 players/teams
8 key angles

Angles in this read

  • Odds tick Micro tick movement reinforces live market and pricing language.
  • Line arrow Spread, total, and price movement sections get directional cues.
  • CLV scan A scanning underline highlights closing-line value concepts.
  • Widget lift Calculators and decision widgets get a measured surface entrance.
  • Market steam Line movement and public/sharp topics get steam-style emphasis.
  • Line reveal Pretext-measured lines reveal without reflowing the article.

This article's context stays anchored to Signal Positive CLV Explainer and Eagles and closing line value, model and price, all of which appear in the post itself.

Names and terms found in this article
How to Track Your Bets: The Spreadsheet Every Bettor Needs explanatory concept diagram
How to Track Your Bets: The Spreadsheet Every Bettor Needs concept map A generated visual reference that turns the article workflow into a single-page diagram for quicker review while reading. Source: Assistant internal image generation, maximum quality.
Signal Positive CLV ExplainerEaglesclosing line valuemodelpriceweatherbet tracking
Share this guide Help another reader make a sharper decision.

Get picks in your inbox

One email, every slate — ranked edges, no touts. Unsubscribe any time.

Start free — pick a sport

Go →

Continue with evidence

Related reading and source status

Related Reads

When the Board Goes Quiet, Sharps and Contrarians Both Agree — Shark Snip
NFL

When the Board Goes Quiet, Sharps and Contrarians Both Agree

A flat San Francisco board is the whole story today. Seven books posted the same number — pick which take earns its paycheck.

Sep 4, 2026 4 min read
The CLV Ledger #1 — The board moved. The ledger hasn’t. — Shark Snip
Market

The CLV Ledger #1 — The board moved. The ledger hasn’t.

Week 1 captured spread moves from our own odds table, what CLV actually measures, and why our public graded CLV ledger starts empty.

Aug 31, 2026 5 min read
The season-kickoff CLV checklist: logging bets from Week 1 on — Shark Snip
Bet Tracking

The season-kickoff CLV checklist: logging bets from Week 1 on

Log the right fields from Week 1 so closing line value can be calculated later without reconstructing prices, markets, or timestamps.

Aug 27, 2026 5 min read

query: loadMergedBlogPostCards + scoreRelated · n = 3

No data

No graded source picks match this article yet

The public.source_accuracy_scores 90-day query returned no rows for this article's inferred sport.