calculations.matches_11_probability

Converts the last prematch decimal odds for each outcome into bookmaker-implied probabilities (1 / odd) and computes the bookmaker margin (overround). Inherits all upstream columns from matches_1_odds_prematch.

Lineage

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

Columns

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