2 Messages

Digest #4081

RCHGetYahooQuotes returning "Error" by justy_sports

Re: RCHGetYahooQuotes returning "Error" by "Randy Harmelink" rharmelink

Messages

1a

RCHGetYahooQuotes returning "Error"

Wed Jul 5, 2017 5:33 pm (PDT) . Posted by:

justy_sports

I uploaded a screenshot showing the version of the add-in I am running. It also shows my RCHGetYahooQuotes formula that is returning an error. For comparison, I included an RCHGetYahooHistory formula which is working as expected.

This is a blank Excel file (I closed Excel completely and re-opened)... these are the only 3 formulas in the entire workbook.

Any ideas?

https://xa.yimg.com/df/smf_addin/Capture.PNG?token=kRXqBjhbsRqBMCteMZoWVFfFPxDzWyAjfSbSD4mPur2ZGFkMLuO8yEXFQAX9zb2tAfZ2aTkhfglA-njTxhKmAWre14iVr37W5tzy9p6prAdyWm_IE1yg8IrYxZw6bdkl8Aqy6EJe66BU&type=download https://xa.yimg.com/df/smf_addin/Capture.PNG?token=kRXqBjhbsRqBMCteMZoWVFfFPxDzWyAjfSbSD4mPur2ZGFkMLuO8yEXFQAX9zb2tAfZ2aTkhfglA-njTxhKmAWre14iVr37W5tzy9p6prAdyWm_IE1yg8IrYxZw6bdkl8Aqy6EJe66BU&type=download

https://xa.yimg.com/df/smf_addin/Capture.PNG?token=kRXqBjhbsRqBMCteMZoWVFfFPxDzWyAjfSbSD4mPur2ZGFkMLuO8yEXFQAX9zb2tAfZ2aTkhfglA-njTxhKmAWre14iVr37W5tzy9p6prAdyWm_IE1yg8IrYxZw6bdkl8Aqy6EJe66BU&type=download

https://xa.yimg.com/df/smf_addin/Capture.PNG?token=kRXqB... https://xa.yimg.com/df/smf_addin/Capture.PNG?token=kRXqBjhbsRqBMCteMZoWVFfFPxDzWyAjfSbSD4mPur2ZGFkMLuO8yEXFQAX9zb2tAfZ2aTkhfglA-njTxhKmAWre14iVr37W5tzy9p6prAdyWm_IE1yg8IrYxZw6bdkl8Aqy6EJe66BU&type=download

View on xa.yimg.com https://xa.yimg.com/df/smf_addin/Capture.PNG?token=kRXqBjhbsRqBMCteMZoWVFfFPxDzWyAjfSbSD4mPur2ZGFkMLuO8yEXFQAX9zb2tAfZ2aTkhfglA-njTxhKmAWre14iVr37W5tzy9p6prAdyWm_IE1yg8IrYxZw6bdkl8Aqy6EJe66BU&type=download
Preview by Yahoo

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

1b

Re: RCHGetYahooQuotes returning "Error"

Wed Jul 5, 2017 6:02 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's working here:

=RCHGetYahooQuotes("AAPL","l1")

The formula in your image looks fine to me.

Temporary Yahoo glitch? They no longer have a download quotes link on their
web page, so it's tough to check to see if the web site is having the same
problem. I suppose you could do it via a Yahoo Portfolio. It has a download
CSV option that uses the same URL RCHGetYahooQuotes() does...

On Wed, Jul 5, 2017 at 5:33 PM, justy_sports@
...
wrote:

> I uploaded a screenshot showing the version of the add-in I am running.
> It also shows my RCHGetYahooQuotes formula that is returning an error. For
> comparison, I included an RCHGetYahooHistory formula which is working as
> expected.
>
> This is a blank Excel file (I closed Excel completely and re-opened)...
> these are the only 3 formulas in the entire workbook.
>
> Any ideas?
>
>
>