#N/A errors in DFS salaries explained

Etwas Besonderes Leave a Comment

At BigDataBall, we only support “CLASSIC” style salaries and positions.  On the weekends and on special days like Christmas, MLK, if there is an afternoon game, DraftKings, or the other operators can sometimes prefer not to include the earliest game in any classic slate. We also added a note to the DFS dataset column headers. And the below image explains …

Adding a new column

Etwas Besonderes Leave a Comment

Ever wanted to calculate a metric that is not included in the original dataset template? It is very easy to add a new column to a BigDataBall spreadsheet. As an example, we can use a simple IF formula to determine the winning/losing team for the NBA games.

Converting date formats in Excel

Etwas Besonderes Leave a Comment

We use the MM/DD/YYYY format in the datasets. This might not be the date format you’d like, but with this guide, you can learn how to convert the cell value to any date format or convert date to text. Working with dates in Excel can be quite irritating. If you want to make date-based calculations, your cells must be recognized …

How to calculate aggregated stats

Etwas Besonderes Leave a Comment

By default, BigDataBall provides game-by-game logs. In case you’d like to have a season averages table using the logs, follow this walkthrough. A) Getting the Unique List of Players A1) We need to transform game-by-game logs to a table that shows season averages of players from the NBA 2019-20 season. A2) Open your most recent version of the BigDataBall NBA …

Introduction to predictive analytics

Etwas Besonderes Leave a Comment

In this guide, we will try to execute a multiple linear regression in Excel and our aim is to help you interpret the results statistically. Let’s try to predict DFS salaries to exercise how the ideal salary compares to the official DraftKings salary. After completing the regression, identifying value players or avoiding expensive players for a given day becomes quite …

Predicting the outcome of games

Etwas Besonderes Leave a Comment

Predicting the outcome of sports games has been the focus of a great deal of data science. Sports offer a ton of in-game and post-game raw data that can be leveraged to make more accurate predictions and to make money as well. Bettors need to beat oddsmakers who also use data analytics to predict the outcome of every game. And …

Understanding the odds

Etwas Besonderes Leave a Comment

At BigDataBall, we always use American odds which are obtained from sources like ScoresandOdds.com and SportsbookReview.com. This guide aims to explain the way we display game odds including juices, PKs, EVENs. Let’s get started with a few samples: “13.5 -05”   –  Identical to “13.5 -105”.   –  You are betting on the underdog team while the spread is “13.5”.   –  But you …