Excel Iddaa Programi Yapma -
Now we move to a second sheet: Calculations. Here, we transform raw data into insights.
A) Attack & Defense Strength (Poisson Distribution Basis)
First, calculate league averages:
=AVERAGE(RawData!E:E) → League average home goals
=AVERAGE(RawData!F:F) → League average away goals
Then, for each team:
Home Attack Strength = (Team's home goals per match) / (League avg home goals)
Home Defense Strength = (Team's home goals conceded per match) / (League avg away goals)
B) Expected Goals for a Future Match
If Galatasaray (attack strength 1.25) hosts Fenerbahçe (defense strength 0.90):
Expected Home Goals = League avg home goals * Home Attack Strength * Away Defense Strength
This gives you a decimal (e.g., 1.84).
C) Converting xG to Match Outcome Probabilities
Using the Poisson distribution (Excel function POISSON.DIST):
Home Win Probability = POISSON.DIST(0, Expected_Away_Goals, TRUE) * (1 - POISSON.DIST(0, Expected_Home_Goals, TRUE)) ...
Simplified practical formula for Excel:
=1 - POISSON.DIST(Home_Goals_Threshold, Expected_Home_Goals, TRUE)
(You'll need a full probability matrix for 0-5 goals from both sides). excel iddaa programi yapma
D) Value Betting Indicator
Once you have your calculated probability (e.g., 45% for home win), compare to the bookmaker's implied probability:
Implied Probability = 1 / Decimal Odds
Value = Calculated Probability - Implied Probability
If Value > 5-10%, that is a value bet. Highlight it in green.
Before we open a single spreadsheet, let's address the psychology of betting. The human brain is terrible at calculating probability. We suffer from recency bias (thinking a team will win because they won last week) and confirmation bias (only remembering the bets we won).
An Excel program solves this by acting as a cold, hard mirror.
Benefits of an Excel system:
This is where you enter daily matches.
=EĞER(J2="1"; B2; EĞER(J2="0";C2; EĞER(J2="2";D2; "")))
(Not: B2=MS/1, C2=MS/0, D2=MS/2) 3. Toplam Oran ve Kazanç: Kuponun toplam oranını hesaplamak için K sütunundaki tüm oranları çarpın. Bunun için ÇARPIM (PRODUCT) fonksiyonunu kullanın:
=ÇARPIM(K2:K10)
Basılacak miktarı (örneğin 10 TL) bu oranla çarparak Potansiyel Kazanç'ı bulun.
Open a new Excel workbook. You will need three main sheets (tabs) at the bottom: Now we move to a second sheet: Calculations
Write a small VBA macro that scans the Value column and sends a pop-up message when a +10% value bet is found.
By building this yourself, you gain a better understanding of probability and can customize the tool exactly to your betting strategy (e.g., focusing only on Over/Under or specific leagues).
The core of your program is getting fresh data. Instead of manual entry, use Excel's Power Query to pull "İddaa Programı" lists directly from sports websites.
Web Import: Use Data > Get Data > From Web to link to a live odds table.
Auto-Refresh: Set the connection properties to refresh every 60 minutes or upon opening the file. 2. Analysis & Prediction Features
Once you have the data, add these "smart" columns to evaluate matches:
Percentage Breakdown: Convert decimal odds into implied probability using
The "Value" Indicator: Create a formula that compares your calculated probability against the bookmaker's odds.
Formula Example: IF(My_Prob > Implied_Prob, "VALUE", "PASS")
Form Analysis: Use a VLOOKUP or XLOOKUP to pull the last 5 match results (W-D-L) for both teams from a separate "League Standings" sheet. 3. Dashboard & Filters A clean interface is vital for quick decision-making: Then, for each team: Home Attack Strength =
Slicer Filters: Insert Slicers for League, Match Time, and Minimum Odds to quickly narrow down the daily program. Conditional Formatting: Highlight "High Confidence" picks in green.
Highlight matches with dropping odds (indicating market movement) in red. 4. Advanced "Odds Filtering" (Oran Analizi)
Experienced users often filter by historical outcome based on specific odds.
Archive Matcher: Create a historical database of past results.
Search Feature: Use COUNTIFS to see how many times a match with exactly 1.45 - 3.20 - 4.50 odds resulted in a "Home Win" in the past 2 years. Recommended Layout Structure Match ID League Home vs Away Odds (1-X-2) AI Prediction Confidence % Premier League Arsenal vs Liverpool 2.10 - 3.40 - 3.10 Pro Tools for Your Draft
Microsoft Support: Learn to use Advanced Selection and CTRL+A to manage large data sets efficiently.
Yandex Video Guides: Watch step-by-step tutorials on Filtering Odds in Excel to refine your "Oran Analizi" logic.
Most amateur Excel programs fail because they focus on predictions, not stake sizing. Do not use the "Martingale" system (doubling after a loss)—it will bankrupt you after 5 losses.
Instead, program a Kelly Criterion or Fixed Percentage (1-5% of bankroll).
Formula for fixed stake (2% of current bankroll):
=ROUND(C1*0.02, -1)
Every time you enter a new bet, the stake auto-updates based on current bankroll size. When you are winning, stakes go up. When losing, stakes shrink naturally—protecting you.