The 3-Step Process for Poisson Betting Decisions
To use Poisson profitably, your job is not to memorize formulas. Your job is to build a repeatable process that turns a projection (λ) into an EV decision.
Key Insight
The edge usually comes from λ, not from Excel—books can run POISSON.DIST too. Your advantage is in estimating λ better than the market.
The Three Steps
Step 1: Estimate λ (The Expected Count)
Start with a baseline average, then adjust for:
- Matchup — Is the opponent weak or strong against this stat?
- Opportunity — Any changes to role, snap count, or usage?
- Game environment — Weather, pace, spread implications?
Example λ Estimation:
Base λ (season average): 0.75 TDs/game
× Recent form multiplier: 1.05 (hot streak)
× Matchup adjustment: 1.15 (weak defense)
× Game script adjustment: 1.10 (team favored)
= Final λ: 0.99 TDs/game
Step 2: Convert λ Into Probability
Use POISSON.DIST in Excel to calculate exact, under, or over probabilities:
Under a Half-Point Line
P(Under 0.5) = P(X = 0)=POISSON.DIST(0, λ, TRUE)Over a Half-Point Line
P(Over 0.5) = P(X ≥ 1)=1 - POISSON.DIST(0, λ, TRUE)Over Higher Lines (e.g., 7.5)
P(Over 7.5) = P(X ≥ 8)=1 - POISSON.DIST(7, λ, TRUE)Step 3: Compare to Market Implied Probability
Calculate the market's implied probability from the odds, then compare to your probability.
Converting American Odds to Implied Probability:
| Odds Type | Formula |
|---|---|
| Negative odds (e.g., -150) | 150 / (150 + 100) = 60.0% |
| Positive odds (e.g., +120) | 100 / (120 + 100) = 45.5% |
If your probability > market implied probability + vig margin, you have a candidate bet.
Putting It All Together: A Framework
Here's the complete decision framework in one view:
┌─────────────────────────────────────────────────────────┐
│ POISSON BETTING FRAMEWORK │
├─────────────────────────────────────────────────────────┤
│ │
│ STEP 1: ESTIMATE λ │
│ ┌───────────────────────────────────────────────────┐ │
│ │ Base Rate × Recent Form × Matchup × Game Script │ │
│ └───────────────────────────────────────────────────┘ │
│ ↓ │
│ STEP 2: CALCULATE PROBABILITY │
│ ┌───────────────────────────────────────────────────┐ │
│ │ Excel: =1-POISSON.DIST(threshold, λ, TRUE) │ │
│ └───────────────────────────────────────────────────┘ │
│ ↓ │
│ STEP 3: COMPARE TO MARKET │
│ ┌───────────────────────────────────────────────────┐ │
│ │ Your P(Over) vs. Market Implied → Edge? │ │
│ └───────────────────────────────────────────────────┘ │
│ ↓ │
│ DECISION: Edge > Vig? → BET | Edge < Vig? → PASS │
│ │
└─────────────────────────────────────────────────────────┘
Quick Reference: Common Calculations
| Line Type | What You're Betting | Excel for P(Over) | Excel for P(Under) |
|---|---|---|---|
| Over/Under 0.5 | 1+ events vs 0 events | =1-POISSON.DIST(0,λ,TRUE) | =POISSON.DIST(0,λ,TRUE) |
| Over/Under 1.5 | 2+ events vs 0-1 events | =1-POISSON.DIST(1,λ,TRUE) | =POISSON.DIST(1,λ,TRUE) |
| Over/Under 2.5 | 3+ events vs 0-2 events | =1-POISSON.DIST(2,λ,TRUE) | =POISSON.DIST(2,λ,TRUE) |
| Over/Under 7.5 | 8+ events vs 0-7 events | =1-POISSON.DIST(7,λ,TRUE) | =POISSON.DIST(7,λ,TRUE) |
The λ Adjustment Template
Build this template for every prop you analyze:
| Factor | Multiplier | Notes |
|---|---|---|
| Base λ (season average) | — | Starting point |
| Recent form | 0.90–1.10 | Last 5-10 games vs. season |
| Matchup adjustment | 0.85–1.15 | Opponent strength at defending this stat |
| Game script adjustment | 0.90–1.10 | Blowout risk, pace implications |
| Opportunity adjustment | 0.80–1.20 | Role changes, injury to teammates |
| Final λ | Base × All multipliers | Your projection |
Warning
Don't stack too many large adjustments. If you're multiplying 1.15 × 1.10 × 1.10, you're projecting a 39% increase—make sure that's justified by real factors, not wishful thinking.
Try the Calculator
Use this Poisson calculator to practice the 3-step process:
Poisson Calculator
Try the interactive calculator for this concept
📝 Exercise
Instructions
Apply the 3-step process to evaluate a prop bet.
You estimate a receiver's λ = 0.70 TDs/game. The market offers Over 0.5 TDs at -140. What's your P(Over) and is there an edge?
A pitcher has λ = 7.2 strikeouts. You adjust for a weak-hitting opponent (+10%) and recent hot streak (+5%). What's your adjusted λ?
At -110 odds, what's the break-even win rate (implied probability)?