[smf_addin] Digest Number 4460

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #4460

1a

Re: Sectors and Industry Models by "Randy Harmelink" rharmelink

2a

How to get mutual fund MER value by crollalanzaws

2b

Re: How to get mutual fund MER value by "Randy Harmelink" rharmelink

Messages

1a

Re: Sectors and Industry Models

Mon Jan 14, 2019 12:37 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You could do smfPricesByDates() on the S&P 500 sector EFTs, and for any
ETFs that exist for industry groups. Maybe indexes, if Yahoo carries the
history on them.

Most industry group performance web pages I'm aware of just have predefined
periods, like last week, last month, last quarter, YTD, 1-year, 3-year,
5-year, etc.

On Sun, Jan 13, 2019 at 10:19 AM chris.heidbreder@... wrote:

> Its been a while since I have participated with group discussions.
> Apologies if Im not soliciting this in the correct format.
>
> Ive been looking for sources and/or models to pull sector and industry
> performance quarterly and annual. Anyone have any good sources or SMF
> Add-In models I could utilize?
>
>
>

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

2a

How to get mutual fund MER value

Mon Jan 14, 2019 11:37 pm (PST) . Posted by:

crollalanzaws

Hi,
I'm new to SMF.


I would like to get the "MER" value from this web page:
http://quote.morningstar.ca/quicktakes/Fund/f_ca.aspx?t=0P0000713N&region=CAN&culture=en-CA http://quote.morningstar.ca/quicktakes/Fund/f_ca.aspx?t=0P0000713N&region=CAN&culture=en-CA


I can see that the value is on the page:
<span vkey="ExpenseRatio" class="gr_text1"> 2.62% </span>


I've tried using the RCHGetWebData function with smfStrExtr, but I don't seem to be getting
anywhere with this.


Could someone please point me in the right direction.


Thanks.

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

2b

Re: How to get mutual fund MER value

Tue Jan 15, 2019 12:04 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The HTML code you cite is not within the delivered source code. You must
have found it in a browser after the source code is rendered. Morningstar
dynamically builds their web pages after the initial source code of the web
page is delivered. But the add-in extracts data from delivered source code,
not rendered web pages.

However, the pages that Morningstar uses to dynamically build the web page
can be utilized. Try this:

=smfGetTagContent("
http://quotes.morningstar.com/fund/c-header?t=0P0000713N®ion=CAN&culture=en-CA&cur=CAD
","span",-1,"vkey=""ExpenseRatio""",,,,1)

On Tue, Jan 15, 2019 at 12:54 AM florio.crollalanza@... wrote:

> I'm new to SMF.
>
> I would like to get the "MER" value from this web page:
>
>
> http://quote.morningstar.ca/quicktakes/Fund/f_ca.aspx?t=0P0000713N&region=CAN&culture=en-CA
>
> I can see that the value is on the page:
>
> <span vkey="ExpenseRatio" class="gr_text1"> 2.62% </span>
>
> I've tried using the RCHGetWebData function with smfStrExtr, but I don't
> seem to be getting
>
> anywhere with this.
>
> Could someone please point me in the right direction.
>
>
>

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

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

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use