Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help - Download Stock quotes from Yahoo! (long history)
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help - Download Stock quotes from Yahoo! (long history)
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...4&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. ================== wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help - Download Stock quotes from Yahoo! (long history)
Thank you very much for your suggestion! 200 records are much better
than 70. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where it is possible to download MSN MoneyCentral stock quotes | Excel Discussion (Misc queries) | |||
download stock quotes in excel? | Excel Discussion (Misc queries) | |||
Pulling stock quotes from Yahoo Finance into a spreadsheet | Excel Discussion (Misc queries) | |||
Getting Yahoo Stock Quotes by a USer Defined Function | Excel Worksheet Functions | |||
Getting Yahoo Stock Quotes by a USer Defined Function | Excel Discussion (Misc queries) |