YQL samples

Money Manager Ex Development related posts
(http://github.moneymanagerex.org/)
Post Reply
Nikolay
MMEX Developer
Posts: 1346
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

YQL samples

Post by Nikolay »

How to get currencis historical data using YQL for specific date (or range)

Code: Select all

SELECT * FROM yahoo.finance.historicaldata WHERE symbol in("EUR=X","RUB=X") AND startDate = "2016-01-01" AND endDate = "2016-01-01"
Result 

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

Re: YQL samples

Post by Nikolay »

How to get RUB vs USD rates for last year

Code: Select all

SELECT * FROM yahoo.finance.historicaldata WHERE symbol in("RUB=X") AND startDate = "2015-01-01" AND endDate = "2015-12-31"
Result

PS it working, for example from 2009-01-01 till 2010-01-01 as well but not for 2009-2015 range (seems like buffer limitation)

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

Re: YQL samples

Post by Nikolay »

Speedup

Code: Select all

SELECT  Date, Close FROM yahoo.finance.historicaldata WHERE symbol = "RUB=X" AND startDate = "2015-01-01" AND endDate = "2016-01-01" 
Result

Post Reply