A team can advance from a knockout tie without winning the match in regular time. That distinction matters when a historical odds record is joined to a results file. A column labelled “winner” may be accurate for qualification but wrong for the market being studied.
Identify the football outcome before the market outcome
IFAB Law 7 describes the duration of a match and allowance for time lost. Law 10 covers methods of determining the outcome. Time added at the end of a half and additional periods of extra time are different concepts. Treating both as a generic “extended match” category obscures which score belongs in the analysis.
The settlement of a betting market is governed by the relevant provider's market rules. IFAB's Laws explain football; they are not the settlement terms for a specific betting product. Retain the market description rather than inferring its scope from a short label such as “match winner”.
One fictional fixture, three separate records
Imagine a single-leg knockout match that ends 1–1 after regular time. The home team scores during extra time and the match finishes 2–1. The regular-time result is a draw, the score after extra time favours the home team, and the home team qualifies. These records describe different questions even though they concern the same fixture.
In another scenario, a tie could proceed to penalties. Keep the shoot-out result separate from the goals scored during play. Automatically adding shoot-out kicks to a match-goals column would distort a totals study. The analyst needs the definition of the score field, not just its numerical value.
Design the archive around distinct fields
- Home and away goals at the end of regular time
- Score after extra time, where applicable
- Penalty shoot-out result, where applicable
- Qualifying team and competition format
- Scope of the quoted market and the source of its settlement terms
Not every field applies to every match. An extra-time field should distinguish “not played” from “unknown”. Filling both with zero can imply that a phase took place when it did not. For two-leg ties, qualification also depends on information from the other leg; the current match score is not a complete description of the tie.
Audit the join, not just the final percentage
Before publishing an aggregate result, trace a small selection of knockout fixtures back to their source scores and market definitions. Check the phase represented by the result field, the competition format and whether the quote covers that same phase.
If the scope remains unresolved, report why the record was excluded. Adding more fixtures cannot fix a mismatch between the question priced by the market and the outcome supplied by the results file. A smaller, clearly defined comparison can be more informative than a large table built from incompatible labels.
Sources and method
Calculations and scenarios are original teaching examples, not observed match data, product performance or predictions. Sources support the stated concepts and methods. This article was prepared with AI assistance; sources and calculations were checked.
- IFAB: Law 7, the duration of the match — accessed 14 September 2026
- IFAB: Law 10, determining the outcome — accessed 14 September 2026