CODEWITHSUNDEEP
yql
Glide
Glide

Reputation: 21245

YQL finance gets null in results

I'm just using one of the sample datatables in the YQL console. The YQL statement is select * from yahoo.finance.stock where symbol="yhoo"

Why am I get null in the results?

Link to YQL console with the YQL statement

Upvotes: 2

Views: 1477

Answers (2)

Paul M
Paul M

Reputation: 37

I had better luck with yahoo.finance.stock (singular, no "s"). The data seems to be better maintained.

Upvotes: 0

BrianC
BrianC

Reputation: 10721

It looks like the yahoo.finance.stock YQL data table is no longer working. When run with Diagnostics enabled, several JavaScript errors appear. Because there is no official Yahoo Finance API, this community table is retrieving data by scraping web pages, and is therefore susceptible to page changes causing breakage like this.

The table yahoo.finance.stocks does seem to work, but I'm not sure if the data returned is what you're looking for.

Example query:

select * from yahoo.finance.stocks where symbol="yhoo"

Upvotes: 2

Related Questions