![]() |
|
![]() | ||
|
Subject:
Historical database for european stock prices.
Category: Business and Money Asked by: wpaul-ga List Price: $5.00 |
Posted:
23 May 2003 08:41 PDT
Expires: 22 Jun 2003 08:41 PDT Question ID: 207734 |
Where can I find a database for historical european stock quotes (open, high, low, close, volume)? | |
| |
| |
|
![]() | ||
|
There is no answer at this time. |
![]() | ||
|
Subject:
Re: Historical database for european stock prices.
From: kingsd-ga on 04 Jun 2003 20:25 PDT |
Hi, one easy way would be through a Web Query and a Excel Macro and go to the website http://table.finance.yahoo.com/d?a=2&b=3&c=1998&d=5&e=4&f=2003&g=d&s=t Here the diff input Variables are http://table.finance.yahoo.com/d?a=2&b=3&c=START YEAR &d=5&e=4&f= END YEAR &g=d&s= TICKER (The variables are written in a bold Format) So what you need to do is enter all the Tickers for the company u want in an excel spreadsheet then create this webquery which takes the ticker as a parameter and put it in a loop which runs for all the 600 names Do let me know if you need any clarification about this method Regards Saurabh Devendra Singh aka SD |
Subject:
Re: Historical database for european stock prices.
From: wpaul-ga on 04 Jun 2003 23:04 PDT |
Well...thanks for the input! I really didn't know this hidden side of Yahoo. But will it work for *european stocks* as well? I believe the page you pointed out works only for US stocks.... Paul |
Subject:
Re: Historical database for european stock prices.
From: kingsd-ga on 06 Jun 2003 08:57 PDT |
Hi Paul, for eurpopean stocks what yahoo does is that it adds a extension based on the exchange after the ticker so For a company traded in the London Stock Exchange you add a .l for London Stock Exchange MARCONI with Symbol MONI.L so your address line becomes :- http://uk.table.finance.yahoo.com/d?b=5&a=2&c=2003&e=6&d=5&f=2003&g=d&s=moni.l Now the Next Question is where will you get the extension from ? that can be done by a symbol lookup for any one company in each exchange Regards SD |
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 |