Sports Betting Web Scraper

[@nato78g]

you wouldnt believe the amount of times ive manually entered data! This is amazing!

[@wageredontilt1649]

Glad it helped! If there is anything else you'd like to see, learn, or have automated just let me know. I like to get the knowledge in everyone's hands so they can start to find the edge. Happy Wagering!

[@discovermetaldetecting]

Brilliant! A bit late to this video and wished I found it last year before struggling writing a VBA scraper for MS Excel. 👍🏻🙏🏻

[@wageredontilt1649]

Thank you, glad you found it usefull!

[@Dolf_1x]

Thanks so much for the tuto... Really helpful to start with the mobile Google sheets.

[@degizmomusic2082]

Massive help and time saver, thanks so much.

[@wageredontilt1649]

You are welcome, let me know if ya have any questions or need me to do a video on similar/deeper content knowledge.

[@davidrohan6098]

Amazing video! Do you know if any of these methods work for sites behind a subscription / login

[@wageredontilt1649]

These methods will not get around a log in. It will only scrap data that is access available. So if you are subscribed to a data source, and are logged in you can scrape, but will be unable to do so if you are logged out.

[@davidrohan6098]

@wageredontilt1649 Oh so if I go through the same steps for a site that I'm logged into in another browser it should work fine? It's not a book by the way it's a source for player football stats

[@wageredontilt1649]

Correct. As long as you are not logged in via incognito mode in a browser, it should work just fine. It did the the past. When you log in, there is a key that is basically shared amongst the browser and its tabs. While that key is active it should work. If once the key/log in times out, the pulling data will stop working. In the past, this had worked with data that you needed to log in to see, however each site is differing. SO if they came up with a way to block something like this, I would be unaware. Hope it still works for ya!

[@davidrohan6098]

@wageredontilt1649 Thanks so much for your time! Being try to build model for player prop fouls, passes, shots for soccer for a few weeks now and best channel I've came across for it. Earned a sub here

[@TheManto1980]

what excel version is this? because i dont have this options in mine.

[@wageredontilt1649]

This is in the most recent version. You may need to enable it. If you select File and Options, to enable it should be in there

[@Mcgurkyyy101]

Know why I’m getting a “resource at url contents exceeded maximum size” message when I do this. I’m also using sports reference and it worked for 2 tables already but won’t work for another one

[@wageredontilt1649]

Reference recently started slowing the amount of times their site can get pinged by scrapers, as it was hammering their site. Which site/table is throwing the exceeds maximum?

[@Mcgurkyyy101]

@@wageredontilt1649 the MLB team fielding table

[@Jdoghaynes2]

when i do this i get a #N/A could not fetch url error, do you know how to fix this?

[@wageredontilt1649]

What is the url you are using and for which table? I can try to reproduce and let you know.

[@gavooleiva6040]

I tried the google sheets and didnt work for the websites i was trying to scrap data It gave me a #N/A

[@wageredontilt1649]

There may be an issue with the URL you are attempting to pull in, what was the specific URL that had the data? If there are several tables on the screen, what was the specific table you were looking to pull in?

[@realezamantilla]

Only Office 365?

[@wageredontilt1649]

Sorry, don’t understand the question. Are you asking if this stuff only works on O365?

[@realezamantilla]

@@wageredontilt1649 import web, is it only for Office 365?

[@wageredontilt1649]

Google Sheet has a similar behavior but I don’t know if other spreadsheet systems have it

[@wageredontilt1649]

Google sheet has a similar thing, however I’m unsure about other spreadsheet applications

[@thewaffler12]

Is there a way to do this with sportsbook odds?

[@wageredontilt1649]

You can, however many will require a log in and user name, and make the tables far more complex. There are services that offer this type of feature along with many others. You could check out Unabated.com I’ve done these in excel in the past, but they break easily if the book makes a slight change.

[@thewaffler12]

@@wageredontilt1649 I dont think unabated will work for me because I am interested in player props. Are there any services like this that have player props?

[@wageredontilt1649]

None that I know of as of right. The few that used to do it no longer are operational. You could look into a custom code or python script on github

[@Cruz27682]

This is so helpful, would you be kind enough to share the file with us?

[@wageredontilt1649]

So, for this one I am not so sure how helpful the scraper sheet would help, as it really depends on which stats you are needing and wanting. Were you referring to a differing video or sheet I have demoed?

[@Cruz27682]

@@wageredontilt1649 I was hoping you would automate a system that scrapes odds from different bookies and automatically calculate for arbitrage opportunities.

[@wageredontilt1649]

So, this would be a bit more complicated as most books put their live odds behind a sign in. You could possibly do this if you have the accounts all logged in, and set the import html in Google sheet to point to those screen, or set to import those tables via ms excel. You’d be able to add a column that looks at the values comparing them and calling out which ones would play well. The easier way would be to use a service that offers this like Unabatted or see if there is an API feed somewhere to make calls to

[@Cruz27682]

@@wageredontilt1649 brilliant!

[@melancholiac]

Please: it's scraper, not "scrapper". But we'll done for the content.

[@wageredontilt1649]

Good catch. Totally missed the typo. Thank you! I have updated as such.