Tools
How to Build a Lottery Tracker: 5 KPIs That Matter
Published on
A lottery tracker is a simple log that measures your own play against the math of the game. Track five KPIs: expected value per ticket, cumulative spend versus theoretical return, a split-risk score for each combination, hit frequency versus expected frequency, and your bankroll burn rate. Update it once per draw, in a spreadsheet or in LotteryCortex.
A useful lottery tracker measures five KPIs: expected value per ticket, cumulative spending versus theoretical return, split risk, observed versus expected hit frequency, and bankroll burn rate. Together, these metrics show whether your spending aligns with the game's mathematics and stays within the budget you set.
Most "lottery trackers" track the wrong things—winning numbers, hot and cold counts, and lucky streaks. None of those improves your decisions. A useful tracker measures your own play against the math of the game, so you know whether you are spending rationally.
Here are the five KPIs we built into the LotteryCortex tracker, why they matter, and how to calculate them yourself if you would rather build your own.
KPI 1: What Is Expected Value per Lottery Ticket?
This is the single most important number. EV/ticket = (sum of all prize tiers × their probability) − ticket cost.
EV = Σ (P(tier) × payout(tier) × (1 − tax) × (1 − split_factor)) − cost
Most weeks, EV is negative (you "pay" about 50 cents on every euro). When jackpots roll over and the cap structure kicks in, EV can climb above €1 per €1 wagered. Your tracker should highlight when EV crosses zero—that is the only mathematically defensible time to buy more lines.
KPI 2: How Does Spending Compare With Expected Return?
Plot two lines over time:
Cumulative spend: every euro you have put in.
Cumulative theoretical return: the sum of (EV/ticket × tickets bought).
The gap between them is your expected loss. If it is growing faster than 50% of your spending, you are playing during periods with especially low EV. If it is narrowing, you are exercising discipline during cap weeks.
KPI 3: What Is the Split Risk of Each Combination?
A combination's EV drops sharply if many other people pick it. A tracker should calculate a popularity score for every line you play:
+10 if all numbers are ≤ 31 (birthday pattern)
+5 if the numbers form a visual line on the bet slip
+5 if the combination matches a famous date (anniversary or lucky-number culture)
−5 if at least three numbers are >31 and randomly spread
Anything above +15 means you are sharing your jackpot with 5–10 other winners on average.
KPI 4: Are Your Hits in Line With Expected Frequency?
For every prize tier, compare:
Observed hits: how many times you have won that tier
Expected hits: tickets_bought × P(tier)
Over short runs, they will diverge significantly—that is variance, not a signal. Over long runs (more than 500 tickets), deviations greater than 2σ usually mean your number selection has a structure that does not match the game's random output. Sometimes, that indicates a bug in your random-pick logic.
KPI 5: How Quickly Are You Using Your Bankroll?
Your bankroll is the cap you set for lottery spending per month or quarter. Track:
€ spent / € budgeted (target ≤ 100%)
Average ticket cost (creeping upward = scope drift)
"Chase spending": tickets bought within 24 hours of a near miss (>0% = warning sign)
Bankroll burn matters more than EV when you are new to lottery tracking. EV optimization assumes you are not betting beyond your means.
How Do You Build a Lottery Tracking Spreadsheet?
If you do not want to use our app, here is a basic Google Sheets schema:
Column Type Source
date date manual
game text manual
draws_played int manual
cost currency manual
ev_per_line currency from /api/public/ev?game=
split_score int formula
prize_won currency manual
running_spend currency =SUM(cost up to row)
running_ev currency =SUM(ev × draws up to row)
Add a chart: running_spend vs. running_ev. That single chart tells you whether your long-term spending aligns with the math, regardless of any individual draw.
What Should You Not Track in a Lottery Tracker?
Hot and cold numbers: a 20-year backtest shows no edge; see our backtest.
"Due" numbers: gambler's fallacy. Each draw is independent.
Lucky personal numbers: fine as a hobby but terrible as a strategy (high split risk).
What Is the Purpose of a Lottery Tracker?
A tracker is not there to make you win—nothing makes you win at a negative-EV game most weeks. It is there to make sure you only spend when the math supports the decision and that your bankroll stays within your budget. Five KPIs, one chart, and ten minutes a week.
Want these features built in? Open the LotteryCortex tracker.
Free Weekly AI Picks
Every Monday: AI-generated numbers + the week's highest-EV lottery. Free, no spam.
Only the weekly AI picks. One-click unsubscribe.