Investments interfaces

Money Manager Ex Development related posts for both Android and Desktop

Moderator: Renato

Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Investments interfaces

Post by Nikolay »

Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Investments interfaces

Post 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.
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Investments interfaces

Post by Nikolay »

Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Investments interfaces

Post 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.
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Investments interfaces

Post by Nikolay »

Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Investments interfaces

Post by Nikolay »

Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Investments interfaces

Post 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'
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Investments interfaces

Post 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
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Investments interfaces

Post by Nikolay »

History for all currencies for specific date
http://finance.yahoo.com/connection/cur ... e=20160101
Post Reply