Great Video!! Really enjoy looking at probabilities and seeing how accurate you can get it. I was wondering if there was a way to have the daily line up and auto update the batters/pitcher once you select a team on the Props page? Could I set up a new sheet to have the daily games and line up and once you select the team it'll auto input the batters? Thanks
Great Sheet. I've been looking for a props model like this. I was wondering if you might be able to add/incorporate a couple of additions to the model. For hitters can you add projections for total bases since this is another popular hitters prop. For pitchers over/under on earned runs has become a popular prop this season. Any chance you might be able to add projections for that to the model? Finally, I'm wondering if it would be possible to account for recent form in this model? Maybe giving additional weight to last 14 days worth of data.
Hello, taking your project I am trying to create my own but focused only on the number of strikeouts of the pitcher and the strikeouts of the batters, I am struggling with that since I do not have the management sheet like you have, otherwise it takes up a lot of time could you add some video about that...
This was a great video and it was a great basis that I have taken and adjusted to improve on it! I was curious how you generated the Player IDs sheet and if there was a way to automate it? That seems to be the one thing that could hinder the use of this model in the future as rosters change and more and more players cannot be found on the sheet. Thanks for all of this guidance!
I used python to scrape baseball reference for all the players using BeautifulSoup and Pandas. In my video on scraping DraftKings lines, you can see how that works.
@@cadetheking th-cam.com/video/ecBL6ZoNDag/w-d-xo.htmlsi=ACz39poFpCYJtksc You’ll want to scrape the 40 man roster page for each team. The player ID is inside the link to each player page. You’ll have to slice the string since it’s a full link.
How long does this sheet take to load? I'm still showing errors all over the place and loading and I opened the sheet 5 minutes ago. How long should it take?
Poisson is better for things in increments of 1. Like runs scored or three points made. Normal distribution would be better for total points in a basketball game because they can be increments of 1, 2 or 3.
@@TheBenjaminWagner thanks for explaining. you would obviously also need the SD to do normal distribution. i am building a model for AFL prop bets and found this video incredibly useful to tweak some stuff i've been trying. thanks again!
thanks for the sheet. when i change the team the other information is not correlating the other information to change with it. example if i change from mia to lad the information isnt changing. nor if i change the player or pitcher.
@@johnnygore8817 I would try copying the sheet over again. Make sure you click “allow access” when the yellow bar pops up at the top. Look in the data tab and hover over any cells that contain #REF and allow permissions. You’ll also need to give it a few minutes to load the initial data because of how many requests are happening all at once. I’m working on a more efficient sheet that will reduce wait time and will post in the near future.
Assuming you’re using the finished sheet I linked it’s one of two things. Either the particular player has recorded zero for the particular stat (like home runs) or more likely, the data hasn’t loaded in yet. Check the bottom of the Data tab and see if those cells say “Loading”. If so, give it a few minutes.
This is amazing job. Your sheets and movies gives a lot of opportunities to learn and I hope earn :) If it isn't a problem could you send me a finish sheet? Thx in advance
The link to the sheet with player ID's? Or inside the finished sheet? If it says "Loading", let it do it's thing. It sometimes take a few minutes to scrape all the data.
for your over/under you could use a sumif function instead of the manual approach you did
Great Video!! Really enjoy looking at probabilities and seeing how accurate you can get it. I was wondering if there was a way to have the daily line up and auto update the batters/pitcher once you select a team on the Props page? Could I set up a new sheet to have the daily games and line up and once you select the team it'll auto input the batters? Thanks
Great Sheet. I've been looking for a props model like this. I was wondering if you might be able to add/incorporate a couple of additions to the model. For hitters can you add projections for total bases since this is another popular hitters prop. For pitchers over/under on earned runs has become a popular prop this season. Any chance you might be able to add projections for that to the model? Finally, I'm wondering if it would be possible to account for recent form in this model? Maybe giving additional weight to last 14 days worth of data.
Hello, taking your project I am trying to create my own but focused only on the number of strikeouts of the pitcher and the strikeouts of the batters, I am struggling with that since I do not have the management sheet like you have, otherwise it takes up a lot of time could you add some video about that...
I like it 😊
This was a great video and it was a great basis that I have taken and adjusted to improve on it! I was curious how you generated the Player IDs sheet and if there was a way to automate it? That seems to be the one thing that could hinder the use of this model in the future as rosters change and more and more players cannot be found on the sheet. Thanks for all of this guidance!
I used python to scrape baseball reference for all the players using BeautifulSoup and Pandas. In my video on scraping DraftKings lines, you can see how that works.
@@TheBenjaminWagner Thank you! Could you link the video you are talking about?
@@cadetheking th-cam.com/video/ecBL6ZoNDag/w-d-xo.htmlsi=ACz39poFpCYJtksc
You’ll want to scrape the 40 man roster page for each team. The player ID is inside the link to each player page. You’ll have to slice the string since it’s a full link.
@@TheBenjaminWagner Thanks again! This video was great! I’ve already started to profit from having a strikeout model like this!
Would love a finished sheet. Love the video!
docs.google.com/spreadsheets/d/1AwKopyWTOGIXKkRdP4XPKhE8ZXotsMkqp40gZ-u0oUA/copy
Well done presentation. Would love a copy of the finished sheet.
docs.google.com/spreadsheets/d/1AwKopyWTOGIXKkRdP4XPKhE8ZXotsMkqp40gZ-u0oUA/copy
Great video! Would love a copy
docs.google.com/spreadsheets/d/1AwKopyWTOGIXKkRdP4XPKhE8ZXotsMkqp40gZ-u0oUA/copy
I would love a finished sheet. Thanks
docs.google.com/spreadsheets/d/1AwKopyWTOGIXKkRdP4XPKhE8ZXotsMkqp40gZ-u0oUA/copy
Is there any way you can make a google sheet document that will predict the winner of each game? That would be sweet!
Yes, in the follow up video I show how to do that. th-cam.com/video/5IYbjDRa_-o/w-d-xo.htmlsi=UExXr5Wk7IxZoorx
How long does this sheet take to load? I'm still showing errors all over the place and loading and I opened the sheet 5 minutes ago. How long should it take?
On first load, it can be a while..maybe 20 minutes, but subsequent loads are only a minute or two.
Can I get a link to the finished sheet? Thank you!!
docs.google.com/spreadsheets/d/1AwKopyWTOGIXKkRdP4XPKhE8ZXotsMkqp40gZ-u0oUA/copy
why do you use the poisson dist instead of norm dist? is it because you don't have the standard deviation available?
Poisson is better for things in increments of 1. Like runs scored or three points made. Normal distribution would be better for total points in a basketball game because they can be increments of 1, 2 or 3.
@@TheBenjaminWagner thanks for explaining. you would obviously also need the SD to do normal distribution. i am building a model for AFL prop bets and found this video incredibly useful to tweak some stuff i've been trying. thanks again!
Beautiful Work! Can you help me or send a link?
docs.google.com/spreadsheets/d/1AwKopyWTOGIXKkRdP4XPKhE8ZXotsMkqp40gZ-u0oUA/copy
Can you make a video for mlb to find out who can win in the game and have an idea of how many runs can be scored in the game thanks for everything
Definitely. I’ll try to put one up this week.
I would greatly appreciate this video as well. Love your most recent one, thanks for all you do!
This would be a great video to see runs, totals, winners. Looking forward to it.
Can i get finished sheet. Tried to follow video but get error when adding the formula under with team names and baseball reference page
docs.google.com/spreadsheets/d/1AwKopyWTOGIXKkRdP4XPKhE8ZXotsMkqp40gZ-u0oUA/copy
thanks for the sheet. when i change the team the other information is not correlating the other information to change with it. example if i change from mia to lad the information isnt changing. nor if i change the player or pitcher.
@@johnnygore8817 does it say loading or perhaps an error or is it literally not changing at all?
Literally not changing.
@@johnnygore8817 I would try copying the sheet over again. Make sure you click “allow access” when the yellow bar pops up at the top. Look in the data tab and hover over any cells that contain #REF and allow permissions. You’ll also need to give it a few minutes to load the initial data because of how many requests are happening all at once. I’m working on a more efficient sheet that will reduce wait time and will post in the near future.
Could I get a link to the sheet please? Thank you!
docs.google.com/spreadsheets/d/1smkrqwTCgNuU5rTNV_6G8flR-rHepkdjk9W4C7vuMi4/edit
Hey man, can you please send me a link to the finished sheet?
docs.google.com/spreadsheets/d/1AwKopyWTOGIXKkRdP4XPKhE8ZXotsMkqp40gZ-u0oUA/copy
What should I do if the possion tab shows #div/o!
Assuming you’re using the finished sheet I linked it’s one of two things. Either the particular player has recorded zero for the particular stat (like home runs) or more likely, the data hasn’t loaded in yet. Check the bottom of the Data tab and see if those cells say “Loading”. If so, give it a few minutes.
This is amazing job.
Your sheets and movies gives a lot of opportunities to learn and I hope earn :)
If it isn't a problem could you send me a finish sheet?
Thx in advance
docs.google.com/spreadsheets/d/1AwKopyWTOGIXKkRdP4XPKhE8ZXotsMkqp40gZ-u0oUA/copy
Do you have one for mlb side’s and totals ?
I’ll try to make a video for that this week.
CAN YOU DO THIS FOR ANY SPORTS LIKE 🏈NFL &🏀NBA ?
For sure. Once we get closer to the season, I’ll make one for NFL.
could you send me the finished sheet?
docs.google.com/spreadsheets/d/1AwKopyWTOGIXKkRdP4XPKhE8ZXotsMkqp40gZ-u0oUA/copy
Would love a finished sheet
docs.google.com/spreadsheets/d/1smkrqwTCgNuU5rTNV_6G8flR-rHepkdjk9W4C7vuMi4/edit?usp=sharing
also the link for player stats no longer works?
The link to the sheet with player ID's? Or inside the finished sheet? If it says "Loading", let it do it's thing. It sometimes take a few minutes to scrape all the data.
@@TheBenjaminWagner The URL that was hand typed reaches a 404 error on baseball reference.
I would love a finished sheet
docs.google.com/spreadsheets/d/1AwKopyWTOGIXKkRdP4XPKhE8ZXotsMkqp40gZ-u0oUA/copy
Can I get a finished sheet
docs.google.com/spreadsheets/d/1smkrqwTCgNuU5rTNV_6G8flR-rHepkdjk9W4C7vuMi4/edit
I would love a finished sheet
docs.google.com/spreadsheets/d/1AwKopyWTOGIXKkRdP4XPKhE8ZXotsMkqp40gZ-u0oUA/copy