Closing Line Value (CLV)

Aggregate Closing Line Value statistics for SharpAPI’s graded +EV predictions. For every +EV opportunity the engine flags, the system later captures the sharp reference’s closing line and grades the pick against it — this endpoint serves those grades, aggregated along the dimension you choose (group_by), together with realized win/loss outcomes where the game result is known.

GET /api/v1/historical/odds/clv

How CLV is computedPermalink for this section

When an event transitions from pre-match to live, the platform captures each book’s last pre-match price as that event’s closing line. The closing price of the sharp reference (devig_book — typically Pinnacle) is devigged with the Power method to a no-vig closing probability, and each graded prediction is scored as:

CLV% = (closing_no_vig_prob × entry_decimal_odds − 1) × 100

where entry_decimal_odds is the price at the moment SharpAPI flagged the opportunity. Positive CLV means the flagged price beat the close — you could have bet at better odds than the market’s final fair value implied.

Data is served from the historical ClickHouse store. Aggregates are computed over logical predictions — repeated price snapshots of the same pick (same event, market, selection, book, line) are collapsed into one row before counting, so a pick that was re-observed at several prices is not counted multiple times.

Query ParametersPermalink for this section

History windowPermalink for this section

This endpoint is Enterprise-only, and the Enterprise history window is unlimited (meta.tier_window_days = "unlimited"). from defaults to 7 days ago when omitted; there is no enforced upper bound on how far back you can query.

CLV history starts on 2026-09-11 (08:17 UTC). Earlier picks are not served, so a from/to window that ends before that date returns an empty groups array rather than an error.

Example RequestsPermalink for this section

# CLV by sportsbook for the past 7 days
curl -X GET "https://api.sharpapi.io/api/v1/historical/odds/clv?group_by=sportsbook" \
  -H "X-API-Key: YOUR_API_KEY"
 
# Pinnacle-referenced CLV only, grouped by sport
curl -X GET "https://api.sharpapi.io/api/v1/historical/odds/clv?devig_book=pinnacle&group_by=sport" \
  -H "X-API-Key: YOUR_API_KEY"
 
# Day-by-day CLV for DraftKings picks over a date range
curl -X GET "https://api.sharpapi.io/api/v1/historical/odds/clv?sportsbook=draftkings&group_by=day&from=2026-09-14&to=2026-09-21" \
  -H "X-API-Key: YOUR_API_KEY"

const params = new URLSearchParams({
  devig_book: 'pinnacle',
  group_by: 'sportsbook',
});
const response = await fetch(
  `https://api.sharpapi.io/api/v1/historical/odds/clv?${params}`,
  { headers: { 'X-API-Key': 'YOUR_API_KEY' } }
);
const { data } = await response.json();
for (const group of data.groups) {
  // avg_clv_percent, avg_ev_percent, and win_rate are null when a group
  // has no graded / no settled rows — guard before formatting.
  const clv = group.avg_clv_percent !== null
    ? `${group.avg_clv_percent.toFixed(2)}%`
    : 'n/a';
  const wr = group.win_rate !== null
    ? `${(group.win_rate * 100).toFixed(1)}% over ${group.wins + group.losses} settled`
    : 'no settled bets';
  console.log(`${group.group_key}: avg CLV ${clv} (${group.total_graded} graded), win rate ${wr}`);
}

import requests
 
response = requests.get(
    'https://api.sharpapi.io/api/v1/historical/odds/clv',
    params={'devig_book': 'pinnacle', 'group_by': 'sportsbook'},
    headers={'X-API-Key': 'YOUR_API_KEY'},
)
payload = response.json()
for group in payload['data']['groups']:
    # avg_clv_percent / avg_ev_percent / win_rate are None when a group has
    # no graded / no settled rows — guard before formatting.
    clv = (
        f"{group['avg_clv_percent']:.2f}%"
        if group['avg_clv_percent'] is not None else 'n/a'
    )
    settled = group['wins'] + group['losses']
    wr = (
        f"{group['win_rate'] * 100:.1f}% over {settled} settled"
        if group['win_rate'] is not None else 'no settled bets'
    )
    print(f"{group['group_key']}: avg CLV {clv} "
          f"({group['total_graded']} graded), win rate {wr}")

ResponsePermalink for this section

Success (200)Permalink for this section

{
  "success": true,
  "data": {
    "date_range": {
      "from": "2026-10-07T09:53:31.881",
      "to": "2026-10-14T09:53:31.881"
    },
    "group_by": "sportsbook",
    "groups": [
      {
        "group_key": "matchbook",
        "total_graded": 7585,
        "wins": 4846,
        "losses": 4105,
        "win_rate": 0.541392023237627,
        "avg_clv_percent": -1.4250430370269482,
        "avg_ev_percent": 1.3196234670527511,
        "total_predictions": 10039
      },
      {
        "group_key": "sx_bet",
        "total_graded": 7310,
        "wins": 3423,
        "losses": 3290,
        "win_rate": 0.5099061522419187,
        "avg_clv_percent": -0.4994217699214386,
        "avg_ev_percent": 1.0263501475197079,
        "total_predictions": 7414
      }
    ]
  },
  "meta": {
    "filters": {
      "devig_book": null,
      "group_by": "sportsbook",
      "league": null,
      "sport": null,
      "sportsbook": null
    },
    "groups_limit": 500,
    "groups_total": 52,
    "groups_truncated": false,
    "source": "clickhouse",
    "tier_window_days": "unlimited",
    "updated_at": "2026-10-14T08:50:20Z"
  }
}

This sample answers a request with no parameters (group_by=sportsbook over the last 7 days), captured on 2026-10-14 and shortened to the first two of its 52 groups. The meta block is unedited, so groups_total still counts all 52.

An empty groups array is a valid response when no graded predictions exist for the requested filters and date range — not an error.

One response carries at most meta.groups_limit (500) groups, and the endpoint has no limit, offset or cursor. Groups are ordered by total_graded, highest first, with ties broken by group_key. That holds for group_by=day too, so sort by group_key yourself if you need a time series. When more groups qualify than the cap allows, the response holds the first 500 in that order, meta.groups_total reports how many qualified, and meta.groups_truncated is true. In practice only group_by=league over a window of several weeks reaches the cap; narrow the window or filter by sport to see the rest.

Error ResponsesPermalink for this section

403 Tier Restricted

{
  "error": {
    "code": "tier_restricted",
    "message": "This endpoint requires Enterprise tier or higher",
    "docs": "https://sharpapi.io/pricing",
    "tier": "pro",
    "required_tier": "enterprise"
  }
}

400 Validation Error

{
  "error": {
    "code": "validation_error",
    "message": "Invalid group_by. Must be one of: day, devig_book, league, market, sport, sportsbook"
  }
}

Response FieldsPermalink for this section

data objectPermalink for this section

Group row fieldsPermalink for this section

meta objectPermalink for this section

Interpreting CLVPermalink for this section

Related EndpointsPermalink for this section

• Closing Odds — Per-event raw closing prices (Pro tier and up)
• Closing Odds by Date — Historical per-event closing prices for a given date
• +EV Opportunities — Real-time positive expected value bets
• Odds Snapshot — Current pre-match and live odds