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

*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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KpBpr-BNVb8.html 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!

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

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

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.

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

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

Definitely needed this. Appreciate you my guy!

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

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!

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

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!!!

Great video. Appreciate the help.

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

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 🐠🤣🤣

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

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!

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

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

Thank you for this!!!!

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

Your a gem bro love ya man

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.

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

Very impressive. New sub

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

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?

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 🔥

great video buddy

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?

thank you

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

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

Catching up and sharpening my skills

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.

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?

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!

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

This is amazing đude

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

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

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?

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

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?

You should do one for player props

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

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

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!

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?

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!

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?

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

@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).

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

is this still the spread model you use?

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.

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

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.

I been subscribed to Ev for a while and I can honestly say that he is the best on RU-vid 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!!

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

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

Taking notes 📝

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

How has your model been doing this year?

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!

I don’t have an import html option

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

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.

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

Anyone have a model for players stats?

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.

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....

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

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

The vlookup keeps telling me array value could not be found

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.

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

How I get in the discord

Team rankings does not work anymore

🐐🐐🐐🐐

🔥🔥🔥🔥🔥🔥🔥

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

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