[smf_addin] Digest Number 4411

EXCEL Stock Market Functions Add-in Group

2 Messages

Digest #4411

1a

Morningstar Fair Value, FV uncertainty, Moat, #*'s by "Jose Jacob" pepecan47

1b

Re: Morningstar Fair Value, FV uncertainty, Moat, #*'s by "Randy Harmelink" rharmelink

Messages

1a

Morningstar Fair Value, FV uncertainty, Moat, #*'s

Sun Oct 14, 2018 9:13 am (PDT) . Posted by:

"Jose Jacob" pepecan47

Hell Randy and SMF users - I have a Morningstar premium membership. I use the following formulas that work for almost all the stocks that I follow:
Fair Value: =SUBSTITUTE(SUBSTITUTE(RCHGetElementNumber($D4, 886), "$ ", ""), "CAD", "")FV Uncertainty: =RCHGetElementNumber($A5,889)Moat: =RCHGetElementNumber($A5,890)#*'s: =smfConvertData(smfStrExtr(RCHGetWebData("http://financials.morningstar.com/company-profile/c.action?t="&$D4,"r_star"),"r_star","'"))&"*"
However, there are some stocks that the above formulas don't return values:XTSE:ALAXTSE:AQNXTSE:BEP.UNXTSE:BIP.UN
But I see the values in the following page, for example AQN
AQN Algonquin Power & Utilities Corp Stock Quote Price | Morningstar

|
|
|
| | |

|

|
|
| |
AQN Algonquin Power & Utilities Corp Stock Quote Price | Morningstar
| |

|

|

Would you please help in extracting the values? Thank you very much.
Regards, Jose L. Jacob

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

1b

Re: Morningstar Fair Value, FV uncertainty, Moat, #*'s

Sun Oct 14, 2018 1:10 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but Canadian stocks appear to have their data retrieved from an API
that requires credentials...

On Sun, Oct 14, 2018 at 9:13 AM Jose Jacob pepecan47@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hell Randy and SMF users - I have a Morningstar premium membership. I use
> the following formulas that work for almost all the stocks that I follow:
>
> Fair Value: =SUBSTITUTE(SUBSTITUTE(RCHGetElementNumber($D4, 886), "$ ",
> ""), "CAD", "")
> FV Uncertainty: =RCHGetElementNumber($A5,889)
> Moat: =RCHGetElementNumber($A5,890)
> #*'s: =smfConvertData(smfStrExtr(RCHGetWebData("
> http://financials.morningstar.com/company-profile/c.action?t=
> "&$D4,"r_star"),"r_star","'"))&"*"
>
> However, there are some stocks that the above formulas don't return values:
> XTSE:ALA
> XTSE:AQN
> XTSE:BEP.UN
> XTSE:BIP.UN
>
> But I see the values in the following page, for example AQN
>
> AQN Algonquin Power & Utilities Corp Stock Quote Price | Morningstar
> <https://www.morningstar.com/stocks/xtse/aqn/quote.html>
>
> AQN Algonquin Power & Utilities Corp Stock Quote Price | Morningstar
> <https://www.morningstar.com/stocks/xtse/aqn/quote.html>
>
>
> Would you please help in extracting the values? Thank you very much.
>
>
>

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

• Privacy • Unsubscribe • Terms of Use