Can you copy a webpage into excel using a macro?

[JKC691]

Hi guys

i use statfox stats for some systems i use. The results are good. I am tired of cutting and pasting every game stats into excel. Is there a macro i can use or better way to do it. On saturday it can take a long long time for hoops.

Any help would be greatly appreciated

[Miz]

you should look into scraping.

[a4u2fear]

Yes definitely. You need to use VBA to import a web page, then use code to go through multiple days and pull them in. I once started a thread on how to do this in VBA/Excel but I've had a few too many brews to find it right now.

Whats good about excel and VBA is you can click record macro, do what you want, then stop it and read what the code needed was to perform the action

[a4u2fear]

Read this if you can follow you will succeed

http://forum.sbrforum.com/hockey-betting/2207848-anyone-interested-pulling-historical-results-odds-sbr.html

[Miz]

what sport is it? way faster to buy a subscription... gamblindbs dot com is a good one

[James Marques]

Hi, long-time lurker, first-time poster. Excel is a great tool for web scraping on its own (with the import data function), but even better if you learn to use Python. I haven't used Excel as much in the last couple of years (I'm using OpenOffice Calc now), but it is very user-friendly. The help files can walk you through recording macros to scrape whatever info you need. Some sites (a lot of ratings sites like Dunkel or even somewhat with Sagarin) can be a b**ch but there's always a way around it. I do mostly college football, and cfbstats.com will go as far as to give up .csv files you can easily convert into Excel files with a couple of clicks. They go back all the way to 2003 I think.

[nash13]

I'd like to scrape three websites (Dunkel Index, DCI and Massey Ratings) , but I don't have the knowledge nor the tools to do so. Maybe should start with Python or something simillar.

[a4u2fear]

I could start a day to day tutorial of excel scrapping if people want. VBA is so easy to use and I have successfully scraped data for nhl and nfl for 5-7 years off the web

[nash13]

this would be awesome. i would really like to contribute some strategies based on scrapping data from several websites. i have backtested data from covers.com and various rating sites, but never had the skill to combine them.

[oddsfellow]

Would be very interested in this if at all possible

[antonyp22]

Count me in for the tutorial

[a4u2fear]

Nash, that Massey website is a php/HTML and the data is embedded in tables that not anyone can access, so scraping that page is not doable from my knowledge.

if anyone else wants to see scraping using excel VBA on another website just say so

[nash13]

thanks for the response. i really think that python is the way to go from here. thanks for the effort. but anything else could be useful too.

[solring]

I could start a day to day tutorial of excel scrapping if people want. VBA is so easy to use and I have successfully scraped data for nhl and nfl for 5-7 years off the web

The sticky might be a good place to put this...

[redking]

I could start a day to day tutorial of excel scrapping if people want. VBA is so easy to use and I have successfully scraped data for nhl and nfl for 5-7 years off the web

I don't know if you're still doing this but I would be interested in a tutorial.

[Professor1215]

I am looking to get data from www.fangraphs.com. OP, can you PM me? Would love to work with you.