Cajetan

Predictive analytics for professional American sports

Getting Started

• Dependencies: node, docker, make
• make init: Installs dependencies. Migrates and seeds the database.

Database

Tables and Views

• ELO: Objective rankings per team with as of timestamp.
• Matchup: A competition between 2 teams. Includes start time, score, home team and links for matchup details.
• Odds: Moneyline and point odds for a given matchup. Several odds rows exist for a single matchup. Odds are updated throughout the course of a live matchup.
• Team: The moniker, location and league of a team.
• Team Search Term: A search term for a given team.
• ELO Matchup Probability: Whether or not the ELO rankings correctly predicted a matchup's result. Contains ELO ratings for the teams in the matchup and the diff of the team's ELO ratings.
• Moneyline Matchup Probability: Whether or not the closing moneyline correctly predicted the matchup's result. Contains implied probabilities (the moneyline odds converted to probability).
• Moneyline Probability: Whether or not a given moneyline correctly predicted the matchup's result. Contains implied probabilities (the moneyline odds converted to probability).

ENUMS

• League: NFL, NHL, NBA, MLB