ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
BET TRACKER
3
A free template by @noahwinsbets
4
5
Welcome!
6
This sheet tracks every bet you place, your running profit/loss, and your performance over time. Most of it is automated. You fill in a few fields and the rest calculates itself.
7
8
Getting started
9
1. Make your own copy. In Google Sheets: File → Make a copy. Work in YOUR copy, never this shared original.
10
2. Delete the sample data. “My Bets” and the Dashboard come pre-filled with ~60 example bets so you can see how it all looks. Select the contents of row 2 downward on “My Bets” and delete them (clear the contents rather than deleting the rows since the formulas live there). The Dashboard resets to zero.
11
3. Log your bets. Type directly into “My Bets,” or use the optional “Quick Entry” tab to add one bet at a time (great on mobile).
12
4. Watch the “Dashboard” tab. Totals, win rate, ROI and the profit graph update automatically.
13
14
What you type vs. what calculates automatically
15
16
YOU ENTER these columns:
17
 • Sportsbook – e.g. DraftKings, FanDuel, ESPN BET.
18
 • Type – Straight, SGP, SGP+, Parlay, etc.
19
 • Live? – Live or Pre.
20
 • Date – the date of the bet.
21
 • League – NBA, NHL, NCAAB, etc.
22
 • Bet – a description of the wager.
23
 • Odds – American odds (e.g. -110, +250).
24
 • Profit Boost % – optional. If the book gave a boost, type it as a percent (e.g. 30%).
25
 • Bonus Bet Amount – optional. If you used a free/bonus bet, enter its value; profit is winnings-only (stake not returned) and a loss costs $0.
26
 • Risk – how much you staked (leave blank for a pure bonus bet).
27
 • Result – Win, Lose, Push, or Void (Push and Void refund the stake).
28
29
AUTOMATIC columns (don’t type over — they’re formulas):
30
 • Boosted Odds – recalculates your odds when a Profit Boost % is entered.
31
 • Payout – total return if the bet wins (stake + winnings).
32
 • To Win – the profit portion only.
33
 • Profit – fills in from the Result. Win = winnings, Lose = −risk, Push/Void = 0.
34
35
Quick Entry tab (optional)
36
The “Quick Entry” tab lets you log a bet from one small input block instead of scrolling the big table. This is extra handy on your phone.
37
It needs a one-time setup (about a minute) because Google Sheets must be given permission to add the row for you. Full steps and the script are on the “Quick Entry” tab.
38
Prefer not to set it up? No problem, just type rows straight into “My Bets.” Everything still works.
39
40
Color coding
41
Winning bets shade green, losing bets red, pushes/voids yellow, so you can scan your history at a glance.
42
43
Follow me — @noahwinsbets
44
Instagram: @noahwinsbets
45
X (Twitter): @noahwinsbets
46
YouTube: @noahwinsbets
47
48
Tag me with your results, and if this helped, share it with a friend. Good luck! 🍀
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100