Ever wondered how you are actually doing in sports betting?

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.

Simple betting app software

Download the free sports bet tracking spreadsheet below to get started (available for both Excel and Google Sheets):

Bet Tracker Spreadsheet: Instant Insights

Plus, our betting odds calculator displays both the total return on your wager and the profit you get. Granted, there are a few types of betting odds out there. This means you need to have a reasonable grasp of what odds are and how they work.

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.

Simple Betting App

Download the At The Races mobile and tablet app The ultimate app for horse racing fans Our market-leading app combines detailed racecards and form with FREE archive video and dynamic in-app betting functionality to produce an unrivalled form research and betting service. Best Sports Betting App #1: bet365. They are one of the biggest betting operators not just in the UK but all across the world, and their dedicated app is every bit worthy of their juggernaut reputation and is a fine contender for best betting app. William Hillbetting app is on the top of iPhone rankings. It is visually pleasing, provides in-play markets, great odds rates. One of the most prominent features of the app is that there are functions available only in the mobile version, like betting insurance. This motivates users to install it on their devices.

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:

With Caesars Sportsbook, you now have a convenient way to place a sports wager anytime, anywhere in Indiana. Skip the lines and experience sports wagering using your iOS or Android device. Wager securely and in real time using this mobile sports app.

  • Earn rewards for mobile sports book play and redeem anywhere in our network including our hotels, restaurants, bars etc.
  • Fund, deposit and withdraw from your mobile account and get access to your winnings immediately with Caesars Entertainment Play+.
Betting

Get up to a $500 matched sports free bet. Join now using code MOBILE500, and we’ll match your first wager with a free bet, up to $500.

Rules House Rules - Sports Wagering Terms & Conditions

Simple Betting Apps

FAQs Mobile Sports Wagering FAQs

Promotional Rules $500 Deposit Offer Promotion Terms & Conditions

With Caesars Sportsbook by William Hill, you now have a convenient way to place a sports wager anytime, anywhere in Nevada. Skip the lines and experience sports wagering using your iOS or Android device. Wager securely and in real time using this mobile sports app.

  • Earn rewards for mobile sports book play and redeem anywhere in our network including our hotels, restaurants, bars etc.
  • Fund, deposit and withdraw from your mobile account and get access to your winnings immediately with Caesars Entertainment Play+

Complete application at any Nevada Caesars Entertainment sports book.

Form Mobile Sports Wagering Application

Participating Properties Harrah’s Las Vegas, Flamingo Las Vegas, The Cromwell, The LINQ, Bally’s Las Vegas, Paris Las Vegas, Planet Hollywood Resort and Casino, Caesars Palace, Rio All-Suite Hotel & Casino, Harrah’s Laughlin, Harvey’s Resort Hotel/Casino, Harrah’s Casino Hotel Lake Tahoe, Harrah’s Casino Hotel Reno

Complete application at any Nevada Caesars Entertainment sports book.

Option 1 Deposit or withdraw cash at any participating Caesars Entertainment sports book

Option 2 Deposit or withdraw funds anytime, anywhere with a Caesars Entertainment Play+ account. Sign up now!

Rules House Rules - Sports Wagering Terms & Conditions

FAQs Mobile Sports Wagering FAQs

Free Betting Apps For Android

Caesars Casino & Sportsbook is the place where you can play our world-class online casino games AND wager on sports anytime, anywhere in New Jersey! Skip the lines and experience the most rewarding online casino and sports book in New Jersey using your iOS or Android device. Your account is safe and secure.

App
  • Place your bets on pro football, college basketball, hockey, golf and more!
  • Access 500+ real money casino games including slots, blackjack and roulette.
  • Earn Caesars Rewards® Online Reward Credits® and Tier Credits for all your mobile casino and sports play and redeem anywhere in our network, including our hotels and restaurants.
  • Fund, deposit and withdraw straight from your mobile account.

How do I make a deposit?

Bet and win real money that you can cash out quickly and easily via ACH (Electronic Check), MasterCard/Discover/Visa/American Express*, Online Bank Transfer, PayPal, CaesarsCasino.com Prepaid Card, Cash at the Caesars Atlantic City casino cage, and PayNearMe.

*Some credit card issuers do not accept online gaming transactions.

get up To $500 matched sports free bet

Join now using code MOBILE500, and we’ll match your first wager with a free bet, up to $500.

Promotional Rules $500 Deposit Offer Promotion Terms & Conditions

Rules House Rules - Sports Wagering Terms & Conditions

FAQs Mobile Sports Wagering FAQs

Caesars Casino & Sportsbook is the place where you can place your bets anytime, anywhere in Pennsylvania! Let us bring the thrills of Harrah's Philadelphia to your doorstep. Bet and win real money that you can cash out quickly and easily via ACH (Electronic Check), MasterCard/Discover/Visa/American Express*, Online Bank Transfer, PayPal, Caesars Casino and Sportsbook Play + Card, Cash at the Harrah’s Philadelphia casino cage, and PayNearMe.*

Get in on the action from your PC, Mac, Android or iOS devices.

  • Play the games you love and reap the rewards at nearly 40 resorts and casinos around the world.
  • Explore the bets and odds offered for all your favorite sports.
  • Earn Caesars Rewards® Online Reward Credits® and Tier Credits for all your mobile casino and sports play and redeem anywhere in our network, including our hotels and restaurants.

*Some credit card issuers do not accept online gaming transactions.

How do I make a deposit?

Bet and win real money that you can cash out quickly and easily via ACH (Electronic Check), MasterCard/Discover/Visa/American Express*, Online Bank Transfer, PayPal, Caesars Casino and Sportsbook Play + Card, Cash at the Harrah’s Philadelphia casino cage, and PayNearMe.

*Some credit card issuers do not accept online gaming transactions.

Get up to a $500 matched sports free bet

Join now using code MOBILE500, and we’ll match your first wager with a free bet, up to $500.

Promotional Rules $500 Deposit Offer Promotion Terms & Conditions

Rules House Rules - Sports Wagering Terms & Conditions

FAQs Mobile Sports Wagering FAQs

*Must be 21 or older and physically present in NJ/NV/PA/IN to play.

NJ: Know When to Stop Before You Start® Gambling Problem? Call 1-800-GAMBLER

NV: Know When to Stop Before You Start® Gambling Problem? Call 1-800-522-4700

PA: If you or someone you know has a gambling problem, crisis counseling and referral services can be accessed by calling 1-800-GAMBLER (1-800-426-2537)

IN: Know When To Stop Before You Start®. Gambling Problem? Call 1-800-9-WITH-IT.