[smf_addin] Digest Number 2971

EXCEL Stock Market Functions Add-in Group

6 New Messages

Digest #2971

1a

Re: Reuters 1Y and 3Y div Growth Reuters by "Jacob Jose" pepecan47

2a

Re: retrieve fixed number of quotes by "Randy Harmelink" rharmelink

3a

Re: Yahoo Advancers / Decliners by "Kim Blake" kim54blake

4a

smfpricesbetween with monthly dates by ganevniko

4b

Re: smfpricesbetween with monthly dates by mikemcq802

4c

Re: smfpricesbetween with monthly dates by "Randy Harmelink" rharmelink

Messages

1a

Re: Reuters 1Y and 3Y div Growth Reuters

Sun Feb 16, 2014 7:00 pm (PST) . Posted by:

"Jacob Jose" pepecan47

Hey Randy, I don't know what to say... you are amazing, not only professionally, but more important, as a person.
Thank you very much.

Regards,
Jose L. Jacob

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, February 16, 2014 9:12:23 PM
Subject: Re: [smf_addin] Reuters 1Y and 3Y div Growth Reuters

 
I decided to go ahead and add the new elements you noted, because I also added the new performance table. I know a lot of people were asking about such data when MSN dropped their performance elements.

I just uploaded a new version of the smf-elements-5.txt file to the "Works in Progress" folder in the FILES area, with these new element definitions:

#
Usage
Source
Element
Template or Notes
731 SE ReutersRat Comparison Ratios -- Growth Rates -- Sales - 3 Year Growth Rate -- Company SMF-Template-Reuters-Ratios-Comparison.xls
732 SE ReutersRat Comparison Ratios -- Growth Rates -- EPS - 3 Year Growth Rate -- Company SMF-Template-Reuters-Ratios-Comparison.xls
733 SE ReutersRat Comparison Ratios -- Dividends -- Dividend 1 Year Growth Rate -- Company SMF-Template-Reuters-Ratios-Comparison.xls
734 SE ReutersRat Comparison Ratios -- Dividends -- Dividend 3 Year Growth Rate -- Company SMF-Template-Reuters-Ratios-Comparison.xls
735 SE ReutersRat Performance -- 4 Week -- % Actual SMF-Template-Reuters-Ratios-Comparison.xls
736 SE ReutersRat Performance -- 4 Week -- % vs. S&P 500 SMF-Template-Reuters-Ratios-Comparison.xls
737 SE ReutersRat Performance -- 4 Week -- Rank in Industry SMF-Template-Reuters-Ratios-Comparison.xls
738 SE ReutersRat Performance -- 4 Week -- Industry Rank SMF-Template-Reuters-Ratios-Comparison.xls
739 SE ReutersRat Performance -- 13 Week -- % Actual SMF-Template-Reuters-Ratios-Comparison.xls
740 SE ReutersRat Performance -- 13 Week -- % vs. S&P 500 SMF-Template-Reuters-Ratios-Comparison.xls
741 SE ReutersRat Performance -- 13 Week -- Rank in Industry SMF-Template-Reuters-Ratios-Comparison.xls
742 SE ReutersRat Performance -- 13 Week -- Industry Rank SMF-Template-Reuters-Ratios-Comparison.xls
743 SE ReutersRat Performance -- 26 Week -- % Actual SMF-Template-Reuters-Ratios-Comparison.xls
744 SE ReutersRat Performance -- 26 Week -- % vs. S&P 500 SMF-Template-Reuters-Ratios-Comparison.xls
745 SE ReutersRat Performance -- 26 Week -- Rank in Industry SMF-Template-Reuters-Ratios-Comparison.xls
746 SE ReutersRat Performance -- 26 Week -- Industry Rank SMF-Template-Reuters-Ratios-Comparison.xls
747 SE ReutersRat Performance -- 52 Week -- % Actual SMF-Template-Reuters-Ratios-Comparison.xls
748 SE ReutersRat Performance -- 52 Week -- % vs. S&P 500 SMF-Template-Reuters-Ratios-Comparison.xls
749 SE ReutersRat Performance -- 52 Week -- Rank in Industry SMF-Template-Reuters-Ratios-Comparison.xls
750 SE ReutersRat Performance -- 52 Week -- Industry Rank SMF-Template-Reuters-Ratios-Comparison.xls
751 SE ReutersRat Performance -- Year-to-Date -- % Actual SMF-Template-Reuters-Ratios-Comparison.xls
752 SE ReutersRat Performance -- Year-to-Date -- % vs. S&P 500 SMF-Template-Reuters-Ratios-Comparison.xls
753 SE ReutersRat Performance -- Year-to-Date -- Rank in Industry SMF-Template-Reuters-Ratios-Comparison.xls
754 SE ReutersRat Performance -- Year-to-Date -- Industry Rank SMF-Template-Reuters-Ratios-Comparison.xls
Best practice:

1. Exit EXCEL
2. Download the new version of the element definition file

3. Replace the older version of this file in your add-in's file folder with the newer downloaded version

4. Restart EXCEL
I also uploaded a new copy of the SMF-Template-Reuters-Ratios-Comparison.xls template to the "Works in Progress" folder, with the new data elements added.

On Sun, Feb 16, 2014 at 11:52 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
>Hi Randy - I noticed that Reuters is showing 1/3/5 years dividend growth.
> 
>For 5Y I use element 13674.
> 
>For 1Y I use
>=RCHGetTableCell("http://www.reuters.com/finance/stocks/financialHighlights?symbol=%22&A3,1,%22Dividend %")
> 
>For 3Y I use
>=RCHGetTableCell("http://www.reuters.com/finance/stocks/financialHighlights?symbol=%22&A3,2,%22Dividend %")
>
>Do you thing it is a good idea to assign element#'s to 1Y and 3Y div growth?
>

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

2a

Re: retrieve fixed number of quotes

Sun Feb 16, 2014 7:03 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

If you don't want to get involved with dates, I'd just grab more data than
you need an extract what you want. In your specific example, grab 21 quotes
and extract the last 20.

If you wanted 20 quotes ending with a particular date, you can give it that
ending date and some starting date far enough away so you'll get at least
20 quotes (say 2 months?), then the last two parameters will just grab the
most recent 20 quotes.

On Sun, Feb 16, 2014 at 7:15 PM, <sihlai@yahoo.ca> wrote:

>
> I am probably pushing my luck here, but what happens to the final 2
> parameters in the formula if I am looking for the next 20 quotes prior to
> today, i.e. 20 quotes from yesterday and past, excluding today's?
>

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

3a

Re: Yahoo Advancers / Decliners

Sun Feb 16, 2014 8:17 pm (PST) . Posted by:

"Kim Blake" kim54blake

Thank you Randy;

Your tireless and patient responses to the group continue to amaze me!!!

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

4a

smfpricesbetween with monthly dates

Sun Feb 16, 2014 8:25 pm (PST) . Posted by:

ganevniko

Hi,
I am trying to get monthly prices for a ticker between two dates that I can change. Does anybody know how I can do that and if it possible with the snfpricesbetween formula ?

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

4b

Re: smfpricesbetween with monthly dates

Sun Feb 16, 2014 9:11 pm (PST) . Posted by:

mikemcq802

Use the RCHGetYahooHistory. It does exactly what you are asking (I use it that way myself).
See the docs for the syntax:
https://groups.yahoo.com/neo/groups/smf_addin/files/Documentation/ https://groups.yahoo.com/neo/groups/smf_addin/files/Documentation/

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

4c

Re: smfpricesbetween with monthly dates

Sun Feb 16, 2014 10:13 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

If all you need is closing prices for a number of different dates, I'd just
use the smfPricesByDates() function. The syntax of the two functions would
be the same:

=smfPricesBetween(ticker,date1,date2)
=smfPricesByDates(ticker,date1,date2)

Both would need to be array-entered over a range. See the "Documentation"
folder in the FILES area of the group for more information on the two
functions.

On Sun, Feb 16, 2014 at 9:25 PM, <ganevniko@yahoo.com> wrote:

>
> I am trying to get monthly prices for a ticker between two dates that I
> can change. Does anybody know how I can do that and if it possible with the
> snfpricesbetween formula ?
>

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

Visit Your Group

• New Members 47

• Privacy • Unsubscribe • Terms of Use