0

Finance Data Rate Limit

First of all thank you for all the great APIs. We are starting to use the Finance API at our company for an internal application. In our test, we are noticing that requests are being rejected time to time even though we haven't reached the allowed limit (1000/hour/IP). The application is making a call to the Finance API once every hour. Is that a bug? Also what is the true limit?

Thanks,
Habib Haider

by
6 Replies
  • What finance tables are these? Can you give a sample query that hits the rate limit.<br><br><div class="quote"><div class="quotetop">QUOTE<cite>(Habib @ 22 Mar 2012 2:10 PM)</cite></div><blockquote class="quotemain">First of all thank you for all the great&nbsp;APIs. We are starting to use the Finance API at our company for an internal application. In our test, we are noticing that requests are being rejected time to time even though we haven&#39;t reached the allowed limit (1000/hour/IP). The application is making a call to the Finance API once every hour. Is that a bug? Also what is the true limit?<br><br>Thanks,<br>Habib Haider</blockquote></div>
    0
  • Thanks for your quick response Sriram. Following is the query I am using:<br><br><div>select * from yahoo.finance.quotes where symbol in (&quot;YHOO&quot;,&quot;AAPL&quot;,&quot;GOOG&quot;,&quot;MSFT&quot;)<div><span class="Apple-tab-span" style="white-space:pre;"> </span></div></div>
    0
  • Hi Habib,<br><br>You should not be hitting any limits not specified in http://developer.yahoo.com/yql/guide/usage_info_limits.html<br><br>Can you please give me the request/response when you are hitting the rate limits, and some more information like the IP you are making the request from.<br><br>Sriram
    0
  • Hi,&nbsp;following is the error I am getting:&nbsp;<br><span class="objectBox objectBox-string "><br>com.yahoo.platforms.pipes.model.ModuleException: Error Codes: js.blocked.execute.request Message: &quot;The current table &#39;yahoo.finance.quotes&#39; has been blocked. It exceeded the allotted quotas of either time or instructions&quot;.</span><br><br>This shows up in query.diagnostics.javascript.content.&nbsp;I have increased the request interval to 5 mins and I am still experiencing this issue intermittently.<br><br>Thanks,<br>Habib&nbsp;
    0
  • Habib,<br><br>This is a community contributed table and used by multiple people. We mark a table as abusive if it seems to be hogging our resources, or consistently taking more than 30s to execute (this could also be due to a slow downstream source). This particular table seems to be getting marked as abusive more times than others. We also remove our blocks after a while, hence the sporadic working of the table.<br><br>I would advise that you wait for official tables from Yahoo! Finance if your application needs a stabler data source.<br><br>Sriram
    0
  • Hello, I'd like to make what I think is a rather obvious point here.

    Web services are called by applications, not people. And they need to work pretty much all the time.  I would argue that a web service that works only some of the time actually has a negative value.  

    You mention "official tables from Yahoo! Finance" may be coming.  Do you know if they are?  There are currently people who would like to develop applications that use the finance data, and many would even pay for this as long as it's stable.  Currently you have:

    1.  Unsupported flaky finance services 
    2. No revenue source from those willing to pay.

    Are you opposed to making money or something?  We'll take care of the demand.  Maybe you could work on the supply?

    0

Recent Posts

in YQL