[smf_addin] Digest Number 3203

EXCEL Stock Market Functions Add-in Group

8 Messages

Digest #3203

1a

Analyst Opinion by mustang66.7599

1b

Re: Analyst Opinion by "Randy Harmelink" rharmelink

1c

Re: Analyst Opinion by mustang66.7599

1d

Re: Analyst Opinion by "Randy Harmelink" rharmelink

2a

Re: Canadian Stock Standard Deviation by c2adf9311e2c386ea6b50154ae931d42

2b

Re: Canadian Stock Standard Deviation by "Randy Harmelink" rharmelink

2c

Re: Canadian Stock Standard Deviation by c2adf9311e2c386ea6b50154ae931d42

2d

Re: Canadian Stock Standard Deviation by "Randy Harmelink" rharmelink

Messages

1a

Analyst Opinion

Wed Oct 8, 2014 7:11 am (PDT) . Posted by:

mustang66.7599

With the demise of MSN elements 354-381 is there any replacements in the works? How about from Yahoo?


Thanks

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

1b

Re: Analyst Opinion

Wed Oct 8, 2014 7:57 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

There are some analyst items defined from Yahoo and MorningStar.

On Wed, Oct 8, 2014 at 7:11 AM, kabrod77@verizon.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> With the demise of MSN elements 354-381 is there any replacements in the
> works? How about from Yahoo?
>

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

1c

Re: Analyst Opinion

Wed Oct 8, 2014 8:18 am (PDT) . Posted by:

mustang66.7599

Yes but I'm referring specifically to # Stong Buy, Buy, and Hold - not just the overall Rating #

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

1d

Re: Analyst Opinion

Wed Oct 8, 2014 9:57 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The Morningstar template has that, but just uses different labels:

Buy Outperform Hold Underperform Sell Total Number of Analysts: 1 0 2 1
0

On Wed, Oct 8, 2014 at 8:18 AM, kabrod77@verizon.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Yes but I'm referring specifically to # Stong Buy, Buy, and Hold - not
> just the overall Rating #
>

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

2a

Re: Canadian Stock Standard Deviation

Wed Oct 8, 2014 2:12 pm (PDT) . Posted by:

c2adf9311e2c386ea6b50154ae931d42

TRP.to for example?

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

2b

Re: Canadian Stock Standard Deviation

Wed Oct 8, 2014 2:26 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

TRP.TO has no risk data available:

http://finance.yahoo.com/q/rk?s=trp.to

On Wed, Oct 8, 2014 at 2:12 PM, sdglobe@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> TRP.to for example?
>

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

2c

Re: Canadian Stock Standard Deviation

Wed Oct 8, 2014 2:35 pm (PDT) . Posted by:

c2adf9311e2c386ea6b50154ae931d42

no risk for Canadian securities then?

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

2d

Re: Canadian Stock Standard Deviation

Wed Oct 8, 2014 3:02 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

No idea. I never use the page. I didn't see one for MMM either. It may only
exists for ETFs and funds. For example, this works:

=RCHGetTableCell("http://finance.yahoo.com/q/rk?s=SPY",1,">Standard
Deviation")

On Wed, Oct 8, 2014 at 2:35 PM, sdglobe@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> no risk for Canadian securities then?
>

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

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

Visit Your Group

• New Members 24

• Privacy • Unsubscribe • Terms of Use