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