Hi. I'd like to bring some Yahoo financial data, such as the numbers in the top row of this page:
http://finance.yahoo.com/q/ae?s=HPQ
into an Excel spreadsheet. The numbers in this example would currently be:
0.87 0.95 4.09 4.49
I know it's possible, because I've seen it done years ago, but I really have no idea where to start. Can anyone help me?
Thanks,
Kevin29
Last edited by Kevin29; 01-26-2012 at 08:59 AM.
Use the DATA > Import external data > New Web Query wizard.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for your help. Got it working. Except that it imports the entire page. To import only a table, it asks for the specific table name. I've looked at the source code for the webpage listed above, but I don't see any table names. Are table names located in the source code? Could you possibly tell me the table name of the first table on the website above?
Thanks for any help from anybody.
Kevin29
When using your wizard, the web page appears onscreen. All around the screen you will see tiny yellow arrows pointing to the right. Each of these arrows is a "section" you can import individually.
Click the arrow next to the table you want and it will turn green. When you do this, only the green sections will be imported.
Umm, I don't think I have that. But I just realized I'm using Excel 2000 rather than Excel 2003 as originally thought. Does that make a difference?
When I do a web query, this is what my query looks like:
http://i1233.photobucket.com/albums/...ell3/Excel.png
See? No yellow arrows or preview of a webpage. It just asks me for the name of the table I want.
Thanks again,
Kevin29
When I use the method I described above and record what Excel does, it appears the table name imported is called "8". Try that without the quotes...
Hi Kevin29,
I was looking to see if Web Query works in Excel 2000 and found a page that may help your question at:
http://www.vertex42.com/News/excel-web-query.html
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
MarvinP: Thanks. Interesting read.
Jbeauclaire: Thanks. 8 worked. I searched the source code for all the instances of "8", to see if I could find an "8" that appeared to be a "table name". There were numerous instance of "8" in the source code, but none of them appeared to be a "table name". So I'm not sure how I would use this feature in the future without your help, lol. But at the moment, I wasn't really looking for any more data than the particular data found in table 8, so I guess I am satisfied for the time being. I suppose I could always upgrade to Excel 2003 in the future if I want to become more advanced at this.
Anyways, thanks to both of you for your help with this particular question.
Kevin29
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Excellent feature, that "SOLVED".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks