Same problem here - and it does not work in the YQL Console either - see below...
YQL Console Query
select * from yahoo.finance.historicaldata where symbol = "YHOO" and startDate = "2009-09-11" and endDate = "2010-03-10"
And here is the relevant diagnostic output
"content": "The current table 'yahoo.finance.historicaldata' has been blocked. It exceeded the allotted quotas of either time or instructions"
Yes the quotes and historicaldata tables are "community" tables and are rate limited - but that doesn't really explain the the on-again off-again behavior - since I never come close to the rate limits in my usage (Per IP limits: /v1/public/*: 2,000 calls per hour). Today it is again working flawlessly :-)
I love YQL and truly appreciate the work you and the rest of the YQL team do - but I do get frustrated when access is blocked when my usage is within the allowed limits.
Maybe I'm misunderstanding "rate limited." Is the 3rd party community table (i.e. historicaldata) itself rate-limited? Meaning that specific table is limited to 2,000 calls per hour? Or only calls to my IP (that use the table) are rate-limited? Thanks in advance...
I have successfully imported financial data from yahoo finance to Excel but I have difficulty getting refreshed even though Excel provides for Refresh command. Maybe I need access to the Yahoo Finance server? If so, what do you suggest?