9 Messages
Digest #4529
Messages
Sat Apr 27, 2019 6:40 am (PDT) . Posted by:
freefaller6
HI Randy, circling back after a while, but still in need of finding a source for 10 yr, annual ROIC data. You suggested the formula: =smfWord(smfStrExtr(RCHGetWebData("http://financials.morningstar.com/ajax/exportKR2CSV.html?t=F http://financials.morningstar.com/ajax/exportKR2CSV.html?t=F","Return on Invested Capital"),"~","Interest"),12,",",1)
In this formula, where is the ticker symbol, or where would you enter it? Using AAPL as an example? When I past this into my sheet verbatim, it returns a blank cell.
Thanks,
Brent
In this formula, where is the ticker symbol, or where would you enter it? Using AAPL as an example? When I past this into my sheet verbatim, it returns a blank cell.
Thanks,
Brent
Sat Apr 27, 2019 8:58 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, the Morningstar CSV files now require credentials, so the
add-in doesn't have access to that data.
For free data, I think your only option would be AdvFN. I would use
GuruFocus, but you need to be a member to get that many years of data. And
ROIC is a rather nebulous data item. The definition changes depending on
the source being used.
On Sat, Apr 27, 2019 at 6:40 AM freefaller6@... wrote:
>
> HI Randy, circling back after a while, but still in need of finding a
> source for 10 yr, annual ROIC data. You suggested the formula:
> =smfWord(smfStrExtr(RCHGetWebData("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t=F","Return on
> Invested Capital"),"~","Interest"),12,",",1)
>
> In this formula, where is the ticker symbol, or where would you enter it?
> Using AAPL as an example? When I past this into my sheet verbatim, it
> returns a blank cell.
>
>
>
add-in doesn't have access to that data.
For free data, I think your only option would be AdvFN. I would use
GuruFocus, but you need to be a member to get that many years of data. And
ROIC is a rather nebulous data item. The definition changes depending on
the source being used.
On Sat, Apr 27, 2019 at 6:40 AM freefaller6@... wrote:
>
> HI Randy, circling back after a while, but still in need of finding a
> source for 10 yr, annual ROIC data. You suggested the formula:
> =smfWord(smfStrExtr(RCHGetWebData("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t=F","
> Invested Capital"
>
> In this formula, where is the ticker symbol, or where would you enter it?
> Using AAPL as an example? When I past this into my sheet verbatim, it
> returns a blank cell.
>
>
>
Sat Apr 27, 2019 3:17 pm (PDT) . Posted by:
turley.muller
The problem with these ratios/metrics most of the time we don't know how it's calculated, and we know there is a lot variation among sources- just as you said they are all different. I prefer pulling in the financial statement items and calculating the ratios myself. That way you can be sure the formula and the inputs are correct, and most importantly you can see what is driving the Y/Y ROIC changes-- ROIC increased because margins improved? or from generating more revenue per dollar of invested capital?
A vast amount of 2018 ratios based on net income are worthless. Due to the cut in the corporate tax rate, many companies recorded a huge tax expense (or none) as one-time adjustment to remeasure tax assets and liabilities to reflect the new tax rate.
For instance, CSCO reported $13B pretax income and recorded a $12.9B tax expense leaving $100M income. Morningstar says its P/E is 130ish and ROIC is 0.13%. And not just that, the 5 year average MS gives is widely skewed just from that one year. FCF/Net Income been less than 1.5 every year for the past 10, except the 117x last year- causing the 5 year average to be over 8x. Worthless.
So this is something you need to keep a look out for. I've seen some companies with 2017's tax rate affected. And even some having both years abnormal. It has given me fits.
A vast amount of 2018 ratios based on net income are worthless. Due to the cut in the corporate tax rate, many companies recorded a huge tax expense (or none) as one-time adjustment to remeasure tax assets and liabilities to reflect the new tax rate.
For instance, CSCO reported $13B pretax income and recorded a $12.9B tax expense leaving $100M income. Morningstar says its P/E is 130ish and ROIC is 0.13%. And not just that, the 5 year average MS gives is widely skewed just from that one year. FCF/Net Income been less than 1.5 every year for the past 10, except the 117x last year- causing the 5 year average to be over 8x. Worthless.
So this is something you need to keep a look out for. I've seen some companies with 2017's tax rate affected. And even some having both years abnormal. It has given me fits.
Sat Apr 27, 2019 9:18 am (PDT) . Posted by:
gtoscano2005
33 Dividends Per Share dividendsPerShare
33 no longer works to pull the dividend per share, did the symbole change.
Sat Apr 27, 2019 9:45 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo is aware of the problem, but claims they can't duplicate it, even
though it's been pointed out numerous times. For example:
https://yahoo.uservoice.com/forums/382977-finance/suggestions/37310773-dividends-share-are-not-showing-in-portfolio#comments
I'd suggest switching to one of the other dividend rate fields (forward or
trailing).
On Sat, Apr 27, 2019 at 9:18 AM gtoscano2005@... wrote:
>
> 33 Dividends Per Share dividendsPerShare
>
> 33 no longer works to pull the dividend per share, did the symbole change.
>
>
though it's been pointed out numerous times. For example:
https://yahoo.uservoice.com/forums/382977-finance/suggestions/37310773-dividends-share-are-not-showing-in-portfolio#comments
I'd suggest switching to one of the other dividend rate fields (forward or
trailing).
On Sat, Apr 27, 2019 at 9:18 AM gtoscano2005@
>
> 33 Dividends Per Share dividendsPerShare
>
> 33 no longer works to pull the dividend per share, did the symbole change.
>
>
Sat Apr 27, 2019 9:48 am (PDT) . Posted by:
"Craig Passow" passow
This was addressed recently. Search the archives over the past week or so.
On 4/27/2019 11:18 AM, gtoscano2005@yahoo.com [smf_addin] wrote:
> ??
>
> 33 Dividends Per Share dividendsPerShare
>
> 33 no longer works to pull the dividend per share, did the symbole
> change.??
>
>
On 4/27/2019 11:18 AM, gtoscano2005@yahoo.com [smf_addin] wrote:
> ??
>
> 33 Dividends Per Share dividendsPerShare
>
> 33 no longer works to pull the dividend per share, did the symbole
> change.??
>
>
Sat Apr 27, 2019 10:02 am (PDT) . Posted by:
"Jose Jacob" pepecan47
To get dividend history from GuruFocus, I use, array entered:
=RCHGetHTMLTable("https://www.gurufocus.com/dividend/"&$A$1,">Ex-Date")
but it just stopped working. I am not a member, but the formula worked for me for about a couple of years.
Regards, Jose L. Jacob
On Saturday, February 17, 2018 4:44 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
That's because the RCHGetHTMLTable() processing for every cell strips out HTML code and attempts to convert the remaining string to numeric. If a numeric conversion fails, it returns the string it tried to convert.
But smfGetTagContent() returns the entire content of the HTML tag as a string value, including any HTML markup there might have been, unless you tell it to do the special processing to strip out the HTML code and attempt the numeric conversion (note the additional parameter):
=smfGetTagContent("https://www.gurufocus.com/dividend/"&$A$1,"td",1,">Ex-Date";,"<tr",,,1)
There are two functions that do that special processing -- smfStripHTML() and smfConvertData().
On Sat, Feb 17, 2018 at 11:13 AM, Jose Jacob pepecan47@... wrote:
To get the Dividend History I am using
=RCHGetHTMLTable("https:// www.gurufocus.com/dividend/"&$ A$1,">Ex-Date")
For example, for MCD, I get The first Dividend Amount "1.01"
But if I use =smfGetTagContent("https:// www.gurufocus.com/dividend/"&$ A$1,"td",1,">Ex-Date";,"<tr")
to get the first Dividend Amount, I get "$1.01"
The web page shows "$1.01"
Why is this different? One case with the $ sign, and the other without?
#yiv2475658088 #yiv2475658088 -- #yiv2475658088ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2475658088 #yiv2475658088ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2475658088 #yiv2475658088ygrp-mkp #yiv2475658088hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2475658088 #yiv2475658088ygrp-mkp #yiv2475658088ads {margin-bottom:10px;}#yiv2475658088 #yiv2475658088ygrp-mkp .yiv2475658088ad {padding:0 0;}#yiv2475658088 #yiv2475658088ygrp-mkp .yiv2475658088ad p {margin:0;}#yiv2475658088 #yiv2475658088ygrp-mkp .yiv2475658088ad a {color:#0000ff;text-decoration:none;}#yiv2475658088 #yiv2475658088ygrp-sponsor #yiv2475658088ygrp-lc {font-family:Arial;}#yiv2475658088 #yiv2475658088ygrp-sponsor #yiv2475658088ygrp-lc #yiv2475658088hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2475658088 #yiv2475658088ygrp-sponsor #yiv2475658088ygrp-lc .yiv2475658088ad {margin-bottom:10px;padding:0 0;}#yiv2475658088 #yiv2475658088actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2475658088 #yiv2475658088activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2475658088 #yiv2475658088activity span {font-weight:700;}#yiv2475658088 #yiv2475658088activity span:first-child {text-transform:uppercase;}#yiv2475658088 #yiv2475658088activity span a {color:#5085b6;text-decoration:none;}#yiv2475658088 #yiv2475658088activity span span {color:#ff7900;}#yiv2475658088 #yiv2475658088activity span .yiv2475658088underline {text-decoration:underline;}#yiv2475658088 .yiv2475658088attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2475658088 .yiv2475658088attach div a {text-decoration:none;}#yiv2475658088 .yiv2475658088attach img {border:none;padding-right:5px;}#yiv2475658088 .yiv2475658088attach label {display:block;margin-bottom:5px;}#yiv2475658088 .yiv2475658088attach label a {text-decoration:none;}#yiv2475658088 blockquote {margin:0 0 0 4px;}#yiv2475658088 .yiv2475658088bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2475658088 .yiv2475658088bold a {text-decoration:none;}#yiv2475658088 dd.yiv2475658088last p a {font-family:Verdana;font-weight:700;}#yiv2475658088 dd.yiv2475658088last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2475658088 dd.yiv2475658088last p span.yiv2475658088yshortcuts {margin-right:0;}#yiv2475658088 div.yiv2475658088attach-table div div a {text-decoration:none;}#yiv2475658088 div.yiv2475658088attach-table {width:400px;}#yiv2475658088 div.yiv2475658088file-title a, #yiv2475658088 div.yiv2475658088file-title a:active, #yiv2475658088 div.yiv2475658088file-title a:hover, #yiv2475658088 div.yiv2475658088file-title a:visited {text-decoration:none;}#yiv2475658088 div.yiv2475658088photo-title a, #yiv2475658088 div.yiv2475658088photo-title a:active, #yiv2475658088 div.yiv2475658088photo-title a:hover, #yiv2475658088 div.yiv2475658088photo-title a:visited {text-decoration:none;}#yiv2475658088 div#yiv2475658088ygrp-mlmsg #yiv2475658088ygrp-msg p a span.yiv2475658088yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2475658088 .yiv2475658088green {color:#628c2a;}#yiv2475658088 .yiv2475658088MsoNormal {margin:0 0 0 0;}#yiv2475658088 o {font-size:0;}#yiv2475658088 #yiv2475658088photos div {float:left;width:72px;}#yiv2475658088 #yiv2475658088photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2475658088 #yiv2475658088photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2475658088 #yiv2475658088reco-category {font-size:77%;}#yiv2475658088 #yiv2475658088reco-desc {font-size:77%;}#yiv2475658088 .yiv2475658088replbq {margin:4px;}#yiv2475658088 #yiv2475658088ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2475658088 #yiv2475658088ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2475658088 #yiv2475658088ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2475658088 #yiv2475658088ygrp-mlmsg select, #yiv2475658088 input, #yiv2475658088 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2475658088 #yiv2475658088ygrp-mlmsg pre, #yiv2475658088 code {font:115% monospace;}#yiv2475658088 #yiv2475658088ygrp-mlmsg * {line-height:1.22em;}#yiv2475658088 #yiv2475658088ygrp-mlmsg #yiv2475658088logo {padding-bottom:10px;}#yiv2475658088 #yiv2475658088ygrp-msg p a {font-family:Verdana;}#yiv2475658088 #yiv2475658088ygrp-msg p#yiv2475658088attach-count span {color:#1E66AE;font-weight:700;}#yiv2475658088 #yiv2475658088ygrp-reco #yiv2475658088reco-head {color:#ff7900;font-weight:700;}#yiv2475658088 #yiv2475658088ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2475658088 #yiv2475658088ygrp-sponsor #yiv2475658088ov li a {font-size:130%;text-decoration:none;}#yiv2475658088 #yiv2475658088ygrp-sponsor #yiv2475658088ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2475658088 #yiv2475658088ygrp-sponsor #yiv2475658088ov ul {margin:0;padding:0 0 0 8px;}#yiv2475658088 #yiv2475658088ygrp-text {font-family:Georgia;}#yiv2475658088 #yiv2475658088ygrp-text p {margin:0 0 1em 0;}#yiv2475658088 #yiv2475658088ygrp-text tt {font-size:120%;}#yiv2475658088 #yiv2475658088ygrp-vital ul li:last-child {border-right:none !important;}#yiv2475658088
=RCHGetHTMLTable("https://www.gurufocus.com/dividend/"&$A$1,">Ex-Date")
but it just stopped working. I am not a member, but the formula worked for me for about a couple of years.
Regards, Jose L. Jacob
On Saturday, February 17, 2018 4:44 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
That's because the RCHGetHTMLTable() processing for every cell strips out HTML code and attempts to convert the remaining string to numeric. If a numeric conversion fails, it returns the string it tried to convert.
But smfGetTagContent() returns the entire content of the HTML tag as a string value, including any HTML markup there might have been, unless you tell it to do the special processing to strip out the HTML code and attempt the numeric conversion (note the additional parameter):
=smfGetTagContent("https://www.gurufocus.com/dividend/"&$A$1,
There are two functions that do that special processing -- smfStripHTML(
On Sat, Feb 17, 2018 at 11:13 AM, Jose Jacob pepecan47@... wrote:
To get the Dividend History I am using
=RCHGetHTMLTable(
For example, for MCD, I get The first Dividend Amount "1.01"
But if I use =smfGetTagContent(
to get the first Dividend Amount, I get "$1.01"
The web page shows "$1.01"
Why is this different? One case with the $ sign, and the other without?
#yiv2475658088 #yiv2475658088 -- #yiv2475658088ygrp-