Jumat, 05 Juni 2015

[smf_addin] Digest Number 3424[1 Attachment]

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.


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

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



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


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


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

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

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











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>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar