Jumat, 10 April 2015

[smf_addin] Digest Number 3379

3 Messages

Digest #3379

Messages

Thu Apr 9, 2015 10:17 am (PDT) . Posted by:

rogacox

I am currently getting yahoo retrieval errors about 50% of the time for d,y,t8, and e7. The returns are N/A which then lead to formula errors in my spreadsheet that depends on these inputs. This retrieval error situation began about 2 weeks ago. Any idea why half the time it works fine and the other half I get these returns? I update the array often as I am sorting expected returns on securities using dividend and 1 year target pricing forecast.

Thanks in advance for your help. This is a wonderful app.
Roger


Thu Apr 9, 2015 10:42 am (PDT) . Posted by:

rogacox

The smf function is RCHGetYahooQuotes. Sorry - should have mentioned that in the original mail.

Thu Apr 9, 2015 5:46 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

If you're getting "N/A" results, that's what Yahoo is sending for the data
item. If it's happening sporadically, I suspect they have a server or two
that hasn't been getting updates of those fields? Hard to say.

I'm not sure why you would need to update the array often for your
calculation? Dividend amount and 1-year target prices aren't going to
change frequently. And I suspect the trailing dividend amount/yield is not
what you want in such a calculation?

On Thu, Apr 9, 2015 at 10:17 AM, rogacox@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I am currently getting yahoo retrieval errors about 50% of the time for
> d,y,t8, and e7. The returns are N/A which then lead to formula errors in
> my spreadsheet that depends on these inputs. This retrieval error
> situation began about 2 weeks ago. Any idea why half the time it works
> fine and the other half I get these returns? I update the array often as I
> am sorting expected returns on securities using dividend and 1 year target
> pricing forecast.
>
> Thanks in advance for your help. This is a wonderful app.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar