calculations.matches_11_probability

Converts the earliest captured 1×2 decimal odd for each outcome into bookmaker-implied probabilities (1 / odd) and computes the bookmaker margin (overround). Inherits all upstream columns from matches_1_odds.

Lineage

flowchart LR
m1[/matches_1_odds/] --> me[/calculations.matches_11_probability/]
me --> mart[/mart.matches/]
click m1 "/calculations/matches_1_odds/" "Open"
click mart "/mart/matches/" "Open"

Columns

Column	Description	Formula
* (matches_1_odds)	All upstream columns.	passthrough
prob_implied_home	Implied probability for the home win.	round(case when odds_home is null or odds_home <= 1 then null else 1.0 / odds_home end, 4)
prob_implied_draw	Implied probability for the draw.	round(case when odds_draw is null or odds_draw <= 1 then null else 1.0 / odds_draw end, 4)
prob_implied_away	Implied probability for the away win.	round(case when odds_away is null or odds_away <= 1 then null else 1.0 / odds_away end, 4)
odds_margin	Bookmaker overround = sum of implied probabilities − 1.	round((1/odds_home + 1/odds_draw + 1/odds_away) - 1.0, 4) (NULL when any odd is missing or ≤ 1)