9 Messages
Digest #3424
Messages
Thu Jun 4, 2015 5:03 am (PDT) . Posted by:
bushpilote
Hi Randy, As of yesterday, the following formula (0+smfGetTagContent("http://www.bloomberg.com/quote/"&A1,"span",1,">"&A1 ) for extracting last price from Bloomberg stopped working.
I tried the smfConvertData formulas on ticker: BCOM:IND without any luck.
Am I doing something wrong or have they changed their layout again?
I'm looking for last price and price change.
Thanks and Regards.
I tried the smfConvertData formulas on ticker: BCOM:IND without any luck.
Am I doing something wrong or have they changed their layout again?
I'm looking for last price and price change.
Thanks and Regards.
Thu Jun 4, 2015 6:37 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
They've got everything in DIV HTML tags now. Try:
=smfConvertData(smfGetTagContent("http://www.bloomberg.com/quote/
"&A1,"div",-1,"class=""price"""))
=smfConvertData(smfGetTagContent("http://www.bloomberg.com/quote/
"&A1,"div",1,"class=""change-container"""))
=smfConvertData(smfGetTagContent("http://www.bloomberg.com/quote/
"&A1,"div",2,"class=""change-container"""))
=smfConvertData(smfGetTagContent("http://www.bloomberg.com/quote/
"&A1,"div",-1,"class=""price-datetime"""))
=smfGetTagContent("http://www.bloomberg.com/quote/
"&A1,"div",-1,"class=""currency""")
On Thu, Jun 4, 2015 at 5:03 AM, bushpilote@... wrote:
>
> As of yesterday, the following formula (0+smfGetTagContent("
> http://www.bloomberg.com/quote/"&A1,"span",1,">"&A1 ) for extracting last
> price from Bloomberg stopped working.
>
> I tried the smfConvertData formulas on ticker: BCOM:IND without any luck.
>
> Am I doing something wrong or have they changed their layout again?
>
> I'm looking for last price and price change.
>
>
=smfConvertData(smfGetTagContent("http://www.bloomberg.com/quote/
"&A1,"div",-1,"class=""price"""))
=smfConvertData(smfGetTagContent("http://www.bloomberg.com/quote/
"&A1,"div",1,"class=""change-container"""))
=smfConvertData(smfGetTagContent("http://www.bloomberg.com/quote/
"&A1,"div",2,"class=""change-container"""))
=smfConvertData(smfGetTagContent("http://www.bloomberg.com/quote/
"&A1,"div",-1,"class=""price-datetime"""))
=smfGetTagContent("http://www.bloomberg.com/quote/
"&A1,"div",-1,"class=""currency""")
On Thu, Jun 4, 2015 at 5:03 AM, bushpilote@... wrote:
>
> As of yesterday, the following formula (0+smfGetTagContent("
> http://www.bloomberg.com/quote/"&A1,"
> price from Bloomberg stopped working.
>
> I tried the smfConvertData formulas on ticker: BCOM:IND without any luck.
>
> Am I doing something wrong or have they changed their layout again?
>
> I'm looking for last price and price change.
>
>
Thu Jun 4, 2015 7:31 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Maybe I'm missing something but to me it is just a calculation.
For example, let's say you want to calculate the percentage change for WIN.
Just import the table from one of the websites using SMF-ADDIN table download function.
This is the formula I use in the 2 column array in column A & B
=RCHGetHTMLTable("http://www.dividendinformation.com/search_ticker/?identifier="&$C$5,"Amount Per Share",-1,"",1)
I made my array with more rows than I ever except for dividend payouts. You will need to determine the max number of rows you want to retrieve.
Depending on the site you are using. https://www.dividata.com/stock/IBM/dividend this one returns 211 entries.
While this site http://www.dividendinformation.com/search_ticker/?identifier=ibm returns only 76 entries.
And this one https://www.dividendchannel.com/history/?symbol=ibm returns 79 entries. Cannot use SMF Addin on this site.
You should also be aware the payouts do not always agree. For example, IBM 8/8/1995
Then place the below formula into the first "C" cell below the Percent Change heading and copy it to all "C" cells below
You made need to modify it based on the column and row of your table.
=(B3-B4)/B4
Symbol
WIN
EX-Dividend Dates
Payout Amount
Percent change
3/27/2015
0.25
0%
12/29/2014
0.25
0%
9/26/2014
0.25
0%
6/26/2014
0.25
0%
3/27/2014
0.25
0%
12/27/2013
0.25
0%
9/26/2013
0.25
0%
6/26/2013
0.25
0%
3/26/2013
0.25
0%
12/27/2012
0.25
0%
9/26/2012
0.25
0%
6/27/2012
0.25
0%
3/28/2012
0.25
0%
12/28/2011
0.25
0%
9/28/2011
0.25
0%
6/28/2011
0.25
0%
3/29/2011
0.25
0%
12/29/2010
0.25
0%
9/28/2010
0.25
0%
7/15/2010
0.25
0%
6/28/2010
0.25
0%
3/29/2010
0.25
0%
12/29/2009
0.25
0%
10/15/2009
0.25
0%
9/28/2009
0.25
0%
6/26/2009
0.25
0%
3/27/2009
0.25
0%
12/29/2008
0.25
0%
9/26/2008
0.25
0%
7/15/2008
0.25
0%
6/26/2008
0.25
0%
3/27/2008
0.25
0%
12/26/2007
0.25
0%
9/26/2007
0.25
0%
6/27/2007
0.25
0%
3/28/2007
0.25
0%
12/27/2006
0.25
25%
9/27/2006
0.2
186%
7/12/2006
0.07
-81%
6/28/2006
0.36
0%
3/29/2006
0.36
0%
12/28/2005
0.36
0%
9/28/2005
0.36
0%
6/28/2005
0.36
100%
3/29/2005
0.18
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, June 03, 2015 3:33 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] TTM dividend using RCHGetYahooHistory (last increase)
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' <mailto:kermitp@tampabay.rr.com> kermitp@tampabay.rr.com [smf_addin] < <mailto:smf_addin@yahoogroups.com> smf_addin@yahoogroups.com> wrote:
Subject: RE: [smf_addin] TTM dividend using RCHGetYahooHistory (last increase)
To: <mailto:smf_addin@yahoogroups.com> 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/> 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> https://dividata.com/stock/LPHI/dividend
This is a free site. <https://www.dividendchannel.com/history/?symbol=lphi> https://www.dividendchannel.com/history/?symbol=lphi
this site also gives you the information but you can't access it with the SMFADDIN. From: <mailto:smf_addin@yahoogroups.com> smf_addin@yahoogroups.com [ <mailto:smf_addin@yahoogroups.com> mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, June 02, 2015 11:54 AM
To: <mailto:smf_addin@yahoogroups.com> 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 <mailto:pepecan47@yahoo.ca> pepecan47@yahoo.ca
[smf_addin] < <mailto:smf_addin@yahoogroups.com> 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
------------------------------------
Posted by: Jose Jacob < <mailto:pepecan47@yahoo.ca> pepecan47@yahoo.ca>
------------------------------------
For the Add-in, Documentation, Templates, Tips and FAQs, visit <http://ogres-crypt.com/SMF> http://ogres-crypt.com/SMF
------------------------------------
Yahoo Groups Links
For example, let's say you want to calculate the percentage change for WIN.
Just import the table from one of the websites using SMF-ADDIN table download function.
This is the formula I use in the 2 column array in column A & B
=RCHGetHTMLTable("http://www.dividendinformation.com/search_ticker/?identifier="&$C$5,"Amount Per Share",-1,"",1)
I made my array with more rows than I ever except for dividend payouts. You will need to determine the max number of rows you want to retrieve.
Depending on the site you are using. https://www.dividata.com/stock/IBM/dividend this one returns 211 entries.
While this site http://www.dividendinformation.com/search_ticker/?identifier=ibm returns only 76 entries.
And this one https://www.dividendchannel.com/history/?symbol=ibm returns 79 entries. Cannot use SMF Addin on this site.
You should also be aware the payouts do not always agree. For example, IBM 8/8/1995
Then place the below formula into the first "C" cell below the Percent Change heading and copy it to all "C" cells below
You made need to modify it based on the column and row of your table.
=(B3-B4)/B4
Symbol
WIN
EX-Dividend Dates
Payout Amount
Percent change
3/27/2015
0.25
0%
12/29/2014
0.25
0%
9/26/2014
0.25
0%
6/26/2014
0.25
0%
3/27/2014
0.25
0%
12/27/2013
0.25
0%
9/26/2013
0.25
0%
6/26/2013
0.25
0%
3/26/2013
0.25
0%
12/27/2012
0.25
0%
9/26/2012
0.25
0%
6/27/2012
0.25
0%
3/28/2012
0.25
0%
12/28/2011
0.25
0%
9/28/2011
0.25
0%
6/28/2011
0.25
0%
3/29/2011
0.25
0%
12/29/2010
0.25
0%
9/28/2010
0.25
0%
7/15/2010
0.25
0%
6/28/2010
0.25
0%
3/29/2010
0.25
0%
12/29/2009
0.25
0%
10/15/2009
0.25
0%
9/28/2009
0.25
0%
6/26/2009
0.25
0%
3/27/2009
0.25
0%
12/29/2008
0.25
0%
9/26/2008
0.25
0%
7/15/2008
0.25
0%
6/26/2008
0.25
0%
3/27/2008
0.25
0%
12/26/2007
0.25
0%
9/26/2007
0.25
0%
6/27/2007
0.25
0%
3/28/2007
0.25
0%
12/27/2006
0.25
25%
9/27/2006
0.2
186%
7/12/2006
0.07
-81%
6/28/2006
0.36
0%
3/29/2006
0.36
0%
12/28/2005
0.36
0%
9/28/2005
0.36
0%
6/28/2005
0.36
100%
3/29/2005
0.18
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, June 03, 2015 3:33 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] TTM dividend using RCHGetYahooHistory (last increase)
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' <mailto:kermitp@tampabay.rr.com> kermitp@tampabay.rr.com [smf_addin] < <mailto:smf_addin@yahoogroups.com> smf_addin@yahoogroups.com> wrote:
Subject: RE: [smf_addin] TTM dividend using RCHGetYahooHistory (last increase)
To: <mailto:smf_addin@yahoogroups.com> 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/> 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> https://dividata.com/stock/LPHI/dividend
This is a free site. <https://www.dividendchannel.com/history/?symbol=lphi> https://www.dividendchannel.com/history/?symbol=lphi
this site also gives you the information but you can't access it with the SMFADDIN. From: <mailto:smf_addin@yahoogroups.com> smf_addin@yahoogroups.com [ <mailto:smf_addin@yahoogroups.com> mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, June 02, 2015 11:54 AM
To: <mailto:smf_addin@yahoogroups.com> 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 <mailto:pepecan47@yahoo.ca> pepecan47@yahoo.ca
[smf_addin] < <mailto:smf_addin@yahoogroups.com> 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
------------------------------------
Posted by: Jose Jacob < <mailto:pepecan47@yahoo.ca> pepecan47@yahoo.ca>
------------------------------------
For the Add-in, Documentation, Templates, Tips and FAQs, visit <http://ogres-crypt.com/SMF> http://ogres-crypt.com/SMF
------------
Yahoo Groups Links
Thu Jun 4, 2015 10:58 am (PDT) . Posted by:
"Jose Jacob" pepecan47
Hi Kermit - first of all I really appreciate the time and effort you put into your reply.
Maybe I have to further clarify what I am asking.
I have a spreadsheet that uses the RCHGetYahooHistory function to get the dividend history for a particular stock, I enter MCD and have the history of MCD, I enter JNJ, and get for JNJ. In this spread sheet I do some calculations and, among other things, I get the latest % increase of the dividend.
But for that I need to define and array, get the dividend history, and work with the data.
I want to build another spreadsheet where I follow several companies (about 40), and one of the things I want is the latest %increase of the dividend. In order to avoid coding a macro, or a function, I was asking Randy if there is a way to get what I want with a simpler formula.
Normally I like to get data from Morningstar (I have a subscription), and if not possible from Yahoo, and the main reason is because I follow Canadian stocks.
Hopefully this clarify my question.
Regards,
Jose L. Jacob
--------------------------------------------
On Thu, 6/4/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: Thursday, June 4, 2015, 10:31 AM
Maybe I'm missing
something but to me it is just a calculation. For example, let's say
you want to calculate the percentage change for WIN.Just import the table from
one of the websites using SMF-ADDIN table download
function.This is
the formula I use in the 2 column array in column A &
B =RCHGetHTMLTable("http://www.dividendinformation.com/search_ticker/?identifier="&$C$5,"Amount
Per Share",-1,"",1) I made my array with more
rows than I ever except for dividend payouts. You will need
to determine the max number of rows you want to retrieve.
Depending on the
site you are using. https://www.dividata.com/stock/IBM/dividend
this one returns 211 entries. While this site http://www.dividendinformation.com/search_ticker/?identifier=ibm
returns only 76 entries. And this one https://www.dividendchannel.com/history/?symbol=ibm
returns 79 entries. Cannot use SMF Addin on this
site. You should also be aware the
payouts do not always agree. For example, IBM
8/8/1995
Then place
the below formula into the first "C" cell below the
Percent Change
heading and copy it to all "C" cells belowYou made need to modify it
based on the column and row of your table.
=(B3-B4)/B4
SymbolWINEX-Dividend
DatesPayout
AmountPercent
change3/27/20150.250%12/29/20140.250%9/26/20140.250%6/26/20140.250%3/27/20140.250%12/27/20130.250%9/26/20130.250%6/26/20130.250%3/26/20130.250%12/27/20120.250%9/26/20120.250%6/27/20120.250%3/28/20120.250%12/28/20110.250%9/28/20110.250%6/28/20110.250%3/29/20110.250%12/29/20100.250%9/28/20100.250%7/15/20100.250%6/28/20100.250%3/29/20100.250%12/29/20090.250%10/15/20090.250%9/28/20090.250%6/26/20090.250%3/27/20090.250%12/29/20080.250%9/26/20080.250%7/15/20080.250%6/26/20080.250%3/27/20080.250%12/26/20070.250%9/26/20070.250%6/27/20070.250%3/28/20070.250%12/27/20060.2525%9/27/20060.2186%7/12/20060.07-81%6/28/20060.360%3/29/20060.360%12/28/20050.360%9/28/20050.360%6/28/20050.36100%3/29/20050.18 -----Original
Message-----
From: smf_addin@yahoogroups.com
[mailto:smf_addin@yahoogroups.com]
Sent:
Wednesday, June 03, 2015 3:33 PM
To:
smf_addin@yahoogroups.com
Subject: RE:
[smf_addin] TTM dividend using RCHGetYahooHistory (last
increase) 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
------------------------------------Posted by: Jose Jacob
<pepecan47@yahoo.ca>------------------------------------ For the Add-in,
settings via email: smf_addin-digest@yahoogroups.com
#yiv0919799065 #yiv0919799065 --
#yiv0919799065ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}
#yiv0919799065 #yiv0919799065ygrp-mkp hr {
border:1px solid #d8d8d8;}
#yiv0919799065 #yiv0919799065ygrp-mkp #yiv0919799065hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}
#yiv0919799065 #yiv0919799065ygrp-mkp #yiv0919799065ads {
margin-bottom:10px;}
#yiv0919799065 #yiv0919799065ygrp-mkp .yiv0919799065ad {
padding:0 0;}
#yiv0919799065 #yiv0919799065ygrp-mkp .yiv0919799065ad p {
margin:0;}
#yiv0919799065 #yiv0919799065ygrp-mkp .yiv0919799065ad a {
color:#0000ff;text-decoration:none;}
#yiv0919799065 #yiv0919799065ygrp-sponsor
#yiv0919799065ygrp-lc {
font-family:Arial;}
#yiv0919799065 #yiv0919799065ygrp-sponsor
#yiv0919799065ygrp-lc #yiv0919799065hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}
#yiv0919799065 #yiv0919799065ygrp-sponsor
#yiv0919799065ygrp-lc .yiv0919799065ad {
margin-bottom:10px;padding:0 0;}
#yiv0919799065 #yiv0919799065actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#yiv0919799065 #yiv0919799065activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#yiv0919799065 #yiv0919799065activity span {
font-weight:700;}
#yiv0919799065 #yiv0919799065activity span:first-child {
text-transform:uppercase;}
#yiv0919799065 #yiv0919799065activity span a {
color:#5085b6;text-decoration:none;}
#yiv0919799065 #yiv0919799065activity span span {
color:#ff7900;}
#yiv0919799065 #yiv0919799065activity span
.yiv0919799065underline {
text-decoration:underline;}
#yiv0919799065 .yiv0919799065attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}
#yiv0919799065 .yiv0919799065attach div a {
text-decoration:none;}
#yiv0919799065 .yiv0919799065attach img {
border:none;padding-right:5px;}
#yiv0919799065 .yiv0919799065attach label {
display:block;margin-bottom:5px;}
#yiv0919799065 .yiv0919799065attach label a {
text-decoration:none;}
#yiv0919799065 blockquote {
margin:0 0 0 4px;}
#yiv0919799065 .yiv0919799065bold {
font-family:Arial;font-size:13px;font-weight:700;}
#yiv0919799065 .yiv0919799065bold a {
text-decoration:none;}
#yiv0919799065 dd.yiv0919799065last p a {
font-family:Verdana;font-weight:700;}
#yiv0919799065 dd.yiv0919799065last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#yiv0919799065 dd.yiv0919799065last p
span.yiv0919799065yshortcuts {
margin-right:0;}
#yiv0919799065 div.yiv0919799065attach-table div div a {
text-decoration:none;}
#yiv0919799065 div.yiv0919799065attach-table {
width:400px;}
#yiv0919799065 div.yiv0919799065file-title a, #yiv0919799065
div.yiv0919799065file-title a:active, #yiv0919799065
div.yiv0919799065file-title a:hover, #yiv0919799065
div.yiv0919799065file-title a:visited {
text-decoration:none;}
#yiv0919799065 div.yiv0919799065photo-title a,
#yiv0919799065 div.yiv0919799065photo-title a:active,
#yiv0919799065 div.yiv0919799065photo-title a:hover,
#yiv0919799065 div.yiv0919799065photo-title a:visited {
text-decoration:none;}
#yiv0919799065 div#yiv0919799065ygrp-mlmsg
#yiv0919799065ygrp-msg p a span.yiv0919799065yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#yiv0919799065 .yiv0919799065green {
color:#628c2a;}
#yiv0919799065 .yiv0919799065MsoNormal {
margin:0 0 0 0;}
#yiv0919799065 o {
font-size:0;}
#yiv0919799065 #yiv0919799065photos div {
float:left;width:72px;}
#yiv0919799065 #yiv0919799065photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}
#yiv0919799065 #yiv0919799065photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#yiv0919799065 #yiv0919799065reco-category {
font-size:77%;}
#yiv0919799065 #yiv0919799065reco-desc {
font-size:77%;}
#yiv0919799065 .yiv0919799065replbq {
margin:4px;}
#yiv0919799065 #yiv0919799065ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#yiv0919799065 #yiv0919799065ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}
#yiv0919799065 #yiv0919799065ygrp-mlmsg table {
font-size:inherit;font:100%;}
#yiv0919799065 #yiv0919799065ygrp-mlmsg select,
#yiv0919799065 input, #yiv0919799065 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv0919799065 #yiv0919799065ygrp-mlmsg pre, #yiv0919799065
code {
font:115% monospace;}
#yiv0919799065 #yiv0919799065ygrp-mlmsg * {
line-height:1.22em;}
#yiv0919799065 #yiv0919799065ygrp-mlmsg #yiv0919799065logo {
padding-bottom:10px;}
#yiv0919799065 #yiv0919799065ygrp-msg p a {
font-family:Verdana;}
#yiv0919799065 #yiv0919799065ygrp-msg
p#yiv0919799065attach-count span {
color:#1E66AE;font-weight:700;}
#yiv0919799065 #yiv0919799065ygrp-reco
#yiv0919799065reco-head {
color:#ff7900;font-weight:700;}
#yiv0919799065 #yiv0919799065ygrp-reco {
margin-bottom:20px;padding:0px;}
#yiv0919799065 #yiv0919799065ygrp-sponsor #yiv0919799065ov
li a {
font-size:130%;text-decoration:none;}
#yiv0919799065 #yiv0919799065ygrp-sponsor #yiv0919799065ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}
#yiv0919799065 #yiv0919799065ygrp-sponsor #yiv0919799065ov
ul {
margin:0;padding:0 0 0 8px;}
#yiv0919799065 #yiv0919799065ygrp-text {
font-family:Georgia;}
#yiv0919799065 #yiv0919799065ygrp-text p {
margin:0 0 1em 0;}
#yiv0919799065 #yiv0919799065ygrp-text tt {
font-size:120%;}
#yiv0919799065 #yiv0919799065ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv0919799065
Maybe I have to further clarify what I am asking.
I have a spreadsheet that uses the RCHGetYahooHistory function to get the dividend history for a particular stock, I enter MCD and have the history of MCD, I enter JNJ, and get for JNJ. In this spread sheet I do some calculations and, among other things, I get the latest % increase of the dividend.
But for that I need to define and array, get the dividend history, and work with the data.
I want to build another spreadsheet where I follow several companies (about 40), and one of the things I want is the latest %increase of the dividend. In order to avoid coding a macro, or a function, I was asking Randy if there is a way to get what I want with a simpler formula.
Normally I like to get data from Morningstar (I have a subscription), and if not possible from Yahoo, and the main reason is because I follow Canadian stocks.
Hopefully this clarify my question.
Regards,
Jose L. Jacob
--------------------------------------------
On Thu, 6/4/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: Thursday, June 4, 2015, 10:31 AM
Maybe I'm missing
something but to me it is just a calculation. For example, let's say
you want to calculate the percentage change for WIN.Just import the table from
one of the websites using SMF-ADDIN table download
function.This is
the formula I use in the 2 column array in column A &
B =RCHGetHTMLTable("http://www.dividendinformation.com/search_ticker/?identifier="&$C$5,"Amount
Per Share",-1,"",1) I made my array with more
rows than I ever except for dividend payouts. You will need
to determine the max number of rows you want to retrieve.
Depending on the
site you are using. https://www.dividata.com/stock/IBM/dividend
this one returns 211 entries. While this site http://www.dividendinformation.com/search_ticker/?identifier=ibm
returns only 76 entries. And this one https://www.dividendchannel.com/history/?symbol=ibm
returns 79 entries. Cannot use SMF Addin on this
site. You should also be aware the
payouts do not always agree. For example, IBM
8/8/1995
Then place
the below formula into the first "C" cell below the
Percent Change
heading and copy it to all "C" cells belowYou made need to modify it
based on the column and row of your table.
=(B3-B4)/B4
SymbolWINEX-Dividend
DatesPayout
AmountPercent
change3/27/20150.250%12/29/20140.250%9/26/20140.250%6/26/20140.250%3/27/20140.250%12/27/20130.250%9/26/20130.250%6/26/20130.250%3/26/20130.250%12/27/20120.250%9/26/20120.250%6/27/20120.250%3/28/20120.250%12/28/20110.250%9/28/20110.250%6/28/20110.250%3/29/20110.250%12/29/20100.250%9/28/20100.250%7/15/20100.250%6/28/20100.250%3/29/20100.250%12/29/20090.250%10/15/20090.250%9/28/20090.250%6/26/20090.250%3/27/20090.250%12/29/20080.250%9/26/20080.250%7/15/20080.250%6/26/20080.250%3/27/20080.250%12/26/20070.250%9/26/20070.250%6/27/20070.250%3/28/20070.250%12/27/20060.2525%9/27/20060.2186%7/12/20060.07-81%6/28/20060.360%3/29/20060.360%12/28/20050.360%9/28/20050.360%6/28/20050.36100%3/29/20050.18 -----Original
Message-----
From: smf_addin@yahoogroups.com
[mailto:smf_addin@yahoogroups.com]
Sent:
Wednesday, June 03, 2015 3:33 PM
To:
smf_addin@yahoogroups.com
Subject: RE:
[smf_addin] TTM dividend using RCHGetYahooHistory (last
increase) 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
------------------------------------Posted by: Jose Jacob
<pepecan47@yahoo.ca>------------------------------------ For the Add-in,
settings via email: smf_addin-digest@yahoogroups.com
#yiv0919799065 #yiv0919799065 --
#yiv0919799065ygrp-
border:1px solid #d8d8d8;font-
0;padding:0 10px;}
#yiv0919799065 #yiv0919799065ygrp-
border:1px solid #d8d8d8;}
#yiv0919799065 #yiv0919799065ygrp-
color:#628c2a;
0;}
#yiv0919799065 #yiv0919799065ygrp-
margin-bottom:
#yiv0919799065 #yiv0919799065ygrp-
padding:0 0;}
#yiv0919799065 #yiv0919799065ygrp-
margin:0;}
#yiv0919799065 #yiv0919799065ygrp-
color:#0000ff;
#yiv0919799065 #yiv0919799065ygrp-
#yiv0919799065ygrp-
font-family:
#yiv0919799065 #yiv0919799065ygrp-
#yiv0919799065ygrp-
margin:10px
0px;font-weight:
#yiv0919799065 #yiv0919799065ygrp-
#yiv0919799065ygrp-
margin-bottom:
#yiv0919799065 #yiv0919799065actio
font-family:
#yiv0919799065 #yiv0919799065activ
background-color:
#yiv0919799065 #yiv0919799065activ
font-weight:
#yiv0919799065 #yiv0919799065activ
text-transform:
#yiv0919799065 #yiv0919799065activ
color:#5085b6;
#yiv0919799065 #yiv0919799065activ
color:#ff7900;
#yiv0919799065 #yiv0919799065activ
.yiv0919799065under
text-decoration:
#yiv0919799065 .yiv0919799065attac
clear:both;display:
0;width:400px;
#yiv0919799065 .yiv0919799065attac
text-decoration:
#yiv0919799065 .yiv0919799065attac
border:none;
#yiv0919799065 .yiv0919799065attac
display:block;
#yiv0919799065 .yiv0919799065attac
text-decoration:
#yiv0919799065 blockquote {
margin:0 0 0 4px;}
#yiv0919799065 .yiv0919799065bold {
font-family:
#yiv0919799065 .yiv0919799065bold a {
text-decoration:
#yiv0919799065 dd.yiv0919799065las
font-family:
#yiv0919799065 dd.yiv0919799065las
margin-right:
#yiv0919799065 dd.yiv0919799065las
span.yiv0919799065y
margin-right:
#yiv0919799065 div.yiv0919799065at
text-decoration:
#yiv0919799065 div.yiv0919799065at
width:400px;
#yiv0919799065 div.yiv0919799065fi
div.yiv0919799065fi
div.yiv0919799065fi
div.yiv0919799065fi
text-decoration:
#yiv0919799065 div.yiv0919799065ph
#yiv0919799065 div.yiv0919799065ph
#yiv0919799065 div.yiv0919799065ph
#yiv0919799065 div.yiv0919799065ph
text-decoration:
#yiv0919799065 div#yiv0919799065yg
#yiv0919799065ygrp-
font-family:
#yiv0919799065 .yiv0919799065green {
color:#628c2a;
#yiv0919799065 .yiv0919799065MsoNo
margin:0 0 0 0;}
#yiv0919799065 o {
font-size:0;
#yiv0919799065 #yiv0919799065photo
float:left;width:
#yiv0919799065 #yiv0919799065photo
border:1px solid
#666666;height:
#yiv0919799065 #yiv0919799065photo
color:#666666;
#yiv0919799065 #yiv0919799065reco-
font-size:77%
#yiv0919799065 #yiv0919799065reco-
font-size:77%
#yiv0919799065 .yiv0919799065replb
margin:4px;}
#yiv0919799065 #yiv0919799065ygrp-
margin-right:
#yiv0919799065 #yiv0919799065ygrp-
font-size:13px;
sans-serif;}
#yiv0919799065 #yiv0919799065ygrp-
font-size:inherit;
#yiv0919799065 #yiv0919799065ygrp-
#yiv0919799065 input, #yiv0919799065 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv0919799065 #yiv0919799065ygrp-
code {
font:115% monospace;}
#yiv0919799065 #yiv0919799065ygrp-
line-height:
#yiv0919799065 #yiv0919799065ygrp-
padding-bottom:
#yiv0919799065 #yiv0919799065ygrp-
font-family:
#yiv0919799065 #yiv0919799065ygrp-
p#yiv0919799065atta
color:#1E66AE;
#yiv0919799065 #yiv0919799065ygrp-
#yiv0919799065reco-
color:#ff7900;
#yiv0919799065 #yiv0919799065ygrp-
margin-bottom:
#yiv0919799065 #yiv0919799065ygrp-
li a {
font-size:130%
#yiv0919799065 #yiv0919799065ygrp-
li {
font-size:77%
#yiv0919799065 #yiv0919799065ygrp-
ul {
margin:0;padding:
#yiv0919799065 #yiv0919799065ygrp-
font-family:
#yiv0919799065 #yiv0919799065ygrp-
margin:0 0 1em 0;}
#yiv0919799065 #yiv0919799065ygrp-
font-size:120%
#yiv0919799065 #yiv0919799065ygrp-
border-right:
}
#yiv0919799065
Thu Jun 4, 2015 10:47 am (PDT) . Posted by:
mtgreeley
Hi Randy,
I created a spreadsheet based off of some of the criteria that Warren Buffett looks for. I have about 20,000 RCHgetelementnumber in the spreadsheet and it works for only about 1/3 of them that are in the middle of the sheet. As a test, I have then created a simple sheet to punch in the stock tickers that are pulling up all error's and the new sheet will pull the data properly.
Is their a limitation that excel will pull that your aware of?
I'm using a computer with 8gb of ram and an A10 quad core processor with Micorsoft Office 2010.
Thanks,
Matt
I created a spreadsheet based off of some of the criteria that Warren Buffett looks for. I have about 20,000 RCHgetelementnumber in the spreadsheet and it works for only about 1/3 of them that are in the middle of the sheet. As a test, I have then created a simple sheet to punch in the stock tickers that are pulling up all error's and the new sheet will pull the data properly.
Is their a limitation that excel will pull that your aware of?
I'm using a computer with 8gb of ram and an A10 quad core processor with Micorsoft Office 2010.
Thanks,
Matt
Thu Jun 4, 2015 10:53 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The add-in is designed for ad hoc data retrieval, not for building of
databases. As such, it errors out after 1000 web pages have been retrieved.
That's because it retrieves the web page and saves it into an array, then
does all the data extractions from that saved copy of the web page. It's
done that way so that the web page only needs to be retrieved once, even if
hundreds of data items are extracted from that web page.
I'm also afraid that if enough people were to use something like the add-in
to build databases and update them regularly, the free web sites would
either start charging for access or change the web pages so that something
like the add-in couldn't access their data.
Have you looked into Porftfolio123.com? It allows advanced fundamentals in
screening and [point-in-time] backtesting.
On Thu, Jun 4, 2015 at 9:52 AM, mtgreeley@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I created a spreadsheet based off of some of the criteria that Warren
> Buffett looks for. I have about 20,000 RCHgetelementnumber in the
> spreadsheet and it works for only about 1/3 of them that are in the middle
> of the sheet. As a test, I have then created a simple sheet to punch in
> the stock tickers that are pulling up all error's and the new sheet will
> pull the data properly.
> Is their a limitation that excel will pull that your aware of?
> I'm using a computer with 8gb of ram and an A10 quad core processor with
> Micorsoft Office 2010.
>
databases. As such, it errors out after 1000 web pages have been retrieved.
That's because it retrieves the web page and saves it into an array, then
does all the data extractions from that saved copy of the web page. It's
done that way so that the web page only needs to be retrieved once, even if
hundreds of data items are extracted from that web page.
I'm also afraid that if enough people were to use something like the add-in
to build databases and update them regularly, the free web sites would
either start charging for access or change the web pages so that something
like the add-in couldn't access their data.
Have you looked into Porftfolio123.com? It allows advanced fundamentals in
screening and [point-in-time] backtesting.
On Thu, Jun 4, 2015 at 9:52 AM, mtgreeley@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I created a spreadsheet based off of some of the criteria that Warren
> Buffett looks for. I have about 20,000 RCHgetelementnumber in the
> spreadsheet and it works for only about 1/3 of them that are in the middle
> of the sheet. As a test, I have then created a simple sheet to punch in
> the stock tickers that are pulling up all error's and the new sheet will
> pull the data properly.
> Is their a limitation that excel will pull that your aware of?
> I'm using a computer with 8gb of ram and an A10 quad core processor with
> Micorsoft Office 2010.
>
Thu Jun 4, 2015 11:20 am (PDT) . Posted by:
mtgreeley
Ok, thanks........I created something back in 2012 and had a bunch of parameters. I ran through a list of stocks within a price range (in multiple runs of the spreadsheet) in 2012 and 2013 and gathered the top 10 that fit the parameters the best. 2012's top 10 is 32.94% annualized and 2013 top 10 is 31.32% annualized.........needless to say I was hoping to do it in one run to make it easier and see if these data parameters can hold true to the rate of return that I have seen.
Thanks for all the work you have done with all of this.
Matt
Thanks for all the work you have done with all of this.
Matt
Fri Jun 5, 2015 1:10 am (PDT) . Posted by:
sri.yanto
hello randy,
i want ask something about IE and Ft.com
i'm using Ft.com several days ago to get daily price, then untill i found, my conection to Ft.com doesn't work any longer.
then i check to internet explorer, so i found Ft.com doesn't permit us to enter certain quotes.
i'm ask to you...were..it's happen to you too?
here the link
United Tractors Tbk PT, UNTR:JKT summary - FT.com http://markets.ft.com/research/Markets/Tearsheets/Summary?s=UNTR:JKT
United Tractors Tbk PT, UNTR:JKT summary - FT.com http://markets.ft.com/research/Markets/Tearsheets/Summary?s=UNTR:JKT Latest United Tractors Tbk PT (UNTR:JKT) share price with interactive charts, historical prices, comparative analysis, forecasts, business profile and more.
View on markets.ft.com http://markets.ft.com/research/Markets/Tearsheets/Summary?s=UNTR:JKT
Preview by Yahoo
thanks randy..
i want ask something about IE and Ft.com
i'm using Ft.com several days ago to get daily price, then untill i found, my conection to Ft.com doesn't work any longer.
then i check to internet explorer, so i found Ft.com doesn't permit us to enter certain quotes.
i'm ask to you...were..it's happen to you too?
here the link
United Tractors Tbk PT, UNTR:JKT summary - FT.com http://markets.ft.com/research/Markets/Tearsheets/Summary?s=UNTR:JKT
United Tractors Tbk PT, UNTR:JKT summary - FT.com http://markets.ft.com/research/Markets/Tearsheets/Summary?s=UNTR:JKT Latest United Tractors Tbk PT (UNTR:JKT) share price with interactive charts, historical prices, comparative analysis, forecasts, business profile and more.
View on markets.ft.com http://markets.ft.com/research/Markets/Tearsheets/Summary?s=UNTR:JKT
Preview by Yahoo
thanks randy..
Attachment(s) from
1 of 1 Photo(s)
Fri Jun 5, 2015 2:08 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't know what to tell you. I was able to bring up the web page, both in
IE and FireFox. But I have an older version of IE. It may have been a
temporary issue with one or more, maybe even all, of their servers.
On Fri, Jun 5, 2015 at 1:10 AM, sri.yanto... wrote:
>
> i want ask something about IE and Ft.com
>
> i'm using Ft.com several days ago to get daily price, then untill i found,
> my conection to Ft.com doesn't work any longer.
>
> then i check to internet explorer, so i found Ft.com doesn't permit us to
> enter certain quotes.
>
> i'm ask to you...were..it's happen to you too?
>
> here the link
>
> United Tractors Tbk PT, UNTR:JKT summary - FT.com
> <http://markets.ft.com/research/Markets/Tearsheets/Summary?s=UNTR:JKT>
>
IE and FireFox. But I have an older version of IE. It may have been a
temporary issue with one or more, maybe even all, of their servers.
On Fri, Jun 5, 2015 at 1:10 AM, sri.yanto... wrote:
>
> i want ask something about IE and Ft.com
>
> i'm using Ft.com several days ago to get daily price, then untill i found,
> my conection to Ft.com doesn't work any longer.
>
> then i check to internet explorer, so i found Ft.com doesn't permit us to
> enter certain quotes.
>
> i'm ask to you...were..it's happen to you too?
>
> here the link
>
> United Tractors Tbk PT, UNTR:JKT summary - FT.com
> <http://markets.ft.com/research/Markets/Tearsheets/Summary?s=UNTR:JKT>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar