I thought it was well done. Would you send me the link to the finish sheet? Thanks
@matt-malyschko
4 ай бұрын
for your over/under you could use a sumif function instead of the manual approach you did
@michellemanuel1949
5 күн бұрын
Could you please explain how or what i need to make one of these for over/under for football? I would greatly appreciate it
@officialwise3x896
27 күн бұрын
Wonderful video Ben, I was looking for a mlb model like this to incorporate into my sheets but not very skilled at using sheets like yourself. Can you send me the finished sheet. Thanks
@marcusmathisjr598
2 ай бұрын
Excellent work on the presentation. I would appreciate a copy of the completed sheet.
@VassarCamden
Ай бұрын
Just want to thank you so much for the video. When I've clicked the sheet link for other people, it says #DIV/0! errors everywhere, is there something I can do to fix this?
@royboatwright2401
26 күн бұрын
would love a copy of finial. video was great
@raidennub9932
Ай бұрын
7:44 i can't get the data ,it says imported content empty
@robertduboise2749
4 ай бұрын
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
@watchmeprint
2 ай бұрын
hey brother a lot of cannot divide by zero arguments any reasoning as to why its not working?
@TheBenjaminWagner
2 ай бұрын
@@watchmeprint the most likely is that the data hasn’t loaded yet. The first time you open it, it could take quite a while since you’re making so many requests at once. But if the data is there, it would likely be that the player has an average of zero. That happens most often with things like home runs.
@joespano689
3 ай бұрын
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.
@Amy-Ca
4 ай бұрын
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...
@jester162001
3 ай бұрын
Love your content working through watching it all. If could also get the link to these sheets that would be awesome.
@TheBenjaminWagner
3 ай бұрын
I appreciate that! Here’s the link: docs.google.com/spreadsheets/d/1AwKopyWTOGIXKkRdP4XPKhE8ZXotsMkqp40gZ-u0oUA/copy
@tempyesthatsme9952
6 сағат бұрын
Need it please
@erichcas1778
Ай бұрын
Great Model ! Question, For next year all i have to do is change the 2023 and 2024 dates in the data tab correct? Also, where would i obtain the Player ID list? that was uploaded to the players tab? any other things you can think of would be great. Thanks !
@cadetheking
3 ай бұрын
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!
@TheBenjaminWagner
3 ай бұрын
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
3 ай бұрын
@@TheBenjaminWagner Thank you! Could you link the video you are talking about?
@TheBenjaminWagner
3 ай бұрын
@@cadetheking kzitem.info/news/bejne/xpl4smqQqIB1lJwsi=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.
@cadetheking
3 ай бұрын
@@TheBenjaminWagner Thanks again! This video was great! I’ve already started to profit from having a strikeout model like this!
@jaquaviusroyster5881
29 күн бұрын
Finished sheet
@wagzwagerz
4 ай бұрын
Well done presentation. Would love a copy of the finished sheet.
Love the content- can’t believe you’re actually emailing everyone that’s requesting a sheet. That sounds exhausting but thank you! I liked and subscribed can I please get a link to the sheet? Also, if I pay you for your time, can you look at my current MLB model and help me reverse engineer it to change a couple things. I’ll pay you for your time and you can obviously keep a copy of the model for yourself which I paid for. Can discuss in further detail if you reach out…or simple say no if you’re too busy to mess with it. Should be straightforward but I totally get it no hard feelings…
@TheBenjaminWagner
2 ай бұрын
@@My_oh_face Appreciate it, man. Yea I can take a look. Email me at ben@bookiesmart.com and here’s the link to the sheet: docs.google.com/spreadsheets/d/1AwKopyWTOGIXKkRdP4XPKhE8ZXotsMkqp40gZ-u0oUA/copy
@Mr.Parenting
3 ай бұрын
do you have an entire sheet full of every team if so can you send the link?
@rickycoolige472
3 ай бұрын
Hello, This model is absolutely great... It appears that the links you was using are not working mow. Can you send an update ? Mush thanks....
@TheBenjaminWagner
3 ай бұрын
@@rickycoolige472 everything looks like it’s working fine on my end. What is giving you trouble?
@joshmorgan228
Ай бұрын
@@TheBenjaminWagner the link to player reference is not working for my spreadsheet either . i type the url the same way as you did and it says the link does not work
@njm1451
2 ай бұрын
Also is there any way to make it so the sheet updates automatically with stats? Or does it already do that.
@TheBenjaminWagner
2 ай бұрын
@@njm1451 each time you open the sheet or change a team, the stats are current.
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?
@TheBenjaminWagner
3 ай бұрын
On first load, it can be a while..maybe 20 minutes, but subsequent loads are only a minute or two.
@RyanMorrison-yq4yc
3 ай бұрын
Hey man, can you please send me a link to the finished sheet?
why do you use the poisson dist instead of norm dist? is it because you don't have the standard deviation available?
@TheBenjaminWagner
4 ай бұрын
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.
@matt-malyschko
4 ай бұрын
@@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!
@sawekmartyn1588
3 ай бұрын
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
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.
@johnnygore8817
4 ай бұрын
Can i get finished sheet. Tried to follow video but get error when adding the formula under with team names and baseball reference page
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.
@TheBenjaminWagner
4 ай бұрын
@@johnnygore8817 does it say loading or perhaps an error or is it literally not changing at all?
@johnnygore8817
4 ай бұрын
Literally not changing.
@TheBenjaminWagner
4 ай бұрын
@@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.
@smokey_robinson_5048
4 ай бұрын
CAN YOU DO THIS FOR ANY SPORTS LIKE 🏈NFL &🏀NBA ?
@TheBenjaminWagner
4 ай бұрын
For sure. Once we get closer to the season, I’ll make one for NFL.
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.
@schwabsnow
5 ай бұрын
@@TheBenjaminWagner The URL that was hand typed reaches a 404 error on baseball reference.
Пікірлер: 105