Web Query for Multiple Tables

[martopeteiro]

Hello,
Can anyone please help me with this? I'm trying to get stock quote data
from Yahoo. I want to download the data for 400 hundred stocks, and I'd
like to put each in a *different* worksheet.

Specifically, I want the information in pages such as
http://finance.yahoo.com/q?s=msft

and I need table number 18 from these pages. (That page is for
Microsoft -msft-; I'd like to download several different quotes). So i
would need perhaps a macro that does the following:

-Take http://finance.yahoo.com/q?s=msft , table 18, and store that in
worksheet 1
-Take http://finance.yahoo.com/q?s=yhoo, table 18, and store that in
worksheet 2
-etc.

Does anyone have any idea of how could this be done?

Thanks in advance,
Martín

 

[Don Guillett]

I can custom design whatever you want in this area. What is table 18?
Give me the url. contact at address shown below.

 

[fhunth]

I can develop it for you

*Hello,
Can anyone please help me with this? I'm trying to get stock quot
data from Yahoo. I want to download the data for 400 hundred stocks
and I'd like to put each in a *different* worksheet.

Specifically, I want the information in pages such as
http://finance.yahoo.com/q?s=msft

and I need table number 18 from these pages. (That page is fo
Microsoft -msft-; I'd like to download several different quotes). S
i would need perhaps a macro that does the following:

-Take http://finance.yahoo.com/q?s=msft , table 18, and store that i
worksheet 1
-Take http://finance.yahoo.com/q?s=yhoo, table 18, and store that i
worksheet 2
-etc.

Does anyone have any idea of how could this be done?

Thanks in advance,
Martín

 

[Kevin Stecyk]

Don,

After you are done, please show your solution.

And I too am curious what Table 18 is.

For what it is worth, I believe XL provides a "Microsoft Investor Stock
Quotes.iqy" query and it is located typically somewhere like, C:\Program
Files\Microsoft Office\Office\Queries.

Thank you.

Regards,
Kevin

I can custom design whatever you want in this area. What is table 18?
Give me the url. contact at address shown below.

 

[martopeteiro]

Thank you all for your interest in this question. I've been a bi
unclear. Table 18 refers to the number I have to enter if I try to d
this manually in Excel 2000. I would use Data - Get External Data - Ne
Web Query. From there I would choose as the address something like:

http://finance.yahoo.com/q?s=msft or
http://finance.yahoo.com/q?s=yhoo

or whatever. Then in the box that says "write the number of the tables
separated by commas" (or something like that, I've got the Spanis
version) I would enter 18. The number of the table that has the data
need (price, bid, ask, etc) happens to be 18. I'm not interested in th
rest of the page.

Of course, I don't want to do this manually for 400 stocks. So I wa
wondering if a macro could be made to do this automatically for man
different stocks (msft, yhoo, ebay, aapl, etc.) and store each in
different worksheet.

Thank you very very much for your help,
Martí

 

[Don Guillett]

Symbol Name Date Time last open high low Prev Cl Volume
BMY BRISTOL MYERS SQ 12/11/2003 2:18pm 26.22 26.00 26.22
25.92 25.92 2,909,700
CSCO CISCO SYSTEMS 12/11/2003 2:23pm 23.75 23.69 23.87 23.45
23.78 34,923,588
EXC EXELON CORP 12/11/2003 2:17pm 64.00 63.90 64.07 63.37
63.90 747,000
FE FIRSTENERGY 12/11/2003 2:18pm 34.80 34.90 35.02 34.67
34.79 431,900
GAB GABELLI EQ TRUST 12/11/2003 2:18pm 7.99 8.00 8.00
7.95 7.99 147,700


One mouse click from a list of as many symbols as you like. FAST!
If you are looking for something like the above, I can custom design.
Contact me privately at the address below.