2 Messages
Digest #3738
1b
Re: TTM Yiled for a mutual fund off http://quote.morningstar.ca/quic by "Randy Harmelink" rharmelink
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
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","
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"
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""")))*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?
>
>
>
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
> ","
>
> 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"
>
> Can you help?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar