Use AVERAGEIFS to pull data from the Match Database. Example for home scoring average:
Introduction The Alt Üst (Over/Under) market is one of the most popular betting choices in Iddaa (Turkey’s state-run sports lottery). Instead of predicting the exact winner, you bet on whether the total number of goals in a match will be over or under a certain threshold—typically 2.5 goals.
Poisson probability for Over 2.5 = ~62% Bookmaker odds for Üst = 1.85 → Implied probability = 54%
This article provides a step-by-step guide to building your own Iddaa Alt Üst Excel system. | Bet Type | Meaning | Example (2.5 line) | |----------|---------|--------------------| | Alt (Under) | Total goals < 2.5 | 0-0, 1-0, 0-1, 1-1 | | Üst (Over) | Total goals > 2.5 | 2-1, 3-0, 2-2, etc. |
| A | B | C | D | E | F | G | H | |---|---|---|---|---|---|---|---| | Date | League | Home Team | Away Team | Home Goals | Away Goals | Total Goals | Alt/Üst (2.5) |
=IF(G2>2.5, "Üst", "Alt") | A | B | C | D | E | |---|---|---|---|---| | Team | Avg Goals Scored (Home) | Avg Goals Conceded (Home) | Avg Goals Scored (Away) | Avg Goals Conceded (Away) |
=AVERAGEIFS(MatchDB!E:E, MatchDB!C:C, A2) Then calculate for a fixture: