Kamis, 22 Januari 2015

[smf_addin] Digest Number 3302

2 Messages

Digest #3302

Messages

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?

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

"Randy Harmelink" rharmelink

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?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar