Sports odds history in Google Sheets

A free Google Sheets add-on: type =ODDS_CLOSING("EPL"; "2024-2025") and get every game of the season with opening and closing odds and graded bets — 392,621 games across 38 leagues, plus Pinnacle closing lines, graded player props, arbitrage and value bets. One formula, no code, no CSV downloads.

Coming soon to the Google Workspace MarketplaceGet a free API key

Formulas

FormulaWhat it returns
=ODDS_CLOSING("EPL"; "2024-2025")Every game of a season: opening and closing odds, the market's probabilities and every bet already graded (1X2, totals, handicaps, both teams to score)
=ODDS_GAMES("NBA"; "2026-11-15")Games of a day, or of a date range, with scores and consensus odds
=ODDS_PINNACLE("2026-11-15"; "NBA")Pinnacle's opening and closing lines of a day — the benchmark for closing line value (CLV)
=ODDS_PROPS("2026-11-15"; "NBA")Pinnacle player props of a day: opening and closing line, the player's actual stat and the result
=ODDS_ARBITRAGE("ATP")Price gaps between bookmakers on coming games, with the stake split
=ODDS_VALUE("EPL")Prices above the fair (no-vig) odds of the other bookmakers on coming games
=ODDS_LEAGUES()Every league with its key, its seasons and how far back your plan reaches

Arguments are separated with a semicolon or a comma, depending on your spreadsheet's locale.

Start in a minute

  1. Install Sports Odds History from the Google Workspace Marketplace.
  2. Get a free key: subscribe to the Basic plan of the Sports Betting Odds & Arbitrage API on RapidAPI.
  3. In your sheet: Extensions → Sports Odds History → Set API key.
  4. Type =ODDS_LEAGUES() in any cell.

What your plan gives you in Sheets

PlanPriceRequests / monthSeasonsRequests for a whole EPL season
Basicfree500current and previous season38
Pro$9.99 / month10,0003 seasons4
Ultra$49 / month50,0008 seasons2
Mega$149 / month250,000everything (football since 2005, US sports and tennis since 2009)1

The add-on fetches every page of a season by itself; a larger plan only needs fewer requests.

FAQ

Is the add-on free?

Yes. The data comes from the Sports Betting Odds & Arbitrage API on RapidAPI, called with your own key. Its free Basic plan gives 500 requests a month; a whole Premier League season takes 38 of them on Basic and 4 on Pro.

What does the add-on access?

Only the spreadsheet you use it in — never your other files, email or contacts. Details in the privacy policy.

Where is my API key kept?

In Google's Apps Script storage, with the spreadsheet where you set it and with your account. It is sent only to RapidAPI, with each request. Extensions → Sports Odds History → Remove API key deletes it.

Does it place bets?

No. It is a data tool — odds, lines and results for analysis. It has no links to bookmakers and cannot place or settle bets.

Why are results cached?

History is kept for 6 hours and coming games for 5 minutes, so recalculating a sheet does not spend your plan's requests.

Privacy policy · Terms of service · Ask on the Discussions page of the API on RapidAPI or through the support link on the add-on's Google Workspace Marketplace page.