Import MLB Historical Props

Fetch historical player prop lines from The Odds API (baseball_mlb) and store them as MLBPropLine records for the backfill grading system.

Configuration

Each date costs ~1 + N API requests (1 for events + 1 per game). Check your Odds API quota before importing large ranges.

Start Date

End Date

Prop Markets (12 selected)

Batter Hits

Batter Total Bases

Batter Home Runs

Batter RBIs

Batter Runs Scored

Batter Walks

Batter Stolen Bases

Batter Strikeouts

Pitcher Strikeouts

Pitcher Earned Runs

Pitcher Hits Allowed

Pitcher Walks Allowed

Sportsbooks (1 selected)

DraftKings

FanDuel

BetMGM

Caesars

ESPN Bet

Leave all unchecked to fetch from all available books (more API cost per game).

How It Works

1. For each date, the function fetches the MLB schedule from The Odds API historical events endpoint.

2. For each game, it fetches historical player props for the selected markets and sportsbooks.

3. Props are deduplicated against existing MLBPropLine records and inserted as new rows with is_active: false.

4. Run the MLB Historical Backfill afterwards to grade these props against actual box score results.

⚠️ The Odds API free tier has limited monthly requests. Each date costs ~1 + (number of games) API calls. ~15 games/day = ~16 calls per date.

Bosh Roid