EXCEL Stock Market Functions Add-in Group

8 Messages

Digest #4581

Re: Morningstar items stopped working by "Jim Morlock" kagawonger

Marketscreener by lawleesh

Re: Marketscreener by "Randy Harmelink" rharmelink

Re: Marketscreener by lawleesh

Re: Marketscreener by "Randy Harmelink" rharmelink

Re: Marketscreener by lawleesh

Re: Marketscreener by "Randy Harmelink" rharmelink

Re: Marketscreener by lawleesh

Messages

1a

Re: Morningstar items stopped working

Fri Jul 19, 2019 7:55 am (PDT) . Posted by:

"Jim Morlock" kagawonger

Morningstar recently rolled out changes to their website. There are numerous user complaints about the changes which include data elements being dropped. It may take a while for things to settle down.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, July 19, 2019 4:38 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Morningstar items stopped working

I wasn't able to get it to work here. The login process has changed, and I get a message that the method the EXCEL IE object is using is not allowed. So I don't see any way to actually log in for EXCEL and the add-in to use the premium items.

On Thu, Jul 18, 2019 at 9:35 PM Jose Jacob pepecan47@... wrote:

Hello Randy - suddenly several Morningstar items stopped working.

I have a M* premium membership, logged on with the browser. When entering alt D-D-W to login in excel, the screen I get is different than before, only text. Don't know if it is related.

The items that used to work a couple of days ago:

Fair value uncertainty
=RCHGetElementNumber($A8,889)

Economic Moat
=RCHGetElementNumber($A8,890)

Fair value
=RCHGetElementNumber($A4, 886)

Stars
=smfConvertData(smfStrExtr(RCHGetWebData("http://financials.morningstar.com/company-profile/c.action?t="&A4,"r_star"),"r_star","'"))&"*"

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

2a

Marketscreener

Fri Jul 19, 2019 3:06 pm (PDT) . Posted by:

lawleesh

Hi Randy

https://www.marketscreener.com/KEPPEL-REIT-6498766/company/ https://www.marketscreener.com/KEPPEL-REIT-6498766/company/

May I have the formula for "2016" in the first table and the formula for Singapore in the second? (Can this second formula take reference from "Sales per Regions" as the number of rows for Sales per Businesses vary depending on the stock?)

thanks

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

2b

Re: Marketscreener

Fri Jul 19, 2019 4:30 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=INDEX(RCHGetHTMLTable("
https://www.marketscreener.com/KEPPEL-REIT-6498766/company/","Sales per
Businesses",1,,2,,10,10),1,2)
=INDEX(RCHGetHTMLTable("
https://www.marketscreener.com/KEPPEL-REIT-6498766/company/","Sales per
Regions",1,,2,,10,10),3,1)

The example you gave doesn't help me see how number of rows varies?

On Fri, Jul 19, 2019 at 3:08 PM lawrence.leesh@... wrote:

> https://www.marketscreener.com/KEPPEL-REIT-6498766/company/
>
> May I have the formula for "2016" in the first table and the formula for
> Singapore in the second? (Can this second formula take reference from
> "Sales per Regions" as the number of rows for Sales per Businesses vary
> depending on the stock?)
>
>
>

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

2c

Re: Marketscreener

Fri Jul 19, 2019 6:53 pm (PDT) . Posted by:

lawleesh

Thanks Randy.

What I meant is that for stock such as Apple, there are more lines to each table so I was looking for a formula that works in all instances.

https://www.marketscreener.com/APPLE-4849/company/ https://www.marketscreener.com/APPLE-4849/company/

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

2d

Re: Marketscreener

Fri Jul 19, 2019 6:58 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You could just use the RCHGetHTMLTable() to grab the whole table all at
once.

On Fri, Jul 19, 2019 at 6:53 PM lawrence.leesh@... wrote:

>
> What I meant is that for stock such as Apple, there are more lines to each
> table so I was looking for a formula that works in all instances.
>
> https://www.marketscreener.com/APPLE-4849/company/
>
>
>

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

2e

Re: Marketscreener

Fri Jul 19, 2019 7:48 pm (PDT) . Posted by:

lawleesh

What would be the formula to grab the first table for Keppel REIT?

thanks

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

2f

Re: Marketscreener

Fri Jul 19, 2019 7:57 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

In was in the first formula I gave you:

=RCHGetHTMLTable("
https://www.marketscreener.com/KEPPEL-REIT-6498766/company/","Sales per
Businesses",1,,2)

On Fri, Jul 19, 2019 at 7:48 PM lawrence.leesh@... wrote:

>
> What would be the formula to grab the first table for Keppel REIT?
>
>
>