How to Build a Sports Betting Model for NBA Against the Spread and Totals (SUPER EASY)

Hope this helps you guys! Make sure you truly do your own research and pump in AS MUCH info into a model like this as possible and NEVER stop trying to improve it!
Team Rankings Site: www.teamrankings.com/
------------------------------------------------------------
🔴 Subscribe for more DAILY sports content: kzbin.info...
🔵 Become a BALLER and further support the channel! / @guybostonsports
Check out the Guy Boston Store: guybostonsports.com/store/
Follow Guy Boston Sports on Twitter: / guybostonsports
Follow Guy Boston Sports on Instagram: / gbossports
Follow Guy Boston Sports on Facebook: / guybostonsports

[@GuyBostonSports]

*UPDATE: We have 5+ videos (and counting) that dive DEEPER into building a model for Members on the channel so hit that join button if that interests you!* Another update.. FREE MLB MODEL VIDEO: kzbin.info/www/bejne/gaGloaVjd7OJmJo Hope this helps you guys! Again, make sure you just USE this to build your own model.. i would not recommend something this simple. SUBSCRIBE if you enjoy and let me know if you'd like to see more. ALSO - i never changed the column for the home team to pull from the HOME column on the backend...WHOOPS... so keep that in mind!

[@fab2heata2049]

You don’t have a join button

[@auditingamerica7467]

How can I join to see the other videos

[@joedirt7119]

Let’s give props To one of the hardest working guys on KZbin appreciate the work homeboy good luck

[@GuyBostonSports]

Appreciate that!

[@patrickduran8891]

More of this please!! This video was amazing and a big help! This video was awesome and look forward to the next one

[@theysiguy7367]

Dude, THANK YOU! I needed the basics and this was it! Step by step, small explanation and quick outcome, great video and even added the sources i like uncut and rawness of the video as well it felt like we made as partners LOL. TY again.

[@GuyBostonSports]

Great to hear! Appreciate that

[@howieisboss]

Just the content I was looking for. Hoping you do another video! You've earned a new sub!! Great work.

[@pariscal132]

The grind is worth it, your fans appreciate all your videos!

[@nickrodriguez9771]

this is one of your most viewed/fastest growing videos. I enjoyed it. unfortunately, I can't find any other of your videos on the subject. take it from someone who's looked for model building tutorials, there are almost NO good free resources out there that are feasible for an excel novice. do you plan on doing a series with step by step building of an actual usable model? more in depth formulas and formatting would help people like me learn!

[@aldovittozzi9596]

This was amazing. Can’t wait for the more in depth video

[@mrcdvs]

Definitely needed this. Appreciate you my guy!

[@derekdavis3679]

Dude this is amazing! Thank you for putting this together!

[@GuyBostonSports]

Appreciate that!

[@StatmanJames]

Great video as always my guy. We appreciate your hard work and dedication consistently uploading to the channel. 🙏🏼

[@Dmo_Ace]

Great video! Is there another video you have for weighting multiple stats?

[@Derfledermous]

Thanks for this, it's very helpful. Do you have any videos that show how to create a model using weighted stats?

[@SEABASports]

Omfg!! Thank you so much! Now i can import stats from sites easy! I wish id seen this first, i finished my table for today lol excited to use this tomorrow! Thank you again!!!

[@GuyBostonSports]

Sweet! Yes some sites are tricky to feed in. Keep that in mind

[@MoneyMafia24]

This was such a dope vid. I say go as deep as you can go with these type vids - the info is priceless and I love watching your take every day. Keep up the awesome work EV and steer clear of the guppies 🐠🤣🤣

[@YouViewz]

Great video. Appreciate the help.

[@uncutt_talktv]

Man, I look forward to your videos and picks every morning. I usually I have my picks already, but it's nice to see what you choose. Today, I liked Cavs. I saw you had them as well, so I took them with over in that game since you chose that at well. And you can never go wrong with the thunder. +7 Need a win today. Thanks

[@garymichalske2274]

Thank you so much for showing the detail involved with considering relevant stats in Excel or Google Sheets! I can hardly wait for you to expand on this first video. I was totally stuck on how to incorporate multiple stats to come up with a final spread or total. But after watching your video, I now know to start heading in the right direction. I'd love to see how you add the other stats you mentioned, e.g. pace, turnovers, etc. and the weights you apply to them. Getting real excited about this now. Thank you so much!

[@GuyBostonSports]

Appreciate that Gary! Keep an eye out for more. There will be more

[@alexmusco5152]

@@GuyBostonSports need that next video!! Thanks for all the help this was great

[@derekdavis3679]

@@alexmusco5152 Agreed!!

[@kramsemaj7869]

@@GuyBostonSports Wondering if the followup video is available. Thanks

[@Kieran-qk3ky]

