NFL Betting Model in Excel: Predict Spread, Moneyline & Totals!
Added 2024-09-23 08:04:29 +0000 UTCG'day, lads!
My newest video just dropped π₯ Download the file here: https://www.patreon.com/posts/111333965
Comments
Could you make a nfl player prob model or a nba player prob model? Or even just an nba model?
Clickygg
2024-10-23 17:53:05 +0000 UTCHello, lad! Welcome π₯ The spreadsheet is able to update the stats by itself. To do that, go into the 'Data' tab and select the "Refresh All" icon. This will refresh the spreadsheet's connection with the website Pro Football Reference, and after about 10 seconds for the stats to be imported into the file, the model will be fully up to date π
Excel LADZ
2024-10-23 02:19:26 +0000 UTCDo you update the stats? Or will I have to do that manually?
Clickygg
2024-10-23 01:58:53 +0000 UTCYour a legend mate! I most likely will, I'm a Dallas supporter lol
Bronco1
2024-10-09 13:24:05 +0000 UTCG'day, mate! I actually made an NRL Model for this season. I used a team's results throughout the season to calculate Attack and Defence ratings for each club. I then used these ratings to simulate the score for a matchup and find probabilities for the Match Winner, Total Points and Line markets. Although it performed well, it doesn't use any specific player data to forecast markets like Anytime Tryscorer. I've just made this post free, so you can download the model and have a geez. If you like the spreadsheet, consider becoming a member to get access to the NFL, NBA and NHL Models! Even if you are a Broncos supporter... π€£ (Go the Eels!) Here's the link mate: https://www.patreon.com/posts/107502219
Excel LADZ
2024-10-09 10:24:51 +0000 UTCHello, Fabian! Unfortunately, not right now. The NFL Model relies on the connection between the spreadsheet and the NFL official website through a Power Query. I'm pretty sure this connection will be disrupted if the file were to be opened in Google Sheets. I hope that helps lad π
Excel LADZ
2024-10-09 10:19:36 +0000 UTCLove the spreadsheets you are doing! Would you be able to do something for the NRL?? Something that also contains the betting models along with teams and seasonal info for player positions scored on field, their record against the opposition etc. rankings, seasonal trends. Would pay top $$ for that!
Bronco1
2024-10-08 07:16:46 +0000 UTCIs there a way to put this on google docs so that it's available on mobile?
Fabian Timmons
2024-09-29 23:35:49 +0000 UTCG'day, lad! It could definitely be something I could look into doing π For example, consider a WR's receiving yards. The number of catches he gets could be binomially distributed (from 0 upwards). With each catch he makes, his yards gained could be normally distributed (e.g. mean yardage gained for each catch is 3, with standard deviation of 3 yards). Multiples could be applied to that player to scale the expected number of times he receives the ball; e.g. quarterback, direct opponent strength. Then, simulations could be run to factor in all of those variables and find the probability of under/over a certain threshold π
Excel LADZ
2024-09-26 12:30:58 +0000 UTCthanks mate! you ever considered trying to model player props? is that something that's even possible?
Nate Contreras
2024-09-25 20:42:14 +0000 UTC
