Sports Betting API in Python

import os
from dotenv import load_dotenv
from sharpapi import SharpAPI

load_dotenv()
client = SharpAPI(api_key=os.environ["SHARPAPI_KEY"])

# Fetch current NBA moneylines from all sportsbooks
odds = client.odds.list(sport="basketball_nba", markets=["h2h"])

for event in odds.data:
    print(f"\n{event.home_team} vs {event.away_team}")
    print(f"Start: {event.commence_time}")
    for book in event.bookmakers:
        market = book.markets[0]
        for outcome in market.outcomes:
            print(f"  {book.title}: {outcome.name} {outcome.price}")

SPORTS = ["basketball_nba", "americanfootball_nfl", "icehockey_nhl", "baseball_mlb"]

for sport in SPORTS:
    odds = client.odds.list(sport=sport, markets=["h2h", "spreads"])
    print(f"{sport}: {len(odds.data)} events, "
          f"{sum(len(e.bookmakers) for e in odds.data)} book entries")

def best_moneyline(event, team_name: str) -> tuple[str, float]:
    """Return (sportsbook, best price) for a given team."""
    best_book, best_price = None, float("-inf")
    for book in event.bookmakers:
        for market in book.markets:
            if market.key == "h2h":
                for outcome in market.outcomes:
                    if outcome.name == team_name and outcome.price > best_price:
                        best_price = outcome.price
                        best_book = book.title
    return best_book, best_price

odds = client.odds.list(sport="basketball_nba", markets=["h2h"])
for event in odds.data:
    home_book, home_price = best_moneyline(event, event.home_team)
    away_book, away_price = best_moneyline(event, event.away_team)
    print(f"{event.home_team} best: {home_price} @ {home_book}")
    print(f"{event.away_team} best: {away_price} @ {away_book}")

import sqlite3
from datetime import datetime

conn = sqlite3.connect("odds_history.db")
conn.execute("""
    CREATE TABLE IF NOT EXISTS odds_log (
        id INTEGER PRIMARY KEY,
        event_id TEXT,
        sportsbook TEXT,
        market TEXT,
        outcome TEXT,
        price REAL,
        fetched_at TEXT
    )
""")

def log_odds(event):
    now = datetime.utcnow().isoformat()
    for book in event.bookmakers:
        for market in book.markets:
            for outcome in market.outcomes:
                conn.execute(
                    "INSERT INTO odds_log VALUES (NULL,?,?,?,?,?,?)",
                    (event.id, book.title, market.key,
                     outcome.name, outcome.price, now),
                )
    conn.commit()

odds = client.odds.list(sport="basketball_nba", markets=["h2h", "spreads"])
for event in odds.data:
    log_odds(event)
print(f"Logged {len(odds.data)} events")

from sharpapi.exceptions import RateLimitError, AuthenticationError

try:
    odds = client.odds.list(sport="basketball_nba")
except RateLimitError:
    # Free tier: 12 req/min. Retry after 1 second.
    import time
    time.sleep(1)
    odds = client.odds.list(sport="basketball_nba")
except AuthenticationError:
    print("Check your SHARPAPI_KEY. Get one at sharpapi.io/dashboard/api-keys")