Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Re: Historical Quotes in YAHOO Germany

[ Q2 03 - Q4 05 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

Posted by Mark on May 28, 2004 at 14:22:58:

In Reply to: Historical Quotes in YAHOO Germany posted by Silveira on May 28, 2004 at 12:32:15:

: Hi,

: I can not retrieve historical stocks from Yahoo Germany. For example, I tried to retrieved Oracle (871460.DE). I just can get the today's quote (Yahoo Germany), but not the historical. How can I do that?

: Thank you very much

Hi Silveira,

We don't currently support retrieving historical quotes from Yahoo Germany.
You can however download and import them. For your example, if you go to:

http://de.table.finance.yahoo.com/k?s=orcl.de&g=d

You will see the historical prices for this symbol. At the bottom of the
page you will see a link, where you can download the prices in .csv format.

For example, the link is:

http://de.table.finance.yahoo.com/table.csv?a=0&b=25&c=2003&d=4&e=28&f=2004&s=orcl.de&y=0&g=d&ignore=.csv

If you right click on this link, you can choose "Save Target As..." and then
save this .csv file to your hard drive. You can then use Fund Manager's
generic price import (File / Import / Prices / Generic...) to import this
price information.

Here are a couple of sample lines from that downloaded .csv file:

Date,Open,High,Low,Close,Volume,Adj. Close*
27-May-04,9.59,9.59,9.40,9.40,2595,9.40

So, to import this with the generic price import you would use:

Specify Symbol: Yes
Specify Date: No
Format String: DD-MM-YY,OO,HH,LL,NAV,VV,XX

Thanks,
Mark
--
Mark Beiley

Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP/2003




Replies:



FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy