Want to compare live sports betting odds across US sportsbooks in an Excel spreadsheet?
Tired of doing all your modelling for sports betting in Excel, only to have to go and reference multiple other sites to find out what the current lines are?
Free Betting Odds and line movements in realtime at Sportsbookreview.com. Check out SBR's live odds for all major sports. For sports like basketball and football, betting on the point spread is the most popular method of wagering. For an example, if a favorite is listed at -2.5, that team has to win by 3 or more.
If you are looking to solve these problems, you have come to the right place.
See below for the available sports with live odds comparisons in Excel:
Compare moneyline, spread and totals odds across the following legal US sportsbooks:
The spreadsheet also let’s you toggle between between American and Decimal odds.
Because the file lives in Excel and updates automatically, you can also do any analysis you would like in this file.
The big benefit here is that you could reference the live odds compared to your numbers. This will save you a lot of time jumping from sportsbook to sportsbook checking odds.
All odds link directly to the particular sportsbook/matchup you click on. This makes it quick and easy to get your bets in once you are ready.
The most popular bet types are available:
When viewing moneyline odds, the spreadsheet also displays a percentage that represents the implied win percentage.
Using the implied winning percentages, there is a column labeled “Mkt. Hold” which stands for Market Hold.
In terms of sports betting, Market Hold represents how much vig you are betting into for a given game.
Market Hold is important because it will help you bet into favorable markets and give you a better chance at profiting long term.
Related: Use our vig calculator to figure out the market hold
Take for example an NFL game, the Kansas City Chiefs at the Baltimore Ravens. As you can see below, each sportsbook has slightly different odds for each side. The best odds for each side are automatically highlighted in green.
To calculate market hold, take the best odds for each side, add the implied winning percentages together, and subtract by one.
Conceptually, you are seeing how much more (or less) these percentages compare to 100%. If they are greater than 100%, then the market has that much of an edge on you.
In some scenarios, you are able to find a negative market hold. In this case, you would have an edge on the market.
Now back to the Chiefs/Ravens example. You have the ability to bet both Chiefs -150 (at FanDuel) and Ravens +165 (at SugarHouse). If you were to bet the same amount on each side at the appropriate sportsbook, you would lock in a profit.
Alternatively, if you blindly bet into just one side of this market, on average, you could expect to make the equivalent of the market hold.
Without knowing anything about the game or teams, using the odds comparison tool will give you a huge leg up simply by betting the best numbers available. The lower the market hold on the game, the better chance you will have to win long term.
The sheet will also update with the live lines for these bet types when available.
Live odds are particularly interesting as lines can get really out of wack between sportsbooks, representing an opportunity for you.
Using odds comparison services is an easy way to get an edge. Getting the best possible price is one way to help you win at sports betting long term.
Imagine you are going to buy a new laptop. What would you do?
For me, once I found the laptop I wanted to buy, I would shop around for the best price. Just a little bit of research would likely save you a lot of money.
The same applies to sports betting odds. The nice part is all of the price comparisons have been done for you, and are automatically updated every minute.
Using tools like this will help you win at sports betting in the long run. In addition to this odds comparison spreadsheet, you can check out our other tools that will help you gain an edge:
The vig calculator will be particularly useful as it helps calculate the market hold of a given bet.
Sports betting is slated to be introduced to multiple new markets every calendar year moving forward. That naturally means hordes of new bettors will constantly enter the marketplace for the foreseeable future. As such, an overview of the most common types of wagers is in order:
Although bets based on point spreads may be more of a “mainstream” wager, moneylines (in football and basketball), run lines (baseball) and puck lines (hockey) are likely much more straightforward for a novice better to grasp and one of the most popular super bowl bets.
A wager of this type is simply a good, old-fashioned bet on which team will prevail in a sporting event. Typically, when one places a moneyline wager on the team favored to win the game, it will “cost” the bettor more than when placing another type of wager.
Favorites have a three-digit number with a “minus” sign preceding it in moneyline bets. This number quantifies how much the bettor would have to wager on that team in a moneyline bet in order to win $100. The minus sign is indicative of the fact that when placing money on a favorite in a moneyline bet, the bettor will to wager an amount greater than the one that he/she will potentially win.
Conversely, underdogs have a three-digit number with a “plus’ sign preceding it in moneyline bets. This number quantifies how much the bettor will win if they wager $100 on that team in a moneyline bet. The plus sign is indicative of the fact that when placing money on an underdog in a moneyline bet, the bettor will potentially win an amount greater than the one he/she puts in.
Incidentally, $100 is the figure because it is a round figure that helps to better illustrate how a moneyline wager works. Moneyline wagers are actually accepted in all types of amounts.
To more specifically illustrate how a moneyline wager would work, let’s utilize an NFL example.
In a Cowboys-Giants game where Dallas is listed as the favorite, the moneyline might be listed as such:
Point spreads are one of the most popular forms of sports wagers, and they might be the most commonly known to a sports betting novice. The point spread is essentially defined as a projected margin of victory or defeat for the two teams in a given matchup.
Payouts on point spread bets depend on the odds assigned to either side of the wager. A favorite may nevertheless have better payout odds than an underdog, depending on the size of the spread. To utilize another NFL example, say the Rams are listed as 14-point (-14) favorites over the 49ers. Despite the fact Los Angeles is clearly expected to win the game, the odds of a two-touchdown or greater win in football are worse than one by a lesser margin.
Therefore, your payout if you bet the Rams to win by 14 or greater might be -105 (must bet $105 to win $100). Alternatively, your payout if you take the 49ers to cover – i.e. lose by less than 14 points – might be slightly worse at -115 (must bet $115 to win $100)
Point spreads are set by oddsmakers with the idea of getting wagers to come in on both teams as evenly as possible. Sportsbooks naturally want to avoid being “overexposed” to one side of a wager as much as possible. This helps prevent some potentially sizable losses for the casinos.
Totals, or “over/under” bets, are another fairly simple concept to grasp, even for the inexperienced bettor. In a totals wager, the bettor is simply putting money down on whether or not the cumulative point/run total of the two teams in a game will be more or less than the total set by the sportsbook.
Totals bets are usually set with odds of -110, meaning the bettor must wager $110 to make $100 (utilizing the “100” figure as the example once again).
A totals bet for a Yankees-Red Sox game might be listed as follows:
As with the point spread example provided above, there is also the possibility of a “push” when it comes totals bets. In our Yankees-Red Sox example, this would occur if the cumulative run total is exactly nine. Bettors would receive refunds on their original bets in such an instance.
Parlay bets are wagers that involve at least two games. There are various forms of parlay bets based on the different bet types already discussed above. In other words, bettors can place point spread parlay wagers, moneyline parlay wagers and totals parlay wagers.
For a parlay to lead to a payout, there cannot be a losing bet within it. “Pushes” won’t disqualify a parlay wager from cashing, however. Parlays also survive eventualities such as a rainout in baseball or a game that ends in a tie. However, the payout in those cases is calculated factoring out that game, meaning that it will be less than if all of the “legs” of the parlay would have been valid.
Odds for a parlay vary from sportsbook to sportsbook. Once a parlay bet is placed, however, the odds and lines are locked in. That’s the case irrespective of any other changes the point spread, projected totals or moneyline involving any of the teams within the parlay undergo after the parlay wager has been made.
The more teams wagered on in a parlay, the better the payout. As with all other wagers, the more difficult the bet appears to be, the larger the reward if it hits.
Teaser bets are a form of parlay wager that excludes moneyline bets. In a teaser, the bettor can manipulate a point spread or total within a certain predetermined range in order to improve their odds of winning the bet. Naturally, a teaser will pay out less than a conventional parlay because of the greater probability of the bettor coming out on the winning side.
The one requisite with a teaser bet is that the movement of the line or total must be applied to each team in that parlay. However, it can be applied in different “directions”.
An example of an NBA teaser on a two-team parlay that incorporates the above would be the following:
A futures bet is any bet made for an event which has an outcome that will occur in the future. Most future bets involve odds for a team to win a championship or division, but there are other futures wagers available for various sports. In golf, for example, a bettor can wager on a golfer finishing in the Top 10, Top 20, or Top 30 of a future tournament.
Futures odds are set by an oddsmaker based on the potential outcomes.