3

YAHOO.FINANCE.QUOTES not working

Hi,

We exclusively depend on the table yahoo.finance.* We can see they are not available from YQL console, any idea why ???

select * from yahoo.finance.quotes where symbol in ("YHOO")

=

cbfunc({ "error": { "lang": "en-US", "diagnostics": { "publiclyCallable": "true" }, "description": "No definition found for Table yahoo.finance.quotes" } });

Thanks

by
5 Replies
  • Are you using the community tables env?

    &env=store://datatables.org/alltableswithkeys

    Thanks -Paul YQL Team

    1
  • Where do I append the tables env?

    Regards

    1
  • If you are using the YQL console, make sure that you click on the "Show community tables" link on the right. That should ensure that the YQL query works properly.

    If you are invoking YQL through an API then you can append the env variable like this

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

    2
  • My previous reply got truncated for some reason.

    Here is the rest of the truncated url: =json&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&callback=

    1
  • Thanks

    1

Recent Posts

in YQL