2a

Fri Nov 20, 2015 8:31 pm (PST) . Posted by:

I have been have trouble with RCHGetYahooQuotes. It recently download a quarter of the data points I am requesting.

I tried Force Recalculate and I also tried to set my Internet Browser to check for newer version of stored page. When I tried the latter, it always return to automatically setting. Both does not fix the problem.

I have attached my file for you to see. The problem is in the Download tab.

2b

Fri Nov 20, 2015 11:04 pm (PST) . Posted by:

Oh, man. Change all of those individual RCHGetYahooQuotes() functions into just a few array-entered ones over ranges. You can get multiple data items on up to 200 tickers symbols at once. Your recalculation will run MUCH faster. Probably seconds instead of the LOOOONG time it's taking now.

Nothing I do is anywhere near as large as that. I just don't understand why everyone wants to grab all the data at once, when they can only look at small pieces of it at once anyway. Just grab the data you're gonna look at, and grab the other later when you're gonna look at it.

If you're doing some type of screening, you should get an appropriate tool.

> I have been have trouble with RCHGetYahooQuotes. It recently download a > quarter of the data points I am requesting. > > I tried Force Recalculate and I also tried to set my Internet Browser to > check for newer version of stored page. When I tried the latter, it always > return to automatically setting. Both does not fix the problem. > > I have attached my file for you to see. The problem is in the Download tab. > > Could it be that I am temporarily kicked out of the Yahoo server >