How to Track Your Bets and Improve Over Time

By: Editorial Team | Last updated: 2026-01-12

18+ only. Bet only where it is legal. Set limits. If you feel stress from betting, stop and get help. See BeGambleAware, NCPG, or GamCare.

Education only. This is not financial advice.

Disclosure: Some links may be affiliate. We do not change our views because of this.

Why tracking beats “gut feel”

Your brain loves stories. A hot streak feels like skill. A cold week feels like “bad luck.” Data cuts through this. A simple log shows what works and what fails. It helps you spot mistakes early. It helps you bet smaller in bad spots and bigger in the good ones. It also helps you keep control and avoid harm.

In this guide, you will set up a clear system. You will learn the key stats. You will make a weekly and a monthly review. You will know when to scale up, and when to stop.

What to track: the core fields

Log each bet. Use the same fields every time. Keep names clear and simple.

• Date and time
• Book or exchange (site where you placed the bet)
• Sport, league, and market (for example: NBA, moneyline)
• Pick (team or player)
• Odds and stake (note odds format: decimal or American)
• Line source (open line, consensus line, steam, your model)
• Closing odds (the odds right before the game starts)
• Result (win / loss / push), payout, profit or loss
• Notes (why you made the bet, news, injury, promo)

Optional, but useful:

• Confidence score (1–5)
• Pre-game or live bet
• Free bet / boost / promo used
• Your “edge” estimate (by how much you think the bet is +EV)

Tip: Track in “units,” not only money. One unit can be 1% of your bankroll. Units make results easy to compare over time and across books.

The key metrics (in simple words)

You do not need many stats. But you must know these few well.

ROI (return on investment)

ROI tells you how much you earn per dollar staked. Simple rule:

ROI = profit ÷ total staked

Example: You staked $1,000 in a month. You made $50 profit. ROI = 50 ÷ 1,000 = 5%. Learn more at Investopedia: ROI.

Hit rate and average odds

Hit rate is the share of bets you win. Alone, it can trick you. A 70% hit rate is poor if your odds are 1.10. A 40% hit rate can be great if your odds are 2.80. Always read hit rate with average odds and ROI.

CLV (closing line value)

CLV compares your odds to the closing odds. If you beat the close often, you are likely finding good prices. It is a strong sign of skill, even before results come in.

CLV (decimal) = (your odds ÷ closing odds) − 1

Example: You took 2.10. The close was 2.00. CLV = (2.10 ÷ 2.00) − 1 = +5%. A short guide: Pinnacle on CLV.

Bankroll drawdown

Drawdown is the drop from a peak in your bankroll to a later low point. Big drawdowns feel bad and can break you. Track the worst drawdown and your longest losing streak. It keeps you honest about risk.

Odds and variance basics

Know your odds format. See Wikipedia: Odds. Know that results jump around. That jump is called variance. A short crash or hot run does not mean much. It is normal. A quick intro to spread and standard deviation is here: Khan Academy: Data basics.

Kelly (only if you have a proven edge)

The Kelly idea says: bet a fraction of your bankroll based on your edge. It can grow your bankroll fast, but swings are big. Many pros use half or quarter Kelly to cut stress. Math note: see Kelly criterion. If you do not have a strong model, do not use full Kelly.

Build your tracker (spreadsheet method)

You can use Google Sheets or Excel. It is free, clear, and in your control.

Sheet 1: your raw log

Create columns with the fields above. Keep names the same every time. Use data validation for sport, market, and book so you do not mistype.

Sheet 2: your dashboard

• Total staked, total profit, ROI
• Rolling ROI for the last 50 or 100 bets
• Average CLV and a small chart of CLV over time
• A drawdown chart (bankroll over time, highlight dips)

Sheet 3: pivots by group

• By sport (NBA vs NFL vs soccer)
• By market (spreads, moneylines, props, parlays)
• By book (compare limits and prices)
• By time (day of week or time before kick-off)

How to: see Microsoft: PivotTables and Google Sheets: Pivot tables.

Data hygiene tips

• Use one odds format in your sheet. Convert when you enter.
• Keep book names and market names the same (no typos).
• Check formulas with a test row each week.
• Back up to cloud and export a copy each month.

Copy-and-paste starter CSV

Copy this into a new sheet (File → Import → Upload as CSV):

Apps and tools (pros and cons)

Apps can save time. They can sync odds, pull closing lines, and show charts fast. But some have a cost. Some are “black box” and you cannot check the math. Always export your data often.

• Pros: quick input on phone, auto CLV, easy charts
• Cons: subscription fees, privacy risk, hard to move data

If you pick books or casinos, choose ones with fair odds, fast pays, and clear limits. Bad books can ruin your data. For readers in Norway who want trusted reviews and safety checks, see casino på nett Norge for independent guides and user feedback.

Your weekly and monthly review

Weekly (30–45 minutes)

• Enter all bets. Check totals match your accounts.
• Look at rolling ROI and CLV. Are you beating the close?
• Find markets with bad CLV or bad ROI. Note why.
• Check effect of promos, boosts, and free bets on results.
• Cut or cap the highest variance stuff (far-out futures, big parlays).

