Help - Download Stock quotes from Yahoo! (long history)

[excellearner]

Can anybody advise please if it is possible to import into Excel
historical quotes download from Yahoo? I tried to use Web Query to do
this. However, it imports only about 70 records, the first page of the
data. If I need to download more than 70 records (3.5 months) the
data are broken into several pages and all I am getting is the first
page. Is there a way to download all the information into Excel in one
move?

Thank you for your help,

Excellearner

 

[R.VENKATARAMAN]

is not yahoo giving historiscal data of any scrip both in table format and
spreadsheet format then the question of pags does not come up.At least
in.finace.yahoo.com (i.e. indian yahoo) provides such historical prices.
try this url
http://table.finance.yahoo.com/d?a=6&b=1&c=2004&d=6&e=26&f=2004&g=d&s=chmb.b
o

I downloaded from January 2004 nearly 10 months. it gives open, high ,low
and close and also volume.

If you want to download for many scrips you can use vba with web query. In
some other connection I used vba to download a number of web pages in one
attempt.
==================

 

[German]

Thank you very much for your suggestion! 200 records are much better
than 70.
Thanks.