The One Metric I Track Every Week, CLV
For my first two years I tracked profit and loss. I was wrong to do that. Profit lies for weeks at a time; it can pay a losing strategy and punish a winning one over any sample short enough to matter. Since 2021 I have tracked closing line value instead, and for the first time my weekly numbers actually tell me if I am betting well.
What CLV really is
Closing line value is the ratio between the odds I took and the odds the market settles at when the match starts. If I backed a team at 2.15 and Pinnacle closed at 2.00, I beat the market by 7.5 percent on that slip. Over hundreds of bets, that gap is the only honest measure of whether my reasoning is ahead of the money. Everything else, especially short term P/L, is noise.
How I compute it, on every slip
- Log the taken odds the second I place the bet, straight into my spreadsheet.
- At kick off, I pull the Pinnacle price from a bookmarked tab. If the market has moved in my favour, CLV is positive.
- The formula I use: CLV = (taken_odds / closing_odds) minus 1. So 2.15 on a 2.00 closer gives 0.075, that is plus 7.5 percent.
- Weekly roll up, I average CLV across every settled slip of the week, weighted by stake.
What the curve looks like after 200 bets
My 2024 season. CLV trends up steadily. Bankroll P/L zig zags, converges to the CLV curve after week 20.
| Week | Rolling CLV (%) | Bankroll P/L (%) |
|---|---|---|
| 1 | 0.4 | -0.8 |
| 4 | 0.9 | 0.2 |
| 8 | 1.1 | -1.1 |
| 12 | 1.4 | 0.6 |
| 16 | 1.2 | 1.4 |
| 20 | 1.8 | 0.9 |
| 24 | 2.0 | 2.3 |
| 28 | 1.9 | 1.8 |
| 32 | 2.2 | 2.7 |
Notice the gap. Week 8 had a losing bankroll curve, but my CLV was already positive. By week 32 both curves had converged. That is the whole point of the metric, it tells me I am betting well long before the spreadsheet shows a profit.
The spreadsheet template, in ten fields
My sheet has exactly ten columns. Date, match, market, taken odds, stake, sharp closing odds, CLV percent, settled result, P/L, weekly tag. Nothing else. Each row is one slip, copy pasted from my broker interface. I export to CSV every Sunday and recompute weekly averages with a single pivot. If you want the file, use the contact page and I will send the blank version.
Only count your own stake weighted CLV, not the feed's
Most tracking tools report unweighted CLV across all tipster picks. My sheet weights by actual euros risked, because a 2 percent CLV on a 300 euro slip is worth far more than the same 2 percent on a 10 euro slip. This one change flagged two of my markets as secretly unprofitable and rescued my ROI by roughly 1.3 percent per month.
Never use a soft bookmaker's closing line as your reference. Soft books keep stale prices on purpose and cap winners in seconds, so the closing number is a fiction. I tried that in 2021 and my CLV looked like plus 4 percent while my bankroll leaked for eight months.
Read CLV weekly, not daily
Daily CLV is meaningless; one match drives the number and you will chase ghosts. Weekly is the smallest unit I trust. Monthly is better. If your rolling four week CLV is positive and stable, keep betting the same way even through a losing run, because the math is already on your side. If it sits at zero after 300 bets, your process is not working regardless of the P/L, and it is time to look at which markets you are betting instead of blaming variance.
Frequently asked
How many bets do I need before CLV means anything?
In my experience, the noise clears around 300 settled bets. Below that number, a hot streak of high CLV can still land negative profit and a cold streak of positive CLV looks like a losing strategy. Patience is part of the method.
Which closing line do I use, soft or sharp?
Use a sharp book like Pinnacle at the moment of kick off. Soft books keep stale prices and cap winners, so their closing line is a distorted mirror. If you cannot access a sharp book, use the average of two or three reputable odds comparison feeds.
Is positive CLV a guarantee of profit?
Not in isolation. It is the strongest single predictor I know of, but you still need disciplined stake sizing and surviving accounts. I have logged 500 bet samples at positive CLV that finished negative because of variance. Keep betting, the profit catches up.