Rabu, 03 Juni 2015

[smf_addin] Digest Number 3422

8 Messages

Digest #3422

Messages

Tue Jun 2, 2015 8:35 am (PDT) . Posted by:

"Jose Jacob" pepecan47

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.

Regards,
Jose L. Jacob

--------------------------------------------
On Mon, 6/1/15, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] TTM dividend using RCHGetYahooHistory (last increase)
To: smf_addin@yahoogroups.com
Received: Monday, June 1, 2015, 3:01 PM


 









Year over year:

=SUM(INDEX(RCHGetYahooHistory(A3,YEAR(A4)-1,MONTH(A4),DAY(A4),YEAR(A4),MONTH(A4),DAY(A4),"v",,0,,,20,2),,2))/SUM(INDEX(RCHGetYahooHistory(A3,YEAR(A4)-2,MONTH(A4),DAY(A4),YEAR(A4)-1,MONTH(A4),DAY(A4),"v",,0,,,20,2),,2))-1

Payment over payment:

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

Note that the date-based
formulas may have an issue. Suppose one year they pay a
quarterly dividend on May 31st and the next year they pay it
on May 28th. If you look at the year from May 31 to May 31,
you'll get five quarterly payments. Which technically
*is* what they paid in that year. :(

On Mon, Jun 1, 2015 at
11:40 AM, Jose Jacob pepecan47@... wrote:
Hi Randy, Using a
variation of the below formula, is it possible to get the
percentage of the latest dividend increase?














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

#yiv6663491322 #yiv6663491322ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv6663491322 #yiv6663491322ygrp-mkp #yiv6663491322hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv6663491322 #yiv6663491322ygrp-mkp #yiv6663491322ads {
margin-bottom:10px;}

#yiv6663491322 #yiv6663491322ygrp-mkp .yiv6663491322ad {
padding:0 0;}

#yiv6663491322 #yiv6663491322ygrp-mkp .yiv6663491322ad p {
margin:0;}

#yiv6663491322 #yiv6663491322ygrp-mkp .yiv6663491322ad a {
color:#0000ff;text-decoration:none;}
#yiv6663491322 #yiv6663491322ygrp-sponsor
#yiv6663491322ygrp-lc {
font-family:Arial;}

#yiv6663491322 #yiv6663491322ygrp-sponsor
#yiv6663491322ygrp-lc #yiv6663491322hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv6663491322 #yiv6663491322ygrp-sponsor
#yiv6663491322ygrp-lc .yiv6663491322ad {
margin-bottom:10px;padding:0 0;}

#yiv6663491322 #yiv6663491322actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv6663491322 #yiv6663491322activity span {
font-weight:700;}

#yiv6663491322 #yiv6663491322activity span:first-child {
text-transform:uppercase;}

#yiv6663491322 #yiv6663491322activity span a {
color:#5085b6;text-decoration:none;}

#yiv6663491322 #yiv6663491322activity span span {
color:#ff7900;}

#yiv6663491322 #yiv6663491322activity span
.yiv6663491322underline {
text-decoration:underline;}

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

#yiv6663491322 .yiv6663491322attach div a {
text-decoration:none;}

#yiv6663491322 .yiv6663491322attach img {
border:none;padding-right:5px;}

#yiv6663491322 .yiv6663491322attach label {
display:block;margin-bottom:5px;}

#yiv6663491322 .yiv6663491322attach label a {
text-decoration:none;}

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

#yiv6663491322 .yiv6663491322bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv6663491322 .yiv6663491322bold a {
text-decoration:none;}

#yiv6663491322 dd.yiv6663491322last p a {
font-family:Verdana;font-weight:700;}

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

#yiv6663491322 dd.yiv6663491322last p
span.yiv6663491322yshortcuts {
margin-right:0;}

#yiv6663491322 div.yiv6663491322attach-table div div a {
text-decoration:none;}

#yiv6663491322 div.yiv6663491322attach-table {
width:400px;}

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

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

#yiv6663491322 div#yiv6663491322ygrp-mlmsg
#yiv6663491322ygrp-msg p a span.yiv6663491322yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv6663491322 .yiv6663491322green {
color:#628c2a;}

#yiv6663491322 .yiv6663491322MsoNormal {
margin:0 0 0 0;}

#yiv6663491322 o {
font-size:0;}

#yiv6663491322 #yiv6663491322photos div {
float:left;width:72px;}

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

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

#yiv6663491322 #yiv6663491322reco-category {
font-size:77%;}

#yiv6663491322 #yiv6663491322reco-desc {
font-size:77%;}

#yiv6663491322 .yiv6663491322replbq {
margin:4px;}

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

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

#yiv6663491322 #yiv6663491322ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv6663491322 #yiv6663491322ygrp-mlmsg pre, #yiv6663491322
code {
font:115% monospace;}

#yiv6663491322 #yiv6663491322ygrp-mlmsg * {
line-height:1.22em;}

#yiv6663491322 #yiv6663491322ygrp-mlmsg #yiv6663491322logo {
padding-bottom:10px;}


#yiv6663491322 #yiv6663491322ygrp-msg p a {
font-family:Verdana;}

#yiv6663491322 #yiv6663491322ygrp-msg
p#yiv6663491322attach-count span {
color:#1E66AE;font-weight:700;}

#yiv6663491322 #yiv6663491322ygrp-reco
#yiv6663491322reco-head {
color:#ff7900;font-weight:700;}

#yiv6663491322 #yiv6663491322ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv6663491322 #yiv6663491322ygrp-sponsor #yiv6663491322ov
li a {
font-size:130%;text-decoration:none;}

#yiv6663491322 #yiv6663491322ygrp-sponsor #yiv6663491322ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv6663491322 #yiv6663491322ygrp-sponsor #yiv6663491322ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv6663491322 #yiv6663491322ygrp-text {
font-family:Georgia;}

#yiv6663491322 #yiv6663491322ygrp-text p {
margin:0 0 1em 0;}

#yiv6663491322 #yiv6663491322ygrp-text tt {
font-size:120%;}

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


Tue Jun 2, 2015 8:59 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

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.
>
>
>
>

Tue Jun 2, 2015 11:21 am (PDT) . Posted by:

"Jose Jacob" pepecan47

I need this increase% for a list of stocks. In this case I think it is easier to have the dividend data downloaded to a workarea in the spreadsheet for every stock in the list and have a macro moving what I need to the main spreadsheet.

Is this a good idea?

Regards,
Jose L. Jacob

--------------------------------------------
On Tue, 6/2/15, Randy Harmelink rharmelink@gmail.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, 11:53 AM


 









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.



















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

#yiv9647620849 #yiv9647620849ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv9647620849 #yiv9647620849ygrp-mkp #yiv9647620849hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv9647620849 #yiv9647620849ygrp-mkp #yiv9647620849ads {
margin-bottom:10px;}

#yiv9647620849 #yiv9647620849ygrp-mkp .yiv9647620849ad {
padding:0 0;}

#yiv9647620849 #yiv9647620849ygrp-mkp .yiv9647620849ad p {
margin:0;}

#yiv9647620849 #yiv9647620849ygrp-mkp .yiv9647620849ad a {
color:#0000ff;text-decoration:none;}
#yiv9647620849 #yiv9647620849ygrp-sponsor
#yiv9647620849ygrp-lc {
font-family:Arial;}

#yiv9647620849 #yiv9647620849ygrp-sponsor
#yiv9647620849ygrp-lc #yiv9647620849hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv9647620849 #yiv9647620849ygrp-sponsor
#yiv9647620849ygrp-lc .yiv9647620849ad {
margin-bottom:10px;padding:0 0;}

#yiv9647620849 #yiv9647620849actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv9647620849 #yiv9647620849activity span {
font-weight:700;}

#yiv9647620849 #yiv9647620849activity span:first-child {
text-transform:uppercase;}

#yiv9647620849 #yiv9647620849activity span a {
color:#5085b6;text-decoration:none;}

#yiv9647620849 #yiv9647620849activity span span {
color:#ff7900;}

#yiv9647620849 #yiv9647620849activity span
.yiv9647620849underline {
text-decoration:underline;}

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

#yiv9647620849 .yiv9647620849attach div a {
text-decoration:none;}

#yiv9647620849 .yiv9647620849attach img {
border:none;padding-right:5px;}

#yiv9647620849 .yiv9647620849attach label {
display:block;margin-bottom:5px;}

#yiv9647620849 .yiv9647620849attach label a {
text-decoration:none;}

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

#yiv9647620849 .yiv9647620849bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv9647620849 .yiv9647620849bold a {
text-decoration:none;}

#yiv9647620849 dd.yiv9647620849last p a {
font-family:Verdana;font-weight:700;}

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

#yiv9647620849 dd.yiv9647620849last p
span.yiv9647620849yshortcuts {
margin-right:0;}

