We cover record keeping as a financial-literacy exercise. The Promotion and Regulation of Online Gaming Act, 2025 prohibits offering, operating, advertising and facilitating online money games in India, so check the law that applies to you.
Why Track Your Data
Tracking turns a vague feeling into measurable evidence. Without records, it is impossible to know whether results come from sound analysis, luck or simply spending more than planned.
- Honesty: a ledger shows the real total, not the version memory prefers.
- Spending control: you see at once when monthly totals approach your limit.
- Learning: you can test which types of decision actually work.
- Tax records: dated entries make it easier to reconcile any TDS with official statements.
You can apply this whole method to "paper" predictions, recording hypothetical decisions without spending anything, to test your analysis at zero cost.
Setting Up a Tracking Spreadsheet
Any spreadsheet program works. Create one row per decision and fill it in at the time, not from memory afterward. These columns cover the essentials:
| Column | What to Record | Example (Hypothetical) |
|---|---|---|
| A: Date | Date of the event | 12 April |
| B: Event and market | Match and type of market | Team A vs Team B, match winner |
| C: Your probability | Your estimate before seeing the price | 48% |
| D: Decimal odds | The price you recorded | 2.20 |
| E: Stake | Amount committed | ₹200 |
| F: Result | Won, Lost or Void | Won |
| G: Profit/Loss | Calculated by formula | ₹240 |
| H: Notes | Reasoning and mood | Pitch report; felt calm |
Column G should use a formula so the arithmetic is never done by hand. In most spreadsheet programs, this works in row 2:
G2 = IF(F2="Won", E2*(D2-1), IF(F2="Void", 0, -E2))
Record every entry, including the ones you would rather forget; a ledger with gaps is worse than none because it looks reliable.
Key Metrics (ROI and Yield)
Here is a hypothetical five-entry log to show how the main metrics work.
| # | Odds | Stake | Result | Profit/Loss |
|---|---|---|---|---|
| 1 | 2.20 | ₹200 | Won | +₹240 |
| 2 | 1.75 | ₹200 | Lost | −₹200 |
| 3 | 3.00 | ₹100 | Lost | −₹100 |
| 4 | 1.90 | ₹200 | Won | +₹180 |
| 5 | 2.50 | ₹100 | Lost | −₹100 |
Total Staked = ₹200 + ₹200 + ₹100 + ₹200 + ₹100 = ₹800
Net Profit = ₹240 − ₹200 − ₹100 + ₹180 − ₹100 = ₹20
ROI = Net Profit ÷ Total Staked × 100 = ₹20 ÷ ₹800 × 100 = 2.5%
In this guide, yield means the same calculation: profit divided by turnover, where turnover is the total amount staked. You will sometimes see ROI measured against a starting bankroll instead, which gives a different figure, so always label the base you used.
- Strike rate: winning entries ÷ total entries = 2 ÷ 5 = 40%.
- Average odds: (2.20 + 1.75 + 3.00 + 1.90 + 2.50) ÷ 5 = 11.35 ÷ 5 = 2.27.
- Maximum drawdown: the largest fall from a peak, here from +₹240 after entry 1 to −₹60 after entry 3, a drop of ₹300.
Drawdown = Peak − Trough = ₹240 − (−₹60) = ₹300
Drawdown often matters more than ROI, because it shows how much you must be able to lose without distress.
Analyzing Your Data
Five entries prove nothing. Random variation dominates small samples, so treat early numbers as noise. Once you have a large record, slice it to find patterns:
- Filter by market type to see whether some categories consistently lose.
- Group by odds band, such as below 2.00 and above 2.00, to see whether you misjudge favorites or underdogs.
- Compare your recorded probabilities with outcomes; if your 60% estimates come true far less than 60% of the time, your model is overconfident.
- Read the Notes column for emotional entries, such as those made after a loss or late at night, and check how they performed.
Be honest about what the numbers say. If ROI stays negative over a large sample, the data is telling you to stop, not to stake more. If tracking becomes stressful, or you find yourself hiding totals from family, consider speaking to a doctor or a licensed mental-health professional.