Minggu, 25 September 2016

[smf_addin] Digest Number 3803

6 Messages

Digest #3803

Messages

Sat Sep 24, 2016 1:21 pm (PDT) . Posted by:

joelfp2000

Randy...Thank you Thank you! I've gotten it to work along with some other data points thanks to your help.

Here is one other item I can't figure out. I would like to find the "net expense ratio: category average" for the ETF's I'm following. I'm using the following formula but seek some additional help from you.


=smfGetTagContent("http://financials.morningstar.com/etfund/operations.action?&t="&$A$1,"td",1,">net expense ratio: category average",,1)



I can get the correct page to open but I can't figure out how to maneuver within the page to get my data. I'm just guessing on how to do it at this point.


If you could please help that would be great. Also, can you also direct me to something maybe you've written on how to navigate within the pages...I don't want to keep asking for your help.


Again...a big thanks for all of your work with the SMF addin.


Joel


Sat Sep 24, 2016 1:54 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The "net expense ratio: category average" extraction is very convoluted.
The fees and expenses data is actually on this web page, and loaded from
there:

http://srt.morningstar.com/oprn/etf/c-feesandexpense.html?&t=F00000J3JR

But it looks like you can use VOO as the ticker symbol:

http://srt.morningstar.com/oprn/etf/c-feesandexpense.html?&t=VOO

Even so, extraction from data on that page is not trivial. I'm not even
sure I could come up with a generalized extraction formula. Maybe if a
bunch of substitutions were done to remove the garbage data, such as "\t".

On Sat, Sep 24, 2016 at 1:21 PM, joel.andrews@
​...wrote:

>
> Here is one other item I can't figure out. I would like to find the "net
> expense ratio: category average" for the ETF's I'm following. I'm using the
> following formula but seek some additional help from you.
>
> =smfGetTagContent("http://financials.morningstar.com/
> etfund/operations.action?&t="&$A$1,"td",1,">net expense ratio: category
> average",,1)
>
> I can get the correct page to open but I can't figure out how to maneuver
> within the page to get my data. I'm just guessing on how to do it at this
> point.
>
> If you could please help that would be great. Also, can you also direct
> me to something maybe you've written on how to navigate within the
> pages...I don't want to keep asking for your help.
>
>

Sat Sep 24, 2016 2:00 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I usually try two different paths. For your first question here, I used
HTTPFox with my FireFox browser. It's a URL sniffer, which tells me what
resources are being used from the web. So I just need to review those to
find the external web pages that are being loaded. For the second one, I
ended up reviewing JavaScript code from the web page to find where it was
loading the fees and expenses. Both processes are kind of fluid, with no
set rules, so it's hard to write up anything on what I'm doing.

On Sat, Sep 24, 2016 at 1:21 PM, joel.andrews@lpl.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Also, can you also direct me to something maybe you've written on how to
> navigate within the pages...I don't want to keep asking for your help.
>
>

Sat Sep 24, 2016 2:12 pm (PDT) . Posted by:

joelfp2000

Randy,

You are right. The webpage you referenced is a nightmare.


This formula gets me to a clean webpage.


http://financials.morningstar.com/etfund/operations.action?&t=voo http://financials.morningstar.com/etfund/operations.action?&t=voo


Will this help in navigating to the "Net Expense Ratio: Category Average" ?


Joel



Sat Sep 24, 2016 2:18 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

There's nothing to extract from that web page because the data isn't within
the source code of the web page. It's created dynamically from the
"nightmare" web page. That's where I found the JavaScript code that loaded
it from elsewhere.

On Sat, Sep 24, 2016 at 2:11 PM, joel.andrews@lpl.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> You are right. The webpage you referenced is a nightmare.
>
> This formula gets me to a clean webpage.
>
> http://financials.morningstar.com/etfund/operations.action?&t=voo
>
> Will this help in navigating to the "Net Expense Ratio: Category Average" ?
>
>
>

Sat Sep 24, 2016 8:05 pm (PDT) . Posted by:

joelfp2000

Randy,

Thanks for looking into that for me. Dang...


Have a great weekend and enjoy the Fall.


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

Tidak ada komentar:

Poskan Komentar