EXCEL Stock Market Functions Add-in Group

5 New Messages

Digest #2796

Re: Morningstar dynamic pages - element list update planned? by "Jacob Jose" pepecan47

Re: Morningstar dynamic pages - element list update planned? by "Randy Harmelink" rharmelink

Re: add in not working for Indian stocks by anto_bonn

Re: add in not working for Indian stocks by "Randy Harmelink" rharmelink

Re: Problems With YAHOO RCHGetElementNumber by "PeteA" option2z

Messages

1a

Re: Morningstar dynamic pages - element list update planned?

Wed Oct 2, 2013 9:14 pm (PDT) . Posted by:

"Jacob Jose" pepecan47

Hi Randy - this is amazing, thx a lot.

Any particular reason why "Year 1/2 Mean Estimate" and "Year 1/2 Mean Growth" don't have an element # assigned?

Regards,
Jose L. Jacob

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, October 2, 2013 1:36:35 AM
Subject: Re: [smf_addin] Re: Morningstar dynamic pages - element list update planned?

I just uploaded a new version of smf-elements-6.txt, to the "Works in Progress" folder in the FILES area of the group, with these additional element definitions:
#
Source
Element
14401 MorningStarAE Annual Estimates -- As Of Date
14402 MorningStarAE Annual Estimates -- Year 1 Date
14403 MorningStarAE Annual Estimates -- Year 1 High Estimate
14404 MorningStarAE Annual Estimates -- Year 1 High Growth %
14405 MorningStarAE Annual Estimates -- Year 1 Low Estimate
14406 MorningStarAE Annual Estimates -- Year 1 Low Growth %
14407 MorningStarAE Annual Estimates -- Year 1 Median Estimate
14408 MorningStarAE Annual Estimates -- Year 1 Median Growth %
14409 MorningStarAE Annual Estimates -- Year 1 30 Days Ago Estimate
14410 MorningStarAE Annual Estimates -- Year 1 30 Days Ago Growth %
14411 MorningStarAE Annual Estimates -- Year 1 60 Days Ago Estimate
14412 MorningStarAE Annual Estimates -- Year 1 60 Days Ago Growth %
14413 MorningStarAE Annual Estimates -- Year 1 90 Days Ago Estimate
14414 MorningStarAE Annual Estimates -- Year 1 90 Days Ago Growth %
14415 MorningStarAE Annual Estimates -- Year 1 Number of Estimates
14416 MorningStarAE Annual Estimates -- Year 2 Date
14417 MorningStarAE Annual Estimates -- Year 2 High Estimate
14418 MorningStarAE Annual Estimates -- Year 2 High Growth %
14419 MorningStarAE Annual Estimates -- Year 2 Low Estimate
14420 MorningStarAE Annual Estimates -- Year 2 Low Growth %
14421 MorningStarAE Annual Estimates -- Year 2 Median Estimate
14422 MorningStarAE Annual Estimates -- Year 2 Median Growth %
14423 MorningStarAE Annual Estimates -- Year 2 30 Days Ago Estimate
14424 MorningStarAE Annual Estimates -- Year 2 30 Days Ago Growth %
14425 MorningStarAE Annual Estimates -- Year 2 60 Days Ago Estimate
14426 MorningStarAE Annual Estimates -- Year 2 60 Days Ago Growth %
14427 MorningStarAE Annual Estimates -- Year 2 90 Days Ago Estimate
14428 MorningStarAE Annual Estimates -- Year 2 90 Days Ago Growth %
14429 MorningStarAE Annual Estimates -- Year 2 Number of Estimates
On Tue, Oct 1, 2013 at 6:50 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>http://financials.morningstar.com/valuation/annual-estimate-list.action?t=MMM
>12/2013
> USD Growth % Mean 7.02 11.1
>12/2014
> USD Growth % Mean 7.62 8.5
>

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

1b

Re: Morningstar dynamic pages - element list update planned?

Wed Oct 2, 2013 10:11 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Oops. Just added them. New uploads:

smf-elements-4.txt
SMF-Template-Morningstar-Stock-Data.xls

On Wed, Oct 2, 2013 at 9:10 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
> Any particular reason why "Year 1/2 Mean Estimate" and "Year 1/2 Mean
> Growth" don't have an element # assigned?
>
>

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

2a

Re: add in not working for Indian stocks

Wed Oct 2, 2013 10:08 pm (PDT) . Posted by:

anto_bonn

Hi Randy,

I am in India and I am finding the same problem

when I use =rchgetyahooquotes("IBM","l1") i get the price data of
184.96

but when I use it for some indian tickers say for example
=rchgetyahooquotes("INFY.NS","l1") I am getting a 0

Is there a solution for this?

I am using Excel 2007 on Windows 8

Antony Pradheep

---In smf_addin@yahoogroups.com, <zttez1@...> wrote:

Please ignore my questions
I find out they are using Reuters codes
not the challenge would be find out a list of all Indian code in
reuters

--- In smf_addin@yahoogroups.com
<mailto:smf_addin@yahoogroups.com> , Randy Harmelink
<rharmelink@...> wrote:
>
> You'd have to use their symbol lookup function to find out the
correct
> ticker symbol to use...
>
> On Thu, Nov 4, 2010 at 7:40 AM, zttez1 <zttez1@...> wrote:
>
> > Now it is working (=RCHGetYahooQuotes(A3:A5,B1)) for the
first security but
> > not for the others
> > How do I get to know the yahoo codes for the stocks so that I
don't get
> > zeros?
> >
>

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

2b

Re: add in not working for Indian stocks

Wed Oct 2, 2013 10:21 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

See: http://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/23326

On Wed, Oct 2, 2013 at 10:08 PM, <anto_bonn@yahoo.co.in> wrote:

> I am in India and I am finding the same problem
>
> when I use =rchgetyahooquotes("IBM","l1") i get the price data of 184.96
>
> but when I use it for some indian tickers say for
> example =rchgetyahooquotes("INFY.NS","l1") I am getting a 0
>
> Is there a solution for this?
>

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

3a

Re: Problems With YAHOO RCHGetElementNumber

Wed Oct 2, 2013 10:56 pm (PDT) . Posted by:

"PeteA" option2z

Thanks, Randy. I've run it several times during the day, and SOME of them
came back, but many have not. Seems like YAHOO has quality control problems
AND they manage to make the YAHOO Groups MUCH less usable while trying to
make them more like Googles!

We'll just wait patiently for them to get it back together. I HATE it when
amateur database admins run the show.

Yuck.
Pete A
I tried the elements with ticker MMM and got blanks for the first two and
"Error" for the last two. When I go to Yahoo with my browser, there are no
sector name and industry name listed (the first two items), and the key
statistics page doesn't exists (from which the list two items would be
extracted).

So it's definitely a Yahoo problem. Hopefully temporary.

On Wed, Oct 2, 2013 at 10:03 AM, <optionzz@gmail.com
<mailto:optionzz@gmail.com> > wrote:

>
> Just checking to see if anyone else is having similar problems.
> RCHGetElementNumber
> *13865* *13867* *990* *989*Aren't working as of this morning. (But 13862
> is working). Perhaps just a short term (I hope) YAHOO glitch. Or, maybe
> something has gone awry with my system.
>
> I downloaded the latest TXT files (1 and 4) that have changed. Restarted
> Excel (2013). But since at least one is working, I'm suspecting that YAHOO
> has, sigh, once again changed something.
>
>