Ask a casual gambler: "How much are you up this year?"
They will say: "Oh, I'm about even."
They are lying.
They just don't remember the losses.

The Mirror of Truth

A spreadsheet is a mirror. It shows you the ugly truth about your betting.

  • It tells you that you lose 80% of your Football bets.
  • It tells you that you are a genius at Cricket.
  • It tells you that you lose money on Tuesdays.

Without this data, you are blind.

Betting Tracking Spreadsheet Example

What to Track (The Columns)

Create a Google Sheet with these columns:

  1. Date: When was the bet?
  2. Sport: Cricket, Football, Tennis.
  3. Selection: India to Win.
  4. Odds: 1.90.
  5. Stake: 1000.
  6. Result: Won/Lost.
  7. Profit/Loss: +900 or -1000.
  8. Notes: "Bad mood", "Raining", "Good value".

The Analysis

After 100 bets, filter your sheet.

  • Filter by Sport: Maybe you should stop betting on Football entirely?
  • Filter by Odds: Maybe you lose every time you bet on long shots (5.0+)?

Conclusion

Amateurs guess. Professionals know.
Start your spreadsheet today. It is the most profitable tool you will ever own.

To understand the metrics in your sheet, read: Understanding ROI & Yield.