EXCEL Stock Market Functions Add-in Group

1 Message

Digest #3423

Re: TTM dividend using RCHGetYahooHistory (last increase) by "Jose Jacob" pepecan47

Message

1a

Re: TTM dividend using RCHGetYahooHistory (last increase)

Wed Jun 3, 2015 12:33 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

Hi Kermit, thank you very much for the links, good stuff. But from the links, I cannot figure out how to calculate the percentage of the latest dividend increase.

Regards,
Jose L. Jacob

--------------------------------------------
On Tue, 6/2/15, 'Kermit W. Prather' kermitp@tampabay.rr.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: RE: [smf_addin] TTM dividend using RCHGetYahooHistory (last increase)
To: smf_addin@yahoogroups.com
Received: Tuesday, June 2, 2015, 6:33 PM

Try one of these
links: On all 3 site - you will need to calculate the
percentage yourself. The data is there and it's a simple
formula to calculate the percentagehttp://www.dividendinformation.com/LPHI_dividends/
This is a free site. http://www.dividend.com/dividend-stocks/financial/life-insurance/lphi-life-partners-holdings-inc/
You need premium access to
this site for the complete dividend history https://dividata.com/stock/LPHI/dividend
This is a free site. https://www.dividendchannel.com/history/?symbol=lphi
this site also gives you the information but you
can't access it with the SMFADDIN. From: smf_addin@yahoogroups.com
[mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, June 02, 2015 11:54 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] TTM dividend
using RCHGetYahooHistory (last
increase)

Sorry, but I can't
think of an easy way to get the latest % increase. I think
you'd need to get the range of data returned into a
worksheet and then search for when the change
occurred. On Tue, Jun 2, 2015 at
8:35 AM, Jose Jacob pepecan47@yahoo.ca
[smf_addin] <smf_addin@yahoogroups.com>
wrote:Hi Randy, thank you very
much for your help.

The
Payment over payment formula:

=INDEX(RCHGetYahooHistory(A3,,,,,,,"v",,0,,,1,2),1,2)/INDEX(RCHGetYahooHistory(A3,,,,,,,"v",,0,,,2,2),2,2)-1

gives me the increase% only if
there is an increase in the last dividend (JNJ is ok). But
if the last dividend wasn't raised, it gives zero
(MCD).

I would like to have
the latest %increase, even if this happened 2 or 3 dividends
ago.

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

#yiv9804548184 #yiv9804548184ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv9804548184 #yiv9804548184ygrp-mkp #yiv9804548184hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv9804548184 #yiv9804548184ygrp-mkp #yiv9804548184ads {
margin-bottom:10px;}

#yiv9804548184 #yiv9804548184ygrp-mkp .yiv9804548184ad {
padding:0 0;}

#yiv9804548184 #yiv9804548184ygrp-mkp .yiv9804548184ad p {
margin:0;}

#yiv9804548184 #yiv9804548184ygrp-mkp .yiv9804548184ad a {
color:#0000ff;text-decoration:none;}
#yiv9804548184 #yiv9804548184ygrp-sponsor
#yiv9804548184ygrp-lc {
font-family:Arial;}

#yiv9804548184 #yiv9804548184ygrp-sponsor
#yiv9804548184ygrp-lc #yiv9804548184hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv9804548184 #yiv9804548184ygrp-sponsor
#yiv9804548184ygrp-lc .yiv9804548184ad {
margin-bottom:10px;padding:0 0;}

#yiv9804548184 #yiv9804548184actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv9804548184 #yiv9804548184activity span {
font-weight:700;}

#yiv9804548184 #yiv9804548184activity span:first-child {
text-transform:uppercase;}

#yiv9804548184 #yiv9804548184activity span a {
color:#5085b6;text-decoration:none;}

#yiv9804548184 #yiv9804548184activity span span {
color:#ff7900;}

#yiv9804548184 #yiv9804548184activity span
.yiv9804548184underline {
text-decoration:underline;}

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

#yiv9804548184 .yiv9804548184attach div a {
text-decoration:none;}

#yiv9804548184 .yiv9804548184attach img {
border:none;padding-right:5px;}

#yiv9804548184 .yiv9804548184attach label {
display:block;margin-bottom:5px;}

#yiv9804548184 .yiv9804548184attach label a {
text-decoration:none;}

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

#yiv9804548184 .yiv9804548184bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv9804548184 .yiv9804548184bold a {
text-decoration:none;}

#yiv9804548184 dd.yiv9804548184last p a {
font-family:Verdana;font-weight:700;}

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

#yiv9804548184 dd.yiv9804548184last p
span.yiv9804548184yshortcuts {
margin-right:0;}

#yiv9804548184 div.yiv9804548184attach-table div div a {
text-decoration:none;}

#yiv9804548184 div.yiv9804548184attach-table {
width:400px;}

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

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

#yiv9804548184 div#yiv9804548184ygrp-mlmsg
#yiv9804548184ygrp-msg p a span.yiv9804548184yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv9804548184 .yiv9804548184green {
color:#628c2a;}

#yiv9804548184 .yiv9804548184MsoNormal {
margin:0 0 0 0;}

#yiv9804548184 o {
font-size:0;}

#yiv9804548184 #yiv9804548184photos div {
float:left;width:72px;}

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

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

#yiv9804548184 #yiv9804548184reco-category {
font-size:77%;}

#yiv9804548184 #yiv9804548184reco-desc {
font-size:77%;}

#yiv9804548184 .yiv9804548184replbq {
margin:4px;}

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

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

#yiv9804548184 #yiv9804548184ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv9804548184 #yiv9804548184ygrp-mlmsg pre, #yiv9804548184
code {
font:115% monospace;}

#yiv9804548184 #yiv9804548184ygrp-mlmsg * {
line-height:1.22em;}

#yiv9804548184 #yiv9804548184ygrp-mlmsg #yiv9804548184logo {
padding-bottom:10px;}

#yiv9804548184 #yiv9804548184ygrp-msg p a {
font-family:Verdana;}

#yiv9804548184 #yiv9804548184ygrp-msg
p#yiv9804548184attach-count span {
color:#1E66AE;font-weight:700;}

#yiv9804548184 #yiv9804548184ygrp-reco
#yiv9804548184reco-head {
color:#ff7900;font-weight:700;}

#yiv9804548184 #yiv9804548184ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv9804548184 #yiv9804548184ygrp-sponsor #yiv9804548184ov
li a {
font-size:130%;text-decoration:none;}

#yiv9804548184 #yiv9804548184ygrp-sponsor #yiv9804548184ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv9804548184 #yiv9804548184ygrp-sponsor #yiv9804548184ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv9804548184 #yiv9804548184ygrp-text {
font-family:Georgia;}

#yiv9804548184 #yiv9804548184ygrp-text p {
margin:0 0 1em 0;}

#yiv9804548184 #yiv9804548184ygrp-text tt {
font-size:120%;}

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