#yiv9647620849 div.yiv9647620849attach-table div div a {
text-decoration:none;}

#yiv9647620849 div.yiv9647620849attach-table {
width:400px;}

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

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

#yiv9647620849 div#yiv9647620849ygrp-mlmsg
#yiv9647620849ygrp-msg p a span.yiv9647620849yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv9647620849 .yiv9647620849green {
color:#628c2a;}

#yiv9647620849 .yiv9647620849MsoNormal {
margin:0 0 0 0;}

#yiv9647620849 o {
font-size:0;}

#yiv9647620849 #yiv9647620849photos div {
float:left;width:72px;}

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

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

#yiv9647620849 #yiv9647620849reco-category {
font-size:77%;}

#yiv9647620849 #yiv9647620849reco-desc {
font-size:77%;}

#yiv9647620849 .yiv9647620849replbq {
margin:4px;}

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

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

#yiv9647620849 #yiv9647620849ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv9647620849 #yiv9647620849ygrp-mlmsg pre, #yiv9647620849
code {
font:115% monospace;}

#yiv9647620849 #yiv9647620849ygrp-mlmsg * {
line-height:1.22em;}

#yiv9647620849 #yiv9647620849ygrp-mlmsg #yiv9647620849logo {
padding-bottom:10px;}


#yiv9647620849 #yiv9647620849ygrp-msg p a {
font-family:Verdana;}

#yiv9647620849 #yiv9647620849ygrp-msg
p#yiv9647620849attach-count span {
color:#1E66AE;font-weight:700;}

#yiv9647620849 #yiv9647620849ygrp-reco
#yiv9647620849reco-head {
color:#ff7900;font-weight:700;}

#yiv9647620849 #yiv9647620849ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv9647620849 #yiv9647620849ygrp-sponsor #yiv9647620849ov
li a {
font-size:130%;text-decoration:none;}

#yiv9647620849 #yiv9647620849ygrp-sponsor #yiv9647620849ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv9647620849 #yiv9647620849ygrp-sponsor #yiv9647620849ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv9647620849 #yiv9647620849ygrp-text {
font-family:Georgia;}

#yiv9647620849 #yiv9647620849ygrp-text p {
margin:0 0 1em 0;}

#yiv9647620849 #yiv9647620849ygrp-text tt {
font-size:120%;}

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


Tue Jun 2, 2015 11:36 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

As long as you're doing VBA, why not just make it a function? You'd just
need to retrieve the array of data and then iterate through it until you
find a change in the amount of dividend paid.

On Tue, Jun 2, 2015 at 11:21 AM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I need this increase% for a list of stocks. In this case I think it is
> easier to have the dividend data downloaded to a workarea in the
> spreadsheet for every stock in the list and have a macro moving what I need
> to the main spreadsheet.
>
> Is this a good idea?
>
>
>
>

Tue Jun 2, 2015 3:33 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

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 percentage
http://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.

Tue Jun 2, 2015 2:04 pm (PDT) . Posted by:

"Fred Wright" fredwwright

Is anyone else having problems extracting from FinViz?  When I go through my Excel Data from web to look at the site it tells me I should turn off compatibility mode in IE.  I have done this in IE (didn't realize it was on) but this didn't change anything in the Excel version (don't see how to reach the tools/options setting within Excel for IE) and my data retrievals are freezing up (not responding) before completing the calculations (spreadsheets that worked fine for months). 
Any thoughts?
Fred 

Tue Jun 2, 2015 2:56 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

This worked fine for me:

=RCHGetTableCell("http://finviz.com/quote.ashx?t=MMM",1,">P/E")

On Tue, Jun 2, 2015 at 2:01 PM, Fred Wright fredwwright@yahoo.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
> Is anyone else having problems extracting from FinViz? When I go through
> my Excel Data from web to look at the site it tells me I should turn off
> compatibility mode in IE. I have done this in IE (didn't realize it was
> on) but this didn't change anything in the Excel version (don't see how to
> reach the tools/options setting within Excel for IE) and my data retrievals
> are freezing up (not responding) before completing the calculations
> (spreadsheets that worked fine for months).
>
>
>

Tue Jun 2, 2015 2:51 pm (PDT) . Posted by:

gavega

Randy,


I too have been using Windows Vista and MS Office 2010 and have had no problems. I recently switched to a new computer with Windows 8.1 and MSO 2013 and I am lost. I am going back to your emails and see if I can find one that could help


Thanks,


Gavega

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

Tidak ada komentar:

Posting Komentar