Money Manager Ex Development related posts for both Android and Desktop
Moderator: Renato
-
Nikolay
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
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
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
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
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
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