MMEX Discussion Forum

Posted: **Mon Jan 11, 2016 2:03 pm**

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

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

Posted: **Mon Jan 11, 2016 3:29 pm**

How to get RUB vs USD rates for last year

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)

Posted: **Mon Jan 11, 2016 3:55 pm**

Speedup

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

YQL samples