-
Solved: Getting data from web site
Hi guys. This is a good one. Here is the plan. I would like to download
data from a Yahoo site. I am using Excel 2007. I can go to the Data Tab,then chose From the Web, Next I can type in the web page I need.
Hightlight the arrows for the data I need. Select Import at the bottom of the screen. Then at the ss the data is imported. All this is for just one (1)
symbol. Lets say I want to import the data for 50 symbols. Is there a way
to do that. This might take several times but lets start with this.
Thanks for your time with this.
Max
-
You best start is to record a macro for extracting data to a single page [let's assume you want Yahoo stock quotes]. Next use that code a template, create a lookup range of the URL's and then construct a loop to create separate worksheets for each web-query; then if you like the tricky part use the first sheet in the workbook to create a TOC to reference the other sheets. Stan
-
reply to getting data
Thanks I can take it from here, thanks
Max
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules