Get stock quotes as JSON from Yahoo Finance with Start and End dates

json yahoo yql yahoo-finance
Fizzix picture Fizzix · Jun 16, 2014 · Viewed 17.6k times · Source

I have been attempting to get a stock quote history from a specific symbol (BHP.AX) with a specific start and end date.

Here is my attempted query:

select * from yahoo.finance.quotes where symbol in ("BHP.AX") and startDate = "2014-01-01" and endDate = "2014-06-16"

I was testing it in the YQL console here: https://developer.yahoo.com/yql/console/

Am I missing something? Because the console does not seem to be spitting out the correct data.

Answer

Sathyajith Bhat picture Sathyajith Bhat · Jun 16, 2014

Am I missing something?

Yeah, yahoo.finance.quotes is part of community tables, so to test it out in YQL console, tick the Community tables checkbox.

Your YQL REST URL will be

https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20(%22BHP.AX%22)&format=json&diagnostics=true&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&callback=

Related questions

Return Yahoo! weather API data in Celsius, using YQL

I'm trying to get Yahoo! weather API with temperatures in Celsius. I've added &u=c in the request, but it's still returning data in Fahrenheit. This is the URL I'm using: http://query.yahooapis.com/v1/public/yql?q=…

Read More
Yahoo Finance All Currencies quote API Documentation

I've being using this feed for a long time, I believe Apple does it as well in one of the mac widgets. but what is really curious is that I simply can't find any documentation for it, I've tried google …

Read More
How to get JSON data from an API

i have used yahoo's symbol lookup http://d.yimg.com/autoc.finance.yahoo.com/autoc?query=yahoo&callback=YAHOO.Finance.SymbolSuggest.ssCallback which returns data in JSON format. like following YAHOO.Finance.SymbolSuggest.ssCallback( { "ResultSet": { "Query": "ya", "Result": [ { "symbol": "…

Read More