0

Finance tables

Ah had a framework up and running last night working that used yahoo.finance tables... but today I get the error No definition found for Table yahoo.finance.quotes... And I cant find them in the console either... whats going on?

by
9 Replies
  • They are back now... no idea why they went away?
    0
  • The tables have disappeared again. Anybody from Yahoo online? What is going on guys?
    0
  • Go to YQL Console, click on "Show community tables" and try "Show tables" query. You'll get the following diagnostics message:
    CODE
        <diagnostics>
    <publiclyCallable>true</publiclyCallable>
    <warning>Syntax error(s) [line 0:-1 required (...)+ loop did not match anything at input '&lt;EOF&gt;']</warning>
    <user-time>3</user-time>
    <service-time>0</service-time>
    <build-version>9962</build-version>
    </diagnostics>

    Apparently someone's made an error updating community tables environment... I'm wondering if they'll fix it soon or it's a sort of the "Fri-Mon night" thing...
    0
  • Hey guys,
    Yea same here, I was just on YQL console and tried to look for the finance table and again I got the same error as above? In addition, I notice that all the community tables have disappear and only the regular data tables are there. I hope someone resolves this issue soon.
    0
  • Here is a workaround:

    1. Go to http://www.datatables.org/ and follow the link to Github.
    2. Download all community data tables (takes a few sec on hi-speed internet) and extract the table you need.
    3. Upload the table (XML file) to your favorite webserver.(https://www.dropbox.com/ will do).
    4. Connect the xml with USE statement and proceed as usual, like this:

    use "http://www.myserver.com/mydir/yahoo.finance.quotes.xml" as quotes; select * from quotes where symbol="MSFT"
    0
  • Thanks alot! Got it it to work.

    QUOTE (mtelis @ Nov 27 2010, 12:42 PM) <{POST_SNAPBACK}>
    Here is a workaround:

    1. Go to http://www.datatables.org/ and follow the link to Github.
    2. Download all community data tables (takes a few sec on hi-speed internet) and extract the table you need.
    3. Upload the table (XML file) to your favorite webserver.(https://www.dropbox.com/ will do).
    4. Connect the xml with USE statement and proceed as usual, like this:

    use "http://www.myserver.com/mydir/yahoo.finance.quotes.xml" as quotes; select * from quotes where symbol="MSFT"
    0
  • QUOTE (mtelis @ Nov 27 2010, 12:42 PM) <{POST_SNAPBACK}>
    Here is a workaround:

    1. Go to http://www.datatables.org/ and follow the link to Github.
    2. Download all community data tables (takes a few sec on hi-speed internet) and extract the table you need.
    3. Upload the table (XML file) to your favorite webserver.(https://www.dropbox.com/ will do).
    4. Connect the xml with USE statement and proceed as usual, like this:

    use "http://www.myserver.com/mydir/yahoo.finance.quotes.xml" as quotes; select * from quotes where symbol="MSFT"


    I suggest putting them in your own store:// url rather than hosting them somewhere using the http://www.javarants.com/yqlstorageeditor/ .

    Sam
    0
  • Oh good, I can deal with somebody screwing up the tables... I was concerned they abruptly stopped supporting them, and that was going to be unpleasant.
    0
  • Thanks for mentioning YQL storage, Sam. Good tip.

    The yahoo.finance.quotes table is up now. Here's a link to desc the table in the yql console: http://y.ahoo.it/9jRyq/Ot
    0

Recent Posts

in YQL