2

No definition found for Table yahoo.finance.quotes

I was trying to retrieve quotes using yql but keep getting the error

No definition found for Table yahoo.finance.quotes

I tried to run the query at the developer console and the same error was returned.

http://developer.yahoo.com/yql/console/?q=...OO%22)%0A%09%09

Has the yahoo.finance.quotes been taken out? Is there some other way to get the quotes information.

Thanks
Anoop

by
12 Replies
  • Im having the same problem... my whole application has been knocked out.. bit of a pain any chance of a techy to msg us back on this
    0
    • S
    • Sep 10, 2009
    I would like to know too. I've been searching all morning for the answer.

    I don't see the table anywhere.
    0
  • It seems that the yahoo.finance.quotes open data table has disappeared from www.datatables.org for some reason.

    It's still in the respository at http://github.com/spullara/yql-tables/ so maybe this is just a temporary glitch? My understanding is that tables in that repository automatically get published to datatables.org. For example, yahoo.finance.quotes used to be available at http://www.datatables.org/yahoo/finance/ya...ance.quotes.xml. It also used to be listed in http://datatables.org/alltables.env so it was easy to try from the YQL Console.

    I notice that spullara just committed my fork of yql-tables a few days ago. This was the first change in yql-tables since August 14, 2009 when yahoo.finance.quotes worked fine.

    I never sent him a pull request although about a month ago I asked him for comments on my fork but never got any response. Perhaps my fork inadvertently broke something in the yql-tables/yahoo/finance/ subtree?
    0
  • Since you can now use "raw" github xml files directly in the YQL Console (see Any way to use forked github yql-tables .xml files directly in YQL Console?) you can do the following as a temporary workaround:

    CODE
    use "http://github.com/spullara/yql-tables/raw/d60732fd4fbe72e5d5bd2994ff27cf58ba4d3f84/yahoo/finance/yahoo.finance.quotes.xml" as quotes;
    select * from quotes where symbol in ("YHOO","AAPL","GOOG","MSFT")
    0
    • S
    • Sep 10, 2009
    Thanks so much for the help. I'm going to build an application that needs to pull the stock info but now I'm at a bit of a standstill since I'm not sure what the status of this is. For now I'll work with the temporary solution THANKS AGAIN SO MUCH!

    Is there anywhere we can ask the Yahoo developers?
    0
  • Instead of using YQL to get yahoo finance stock prices you could always just do it the old fashioned way.

    Getting stock information with YQL and open data tables mentions the fact that "under the hood", the YQL Open Data Table is really just using the yahoo CSV "api" to actually get the stock prices. The CSV api is documented here.

    One nice thing about using the CSV api (rather than YQL) is that then you don't have to worry about YQL rate limits and OAuth. I've hit a minor brick wall myself in that I can't seem to get yahoo to correctly give me an OAuth API Key (see API Key Creation Failed..., ...repeatedly... for details).

    You might be interested in three Yahoo Finance Open Data Tables I recently made. You can find them here with some brief documentation here.
    (Using YQL to get summary information on a stock from Yahoo Finance via a single HTTP Get and Open Data Table's execute Javascript quirks? give some background on the table creation process.)

    These tables let you use YQL to get stock information from Yahoo Finance that isn't available via the CSV api (or the yahoo.finance.quotes data table). One table gives you a list of all Yahoo Finance Sectors and their Industries. Another gives you all the stock symbols within an Industry. The last table gives you a stock's Exchange, Country, Sector, Industry, etc. given its symbol. See Example Queries for the kinds of things you can do.
    0
  • I'm having the same problem. Does anybody know what's going on?
    0
  • Broken here too for about a week so my app is down.
    it seems that the env is throwing some parse error or similar ?
    0
  • QUOTE (simonjpascoe@... @ Jan 20 2010, 04:55 AM) <{POST_SNAPBACK}>
    Broken here too for about a week so my app is down.
    it seems that the env is throwing some parse error or similar ?


    http://query.yahooapis.com/v1/public/yql?q...2Falltables.env

    The above seems to work, I think by adding env=http%3A%2F%2Fdatatables.org%2Falltables.env it seems to fix it.

    (and for plaintext version)

    http://query.yahooapis.com/v1/public/yql?q=select * from yahoo.finance.quotes where symbol in ("YHOO","AAPL","GOOG","MSFT")&env=http://datatables.org/alltables.env
    1
  • Thanks Adam. The env saved me a lot of headache.

    QUOTE(Adam Dean @ 14 Apr 2011 2:46 AM)
    QUOTE (simonjpascoe@... @ Jan 20 2010, 04:55 AM) <{POST_SNAPBACK}>
    Broken here too for about a week so my app is down.
    it seems that the env is throwing some parse error or similar ?


    http://query.yahooapis.com/v1/public/yql?q...2Falltables.env

    The above seems to work, I think by adding env=http%3A%2F%2Fdatatables.org%2Falltables.env it seems to fix it.

    (and for plaintext version)

    http://query.yahooapis.com/v1/public/yql?q=select * from yahoo.finance.quotes where symbol in ("YHOO","AAPL","GOOG","MSFT")&env=http://datatables.org/alltables.env
    0
  • Thanking you a million times is less to thank you!

    QUOTE(Adam Dean @ 14 Apr 2011 2:46 AM)
    QUOTE (simonjpascoe@... @ Jan 20 2010, 04:55 AM) <{POST_SNAPBACK}>
    Broken here too for about a week so my app is down.
    it seems that the env is throwing some parse error or similar ?


    http://query.yahooapis.com/v1/public/yql?q...2Falltables.env

    The above seems to work, I think by adding env=http%3A%2F%2Fdatatables.org%2Falltables.env it seems to fix it.

    (and for plaintext version)

    http://query.yahooapis.com/v1/public/yql?q=select * from yahoo.finance.quotes where symbol in ("YHOO","AAPL","GOOG","MSFT")&env=http://datatables.org/alltables.env
    0
  • how to get company list or quotes list from Stock Exchange
    0

Recent Posts

in YQL