Wanted to say thanks for this mate, since making this model and adding stats, I've gone 7-1 so not too shabby.

[@guan3]

I just made this model, may I ask what you added?

[@tyfoster1840]

Thank you for this!!!!

[@andrewvivs7336]

Hey there thanks!! Have you made a more in depth video for nba? I seem the MLB

[@THEREALPHRESHMEN]

This model is very impressive. I was looking for other videos. How do I get the schedule inside excel ?

[@taylorcollison6776]

Any videos or resources about adding other stats? I see how I would logistically do it I think (with import HTML, etc) but I guess I don’t follow the math behind it. Like how can you factor pace or turnover rate or something like that into a projected spread/total?

[@tiagofigueira5361]

Great content 👏 I was really looking for something like this , thank you só much. I just have one question, do the IMPORTHTML funtion , update the statistics automatically everyday in our Sheet, as soon as new data is updated in the website? Keep up the good work 🔥

[@GuyBostonSports]

Yes it does - so whatever that table looks like on the site will be updated automatically. If you ever get #N/A errors, just fo to that "IMPORTHTML" cell and cut/paste it back in and it should refresh

[@tbrissy-rq1nn]

Your a gem bro love ya man

[@ethandupas5750]

Loved the video would love to see a deeper dive into it. Could potentially turn it into a class. I just created this one and have one for efficiency and compare and go off that. Would be cool to see one to see how individuals playing vs not playing because of injury would affect the outcome.

[@zandrrz]

Hey bro i was just wondering if you could help me. I made the model in this video but i’m trying to extend it to other stats too like pace, rebounds, turnovers, etc. How would i incorporate these other stats into the projected team totals? Any help is appreciated

[@Reelbabyja]

@@zandrrz lmk if you learn how I’m trying to make my own model as well

[@sunnyboateng180]

Very impressive. New sub

[@jordantufano5917]

great video buddy

[@GuyBostonSports]

Glad you enjoyed. More model related stuff coming

[@alexbogues6094]

Great video, I recently became a member because of how great these model videos are! I have gotten everything but the last bit. I’m struggling to find how you got to the number total and the 2nd projected game total. I was wondering if you could help me?

[@GuyBostonSports]

For this one I just took the average team ppg and oooh allowed

[@alexbogues6094]

​@@GuyBostonSports sorry just clarifying, how you got the "number spread" value of 1.15. I appreciate it

[@terencepellum8347]

How did you get the numbers for columns B84, B85, C84, C85, D83-D89 at the two minute and 28 second mark of the video?

[@haydenbrill3182]

Great Video! Are you able to make more in depth model content?

[@GuyBostonSports]

Hey! Yes that is a plan I have for the channel

[@donnydew6207]

At 14:21 if you copy paste you need to change C4's 6 to a 5 within the VLOOKUP so you are getting the home ppg instead of away.

[@GuyBostonSports]

Yup! I included that originally in the pinned comment. Was just moving too fast

[@scottwoodrow8481]

My friend I’m in the middle of finishing my google data Ana… cert and would love any advice for me as a beginner. Also I listen to VSiN crazy u used there website not many ppl know about VSiN. And the only problem I see using team rankings or other data sites is sometimes the statistics vary or off by a lil bit.

[@playbookaction]

Would be really cool to see the most accurate version of this model, did you ever do a more in detail video?

[@ericscott4225]

Are you a average joe or a handicapper professional what do you do full time I’m just interested???

[@cristianpreval5939]

thank you

[@guan3]

Do we always take the actual spread of the Home team?

[@Elculichi2]

Do you have a Model for MLB totals? If not, is it possible you make one? Can you show how one would import the last 5 games played? Is it possible to pick and chose what gets imported and automatic updates daily?

[@MrUnknown-qk7sf]

Hey sam wise 🤣 where is frodo baggins bro? Hhahaha. Anyway nice vid man ❤

[@DiegoGarcia-uy6ir]

Great work man! Keep up the spirit. Do you think you'd be able to share your googlesheet file with us? I want to make sure mine is set properly and would love to compare it to yours. If it is not too much to ask! Thanks!

[@GuyBostonSports]

I’m actually going to be creating a series that walks through this even slower. So I can do that and probably share this as well 👍

[@jack10b7]

video is awesome but is there an excel formula you could use to make a drop down menu instead of having to type names in the Home and Away?

[@theFunnyShoww]

Hoping I can answer your question but what I tend to use is, insert > dropdown > criteria > dropdown (from a range) and then you can insert the range from either one of the datasets team names

[@III1II111II1III]

@GuyBostonSports Hey I was wondering if you ever kept track of the "NBA Crazy" model to see how well it did that season? I've been using roughly the same stat lines as 2:23 for this season, but I found that if you calculate heavier weights for the streakier/home teams it becomes a lot more precise at a cost (I'm at 13% ROI/unit on totals, but -8% so far on spreads).

