Hello, Basically I have a list of zipcodes and I would like to create a webquery which will pull back the average temperature, rainfall, snowfall for a week (last week or other historical weeks). I found a website which has this info: http://www.wunderground.com/history/ and I can put in a zipcode and then select the date (which would be last week Sunday) Then it goes to another page which has the info: http://www.wunderground.com/history/airport/KNYC/2012/3/18/DailyHistory.html?req_city=New+York&req_state=NY&req_statename=New+York and I can select a tab to show the weekly info (rather than the specific day) at this address: http://www.wunderground.com/history/airport/KNYC/2012/3/18/WeeklyHistory.html The chart that opens beneath that contains the info that I'm looking for. Now I only need those 3 values. So any ideas on how to be able to run this through for many zipcode values? (700 or so) Thanks!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Complex Web Query Help

Thread starter largeselection
Start date Mar 28, 2012
Tags

history query weather web weekly

largeselection

Active Member

Mar 28, 2012

Hello,

Basically I have a list of zipcodes and I would like to create a webquery which will pull back the average temperature, rainfall, snowfall for a week (last week or other historical weeks).

I found a website which has this info:
http://www.wunderground.com/history/

and I can put in a zipcode and then select the date (which would be last week Sunday)

Then it goes to another page which has the info:
http://www.wunderground.com/history...=New+York&req_state=NY&req_statename=New+York

and I can select a tab to show the weekly info (rather than the specific day) at this address:
http://www.wunderground.com/history/airport/KNYC/2012/3/18/WeeklyHistory.html

The chart that opens beneath that contains the info that I'm looking for. Now I only need those 3 values.

So any ideas on how to be able to run this through for many zipcode values? (700 or so)

Thanks!