YQL samples

Page 1 of 1
3 posts
YQL samples

Nikolay
MMEX Developer

Posts: 2286
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
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

Nikolay
MMEX Developer

Posts: 2286
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
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

Nikolay
MMEX Developer

Posts: 2286
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
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
Page 1 of 1
Who is online

Users browsing this forum: No registered users and 2 guests