[@GuyBostonSports]

Since the tutorial we havent tracked it honestly - if you have any bigger ideas hit me up via email! [e-mail]

[@III1II111II1III]

Thanks for the reply@@GuyBostonSports, I'll let you know if I can put it all together. I'm currently in progress of manually inputting historical odds for each individual game to calculate the different model efficiencies. If I could streamline that I would be golden. I was a bit of an excel whiz but I could never put together the sports side of the spreadsheet until I saw this tutorial. Great stuff!

[@duybaotran6297]

This is amazing đude

[@deyawahdan7668]

when using this model should you use the home team spread for the "actual spread" or the away team?

[@GuyBostonSports]

I usually work off of the home team

[@Iamiami409]

is this still the spread model you use?

[@tahwoncharay5559]

I figured it out... I gotta look at the small words in how it imports... Good looks though

[@jacobquintal3395]

if i was to add more stats into this to dig deeper, would i just add more tables for the stats i want? how would those stats help get different numbers if it thinks those numbers have the same values as the rest? like say i wanted to add offensive efficiency into this. how would that help me get a better edge when spitting out projected totals and spreads

[@GuyBostonSports]

Yeah ideally you could tinker constantly until you get it to a good place. Taking the average or weight of ANYTHING you add in

[@kuoteoble]

Catching up and sharpening my skills

[@terrelljones6867]

Might sound stupid. But when you add stats like Pace and Offensive and Defensive efficiency, how would you have those data points directly factor into the point total or the spread? Is it "if" functions? Do you do like weighted importance of stats or something? Thanks!

[@GuyBostonSports]

a lot of testing, trial and error.. but correlating any metrics like that to a specific amount of points would be the move

[@juanescobar7734]

How can I join the channel for the rest of the "Building sports betting Models" playlist?

[@terencepellum8347]

How did you get the numbers for columns B32, B33, C32 and C33 at the two minute and 25 second mark of the video?

[@peterokodaso9501]

Good morning sir please sir I need your game code please

[@user-yh9tw3qn5b]

Hey man these videos deserve a lot more attention. If you could find a way to re-release these or talk about more with your new following, I'm sure you'll see these get a lot more attention. There are more number junkies these days!

[@GuyBostonSports]

Thanks, will do! Good call

[@traviswilliams8463]

Is Google sheets better for importing external data then excel? I have been trying to create a dfs spreadsheet but running into the issue that I can't find any sites that have tables that will import into excel for things like spread and total

[@GuyBostonSports]

I think long term - excel is more powerful... however, google sheets is more accessible and easier in my opinion

[@biig_vern]

Excel is better with large datasets and I notice you're using Google Sheets (Obviously). Would it not be beneficial to use Excel with all the data you're always referencing? Also, is there not more possibilities with Excel as far as functionality & formulas go? Great Vid. Thanks for takin the time!

[@GuyBostonSports]

First, thank you! Second That is correct, but I wanted to start these videos based on a free platform. I would recommend excel for ANYONE that has the access. But I do want to make it clear to people that it’s possible just with internet!

[@kevinoliveros4340]

Would you be able to explain why you would go with the away or home team based on the projected spread? Not sure if I completely understand it. So if a team is favored but the proj. Spread shows a positive number, based on the model would you choose the underdog?

[@GuyBostonSports]

Technically it is just comparing what the projection comes up with for the final score vs what the book makers have the spread set at. Does that help?

[@kevinoliveros4340]

Yea, thank you. Lately I’ve been following the projected O/U. It’s about 50/50 lol

[@raleighpintodias1781]

im having trouble when using the data from the tables imported. For exemple when i try to calculate the sum ir always returns 0. It seems like the values are seen as text.

[@DarkGamer320]

I’m getting the same issue

[@Dannymiel1]

I think there is something wrong in this model. When looking at the home team for instance in PPG AWAY/HOME, why wouldn't we use the HOME numbers for the home team, instead we use their season average away stats? Same for opponent's away/home for the home team, wouldn't we use how much the team lets up at their home court to opponents?

[@MrCoreyTexas]

You are paying attention! He messed that one up, he forgot to change the column from away to home.

[@clmco36]

I been subscribed to Ev for a while and I can honestly say that he is the best on KZbin as far as really wanting to help people be more profitable sports betters. I've tried other channels and they seem like dirt bags. Ev doesn't treat people like "oh I'm so smart and your all a bunch of morons." Ev is the real deal and he's the man!!

[@GuyBostonSports]

that means so damn much man, truly

[@uncutt_talktv]

💯

[@Reelbabyja]

You should do one for player props

[@davidt6043]

How has your model been doing this year?

[@erickgonzalez1753]

Is there a way to pull the stats from the nba website rather than teamrankings?

