Page 1 of 1
YQL samples
Posted: Mon Jan 11, 2016 2:03 pm
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
Re: YQL samples
Posted: Mon Jan 11, 2016 3:29 pm
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)
Re: YQL samples
Posted: Mon Jan 11, 2016 3:55 pm
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