[smf_addin] Digest Number 3886

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #3886

1a

Re: Looking for Excel VBA Add-In Training by garyhartling

2

Accessing Morningstart Monthly ETF Performance Data by jhfrazer@ymail.com

3a

GetElementNumber 850 (Zacks Industry classification)? by sjagers

3b

Re: GetElementNumber 850 (Zacks Industry classification)? by "Randy Randall" randyr_cds

Messages

1a

Re: Looking for Excel VBA Add-In Training

Tue Jan 10, 2017 6:52 am (PST) . Posted by:

garyhartling

Go to the WiseOwlTutorials channel on Youtube and search for "addin".

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

2

Accessing Morningstart Monthly ETF Performance Data

Tue Jan 10, 2017 11:40 am (PST) . Posted by:

jhfrazer@ymail.com

Hi Randy,

Hope the ER visit went as well as can be hoped. Have you, or has anyone figured out how to access Morningstar's Monthly Performance data? Morningstar provides it for ETFs for each month of the last five years but I can not figure out how to access it on my own and I am not a genius when it comes to your gettable function.

Any ideas? I need total return as opposed to just raw price performance.

Any assistance would be appreciated. Get well.

John

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

3a

GetElementNumber 850 (Zacks Industry classification)?

Tue Jan 10, 2017 6:59 pm (PST) . Posted by:

sjagers

Zack's must have changed their website. GetElementNumber 850 is returning an error, instead of the Industry classification.

I thought I might be able to use RCHGetTableCell or smfGetTagContent, as a workaround, to get the Industry classification from Zack's:

1.) Quote Overview page (https://www.zacks.com/stock/quote/KR?q=kr)

2.) or Comparison to Industry page (https://www.zacks.com/stock/research/KR/industry-comparison),

But, I'm not very familiar with those functions and I'm having trouble using them. I must not be using the function parameters correctly.

Can anyone help me? I'd appreciate the help. Thanks.

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

3b

Re: GetElementNumber 850 (Zacks Industry classification)?

Tue Jan 10, 2017 11:21 pm (PST) . Posted by:

"Randy Randall" randyr_cds

Try =smfGetTagContent("
https://www.zacks.com/stock/research/kr/industry-comparison","strong",1,">Industry
:")

or

=RCHGetTableCell("https://www.zacks.com/stock/quote/kr",1,"abut_top")

Note:
The second one will return both the "Retail-Wholesale» Retail -
Supermarkets" - you can use excel's substitute function similar to this:
=SUBSTITUTE(RCHGetTableCell("https://www.zacks.com/stock/quote/kr",1,"abut_top"),"»","
/")

HTH,
Randy

On Tue, Jan 10, 2017 at 9:59 PM, sjagers@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Zack's must have changed their website. GetElementNumber 850 is returning
> an error, instead of the Industry classification.
>
> I thought I might be able to use RCHGetTableCell or smfGetTagContent, as a
> workaround, to get the Industry classification from Zack's:
>
> 1.) Quote Overview page (https://www.zacks.com/stock/quote/KR?q=kr)
>
> 2.) or Comparison to Industry page (https://www.zacks.com/stock/
> research/KR/industry-comparison),
>
> But, I'm not very familiar with those functions and I'm having trouble
> using them. I must not be using the function parameters correctly.
>
> Can anyone help me? I'd appreciate the help. Thanks.
>
>
>
>
>

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 11

• Privacy • Unsubscribe • Terms of Use