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

"javascript": { "name": "yahoo.finance.historicaldata", "verb": "select", "content": "The current table 'yahoo.finance.historicaldata' has been blocked. It exceeded the allotted quotas of either time or instructions" }

This is a major problem that needs a fix ASAP.

Thanks for jumping on this as soon as possible...

yahoo.finance.quotes is NOT an official YQL table. It was contributed by a 3rd party.

That said, it most likely is being rate limited.

Thanks -Paul YQL Team

Hi Paul,

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.

Thanks for your time,

Bob

Hey Paul,

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...

Bob

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? Carlton