2 Messages

Digest #4093

GetYahooQuotes by cgrablew

Re: GetYahooQuotes by "Randy Harmelink" rharmelink

Messages

1a

Randy,

I'm using the smfUpdateDownloadTable with GetYahooQuotes to get Price and Name plus other values. I've been using it for a few years and lately the GetYahooQuotes has been returning Error. Today I ran it 6 times before it worked. I'm assuming it's an issue with the Yahoo website but I thought I'd ask if there is some kind of problem. By the way, if I run the Yahoo Finance API right after I get the error, it returns the proper values.

Chuck Grablewski

Reply to sender . Reply to group . Reply via Web Post . All Messages (16) . Top ^

1b

Re: GetYahooQuotes

Sun Jul 16, 2017 3:35 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Others have been reporting sporadic issues. Some have been suspicious that
Yahoo is doing some kind of block when too many requests are done in a
short time. The best thing would be to convert those to an array-entered
RCHGetYahooQuotes(), so one function invocation can replace many.

Unfortunately, that means outside of the smfUpdateDownloadTable routine.
But it should speed up things quite a bit if you have a large table.

On Sun, Jul 16, 2017 at 2:35 PM, cgrablew@
...
wrote:

>
> I'm using the smfUpdateDownloadTable with GetYahooQuotes to get Price
> and Name plus other values. I've been using it for a few years and lately
> the GetYahooQuotes has been returning Error. Today I ran it 6 times before
> it worked. I'm assuming it's an issue with the Yahoo website but I thought
> I'd ask if there is some kind of problem. By the way, if I run the Yahoo
> Finance API right after I get the error, it returns the proper values.
>