Senin, 20 April 2015

[smf_addin] Digest Number 3386

7 Messages

Digest #3386

Messages

Sun Apr 19, 2015 6:28 am (PDT) . Posted by:

rr76012

Randy,


PS I love your smfUpdateDownloadTable-Sample spreadsheet.


rr76012

Sun Apr 19, 2015 11:23 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I always use it as a starting point for a new workbook using that macro,
since it has everything set up for it already.

On Sun, Apr 19, 2015 at 6:28 AM, rr76012@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> PS I love your smfUpdateDownloadTable-Sample spreadsheet.
>
>

Sun Apr 19, 2015 3:14 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

Hi Randy - is there a way to extract the latest 24 dividends from this page:

http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=XOM

What I want is to have the dividend growth for the previous 1,2,3,4,5 years

Dividend growth past Year 1 = ((Dividends 1 to 4) - (Dividends 5 to 8))/(Dividends 5 to 8)
Dividend growth past Year 2 = ((Dividends 5 to 8) - (Dividends 9 to 12))/(Dividends 9 to 12)
Dividend growth past Year 3 = ((Dividends 9 to 12) - (Dividends 13 to 16))/(Dividends 13 to 16)
Dividend growth past Year 4 = ((Dividends 13 to 16) - (Dividends 17 to 20))/(Dividends 17 to 20)
Dividend growth past Year 5 = ((Dividends 17 to 20) - (Dividends 21 to 24))/(Dividends 21 to 24)

Regards,
Jose L. Jacob

Sun Apr 19, 2015 4:48 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not easily. You'd have to set up some type of cascading extraction.

Yahoo dividends would be easier to get, using the RCHGetYahooHistory()
function.

Or, how about GuruFocus:

=RCHGetHTMLTable("http://www.gurufocus.com/dividend/XOM",">Record
Date",-1,"",1)

On Sun, Apr 19, 2015 at 3:14 PM, Jose Jacob pepecan47... wrote:

> Hi Randy - is there a way to extract the latest 24 dividends from this
> page:
>
>
> http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=XOM
>
> What I want is to have the dividend growth for the previous 1,2,3,4,5 years
>
> Dividend growth past Year 1 = ((Dividends 1 to 4) - (Dividends 5 to
> 8))/(Dividends 5 to 8)
> Dividend growth past Year 2 = ((Dividends 5 to 8) - (Dividends 9 to
> 12))/(Dividends 9 to 12)
> Dividend growth past Year 3 = ((Dividends 9 to 12) - (Dividends 13 to
> 16))/(Dividends 13 to 16)
> Dividend growth past Year 4 = ((Dividends 13 to 16) - (Dividends 17 to
> 20))/(Dividends 17 to 20)
> Dividend growth past Year 5 = ((Dividends 17 to 20) - (Dividends 21 to
> 24))/(Dividends 21 to 24)
>

Sun Apr 19, 2015 9:08 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

Randy, thank you very much for your help. For GuruFocus, do I need a premium membership?

Regards,
Jose L. Jacob

--------------------------------------------
On Sun, 4/19/15, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Morning star dividend history
To: smf_addin@yahoogroups.com
Received: Sunday, April 19, 2015, 7:48 PM


 









Not easily. You'd
have to set up some type of cascading extraction.

Yahoo dividends would be
easier to get, using the RCHGetYahooHistory() function.

Or, how about
GuruFocus:

=RCHGetHTMLTable("http://www.gurufocus.com/dividend/XOM",">Record
Date",-1,"",1)


On Sun,
Apr 19, 2015 at 3:14 PM, Jose Jacob pepecan47... wrote:
Hi Randy - is there a
way to extract the latest 24 dividends from this page:



http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=XOM



What I want is to have the dividend growth for the previous
1,2,3,4,5 years



Dividend growth past Year 1 = ((Dividends 1 to 4) -
(Dividends 5 to 8))/(Dividends 5 to 8)

Dividend growth past Year 2 = ((Dividends 5 to 8) -
(Dividends 9 to 12))/(Dividends 9 to 12)

Dividend growth past Year 3 = ((Dividends 9 to 12) -
(Dividends 13 to 16))/(Dividends 13 to 16)

Dividend growth past Year 4 = ((Dividends 13 to 16) -
(Dividends 17 to 20))/(Dividends 17 to 20)

Dividend growth past Year 5 = ((Dividends 17 to 20) -
(Dividends 21 to 24))/(Dividends 21 to 24)












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

#yiv4017921967 #yiv4017921967ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv4017921967 #yiv4017921967ygrp-mkp #yiv4017921967hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv4017921967 #yiv4017921967ygrp-mkp #yiv4017921967ads {
margin-bottom:10px;}

#yiv4017921967 #yiv4017921967ygrp-mkp .yiv4017921967ad {
padding:0 0;}

