Skip to content
Access: Anonymous access. Content follows.
Reading progress is unavailable until the article can be measured.
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.

A betting log records the ticket you accepted, the reason for the bet, and what happened after the market moved or the bet settled. Without those fields, postgame review turns into memory instead of evidence.

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, and 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 reason for the bet separately from the ticket. Name the model, manual read, or source that produced the decision, then keep the note short enough to audit later: injury assumption, weather input, lineup expectation, or price discrepancy. “Felt good” leaves no useful case to review.

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 records 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 reason for the bet, 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, and a void is not a push. An open wager does not belong in a graded record. One explicit status per row makes contradictory states harder to create.

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 starts with record quality

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 can 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. Mark an absent close unavailable; when books disagree, record the source or a documented consensus method. For a line repriced after a roster change, note whether your ticket preceded the information. Preserve what happened instead of forcing 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 an 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.

blog.receipts source receipts_summary · prediction_results window graded receipt window Data as of 2026-10-18T20:08:00.101572+00:00 n=8655
Receiptsas_of 2026-10-18T20:08:00.101572+00:00 · all-market graded rows n=8655
ATS spread win rate47.7% · n=4135 1974-2161-146 ATS spread
CLV · secondary29.2%

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 reason for the bet, 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 record quality and on a fixed larger window for strategy. Daily review catches bad rows; longer-window review keeps one result from rewriting the case.
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.
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.

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

3 related posts

No data

No graded picks from this article's sources yet

No tracked source has a graded 90-day record for this sport yet. Source scorecards fill after their picks are graded. The house record is separate: see /picks.