CS2 Bet Tracker: How to Log Your Bets and Actually Learn From Them
Updated · 
Written by Lena Ortiz ·
Ask anyone who's bet on CS2 for a while how they're doing and you'll hear "about even" or "a bit up, I think." Ask to see the numbers and it gets quiet. That's not a dig, bro. It's just how memory works: you remember the 4.50 underdog that came in and forget the six favourites that didn't. A bet tracker fixes that. It's the most boring tool in betting and the most useful one.
This guide shows you how to set up a CS2 bet tracker in about fifteen minutes using a free spreadsheet, which columns to include, the formulas that turn a list of bets into real insight, and how to read the results honestly. No paid app needed.
Quick reminder: tracking won't turn betting into a reliable income. For most people, a tracker mainly shows how much the bookmaker's margin costs them. That's valuable to know.
Why track your CS2 bets at all?
- You find out your real result. Not the one in your head, the actual one.
- You see where you leak money. Maybe match winner is fine but live bets or pistol rounds are a disaster.
- You learn whether your reads are good. Closing line value (more on that below) tells you this long before your profit does.
- It slows you down. Having to write a bet down makes you think about it, which cuts impulse bets.
- It's an early warning. If the losses column is growing faster than you're comfortable with, you see it in black and white.
Setting up the spreadsheet
Open Google Sheets, Excel or any free spreadsheet app. Make one tab called "Bets" and add these columns across the top row.
| Column | Example | Why it matters |
|---|---|---|
| Date | 2026-11-24 | Spot patterns by day or time |
| Event | PGL Major Singapore | Compare big events to small ones |
| Match | Team A vs Team B | Basic record |
| Format | Bo3 | Bo1 results behave very differently |
| Market | Map handicap | Your strongest and weakest markets |
| Pick | Team A -1.5 | What you actually bet |
| Book or site | Where you placed it | Compare prices and payouts |
| Odds (decimal) | 2.10 | Used in every formula |
| Stake | 10 | Exact amount risked |
| Result | W / L / V / HW / HL | Won, lost, void, half-won, half-lost |
| Profit | 11.00 | The money, plus or minus |
| Closing odds | 1.95 | The last price before the start |
| Live? | Y / N | Pre-match vs in-play results |
| Notes | Stand-in for Team B | Why you bet it |
If you bet with skins or crypto, add a "Currency" column and a "Value in [your currency]" column. Record the value on the day you bet, so price moves in skins or coins don't muddy your betting results.
The formulas that do the work
Assume odds are in column H, stake in column I and result in column J. These work in Google Sheets and Excel.
Profit per bet (column K):
For a simple version that handles wins, losses and voids:
=IF(J2="W", I2*(H2-1), IF(J2="L", -I2, 0))
If you use half-won and half-lost results (common with Asian handicaps), extend it:
=IF(J2="W",I2*(H2-1),IF(J2="L",-I2,IF(J2="HW",I2*(H2-1)/2,IF(J2="HL",-I2/2,0))))
Closing line value per bet (new column, say O):
=H2/L2-1
where L is your closing odds. A positive number means you got a better price than the market's final view.
Now add a second tab called "Summary" with the totals below.
The summary numbers
| Metric | Formula idea | What it tells you |
|---|---|---|
| Bets placed | COUNT of stakes | Sample size |
| Total staked | SUM of stakes | How much you've risked |
| Total profit | SUM of profit | The bottom line |
| ROI / yield | Profit / staked x 100 | Return per unit staked |
| Hit rate | Wins / (wins + losses) | How often you're right |
| Average odds | AVERAGE of odds | What kind of bettor you are |
| Implied hit rate | AVERAGE of 1/odds | How often you need to be right |
| Average CLV | AVERAGE of CLV column | Whether your prices beat the close |
Many people use "ROI" and "yield" to mean the same thing for bets: profit divided by total staked. Some use ROI to mean profit compared to the starting bankroll instead. Pick one definition and stick to it so your numbers stay comparable month to month.
Reading your numbers honestly
Hit rate means nothing on its own
Winning 60% of your bets sounds great. But if your average odds are 1.50, you need to win about 67% just to break even, because 1 divided by 1.50 is 0.667. Always compare your hit rate with your implied hit rate (the average of 1 divided by your odds). Beating the implied rate is what matters, not the raw percentage.
Profit is noisy, CLV is less noisy
Over a few dozen bets, results are mostly luck. A couple of upsets either way can swing you from looking brilliant to looking terrible. Closing line value settles down much faster. If your bets consistently get better odds than the closing price, it suggests you're spotting things before the market does. If your CLV is consistently negative, you're usually betting after the value has gone.
Sample size
Don't decide you've "cracked" a market after twenty bets. Treat anything under a few hundred bets as an early read. Keep tracking.
Claim free cases on Clash.gg, no code needed
Split your results the CS2 way
The real insight comes from filtering. CS2 has some quirks that make certain splits really revealing. Use your spreadsheet's filter or a pivot table on these columns:
- Format (Bo1 vs Bo3 vs Bo5). Most bettors find Bo1 results far more random. If your Bo1 numbers are much worse, that tells you something about where to cut back.
- Market. Match winner, map handicap, total maps, map winner, round totals, props. Few people are good at all of them.
- Pre-match vs live. Live betting feels skilful but often loses most, because it's fast and emotional.
- Event tier. Majors and big tournaments vs smaller online events. Some bettors do better where information is plentiful; some do better in lower tiers where prices are softer.
- Favourite vs underdog. Split by odds bands: under 1.50, 1.50 to 2.20, over 2.20.
- Day and time. Late-night bets after a long session often show worse results. If yours do, set a stop time.
- Book or site. Compare the average odds you got at each place for similar bets.
A simple monthly review
Once a month, spend twenty minutes on this:
- Check total profit, ROI and average CLV for the month and all time.
- Find your worst market and worst format. Ask whether you'd be better off not betting them.
- Find your best market. Is the sample big enough to trust? If not, keep tracking before staking more on it.
- Look at your biggest losing day. What happened? Chasing? Too many live bets? Note it.
- Check your stakes stayed consistent. If stakes jump after losses, that's chasing, and the tracker just caught it.
- Write one rule for next month. "No Bo1 handicaps," "max three live bets a day," whatever the data says.
Using the tracker during a Major
Majors are where trackers earn their keep. There are so many matches across three weeks that it's easy to lose count. Before the event, add a filter or a separate tab for it, set your event budget at the top and add a "remaining budget" cell that subtracts your stakes. When it hits zero, you're done for the event. Our guide on where to bet on the CS2 Major covers the format and timing if you're planning for the next one.
CSGOEmpire match betting + free case with FREECASES4U
Tracking skin and case results too
If you also open cases or play skin site games, you can track those in a separate tab with simpler columns: date, game, amount in, amount out. Keep it separate from match betting because the maths is different. Casino-style games have a fixed house edge, so there's no "edge" to find; the tab is purely there to show what the entertainment is costing you. That's honestly the most useful number a lot of players never look at.
Apps vs spreadsheets
There are bet tracking apps that pull in bets automatically from some books, draw charts and calculate everything for you. They can be handy if you bet a lot across several big sportsbooks. But:
- They often don't support skin sites or smaller crypto books, so you end up entering those by hand anyway.
- Some charge a subscription for the useful features.
- You hand over your betting history to another company.
A spreadsheet is free, works with every site and keeps your data yours. Start there. Switch to an app later if you really need it.
Common tracker mistakes
- Not logging losing bets. The whole point is the truth. Log everything.
- Logging late. Enter each bet when you place it, not at the end of the week from memory.
- Mixing currencies. Convert to one currency on the day.
- Ignoring voids. Log them with zero profit; they still count in your bet count.
- Changing definitions. Decide how you calculate ROI once and keep it.
- Only looking at profit. Check CLV and the market splits.
Handy tools to go with your tracker
- Our esports odds calculator converts odds and shows implied probability.
- Our esports parlay calculator shows how fast margins stack up across legs.
- CS2 betting odds explained covers decimal, American and fractional odds.
When the tracker tells you to stop
Sometimes the honest result is that you're losing steadily and the losses are more than you're happy with. That's the tracker doing its job. Lower your stakes, take a few weeks off, or stop betting altogether. If you find that hard, that's a sign to talk to someone. Our responsible gambling page lists free, confidential support.
Want the basics of how a CS2 bet works from start to payout? Read how betting on CS2 works.