Im looking for some advice, I would like to extract some golf stats into excel. I've tried the "Get Data" options but none of the websites I have found allow me to get the data in the desired format.
The stats Im looking for are Top 10 finishes, Putts per round etc. I need them to be updated automatically (Eg "Refresh Data" in excel)
I have tried the following sites:
http://espn.go.com/golf/statistics
http://www.pgatour.com/r/stats/info/?02394
Could somebody suggest either an alternate sight or method for me to get these stats, thanks.
And select the data section you want as that seems to contain the stats from the main page
Lots of these pages are made up with bits from other pages try doing a web query on http://www.pgatour.com/.element/ssi/auto/3.0/sdms/stats/r/body/current/02394_body.htmlAnd select the data section you want as that seems to contain the stats from the
Lots of webpages load info from different places to make up the full page. So you can have a static main page but when info changes like stats there's no need for the website to rewrite the main page just update a database etc. You can use programs called http sniffers that show how the page is being loaded. That'll show any other http addresses the page you're looking at may be calling info from.
The site http://espn.go.com/golf/statistics contains the info you need but it's not organised in an excel friendly format
http://www.pgatour.com/r/stats/info/?02394 actually calls upon the separate page http://www.pgatour.com/.element/ssi/auto/3.0/sdms/stats/r/body/current/02394... for the stats then integrates it into that page. Luckily the page it's calling from is in a more excel friendly format.
Lots of webpages load info from different places to make up the full page. So you can have a static main page but when info changes like stats there's no need for the website to rewrite the main page just update a database etc. You can use programs c