#yiv4017921967 #yiv4017921967ygrp-mkp .yiv4017921967ad p {
margin:0;}

#yiv4017921967 #yiv4017921967ygrp-mkp .yiv4017921967ad a {
color:#0000ff;text-decoration:none;}
#yiv4017921967 #yiv4017921967ygrp-sponsor
#yiv4017921967ygrp-lc {
font-family:Arial;}

#yiv4017921967 #yiv4017921967ygrp-sponsor
#yiv4017921967ygrp-lc #yiv4017921967hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv4017921967 #yiv4017921967ygrp-sponsor
#yiv4017921967ygrp-lc .yiv4017921967ad {
margin-bottom:10px;padding:0 0;}

#yiv4017921967 #yiv4017921967actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv4017921967 #yiv4017921967activity span {
font-weight:700;}

#yiv4017921967 #yiv4017921967activity span:first-child {
text-transform:uppercase;}

#yiv4017921967 #yiv4017921967activity span a {
color:#5085b6;text-decoration:none;}

#yiv4017921967 #yiv4017921967activity span span {
color:#ff7900;}

#yiv4017921967 #yiv4017921967activity span
.yiv4017921967underline {
text-decoration:underline;}

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

#yiv4017921967 .yiv4017921967attach div a {
text-decoration:none;}

#yiv4017921967 .yiv4017921967attach img {
border:none;padding-right:5px;}

#yiv4017921967 .yiv4017921967attach label {
display:block;margin-bottom:5px;}

#yiv4017921967 .yiv4017921967attach label a {
text-decoration:none;}

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

#yiv4017921967 .yiv4017921967bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv4017921967 .yiv4017921967bold a {
text-decoration:none;}

#yiv4017921967 dd.yiv4017921967last p a {
font-family:Verdana;font-weight:700;}

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

#yiv4017921967 dd.yiv4017921967last p
span.yiv4017921967yshortcuts {
margin-right:0;}

#yiv4017921967 div.yiv4017921967attach-table div div a {
text-decoration:none;}

#yiv4017921967 div.yiv4017921967attach-table {
width:400px;}

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

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

#yiv4017921967 div#yiv4017921967ygrp-mlmsg
#yiv4017921967ygrp-msg p a span.yiv4017921967yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv4017921967 .yiv4017921967green {
color:#628c2a;}

#yiv4017921967 .yiv4017921967MsoNormal {
margin:0 0 0 0;}

#yiv4017921967 o {
font-size:0;}

#yiv4017921967 #yiv4017921967photos div {
float:left;width:72px;}

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

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

#yiv4017921967 #yiv4017921967reco-category {
font-size:77%;}

#yiv4017921967 #yiv4017921967reco-desc {
font-size:77%;}

#yiv4017921967 .yiv4017921967replbq {
margin:4px;}

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

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

#yiv4017921967 #yiv4017921967ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv4017921967 #yiv4017921967ygrp-mlmsg pre, #yiv4017921967
code {
font:115% monospace;}

#yiv4017921967 #yiv4017921967ygrp-mlmsg * {
line-height:1.22em;}

#yiv4017921967 #yiv4017921967ygrp-mlmsg #yiv4017921967logo {
padding-bottom:10px;}


#yiv4017921967 #yiv4017921967ygrp-msg p a {
font-family:Verdana;}

#yiv4017921967 #yiv4017921967ygrp-msg
p#yiv4017921967attach-count span {
color:#1E66AE;font-weight:700;}

#yiv4017921967 #yiv4017921967ygrp-reco
#yiv4017921967reco-head {
color:#ff7900;font-weight:700;}

#yiv4017921967 #yiv4017921967ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv4017921967 #yiv4017921967ygrp-sponsor #yiv4017921967ov
li a {
font-size:130%;text-decoration:none;}

#yiv4017921967 #yiv4017921967ygrp-sponsor #yiv4017921967ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv4017921967 #yiv4017921967ygrp-sponsor #yiv4017921967ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv4017921967 #yiv4017921967ygrp-text {
font-family:Georgia;}

#yiv4017921967 #yiv4017921967ygrp-text p {
margin:0 0 1em 0;}

#yiv4017921967 #yiv4017921967ygrp-text tt {
font-size:120%;}

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


Sun Apr 19, 2015 9:40 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try it and see. I'm not sure if that dividend history is part of the
premium membership or not..

On Sun, Apr 19, 2015 at 9:08 PM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Randy, thank you very much for your help. For GuruFocus, do I need a
> premium membership?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.37

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)