[smf_addin] Digest Number 3739

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #3739

1a

Re: TTM Yiled for a mutual fund off http://quote.morningstar.ca/quic by "Kermit W. Prather" kermitpra

2a

Re: Fund summary by thomas777crown

2b

Re: Fund summary by "Randy Harmelink" rharmelink

Messages

1a

Re: TTM Yiled for a mutual fund off http://quote.morningstar.ca/quic

Wed Jul 6, 2016 7:19 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Worked for me as well

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, July 05, 2016 5:11 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] TTM Yiled for a mutual fund off http://quote.morningstar.ca/quicktakes/fund/


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?

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

2a

Re: Fund summary

Wed Jul 6, 2016 5:51 pm (PDT) . Posted by:

thomas777crown

Good day,


I was pulling data off of this link


http://financials.morningstar.com/etfund/operations.html?t=BIL®ion=usa&culture=en-US http://financials.morningstar.com/etfund/operations.html?t=BIL®ion=usa&culture=en-US
and you gave me the link to pull the data off of here with this


=smfStrExtr(smfStrExtr(RCHGetWebData("http://financials.morningstar.com/operation/etf/c-overviewinfo.html?&t=BIL http://financials.morningstar.com/operation/etf/c-overviewinfo.html?&t=BIL",">Investment Objective"),"<td","~"),">","<")



but it has stopped working now.


Thanks in advance.

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

2b

Re: Fund summary

Wed Jul 6, 2016 6:10 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you -- the formula you cite below is working fine for
me...

See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30440

On Wed, Jul 6, 2016 at 5:51 PM, thomas777crown@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I was pulling data off of this link
>
>
> http://financials.morningstar.com/etfund/operations.html?t=BIL®ion=usa&culture=en-US
> <http://financials.morningstar.com/etfund/operations.html?t=BIL®ion=usa&culture=en-US>
>
> and you gave me the link to pull the data off of here with this
>
> =smfStrExtr(smfStrExtr(RCHGetWebData("
> http://financials.morningstar.com/operation/etf/c-overviewinfo.html?&t=BIL",">Investment
> Objective"),"<td","~"),">","<")
> but it has stopped working now.
>
>

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

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 14

• Privacy • Unsubscribe • Terms of Use