All geek questions in one place

Get stock quotes as JSON from Yahoo Finance with start and end dates

I am trying to get stock quotes history from a specific symbol (BHP.AX) with a specific start and end date.

Here is my request:

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

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

Am I missing something? Since the console does not seem to spit out the correct data.

+4
source share
1 answer

Am I missing something?

Yes, yahoo.finance.quotes is part of the community tables, so to test it in the YQL console, check the Community tables.

Your YEST 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=
+11
source

Source: https://habr.com/ru/post/1544691/

More articles:


All Articles