Skip to content
Kelly
⌘K commands · ? keys

Lines and prices

A market at a moment: the consensus line, no-vig probability, hold, books counted and movement.

One row
market_id, moment · per snapshot
Stamped at
price time Join on this time to read only what was known.
Known at
At open (2) · Live (59) · After final (6)
Source
Sportsbook and odds feeds

Fields (67)

Operators: sport: dataset: role: known: grain: entity: type: in: status: -word "a phrase" name:/^opp_/. Try , , , , .

Matching (67) of (67) fieldsOrder: most widely usable, then name

Showing (67) of (67) · Fields

Formula nameLabelKnown atRoleSportsDatasetTypeGrain
best_pricesBest price per side (a book's own price)LivefeatureAny sportLines and pricesrecordsnapshot
betting_trendsA league season's betting trends: favourites and underdogs against the spread and straight up, home and away, home and road favourites, overs, primetime and favourites by spread band, each with its game count, wins, losses, pushes and share; finals with lines and whose closesAfter finalfeatureAny sportLines and pricesrecordseason
board_consideredBets with a consensus price on the day's boardLivefeatureAny sportLines and pricesnumbersnapshot
board_idBoard ID (brd_)LiveidentifierAny sportLines and pricesidsnapshot
board_match_countBets priced exactly at the asked priceLivefeatureAny sportLines and pricesnumbersnapshot
book_linksBooks' bet-slip deep linksLivefeatureAny sportLines and pricesrecordsnapshot
book_pricesPer-book pricesLivefeatureAny sportLines and pricesrecordsnapshot
books_countBooks in the consensusLivefeatureAny sportLines and pricesnumbersnapshot
break_evenBreak-even at the priceLivepriceAny sportLines and pricesprobabilitysnapshot
competitionMarket's competition (Kelly's slug)LivefeatureAny sportLines and pricesnumbersnapshot
consensus_lineConsensus lineLivepriceAny sportLines and pricesnumbersnapshot
edgeEdge (Kelly's estimate minus break-even)LivefeatureAny sportLines and pricesnumbersnapshot
edge_statusEdge status (edge, no_edge, not_validated, market_only)LivefeatureAny sportLines and pricesnumbersnapshot
edge_status_labelBrand label key for the edge status (voice.edge_status.*)LivefeatureAny sportLines and pricesnumbersnapshot
edge_status_price_basisWhich price edge_status is read at (user on askkelly.ai; always consensus off it)LivepriceAny sportLines and pricespricesnapshot
edge_status_reasonWhy this edge status (a stable code)LivefeatureAny sportLines and pricesnumbersnapshot
futuresThe board's competition, type, name, season, page, status, counts, paging and the competition's other boardsLivefeatureAny sportLines and pricesrecordsnapshot
futures_books_countBooks in the board's consensusLivefeatureAny sportLines and pricesnumbersnapshot
futures_historyEach day's no-vig chance per selection on the boardLivefeatureAny sportLines and pricesrecordsnapshot
futures_holdThe median of the books' holds on the boardLivepriceAny sportLines and pricesnumbersnapshot
futures_selectionsA team's or player's consensus price, implied and no-vig chance, rank, and move since open and over seven and thirty daysLivefeatureAny sportLines and pricesrecordsnapshot
game_idGame IDLiveidentifierAny sportLines and pricesidsnapshot
holdBooks' holdLivepriceAny sportLines and pricesnumbersnapshot
idMarket ID (mkt_)LiveidentifierAny sportLines and pricesidsnapshot
idSelection ID (sel_)LiveidentifierAny sportLines and pricesidsnapshot
implied_probImplied probability (vig-in)LivepriceAny sportLines and pricesprobabilitysnapshot
kelly_probKelly's probabilityLivepriceAny sportLines and pricesprobabilitysnapshot
kelly_prob_p1010th percentile of Kelly's estimateLivepriceAny sportLines and pricesprobabilitysnapshot
kindMarket kind (spread, total, moneyline, prop)LivefeatureAny sportLines and pricesnumbersnapshot
line_countsEach line the books hold now, with how many hold itLivefeatureAny sportLines and pricesrecordsnapshot
movementMovement since open (container)LivefeatureAny sportLines and pricesrecordsnapshot
movement_line_changeMovement since openLivepriceAny sportLines and pricesnumbersnapshot
movement_open_lineOpening consensus lineAt openpriceAny sportLines and pricesnumbersnapshot
movement_opened_atOpening timeLivedimensionAny sportLines and pricesdatetimesnapshot
nameMarket nameLivefeatureAny sportLines and pricesnumbersnapshot
nameSelection nameLivefeatureAny sportLines and pricesnumbersnapshot
no_vig_changeNo-vig probability move since openLivepriceAny sportLines and pricesnumbersnapshot
no_vig_probNo-vig probabilityLivepriceAny sportLines and pricesprobabilitysnapshot
offered_priceThe person's offered price, echoed in every formatLivefeatureAny sportLines and pricesrecordsnapshot
offered_price_americanOffered price, AmericanLivepriceAny sportLines and pricespricesnapshot
offered_price_centsOffered price, centsLivepriceAny sportLines and pricespricesnapshot
offered_price_decimalOffered price, decimalLivepriceAny sportLines and pricespricesnapshot
offered_price_fractionalOffered price, fractionalLivepriceAny sportLines and pricespricesnapshot
offered_price_implied_probOffered price's implied probabilityLivepriceAny sportLines and pricesprobabilitysnapshot
open_no_vig_probNo-vig probability at openAt openpriceAny sportLines and pricesprobabilitysnapshot
participant_idMarket participant ID (plr_ or tm_)LiveidentifierAny sportLines and pricesidsnapshot
participant_idSelection participant ID (plr_ or tm_)LiveidentifierAny sportLines and pricesidsnapshot
pointConsensus line for this sideLivefeatureAny sportLines and pricesnumbersnapshot
priceConsensus priceLivepriceAny sportLines and pricespricesnapshot
price_americanConsensus price, American oddsLivepriceAny sportLines and pricespricesnapshot
price_basisWhich price the break-even is at (user, consensus)LivepriceAny sportLines and pricespricesnapshot
price_board_dateThe local day the board is read forLivedimensionAny sportLines and pricesdatesnapshot
price_board_priceThe asked price in every format (arithmetic on the caller's own number)LivepriceAny sportLines and pricespricesnapshot
price_board_rowsThe bets nearest the asked price, nearest first; a row's market type, period and Wire topicLivepriceAny sportLines and pricespricesnapshot
price_board_timezoneThe time zone the day is read in (IANA)LivepriceAny sportLines and pricespricesnapshot
props_entriesOne game's player props for one stat: an entry per player market (props:{game_id}:{stat})LivefeatureAny sportLines and pricesnumbersnapshot
props_needsWhat the player still needs to pass the prop's line: the line less his game total so far, 0 once past itLivefeatureAny sportLines and pricesnumbersnapshot
props_nowThe player's game total so far for the prop's stat (summed for a combined stat)LivefeatureAny sportLines and pricesnumbersnapshot
selectionsEvery side of the market, in the market's orderLivefeatureAny sportLines and pricesnumbersnapshot
sheetThe sheet's week, editions, counts, byes, paging and linksAfter finalfeatureAny sportLines and pricesrecordweek
sheet_gameA game's number on the sheet, its teams, links and Wire topicsAfter finalfeatureAny sportLines and pricesrecordweek
sheet_implied_scoreEach team's implied points from the consensus spread and total (F4.12)After finalpriceAny sportLines and pricesnumberweek
sheet_linesA game's spread (favourite's side), total and moneyline at open, edition, now and close, with the move since open and key numbers crossedAfter finalfeatureAny sportLines and pricesrecordweek
sheet_resultA final game against the closing consensus: covered, push, over or underAfter finalfeatureAny sportLines and pricesrecordweek
sideSide (home, away, draw, over, under, yes, no)LivefeatureAny sportLines and pricesnumbersnapshot
statusConsensus status (ok, one_way, too_few_books, no_prices)LivefeatureAny sportLines and pricesnumbersnapshot
vs_marketKelly's estimate vs the no-vig marketLivefeatureAny sportLines and pricesnumbersnapshot