Page 1 of 2

Investments interfaces

Posted: Tue Jan 18, 2011 7:18 pm
by Nikolay

Re: Investments interfaces

Posted: Sat Feb 12, 2011 10:34 am
by Nikolay

Re: Investments interfaces

Posted: Sat Feb 12, 2011 10:35 am
by Nikolay
I've found symbols for my stocks in yahoo market!
AFLT.ME
Aeroflot - Russian Airlines OJSC (AFLTS:RU)

SBER03.ME
Sberbank of Russia (SBER03:RM)
Industry: Commer Banks Non-US • MICEX Main • Currency: RUB

Now I've set http://finance.yahoo.com/echarts?s=%s
as stock qoutes web page.

Re: Investments interfaces

Posted: Sat May 21, 2011 11:21 am
by Nikolay

Re: Investments interfaces

Posted: Thu Aug 11, 2011 11:45 am
by Nikolay
I have discovered that last time sometimes yahoo return wrong date for stocks.
For example:
wget "http://finance.yahoo.com/d/quotes.csv?s ... f=snd1l1t1" -qO-
"SBER03.ME","SBERBANK","8/2/2011",102.51,"10:43am" <-- wrong date
"SBER03.ME","SBERBANK","8/11/2011",83.31,"7:23am" <-- correct date
It seems that should be added some checker for returned values.

Re: Investments interfaces

Posted: Sat Dec 29, 2012 8:30 pm
by Nikolay

Re: Investments interfaces

Posted: Thu Mar 20, 2014 6:06 pm
by Nikolay

Re: Investments interfaces

Posted: Fri Jan 08, 2016 1:36 pm
by Nikolay
The csv output for RUB exchange rate:

Code: Select all

http://download.finance.yahoo.com/d/quotes.csv?s=USDRUB=X&f=sl1&e=.csv
may be transformed to XML or JSON:


using this  code for the console:

Code: Select all

select * from csv where url='http://download.finance.yahoo.com/d/quotes.csv?s=USDRUB=X&f=sl1&e=.csv' and columns='symbol,price'

Re: Investments interfaces

Posted: Fri Jan 08, 2016 2:02 pm
by Nikolay
Also available this link:

Code: Select all

http://finance.yahoo.com/webservice/v1/symbols/USDRUB=X/quote?format=xml
More info here: http://stackoverflow.com/questions/1004 ... inance-api

Re: Investments interfaces

Posted: Mon Jan 11, 2016 1:09 pm
by Nikolay
History for all currencies for specific date
http://finance.yahoo.com/connection/cur ... e=20160101