[@wagzwagerz]

Google API for sports.

[@tahwoncharay5559]

Yo did your module go down? The way you got it laid out it wont import with your process...

[@GuyBostonSports]

Some sites just simply dont import well. However, if you are using a site that you HAVE successfully imported with before, try changing the table number in the import formula from "1" to "0" or vis versa. Sometimes formulas just break and need a refresh, sadly. But the function should be working completely

[@jasonwilliams1700]

Does the =import thing work on excel cuz I can’t find it it’s not working when I do that

[@user-be3ob6zx6d]

Did you ever figure that out?

[@christophermann94]

How do you add in things for the score prediction like rebounds, pace, etc. My numbers go all kinds of wonky when i add stuff other than ppg/opp ppg.

[@GuyBostonSports]

You have to correlate those to a point value!

[@andrewvivs7336]

What do you mean by that​@@GuyBostonSports

[@johncorley9785]

I don’t have an import html option

[@tahwoncharay5559]

Man I am no Computer wiz.. Took me about 3 hours of watching your video over and over... Yelling and screaming pretty much 1/2 the time because I didn't pay attention to the small details. In the end I got this model up and running... I usually do all these numbers on paper every morning takes hours to go through games...Now this will give me a gr8 way of weeding out games with sharp lines....Can't wait to see more boring But hugely informative ways to take it to the bookies....

[@GuyBostonSports]

Yup! It gets more and more complex. But even simple models can help! I know the videos are confusing. BUT I may make more videos on the channel on how to make these

[@alexbogues6094]

How were you able to get the "number total" and the projected game totals? I'd really appreciate it, I've got everything else, just stuck on this part at the end

[@tathagatachattopadhyay399]

@@alexbogues6094 Did you figure it out?

[@karlgawarecki4321]

I’m trying to pay but it’s saying error anyway you can send me link privately ?

[@mrcdvs]

Anyone have a model for players stats?

[@vadimmironov343]

How do we calculate average/weight? Stuck on this spot right now.

[@GuyBostonSports]

That is a tough formula, but I would recommender googling how to utilize the "weighted average" formula in excel/google sheets. PS: I am going to be bring more and more model content to the channel, including an extensive deep-dive series on building one from scratch

[@vadimmironov343]

@@GuyBostonSports Yep I was looking at weighted average. Sort of confused on how to group all of them up to get the final result. Will do some more research, if it doesn't work I'll wait on your video. Thanks.

[@alivstyson1864]

Could you reply back on the following please. I see odds jam videos ( dont know if you are familiar with them ? ) And it's not making a lot of sense sounds almost like a hustle. Do I believe in positive EV ? Zero doubt BUT on their videos most of their plays are plus 1 to 3 % EV. Your average odds would need to be plus ( underdogs ) with so slim an edge. And their picks dont seem to reflect those average odds. ALSO do they really expect most people to open accounts at 7 to 10 books to shop lines ? Last but not least to justify a 150 to 200 a month fee operating on 2 to 3 % edge you would need to be betting like 40k a month at which point you would be giving them 25% of your profits at 2%. Seems like some pretty big leafs of faith on a few fronts. Your 2 cents please.

[@handsumc363]

Taking notes 📝

[@matheuszanon7316]

When you import the data from the home team column, you use (C$2;Data!$B$2:$G$32;6;0). Shouldn't I use 5 instead of 6? Because 5 would be the data column for the home team and not the away team.

[@GuyBostonSports]

Yeah I think I address that in the pinned comment. It was a mistake when recording. Good catch!

[@matheuszanon7316]

@@GuyBostonSports It's true, sorry, I was watching the video on my cell phone and ended up not noticing this pinned comment. Thanks for answering!

[@kevinmilani466]

Since it just turned 2023, my data source went away and now it dosent work, any suggestions anybody?

[@AnswersToYourHeart]

It’s kinda hard to follow along can u repeat what to put down down at the end of the video please

[@jonahherring853]

How do you get the value of 1.15 for number spread? Thank you!!

[@tathagatachattopadhyay399]

Did you figure it out?

[@shawnjones6414]

🔥🔥🔥🔥🔥🔥🔥

[@shawnjones6414]

🐐🐐🐐🐐

[@megacrod1234]

How I get in the discord

[@GuyBostonSports]

Right in the description of any of my recent vids!

[@antoinetate5155]

The vlookup keeps telling me array value could not be found

[@TBMetalDetecting]

Team rankings does not work anymore

[@GuyBostonSports]

it was not working for a few weeks, but should be now

[@sunnyboateng180]

Bro just get to the point. Geez . 5 min in and he still talking

[@GuyBostonSports]

Imagine that. Me talking in a KZbin video? Wow

[@andrewsanta-cruz8790]

Trying to build my first model, starting the video now🫡 will see how far I get