Investments interfaces
Moderator: Renato
-
- 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
For Currencies:
http://www.google.com/finance?q=CURRENCY%3AUSD
http://www.google.com/finance?q=CURRENCY%3ARUB
http://www.google.com/finance?q=CURRENCY%3AEUR
YAHOO Currency exchange
http://finance.yahoo.com/q?s=USDRUB=X
http://download.finance.yahoo.com/d/quo ... sl1&e=.csv
http://finance.yahoo.com/lookup/all?s=R ... L&r=3&b=80
http://www.google.com/finance?q=CURRENCY%3AUSD
http://www.google.com/finance?q=CURRENCY%3ARUB
http://www.google.com/finance?q=CURRENCY%3AEUR
YAHOO Currency exchange
http://finance.yahoo.com/q?s=USDRUB=X
http://download.finance.yahoo.com/d/quo ... sl1&e=.csv
http://finance.yahoo.com/lookup/all?s=R ... L&r=3&b=80
-
- 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
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.
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.
-
- 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
http://finance.yahoo.com/futures?t=metals
(GCU10.CMX <- GOLD)
IBM since 1800 till 17 april 2011
http://ichart.finance.yahoo.com/table.c ... gnore=.csv
(GCU10.CMX <- GOLD)
IBM since 1800 till 17 april 2011
http://ichart.finance.yahoo.com/table.c ... gnore=.csv
-
- 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
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.
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.
-
- 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
The csv output for RUB exchange rate:
may be transformed to XML or JSON:
using this code for the console:
Code: Select all
http://download.finance.yahoo.com/d/quotes.csv?s=USDRUB=X&f=sl1&e=.csv
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'
-
- 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
Also available this link:
More info here: http://stackoverflow.com/questions/1004 ... inance-api
Code: Select all
http://finance.yahoo.com/webservice/v1/symbols/USDRUB=X/quote?format=xml
-
- 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
History for all currencies for specific date
http://finance.yahoo.com/connection/cur ... e=20160101
http://finance.yahoo.com/connection/cur ... e=20160101