Google Answers Logo
View Question
 
Q: Historical database for european stock prices. ( No Answer,   3 Comments )
Question  
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)?

Request for Question Clarification by leader-ga on 23 May 2003 16:27 PDT
How historical the quotes be? (1 year, 5 year more). Do you seek all
the european markets or just the major stock exchanges? I know a
website which lists nine major stock exchanges with five years of
quotes? Does this sound acceptable?

Clarification of Question by wpaul-ga on 25 May 2003 23:37 PDT
Ok..... I shall clarify.

Basically I need to perform technical analysis studies on 600 european
stocks via Metastock or Omega Tradestation. I do need to access a
service (will pay the usual fees, etc) that gives me daily updates as
well (but that's the easy part).

5 years' worth of history would be perfect.

Thank you...

Paul

Clarification of Question by wpaul-ga on 29 May 2003 09:07 PDT
Uh... any ideas, Leader-Ga?

Willing to increase the price (to a certain extent) but I would need a
swift answer, if possible.

Thx,

Paul
Answer  
There is no answer at this time.

Comments  
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

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

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 Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy