EXCEL Stock Market Functions Add-in Group

1 Message

Digest #3684

Re: Finding most recent dividend increase by "Jose Jacob" pepecan47

Message

1a

Re: Finding most recent dividend increase

Mon Apr 25, 2016 7:02 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

Randy, Jim - thank you very much for the replies. Both work, but in my particular case, for simplicity, I will use Jim's formula (2).

In another spreadsheet I use Randy's approach.

Regards,
Jose L. Jacob

--------------------------------------------
On Sun, 4/24/16, jmcatee133@aol.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Finding most recent dividend increase
To: smf_addin@yahoogroups.com
Received: Sunday, April 24, 2016, 5:22 PM

Jose. Here are a
couple of ways to calculate the most recent change (positive
or negative) within your string of 8 values. You may want
to try both as each may be helpful for what you are
doing.

1. calculates change for each column:

   A
B
C
D               E
F                G
H                I

MCD0.890.890.850.850.850.850.810.81

4.71%

4.94%

The formula to place in column B under the first
dividend in this e.g.:
=if(B1<>C1,(B1-C1)/C1,"")

It would then be copied to columns C - H. (The MCD
data for this formula happened to be in row 1 of my
spreadsheet.)

2. calculates latest change only in columns B - H

MCD0.890.890.850.850.850.850.810.81

4.71%

The formula for the result in column A under MCD in
this e.g.:
=+IF(B4<>C4,(B4-C4)/C4,IF(C4<>D4,(C4-D4)/D4,IF(D4<>E4,(D4-E4)/E4,IF(E4<>F4,(E4-F4)/F4,IF(F4<>G4,(F4-G4)/G4,IF(G4<>H4,(G4-H4)/H4,IF(H4<>I4,(H4-I4)/I4,"")))))))

As you can see it is a conditional logic statement
of repeated column comparison starting with 1st two columns
and advancing to next two. Once if finds an increase or
decrease between columns it stops populating allowing the
first result to show. (The MCD data for this formula
happened to be in row 4 of my spreadsheet.)

Both formulas can be changed to show only increases by
removing the "<" in each of the comparisons.

Hope this helps. Jim

-----Original
Message-----

From: Jose Jacob pepecan47@yahoo.ca [smf_addin]
<smf_addin@yahoogroups.com>

To: smf_addin <smf_addin@yahoogroups.com>

Sent: Sun, Apr 24, 2016 1:00 pm

Subject: [smf_addin] Finding most recent dividend
increase

This is a question more related to Excel than SMF, but
since there are gurus here I will ask anyway.

I have the following spreadsheet with the last 8 dividends.
How can I find the most recent dividend increase?

Ticker    Past1div Past2div Past3div Past4div Past5div
Past6div Past7div Past8div

d       0.7000 0.6480 0.6480
0.6480 0.6480 0.6000 0.6000 0.6000

mcd      0.8900 0.8900 0.8500 0.8500
0.8500 0.8500 0.8100 0.8100

For D, (0.7000 - 0.6480) / 0.6480 = 8.02%

for MCD, (0.8900 - 0.8500) / 0.8500 = 4.71%

Regards,

Jose L. Jacob

#yiv2167146915 #yiv2167146915 --
#yiv2167146915ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv2167146915 #yiv2167146915ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv2167146915 #yiv2167146915ygrp-mkp #yiv2167146915hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv2167146915 #yiv2167146915ygrp-mkp #yiv2167146915ads {
margin-bottom:10px;}

#yiv2167146915 #yiv2167146915ygrp-mkp .yiv2167146915ad {
padding:0 0;}

#yiv2167146915 #yiv2167146915ygrp-mkp .yiv2167146915ad p {
margin:0;}

#yiv2167146915 #yiv2167146915ygrp-mkp .yiv2167146915ad a {
color:#0000ff;text-decoration:none;}
#yiv2167146915 #yiv2167146915ygrp-sponsor
#yiv2167146915ygrp-lc {
font-family:Arial;}

#yiv2167146915 #yiv2167146915ygrp-sponsor
#yiv2167146915ygrp-lc #yiv2167146915hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv2167146915 #yiv2167146915ygrp-sponsor
#yiv2167146915ygrp-lc .yiv2167146915ad {
margin-bottom:10px;padding:0 0;}

#yiv2167146915 #yiv2167146915actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv2167146915 #yiv2167146915activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv2167146915 #yiv2167146915activity span {
font-weight:700;}

#yiv2167146915 #yiv2167146915activity span:first-child {
text-transform:uppercase;}

#yiv2167146915 #yiv2167146915activity span a {
color:#5085b6;text-decoration:none;}

#yiv2167146915 #yiv2167146915activity span span {
color:#ff7900;}

#yiv2167146915 #yiv2167146915activity span
.yiv2167146915underline {
text-decoration:underline;}

#yiv2167146915 .yiv2167146915attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv2167146915 .yiv2167146915attach div a {
text-decoration:none;}

#yiv2167146915 .yiv2167146915attach img {
border:none;padding-right:5px;}

#yiv2167146915 .yiv2167146915attach label {
display:block;margin-bottom:5px;}

#yiv2167146915 .yiv2167146915attach label a {
text-decoration:none;}

#yiv2167146915 blockquote {
margin:0 0 0 4px;}

#yiv2167146915 .yiv2167146915bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv2167146915 .yiv2167146915bold a {
text-decoration:none;}

#yiv2167146915 dd.yiv2167146915last p a {
font-family:Verdana;font-weight:700;}

#yiv2167146915 dd.yiv2167146915last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv2167146915 dd.yiv2167146915last p
span.yiv2167146915yshortcuts {
margin-right:0;}

#yiv2167146915 div.yiv2167146915attach-table div div a {
text-decoration:none;}

#yiv2167146915 div.yiv2167146915attach-table {
width:400px;}

#yiv2167146915 div.yiv2167146915file-title a, #yiv2167146915
div.yiv2167146915file-title a:active, #yiv2167146915
div.yiv2167146915file-title a:hover, #yiv2167146915
div.yiv2167146915file-title a:visited {
text-decoration:none;}

#yiv2167146915 div.yiv2167146915photo-title a,
#yiv2167146915 div.yiv2167146915photo-title a:active,
#yiv2167146915 div.yiv2167146915photo-title a:hover,
#yiv2167146915 div.yiv2167146915photo-title a:visited {
text-decoration:none;}

#yiv2167146915 div#yiv2167146915ygrp-mlmsg
#yiv2167146915ygrp-msg p a span.yiv2167146915yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv2167146915 .yiv2167146915green {
color:#628c2a;}

#yiv2167146915 .yiv2167146915MsoNormal {
margin:0 0 0 0;}

#yiv2167146915 o {
font-size:0;}

#yiv2167146915 #yiv2167146915photos div {
float:left;width:72px;}

#yiv2167146915 #yiv2167146915photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv2167146915 #yiv2167146915photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv2167146915 #yiv2167146915reco-category {
font-size:77%;}

#yiv2167146915 #yiv2167146915reco-desc {
font-size:77%;}

#yiv2167146915 .yiv2167146915replbq {
margin:4px;}

#yiv2167146915 #yiv2167146915ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv2167146915 #yiv2167146915ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv2167146915 #yiv2167146915ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv2167146915 #yiv2167146915ygrp-mlmsg select,
#yiv2167146915 input, #yiv2167146915 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv2167146915 #yiv2167146915ygrp-mlmsg pre, #yiv2167146915
code {
font:115% monospace;}

#yiv2167146915 #yiv2167146915ygrp-mlmsg * {
line-height:1.22em;}

#yiv2167146915 #yiv2167146915ygrp-mlmsg #yiv2167146915logo {
padding-bottom:10px;}

#yiv2167146915 #yiv2167146915ygrp-msg p a {
font-family:Verdana;}

#yiv2167146915 #yiv2167146915ygrp-msg
p#yiv2167146915attach-count span {
color:#1E66AE;font-weight:700;}

#yiv2167146915 #yiv2167146915ygrp-reco
#yiv2167146915reco-head {
color:#ff7900;font-weight:700;}

#yiv2167146915 #yiv2167146915ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv2167146915 #yiv2167146915ygrp-sponsor #yiv2167146915ov
li a {
font-size:130%;text-decoration:none;}

#yiv2167146915 #yiv2167146915ygrp-sponsor #yiv2167146915ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv2167146915 #yiv2167146915ygrp-sponsor #yiv2167146915ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv2167146915 #yiv2167146915ygrp-text {
font-family:Georgia;}

#yiv2167146915 #yiv2167146915ygrp-text p {
margin:0 0 1em 0;}

#yiv2167146915 #yiv2167146915ygrp-text tt {
font-size:120%;}

#yiv2167146915 #yiv2167146915ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv2167146915