Rabu, 06 Juli 2016

[smf_addin] Digest Number 3738

2 Messages

Digest #3738

Messages

Tue Jul 5, 2016 2:00 pm (PDT) . Posted by:

sabasu

Dear Randy,

I have been successfully using the following formula to get the TTM Yield for Dividends.


=(smfConvertData(smfGetTagContent("http://quotes.morningstar.com/fund/c-header?t=VBMFX","span",1,"gkey=""ttmYield""")))*100.



I have verified the results with Morningstar and found them to be correct.


However, when I use the same formula with ticker symbols "VGTSX" or "VTSAX", I get an Error. Not sure what is happening here.


Can you help?


Thanks in advance.


/sabasu

Tue Jul 5, 2016 2:17 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you? All three of those ticker symbols work fine for
me...

Sometimes, I have cookie issues with MorningStar. I can get "Error" on
something that worked before. First thing I try is to use the EXCEL Web
Query dialog (alt+d+d+w) to visit "morningstar.com". Then I cancel out of
the dialog and use smfForceRecalculation to refresh the web page retrieval.
And the "Error" changes to the value I expected.

This used to be a daily issue, because MorningStar would use the first web
page visit of the day to redirect a user to some type of advertising. That
"first visit of the day" is kept by cookies. So if you don't use IE or the
EXCEL Web Query dialog to update the cookie, something like the add-in will
time after time be redirected.

But that doesn't explain why one did work, unless the cookie expired in
between? :(

On Tue, Jul 5, 2016 at 2:00 PM, sabasu@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I have been successfully using the following formula to get the TTM Yield
> for Dividends.
>
> =(smfConvertData(smfGetTagContent("
> http://quotes.morningstar.com/fund/c-header?t=VBMFX
> ","span",1,"gkey=""ttmYield&quot;"")))*100.
>
> I have verified the results with Morningstar and found them to be correct.
>
> However, when I use the same formula with ticker symbols "VGTSX" or
> "VTSAX", I get an Error. Not sure what is happening here.
>
> Can you help?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar