What Is CLV in Sports Betting? Closing Line Value Explained

Win rate and P&L are the numbers most bettors watch. They're not useless, but they're noisy — over a short sample, they tell you more about variance than about your actual ability to find value. Closing line value cuts through the noise. It's the metric professional bettors and syndicates actually use to evaluate performance, and it's the one most recreational bettors have never set up in their bet tracker.

This is how CLV works, why the closing line is the right benchmark, how to calculate it, and how to add it to your spreadsheet.

What Is CLV?

Closing line value is the difference between the odds you got when you placed your bet and the odds the market closed at — meaning the price posted right when the game started.

Say you bet a team at +150 on Monday morning. By game time Sunday, the line has moved to +130. You got a better price than the closing line. That's positive CLV — you found value before the market corrected.

The reverse also applies. If you bet a team at -110 and the line closes at -130, the market moved against you. You got a worse price than the closing line. That's negative CLV, and it means you were on the wrong side of where sharp money moved.

Why the Closing Line Is the Right Benchmark

The closing line isn't arbitrary. It reflects the aggregate judgment of the sharpest bettors in the world, after all the information available before game time has been processed by the market.

When sharp money hits a line, sportsbooks adjust immediately. A big bet from a known winning player on one side will push the line several points within minutes. Over the course of a week, the market ingests sharp action from hundreds of syndicates and professional bettors. By the time the game starts, the closing line is the most accurate probability estimate the betting market can produce.

This is why the closing line is the benchmark. If you consistently get better odds than the closing price, you're consistently finding value before the sharps do — or betting alongside them before the line moves. Either way, you're buying value. Over a large enough sample, that's the definition of a real edge.

Conversely, if you're consistently losing to the closing line — getting odds that the market later prices worse — you're systematically buying at retail while selling at wholesale. Your win rate might look fine for a while, but the long-term result is mathematically predictable.

The CLV Formula

CLV is cleanest when calculated in decimal odds, so you'll need to convert from American odds first.

Converting American odds to decimal:

• Positive American (e.g. +150): Decimal = (American / 100) + 1 → +150 becomes 2.50
• Negative American (e.g. -110): Decimal = (100 / |American|) + 1 → -110 becomes 1.909

CLV% formula:

CLV% = (Decimal(YourOdds) / Decimal(ClosingOdds) − 1) × 100

Worked example: You bet at +150 (2.50 decimal). The line closes at +130 (2.30 decimal).

CLV% = (2.50 / 2.30 − 1) × 100 = +8.7%

You got 8.7% more expected value per dollar than the closing price offered. That's a meaningful edge on a single bet.

Now reverse it: you bet at +130 (2.30 decimal), line closes +150 (2.50 decimal).

CLV% = (2.30 / 2.50 − 1) × 100 = −8.0%

Negative CLV. The market moved in the opposite direction, meaning you bet against where value ended up.

How to Track CLV in Your Spreadsheet

Adding CLV tracking to an existing bet tracker spreadsheet requires three things: a Closing Odds column, a decimal conversion helper, and a CLV% formula column.

Here's the exact setup, using American odds throughout:

1. Add a "Closing Odds" column. After your Odds column (say column F), add a new column G labelled "Closing Odds (American)". After each game starts, go back to your sportsbook or an odds archive and record the final pre-game line.
2. Add decimal conversion helper columns. In column H ("Your Odds Decimal"), enter this formula in H2:
   =IF(F2>0, F2/100+1, 1+100/ABS(F2))
   In column I ("Closing Odds Decimal"), apply the same formula referencing column G:
   =IF(G2>0, G2/100+1, 1+100/ABS(G2))
3. Add a CLV% column. In column J ("CLV%"), enter:
   =(H2/I2-1)*100
   This returns your CLV as a percentage. Positive = you beat the close. Negative = line moved against you.

Once set up, drag all three formulas down the full column. You can hide columns H and I if you want a cleaner view — they'll still calculate in the background.

What Positive CLV Looks Like Over Time

Here's something important to understand: in the short run, CLV is noisy. Over your first 50 or 100 bets, you can have consistently positive CLV and still be down on P&L due to variance. The opposite is also true — you can have negative CLV and be running hot.

This is not a flaw in CLV as a metric. It's a reflection of how variance works in sports betting. A single outcome is almost entirely luck. The edge shows up across hundreds of bets.

The rough sample thresholds:

• Under 200 bets: CLV gives directional signal but conclusions are premature. Don't over-index on it.
• 200–500 bets: A clear pattern starts to emerge. Sustained positive CLV is encouraging; sustained negative CLV is a warning sign.
• 500+ bets: Sustained positive CLV at this sample size is strong evidence of a real edge. This is where CLV separates skilled bettors from lucky ones.

The practical implication: start tracking CLV now, even if your sample is small. The data compounds. You can't go back and reconstruct closing lines from memory — you have to capture them at the time.

The Tracking Challenge

There's one unavoidable friction point in CLV tracking: you have to record the closing odds for every bet. That means going back to your sportsbook (or an odds archive) right around game time to capture the final pre-game line, then entering it in your spreadsheet.

If your bet logging is spotty, your CLV calculation is worthless. You need complete data — every bet logged with its original odds — for the CLV% column to give you an accurate picture. A cherry-picked sample of your "best" bets will show flattering CLV that means nothing.

This is why accurate initial logging matters so much. S2S Bets handles that part automatically — every bet gets logged from your screenshot the moment you place it, with the exact odds captured. You just need to add the closing odds column when you settle the bet. The Google Sheets guide covers how to structure the full tracking workflow.