2 Messages

Digest #3302

Morningstar gold, silver, bronze ratings by lezm001

Re: Morningstar gold, silver, bronze ratings by "Randy Harmelink" rharmelink

Messages

1a

Morningstar gold, silver, bronze ratings

Wed Jan 21, 2015 3:53 am (PST) . Posted by:

lezm001

will one of the SMF functions pull the gold, silver, bronze rating from morningstar for the mutual funds?

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

1b

Re: Morningstar gold, silver, bronze ratings

Wed Jan 21, 2015 4:51 am (PST) . Posted by:

Try something like:

=PROPER(smfstrExtr(RCHGetWebData("
http://quotes.morningstar.com/fund/xxxxx/f?t=
"&B3,"r_star",50,10),"'r_","_"))

If you want the individual pillars, try:

=smfGetTagContent("http://quotes.morningstar.com/fund/c-mroningstar-take?t="&$B6,"span",1,"
Pillars","Process")
=smfGetTagContent("http://quotes.morningstar.com/fund/c-mroningstar-take?t="&$B6,"span",1,"
Pillars","Performance")
=smfGetTagContent("http://quotes.morningstar.com/fund/c-mroningstar-take?t="&$B6,"span",1,"
Pillars","People")
=smfGetTagContent("http://quotes.morningstar.com/fund/c-mroningstar-take?t="&$B6,"span",1,"
Pillars","Parent")
=smfGetTagContent("http://quotes.morningstar.com/fund/c-mroningstar-take?t="&$B6,"span",1,"
Pillars","Price")

I believe those are all premium items, for subscribers only?

Note that they spelled "morningstar" incorrectly on the URLs for the
pillars. If they correct that spelling, those formulas would need to be
changed.

On Wed, Jan 21, 2015 at 4:53 AM, dlezman@steelcase.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> will one of the SMF functions pull the gold, silver, bronze rating from
> morningstar for the mutual funds?
>