General Betting

‹ back to topics

There is currently 1 person viewing this thread.

Excel Help

jamiedavies02

08 Jun 11 16:29

Joined:

Date Joined: 16 Nov 10

| Topic/replies: 107 | Blogger: jamiedavies02's blog

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.

Switch to Live View refresh Post Reply

Post your reply

sort by:

Show per page

Replies: 3

By:

Ghetto Joe When: 08 Jun 11 17:05

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

And select the data section you want as that seems to contain the stats from the main page

By:

jamiedavies02 When: 08 Jun 11 17:23

Theres other pages that i'd like to, how didi you get it into that format?

By:

Ghetto Joe When: 08 Jun 11 22:16

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_body.html for the stats then integrates it into that page. Luckily the page it's calling from is in a more excel friendly format.