| View Question |
|
|
 | ||
|
| Subject:
Downloading information Yahoo Historical Trades to Excel
Category: Computers > Programming Asked by: noon-ga List Price: $50.00 |
Posted:
06 Aug 2004 09:07 PDT
Expires: 05 Sep 2004 09:07 PDT Question ID: 384384 |
I am looking for a solution (probably VBA) to download historical quotes from Yahoo. Basically looking for line 1 of the spreadsheet to hold the symbols and then historical quotes listed downwards in columns (first column being the date) | |
| |
|
| ||
|
| There is no answer at this time. |
| ||
|
| Subject:
Re: Downloading information Yahoo Historical Trades to Excel
From: just4fun2-ga on 06 Aug 2004 11:34 PDT |
Have you tried just coping the data and then using Paste Special in Excel to place it in the cells you want? |
| Subject:
Re: Downloading information Yahoo Historical Trades to Excel
From: noon-ga on 06 Aug 2004 12:55 PDT |
just4fun-ga...thanks for the suggestion....as i am looking at downloading this data and keep it going for around 50 stocks, copying and pasting will be very cumbersome. I was hoping for a small program within excel that can do this for me. At the moment i have to do each symbol separately and it is rather time consuming. |
| Subject:
Re: Downloading information Yahoo Historical Trades to Excel
From: ssl_answer-ga on 21 Aug 2004 18:02 PDT |
I have a perl program that can do the similar jobs. http://www.employees.org/~ssl/perl/stock.txt Sheng-Liang Reference: http://www.css.tayloru.edu/~btoll/resources/direct.php?loc=Perl+Examples |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
| Search Google Answers for |
| Google Home - Answers FAQ - Terms of Service - Privacy Policy |