Monthly (60–90 minutes)

• Deep dive by sport, market, and book. Where are you strong?
• Study drawdowns. Did you follow your loss limits?
• Decide: stop, reduce, or scale a market. Write down the change.
• Set one test for next month (A/B test a rule, like time-to-bet).

Tip: Wait for 200–300 bets before big changes. Small samples can trick you.

Bankroll rules that keep you safe

• Pick a unit size. Many use 0.5% to 2% of bankroll per bet.
• Do not raise unit size after a hot week. Raise only after a long sample with stable ROI and CLV.
• If you use Kelly, use half or quarter Kelly to reduce swings.
• Set a daily and weekly stop-loss. When you hit it, stop for the day.
• Take breaks. If you feel tilt or chase, log it and cool off.

See also: Responsible Gambling Council and your local regulator, for example the UK Gambling Commission.

Common mistakes to avoid

• No closing line data. Without CLV you cannot tell if price picking is good.
• Changing unit size often. This hides real risk and ROI.
• Too many parlays. They boost variance and mask skill.
• Mixing accounts without notes. Limits, slow pays, and fees matter.
• Ignoring costs. Track exchange fees and payment fees.
• Overfitting. Do not copy a rule from 30 bets. It will likely fail next month.

Example: your simple 30‑day plan

Week 1

• Set up the tracker with the fields above.
• Log 25–50 bets. Record closing odds for each.
• Note any promos used.

Week 2

• Add a CLV column and chart.
• Compare books. Are you getting worse prices at one book? If yes, switch or use it only for promos.
• Test one small rule (for example: do not bet props after big line moves).

Week 3

• Build the dashboard: ROI, rolling ROI, CLV, drawdown.
• Start a weekly review habit. Keep a one-page log of changes.
• Cut your worst market for one week. See if results improve.

Week 4

• Do a full monthly review.
• Set next month goals: one A/B test, one market to grow, one to pause.
• Back up your sheet and export a CSV copy.

How to log promos, free bets, and boosts

• Mark the bet as “promo” in notes.
• Track the real cost. Free bets often pay only profit, not stake.
• Note rollover rules if any.
• Keep ROI with and without promos so you can see real edge.

Quick odds format tips

Pick one odds format in your sheet. If you must convert, use a trusted tool or write small helper cells.

• American to decimal: if +X, then 1 + (X/100). If −X, then 1 + (100/X).
• Decimal to implied chance: 1 ÷ decimal odds (for example 2.00 = 50%).

For a deeper read, see Wikipedia: Odds.

Choosing books and keeping clean data

Good books help you get fair odds and fast payouts. Bad books cause limits, delays, and stress. This skews your data and your mind. Keep notes on each book: limits, KYC time, payout speed, and odds quality. If a book often gives you worse closes, use it less. Keep a clean list of trusted sites, with your own notes.

Sample review checklist (copy this)

• Did I beat the close this week? If no, why?
• Which sport or market had the best ROI and CLV?
• Which book gave me the best prices?
• Did I follow bankroll rules and stop-loss?
• One thing to stop next week:
• One thing to try next week:

Responsible gambling and legal note

Only bet if you are 18+ (or your local legal age). Set limits. Take breaks. If you feel you must bet, or you hide betting from your friends or family, seek help now. Helpful resources: BeGambleAware, NCPG, GamCare. Check your local laws and the rules of your regulator (for example, the UK Gambling Commission).

Resources and next steps

• ROI basics: Investopedia
• CLV explainer: Pinnacle
• Kelly primer: Wikipedia
• Pivot tables: Microsoft, Google
• Compare odds quality, limits, and payout speed (Norway): casino pÃ¥ nett Norge
• Regulator advice: UKGC consumer guide

Final tip: small, steady steps win. Track every bet. Review every week. Make one clear change each month. Your data will guide you.

FAQ

What is the best way to track bets: a sheet or an app?

A sheet is free, clear, and easy to audit. An app is fast and can auto-calc CLV. If you use an app, export your data often. If you use a sheet, back it up to cloud and a USB.

How many bets do I need before ROI means something?

It depends on odds and variance. A common rule is 200–300 bets for a first read. For props and long odds, you may need more. Use rolling ROI and CLV to see early signs.

What is a “good” CLV?

There is no fixed number. But beating the close by even 1–2% on average is a strong sign. Focus on the process: find better lines earlier, and avoid bad steam chases.

Should I use Kelly staking?

Only if you have a tested edge and accept big swings. Most rec bettors should not use full Kelly. If you try it, use half or quarter Kelly. Keep strict stop-loss rules.

How do I track free bets, boosts, and promos?

Mark them in notes. Track ROI with and without promos. For free bets, log only the profit, not the stake return. Note any rollover rules that change real value.

How do I handle losing streaks?

Expect them. Keep unit size small. Review your CLV and mistakes. If CLV is fine, the streak may be variance. If CLV is bad, your price picking needs work. Take a break if you feel tilt.