0

Retrieval of options data with YQL returning error


In the YQL Console, select yahoo.finance.options table (you may need to show community tables), then enter the following query, check Diagnostics:
SELECT * FROM yahoo.finance.options WHERE symbol='GOOG' AND expiration='2012-06'

No option data is returned, and you'll see the following error in the result set:

<javascript><![CDATA[Exception: TypeError: Cannot find function toInt in object . (<javascript>#90)]]></javascript>

by
12 Replies
  • same problem here.<br>option chains that have already expired still work (don&#39;t return the error). but not options that have not expired yet do not work and show the error above.<br><br><div class="quote "><div class="quotetop ">QUOTE<cite>(The Eagle @ 2 Feb 2012 10:02 AM)</cite><blockquote class="quotemain"><br>In the YQL Console, select yahoo.finance.options table (you may need to show community tables), then enter the following query, check Diagnostics:<br>SELECT * FROM yahoo.finance.options WHERE symbol=&#39;GOOG&#39; AND expiration=&#39;2012-06&#39;<br><br>No option data is returned, and you&#39;ll see the following&nbsp;error in the result set:<br><br><span class="sc3"><span class="re1"><span class="re4">&gt;<span></span></span><span class="re2"><!---->[</span>CDATA<span class="br0">[</span>Exception: TypeError: Cannot find function toInt in object . <span class="br0">(</span><span class="re1"><span class="re4">&gt;<span></span>#90)]]&gt;<span class="sc3"><span class="re1">&gt;</span></span></span></span></span></span></blockquote></div></div>
    0
  • I have the same issue here,&nbsp; starting from Feb 2nd, no return for the query like:<br><br>http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.options%20where%20symbol%20in%20%28%22amzn%22%29%20%20and%20expiration=%222012-02%22%20&env=http://datatables.org/alltables.env<br><br>anyone has any solution yet? I need the returned option chain infos for my API.&nbsp;&nbsp; Very Sad Now!!<br><br><div class="quote"><div class="quotetop">QUOTE<cite>(The Eagle @ 2 Feb 2012 10:02 AM)</cite></div><blockquote class="quotemain"><br>In the YQL Console, select yahoo.finance.options table (you may need to show community tables), then enter the following query, check Diagnostics:<br>SELECT * FROM yahoo.finance.options WHERE symbol=&#39;GOOG&#39; AND expiration=&#39;2012-06&#39;<br><br>No option data is returned, and you&#39;ll see the following&nbsp;error in the result set:<br><br><span class="sc3"><span class="re1"><span class="re4">&gt;<span></span></span><span class="re2"><!---->[</span>CDATA<span class="br0">[</span>Exception: TypeError: Cannot find function toInt in object . <span class="br0">(</span><span class="re1"><span class="re4">&gt;<span></span>#90)]]&gt;<span class="sc3"><span class="re1">&gt;</span></span></span></span></span></span></blockquote></div>
    0
  • Seems to be working fine now.
    0
  • <br>No. Still doesn&#39;t work
    0
  • Getting the same error here too. Haven&#39;t found a way around it.<br><br><div class="quote"><div class="quotetop">QUOTE<cite>(The Eagle @ 3 Feb 2012 5:19 PM)</cite></div><blockquote class="quotemain"><br>No. Still doesn&#39;t work</blockquote></div>
    0
  • I&#39;ve been seeing the same error since Feb. 1.&nbsp;
    0
  • same error, been using it for months, stopped working.
    0
  • The dev in charge on the open data side &#39;Thomas&#39; fixed today. &nbsp;He has an open request for yahoo to pull into their codebase. &nbsp;Won&#39;t be long now till fix is active.
    0
  • Link to bug fix intergration. &nbsp;When this is closed, we should be working again. &nbsp;https://github.com/yql/yql-tables/pull/153
    0
  • Integrated, so it should be working tonight.
    0
  • <p>Reading through the pull requests, it seems that the yql table is created by parsing the html page on Yahoo! Finance. Why isn&#39;t table populated directly from the raw data? Just curious.</p>
    0
  • Also the CompanyName in yahoo.finance.stocks is &quot;&quot; my app has blow-up becuse of this as this field was crucial for the screen display on the Playbook.&nbsp; No matter what stock symbol is typed into the YQL console the result is always NULL.<br><br>As follows: <br><br>select * from yahoo.finance.stocks where symbol =&quot;yhoo&quot;<br><br>&quot;results&quot;: {<br>&nbsp;&nbsp; &quot;stock&quot;: {<br>&nbsp;&nbsp;&nbsp; &quot;symbol&quot;: &quot;yhoo&quot;,<br>&nbsp;&nbsp;&nbsp;<strong> &quot;CompanyName&quot;: &quot;&quot;,</strong><br>&nbsp;&nbsp;&nbsp; &quot;start&quot;: &quot;1996-04-12&quot;,<br>&nbsp;&nbsp;&nbsp; &quot;end&quot;: &quot;2012-02-13&quot;,<br>&nbsp;&nbsp;&nbsp; &quot;Sector&quot;: &quot;Technology&quot;,<br>&nbsp;&nbsp;&nbsp; &quot;Industry&quot;: &quot;Internet Information Providers&quot;,<br>&nbsp;&nbsp;&nbsp; &quot;FullTimeEmployees&quot;: &quot;N/A&quot;<br>&nbsp;&nbsp; }<br><br>I have posted this issue 3 times here and once on stackoverflow.com still no resolution!!<br><br>Bob<br><br>
    0

Recent Posts

in YQL