Track Your Sports Bets
Ever wondered how you are actually doing in sports betting?
Track your bets Keep track of your bets with Bettracker, Betmanagers advanced betting spreadsheet. Bettracker is an accounting system for sportsbettors. Input your bets and transactions and get detailed stats on your betting performance and bankroll. Since sports betting involves a lot of very fine margins, the difference between winning and losing can come down to a single point or even half a point. As a result, a tiny increase in your overall win rate can boost you from losing to making a profit. The same applies for obtaining slightly better odds or practicing better bankroll management. With this comes the need to analyze your. The sports bet tracker is an simple, but great way to handle your bets and chart your successes and failures. With statistical analysis and performance graphs of your wagers, using it will give you a complete and comprehensive overview of your betting history. ANALYZE YOUR RECORDS Smart Bet Tracker lets you analyze your bets and track your balances in real time. You can see trends and indicators, calculate ROI and yield, hit rate and more. You can display many graphs and reports showing your performance, and comparing how you did at each bookmaker.
Just like tracking your finances can be an eye opening experience (I spent how much at restaurants last month?!), tracking your bets can shed some light on your performance.
Download the free sports bet tracking spreadsheet below to get started (available for both Excel and Google Sheets):
Bet Tracker Spreadsheet: Instant Insights
If you want to measure your performance and see where you are succeeding and failing, you need to track it.
With this free tool, you can see your performance broken down by various dimensions.
Have a great ROI on betting NBA 2nd halves? Getting solid closing line value on NFL point spreads? This spreadsheet allows you to answer questions like this and more.
How to use the spreadsheet
While the spreadsheet is pretty straightforward, I’d like to walk you through how it works.
How to track sports bets
Everything lives in the “Bet Log” tab. This is the only place information is manually entered. Once the data is entered there, all other tabs will automatically populate.
In the “Bet Log” tab, blue columns are required while red columns are optional. The more information you input, the more useful the spreadsheet will be.
Entering things like the closing line, while slightly annoying, will also be the most important to your success.
How to analyze performance
Each tab will have different graphs and tables that show your performance. The beauty of this is that you can filter the data by any dimension you like.
Any yellow cell is an “input” cell that can be changed. All of these are dropdowns that are pre-populated based on the information you enter in the Bet Log.
How to add more leagues and teams
To add new leagues and teams, you will do so in the “REF” tab. This tab holds all of the lookup information for the dropdowns throughout the spreadsheet.
Again, the cells available to modify are in yellow. You can add the following dimensions:
- Leagues (ex: WNBA)
- Teams (ex: Chicago Sky)
- Tags (ex: 2nd half)
Bet Tracker Spreadsheet Metrics
Deciding what to track is important in determining how you measure success. The spreadsheet tracks the following key metrics:
Closing Line Value
Closing line value (CLV) is a measure of how much better or worse the odds you bet at were compared to where they closed.
If you believe the markets you are betting into are efficient (NFL point spreads, MLB moneylines, etc.), then CLV is a great predictor of long term success.
All you need to do is input the odds you placed your bet at as well as where the odds closed. Preferably you use a market making sportsbook like Pinnacle to decide what the “true” closing line was.
Profit
Profit is about as simple as it gets. Are you making or losing money?
While this is the “bottom line”, surprisingly it isn’t always predictive of long term success. Still, you will obviously want to see how much money you have made or lost.
ROI
This is what most people tend to look at. It is a measure of how profitable you are relative to how much you are risking.
While at the end of the day, the money in your pocket is what matters, this metric focuses more on results rather than process and is a measure of efficiency.
ROI isn’t as predictive of long term winning as CLV, but is useful to track to see where you stand.
Risk
This one is simple, yet will likely give you insights into where you are putting your money.
If you have a model, does it consistently value the Dallas Cowboys differently than the market? Thus making many of your bets on the Cowboys? Analyzing your risk by league/team/bet type can give you these types of answers.
Bankroll
Bankroll will track our running total of how much money you have in your accounts across all sportsbooks. You can also see this trended over time to help you see any changes in your betting strategy and how that has affected your bankroll.
It is very useful to see, at a glance, where your money lies. Is 95% of our bankroll at FanDuel? Maybe you should shift some to DraftKings.
Bet Tracker Spreadsheet Dimensions
Having these metrics available is important, but insights really come from slicing the data by different dimensions.
League/Team
Tracking your performance by league or team can give you clues into where your strengths or weaknesses are.
Do you watch every second of every New York Knicks game? Think you have an edge on Knicks games? You can find out using the spreadsheet.
Same goes for leagues. Do you follow NFL closely but use strictly numbers for NCAA Basketball? Compare the performance of the two and see what’s working.
Bet Type
Looking at performance by bet type can also shed some light on your process, especially if it is model driven.
Track your performance by the following bet types:
- Spread
- Moneyline
- Total
- Prop
- Future
You can also use the “Tag” field to designate special types of bets. For example, if you want to see your performance on moneylines for NBA 2nd halves, you would put “2H” (or something similar) in the Tag field and “moneyline” in the bet type field.
Date
A common way to analyze performance is to look at metrics trended over time.
Look at any of the metric/dimension combinations above trended over any time period you’d like.
Want to see your performance over the last 14 days? Or how about the last 12 weeks? Both are possible here.
Google Sheets Sports Betting Tracker
The sports betting tracker is also available on Google Sheets. While the features are the same as the Excel file, Google Sheets has some notable benefits:
- Available/online at all times
- Can enter bets on your phone using the Sheets app
- You don’t need to be at a computer to enter your bets
- Google Sheets auto saves any changes
- Allows multiple users to be in the sheet at the same time and make changes
Related posts:
All About
Pick Monitor was started by Patrick in April of 2010 with the idea that a monitor focusing on transparency, advanced stats and ease-of-use would be a welcomed addition to the industry. It was bought by Michael in October 2017.
Track Your Sports Bets
And let's face it: the sports tipping industry is depressing. You probably already know this, but to make a point we'd like you to leave for a second and go search for 'tipsters' on Twitter. If the majority of those profiles don't make you want to vomit in your mouth then we conceed defeat right now. Please hit the 'back' button on your browser. We won't even try to get your business.
That queasy feeling you just got from looking at those Twitter profiles? You won't get that here. That's not to say that we won't try to paint pretty pictures for you. Of course we will. We sell a service and we need people to buy that service in order to keep our business afloat. The difference with us, though, is that transparency is the focal point of our sales pitch.
No, really.
How To Keep Track Of Your Sports Bets
Aside from having a strong desire not to be complete ass-hats, there's a surprising monetary benefit to our transparency. 90% of sports-pick buyers may indeed fall for the shady, dirty, makes-you-want-to-vomit-in-your-mouth too-good-to-be-true nonsense (read: pregame.com) that is our 'competition'. But 10% don't. And how many sites cater to that 10% seeking transparency above breathtaking results? Not many.
By going out of our way to be unrivaled in our transparency we are trusting that there is some small part of humanity that is above the lies. We rely on that small part of humanity to pay our bills, and so far it's working. And if it ever stops working, screw it. We'd rather go the way of MySpace (oh wait, that might technically still exist, but you get the point) then join the dirtbags.
---
Track My Sports Bets
Our business model? We're not a tipping service. We're an independent sports monitor that allows users to pay a fee to sell their tips and keep 100% of the profits. Any handicapper who doesn't choose to sell his tips agrees to have his tips included in our tip packages. The majority of our users are free users. That's cool with us. We'll put some 'upgrade' links various places on the site but we'll never call you. We'll never hard sell you. If being a free member is best for you then so be it.
---
We're founded on the basis of actually increasing your chance of winning as opposed to selling you bullshit and we're run by a super nerdy, data-loving computer scientist. Resulting is a tracking service whose attention to detail and statistical insight is simply better than that of the competition. We analyze the snot out of tips and tipsters to give you as much info as humanlycomputerly possible. From there, after giving you instant access to every piece of data from every user on the site, we leave things up to you.