EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #3843

Debt and Coverage ratios from Morningstar by "Jose Jacob" pepecan47

Re: Debt and Coverage ratios from Morningstar by "Randy Harmelink" rharmelink

Re: Debt and Coverage ratios from Morningstar by "Jose Jacob" pepecan47

Re: Debt and Coverage ratios from Morningstar by "Craig Passow" passow

Messages

1a

Debt and Coverage ratios from Morningstar

Tue Nov 15, 2016 1:10 pm (PST) . Posted by:

"Jose Jacob" pepecan47

Randy, I would like to get the Debt and Coverage Ratios from
http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol=MCD&Country=USA

specially interested in "Cashflow Ops/Total Debt" 0.26

If possible, could you make these ratios Element #'s?

Regards,
Jose L. Jacob

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1b

Re: Debt and Coverage ratios from Morningstar

Tue Nov 15, 2016 3:24 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Yuck. Awkward extraction. The data you want is actually contained within a
frame on the page, which refers to a different URL that doesn't use the
ticker symbol:

http://bond.morningstar.com/internal/company.aspx?cID=0C000008A4

The extraction would be something like:

=RCHGetTableCell("http://bond.morningstar.com/internal/company.aspx?cID=
"&smfStrExtr(RCHGetWebData("
http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol=MCD","?cID="),"?cID=","&"),1,"Cashflow
Ops/Total Debt")

I haven't been anxious to attack MorningStar element definitions, because
there are so many, and they don't necessarily replace the original elements
that were defined. It's a messy process. Also, since they have such
specific data on each web page, I'm afraid the 1000 web page limit would be
hit quickly for people getting data on multiple tickers. That wasn't a
concern when everything was on one print page.

If you have a few data items you use regularly, you could always define
your own element numbers for those items.

On Tue, Nov 15, 2016 at 2:10 PM, Jose Jacob pepecan47@
...wrote:

> Randy, I would like to get the Debt and Coverage Ratios from
> http://quicktake.morningstar.com/StockNet/bonds.aspx?
> Symbol=MCD&Country=USA
>
> specially interested in "Cashflow Ops/Total Debt" 0.26
>
> If possible, could you make these ratios Element #'s?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1c

Re: Debt and Coverage ratios from Morningstar

Tue Nov 15, 2016 8:35 pm (PST) . Posted by:

"Jose Jacob" pepecan47

Randy, when entering the formula on a spreadsheet I get "Error"

Regards,
Jose L. Jacob

--------------------------------------------
On Tue, 11/15/16, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Debt and Coverage ratios from Morningstar
To: smf_addin@yahoogroups.com
Received: Tuesday, November 15, 2016, 6:24 PM

Yuck. Awkward extraction. The data
you want is actually contained within a frame on the page,
which refers to a different URL that doesn't use the
ticker symbol:

http://bond.morningstar.com/internal/company.aspx?cID=0C000008A4

The extraction would be something
like:

=RCHGetTableCell("http://bond.morningstar.com/internal/company.aspx?cID="&smfStrExtr(RCHGetWebData("http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol=MCD","?cID="),"?cID=","&"),1,"Cashflow
Ops/Total Debt")

I
haven't been anxious to attack MorningStar element
definitions, because there are so many, and they don't
necessarily replace the original elements that were defined.
It's a messy process. Also, since they have such
specific data on each web page, I'm afraid the 1000 web
page limit would be hit quickly for people getting data on
multiple tickers. That wasn't a concern when everything
was on one print page.

If you
have a few data items you use regularly, you could always
define your own element numbers for those items.

On Tue,
Nov 15, 2016 at 2:10 PM, Jose Jacob pepecan47@...wrote:
Randy, I would like to get the Debt and Coverage
Ratios from

http://quicktake.morningstar.
com/StockNet/bonds.aspx? Symbol=MCD&Country=USA

specially interested in "Cashflow Ops/Total Debt"
0.26

If possible, could you make these ratios Element #'s?

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

#yiv5899819010 #yiv5899819010ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv5899819010 #yiv5899819010ygrp-mkp #yiv5899819010hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv5899819010 #yiv5899819010ygrp-mkp #yiv5899819010ads {
margin-bottom:10px;}

#yiv5899819010 #yiv5899819010ygrp-mkp .yiv5899819010ad {
padding:0 0;}

#yiv5899819010 #yiv5899819010ygrp-mkp .yiv5899819010ad p {
margin:0;}

#yiv5899819010 #yiv5899819010ygrp-mkp .yiv5899819010ad a {
color:#0000ff;text-decoration:none;}
#yiv5899819010 #yiv5899819010ygrp-sponsor
#yiv5899819010ygrp-lc {
font-family:Arial;}

#yiv5899819010 #yiv5899819010ygrp-sponsor
#yiv5899819010ygrp-lc #yiv5899819010hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv5899819010 #yiv5899819010ygrp-sponsor
#yiv5899819010ygrp-lc .yiv5899819010ad {
margin-bottom:10px;padding:0 0;}

#yiv5899819010 #yiv5899819010actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv5899819010 #yiv5899819010activity span {
font-weight:700;}

#yiv5899819010 #yiv5899819010activity span:first-child {
text-transform:uppercase;}

#yiv5899819010 #yiv5899819010activity span a {
color:#5085b6;text-decoration:none;}

#yiv5899819010 #yiv5899819010activity span span {
color:#ff7900;}

#yiv5899819010 #yiv5899819010activity span
.yiv5899819010underline {
text-decoration:underline;}

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

#yiv5899819010 .yiv5899819010attach div a {
text-decoration:none;}

#yiv5899819010 .yiv5899819010attach img {
border:none;padding-right:5px;}

#yiv5899819010 .yiv5899819010attach label {
display:block;margin-bottom:5px;}

#yiv5899819010 .yiv5899819010attach label a {
text-decoration:none;}

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

#yiv5899819010 .yiv5899819010bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv5899819010 .yiv5899819010bold a {
text-decoration:none;}

#yiv5899819010 dd.yiv5899819010last p a {
font-family:Verdana;font-weight:700;}

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

#yiv5899819010 dd.yiv5899819010last p
span.yiv5899819010yshortcuts {
margin-right:0;}

#yiv5899819010 div.yiv5899819010attach-table div div a {
text-decoration:none;}

#yiv5899819010 div.yiv5899819010attach-table {
width:400px;}

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

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

#yiv5899819010 div#yiv5899819010ygrp-mlmsg
#yiv5899819010ygrp-msg p a span.yiv5899819010yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv5899819010 .yiv5899819010green {
color:#628c2a;}

#yiv5899819010 .yiv5899819010MsoNormal {
margin:0 0 0 0;}

#yiv5899819010 o {
font-size:0;}

#yiv5899819010 #yiv5899819010photos div {
float:left;width:72px;}

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

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

#yiv5899819010 #yiv5899819010reco-category {
font-size:77%;}

#yiv5899819010 #yiv5899819010reco-desc {
font-size:77%;}

#yiv5899819010 .yiv5899819010replbq {
margin:4px;}

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

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

#yiv5899819010 #yiv5899819010ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv5899819010 #yiv5899819010ygrp-mlmsg pre, #yiv5899819010
code {
font:115% monospace;}

#yiv5899819010 #yiv5899819010ygrp-mlmsg * {
line-height:1.22em;}

#yiv5899819010 #yiv5899819010ygrp-mlmsg #yiv5899819010logo {
padding-bottom:10px;}

#yiv5899819010 #yiv5899819010ygrp-msg p a {
font-family:Verdana;}

#yiv5899819010 #yiv5899819010ygrp-msg
p#yiv5899819010attach-count span {
color:#1E66AE;font-weight:700;}

#yiv5899819010 #yiv5899819010ygrp-reco
#yiv5899819010reco-head {
color:#ff7900;font-weight:700;}

#yiv5899819010 #yiv5899819010ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv5899819010 #yiv5899819010ygrp-sponsor #yiv5899819010ov
li a {
font-size:130%;text-decoration:none;}

#yiv5899819010 #yiv5899819010ygrp-sponsor #yiv5899819010ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv5899819010 #yiv5899819010ygrp-sponsor #yiv5899819010ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv5899819010 #yiv5899819010ygrp-text {
font-family:Georgia;}

#yiv5899819010 #yiv5899819010ygrp-text p {
margin:0 0 1em 0;}

#yiv5899819010 #yiv5899819010ygrp-text tt {
font-size:120%;}

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

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1d

Re: Debt and Coverage ratios from Morningstar

Tue Nov 15, 2016 9:00 pm (PST) . Posted by:

"Craig Passow" passow

There's a line feed in the equation between "Cashflow" and "Ops" as
shown in the message. Replace that with a space and it returns 0.26.

On 11/15/2016 10:35 PM, Jose Jacob pepecan47@yahoo.ca [smf_addin] wrote:
>
>
> Randy, when entering the formula on a spreadsheet I get "Error"
>
> Regards,
> Jose L. Jacob
>
> --------------------------------------------
> On Tue, 11/15/16, Randy Harmelink rharmelink@gmail.com [smf_addin]
> <smf_addin@yahoogroups.com> wrote:
>
> Subject: Re: [smf_addin] Debt and Coverage ratios from Morningstar
> To: smf_addin@yahoogroups.com
> Received: Tuesday, November 15, 2016, 6:24 PM
>
>
>
>
>
>
>
>
>
>
>
>
> Yuck. Awkward extraction. The data
> you want is actually contained within a frame on the page,
> which refers to a different URL that doesn't use the
> ticker symbol:
>
> http://bond.morningstar.com/internal/company.aspx?cID=0C000008A4
>
> The extraction would be something
> like:
>
> =RCHGetTableCell("http://bond.morningstar.com/internal/company.aspx?cID="&smfStrExtr(RCHGetWebData("http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol=MCD","?cID="),"?cID=","&"),1,"Cashflow
> Ops/Total Debt")
>
> I
> haven't been anxious to attack MorningStar element
> definitions, because there are so many, and they don't
> necessarily replace the original elements that were defined.
> It's a messy process. Also, since they have such
> specific data on each web page, I'm afraid the 1000 web
> page limit would be hit quickly for people getting data on
> multiple tickers. That wasn't a concern when everything
> was on one print page.
>
> If you
> have a few data items you use regularly, you could always
> define your own element numbers for those items.
>
>
> On Tue,
> Nov 15, 2016 at 2:10 PM, Jose Jacob pepecan47@...wrote:
> Randy, I would like to get the Debt and Coverage
> Ratios from
>
> http://quicktake.morningstar.
> com/StockNet/bonds.aspx? Symbol=MCD&Country=USA
>
>
>
> specially interested in "Cashflow Ops/Total Debt"
> 0.26
>
>
>
> If possible, could you make these ratios Element #'s?
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> #yiv5899819010 #yiv5899819010 --
> #yiv5899819010ygrp-mkp {
> border:1px solid #d8d8d8;font-family:Arial;margin:10px
> 0;padding:0 10px;}
>
> #yiv5899819010 #yiv5899819010ygrp-mkp hr {
> border:1px solid #d8d8d8;}
>
> #yiv5899819010 #yiv5899819010ygrp-mkp #yiv5899819010hd {
> color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
> 0;}
>
> #yiv5899819010 #yiv5899819010ygrp-mkp #yiv5899819010ads {
> margin-bottom:10px;}
>
> #yiv5899819010 #yiv5899819010ygrp-mkp .yiv5899819010ad {
> padding:0 0;}
>
> #yiv5899819010 #yiv5899819010ygrp-mkp .yiv5899819010ad p {
> margin:0;}
>
> #yiv5899819010 #yiv5899819010ygrp-mkp .yiv5899819010ad a {
> color:#0000ff;text-decoration:none;}
> #yiv5899819010 #yiv5899819010ygrp-sponsor
> #yiv5899819010ygrp-lc {
> font-family:Arial;}
>
> #yiv5899819010 #yiv5899819010ygrp-sponsor
> #yiv5899819010ygrp-lc #yiv5899819010hd {
> margin:10px
> 0px;font-weight:700;font-size:78%;line-height:122%;}
>
> #yiv5899819010 #yiv5899819010ygrp-sponsor
> #yiv5899819010ygrp-lc .yiv5899819010ad {
> margin-bottom:10px;padding:0 0;}
>
> #yiv5899819010 #yiv5899819010actions {
> font-family:Verdana;font-size:11px;padding:10px 0;}
>
> #yiv5899819010 #yiv5899819010activity {
> background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
>
> #yiv5899819010 #yiv5899819010activity span {
> font-weight:700;}
>
> #yiv5899819010 #yiv5899819010activity span:first-child {
> text-transform:uppercase;}
>
> #yiv5899819010 #yiv5899819010activity span a {
> color:#5085b6;text-decoration:none;}
>
> #yiv5899819010 #yiv5899819010activity span span {
> color:#ff7900;}
>
> #yiv5899819010 #yiv5899819010activity span
> .yiv5899819010underline {
> text-decoration:underline;}
>
> #yiv5899819010 .yiv5899819010attach {
> clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
> 0;width:400px;}
>
> #yiv5899819010 .yiv5899819010attach div a {
> text-decoration:none;}
>
> #yiv5899819010 .yiv5899819010attach img {
> border:none;padding-right:5px;}
>
> #yiv5899819010 .yiv5899819010attach label {
> display:block;margin-bottom:5px;}
>
> #yiv5899819010 .yiv5899819010attach label a {
> text-decoration:none;}
>
> #yiv5899819010 blockquote {
> margin:0 0 0 4px;}
>
> #yiv5899819010 .yiv5899819010bold {
> font-family:Arial;font-size:13px;font-weight:700;}
>
> #yiv5899819010 .yiv5899819010bold a {
> text-decoration:none;}
>
> #yiv5899819010 dd.yiv5899819010last p a {
> font-family:Verdana;font-weight:700;}
>
> #yiv5899819010 dd.yiv5899819010last p span {
> margin-right:10px;font-family:Verdana;font-weight:700;}
>
> #yiv5899819010 dd.yiv5899819010last p
> span.yiv5899819010yshortcuts {
> margin-right:0;}
>
> #yiv5899819010 div.yiv5899819010attach-table div div a {
> text-decoration:none;}
>
> #yiv5899819010 div.yiv5899819010attach-table {
> width:400px;}
>
> #yiv5899819010 div.yiv5899819010file-title a, #yiv5899819010
> div.yiv5899819010file-title a:active, #yiv5899819010
> div.yiv5899819010file-title a:hover, #yiv5899819010
> div.yiv5899819010file-title a:visited {
> text-decoration:none;}
>
> #yiv5899819010 div.yiv5899819010photo-title a,
> #yiv5899819010 div.yiv5899819010photo-title a:active,
> #yiv5899819010 div.yiv5899819010photo-title a:hover,
> #yiv5899819010 div.yiv5899819010photo-title a:visited {
> text-decoration:none;}
>
> #yiv5899819010 div#yiv5899819010ygrp-mlmsg
> #yiv5899819010ygrp-msg p a span.yiv5899819010yshortcuts {
> font-family:Verdana;font-size:10px;font-weight:normal;}
>
> #yiv5899819010 .yiv5899819010green {
> color:#628c2a;}
>
> #yiv5899819010 .yiv5899819010MsoNormal {
> margin:0 0 0 0;}
>
> #yiv5899819010 o {
> font-size:0;}
>
> #yiv5899819010 #yiv5899819010photos div {
> float:left;width:72px;}
>
> #yiv5899819010 #yiv5899819010photos div div {
> border:1px solid
> #666666;height:62px;overflow:hidden;width:62px;}
>
> #yiv5899819010 #yiv5899819010photos div label {
> color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
>
> #yiv5899819010 #yiv5899819010reco-category {
> font-size:77%;}
>
> #yiv5899819010 #yiv5899819010reco-desc {
> font-size:77%;}
>
> #yiv5899819010 .yiv5899819010replbq {
> margin:4px;}
>
> #yiv5899819010 #yiv5899819010ygrp-actbar div a:first-child {
> margin-right:2px;padding-right:5px;}
>
> #yiv5899819010 #yiv5899819010ygrp-mlmsg {
> font-size:13px;font-family:Arial, helvetica, clean,
> sans-serif;}
>
> #yiv5899819010 #yiv5899819010ygrp-mlmsg table {
> font-size:inherit;font:100%;}
>
> #yiv5899819010 #yiv5899819010ygrp-mlmsg select,
> #yiv5899819010 input, #yiv5899819010 textarea {
> font:99% Arial, Helvetica, clean, sans-serif;}
>
> #yiv5899819010 #yiv5899819010ygrp-mlmsg pre, #yiv5899819010
> code {
> font:115% monospace;}
>
> #yiv5899819010 #yiv5899819010ygrp-mlmsg * {
> line-height:1.22em;}
>
> #yiv5899819010 #yiv5899819010ygrp-mlmsg #yiv5899819010logo {
> padding-bottom:10px;}
>
>
> #yiv5899819010 #yiv5899819010ygrp-msg p a {
> font-family:Verdana;}
>
> #yiv5899819010 #yiv5899819010ygrp-msg
> p#yiv5899819010attach-count span {
> color:#1E66AE;font-weight:700;}
>
> #yiv5899819010 #yiv5899819010ygrp-reco
> #yiv5899819010reco-head {
> color:#ff7900;font-weight:700;}
>
> #yiv5899819010 #yiv5899819010ygrp-reco {
> margin-bottom:20px;padding:0px;}
>
> #yiv5899819010 #yiv5899819010ygrp-sponsor #yiv5899819010ov
> li a {
> font-size:130%;text-decoration:none;}
>
> #yiv5899819010 #yiv5899819010ygrp-sponsor #yiv5899819010ov
> li {
> font-size:77%;list-style-type:square;padding:6px 0;}
>
> #yiv5899819010 #yiv5899819010ygrp-sponsor #yiv5899819010ov
> ul {
> margin:0;padding:0 0 0 8px;}
>
> #yiv5899819010 #yiv5899819010ygrp-text {
> font-family:Georgia;}
>
> #yiv5899819010 #yiv5899819010ygrp-text p {
> margin:0 0 1em 0;}
>
> #yiv5899819010 #yiv5899819010ygrp-text tt {
> font-size:120%;}
>
> #yiv5899819010 #yiv5899819010ygrp-vital ul li:last-child {
> border-right:none !important;
> }
> #yiv5899819010
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

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

Visit Your Group

New Members 23

• Privacy • Unsubscribe • Terms of Use

EXCEL FEED

Rabu, 16 November 2016

[smf_addin] Digest Number 3843

4 Messages

Messages

1a

Debt and Coverage ratios from Morningstar

Tue Nov 15, 2016 1:10 pm (PST) . Posted by:

"Jose Jacob" pepecan47

1b

Re: Debt and Coverage ratios from Morningstar

Tue Nov 15, 2016 3:24 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

1c

Re: Debt and Coverage ratios from Morningstar

Tue Nov 15, 2016 8:35 pm (PST) . Posted by:

"Jose Jacob" pepecan47

1d

Re: Debt and Coverage ratios from Morningstar

Tue Nov 15, 2016 9:00 pm (PST) . Posted by:

"Craig Passow" passow

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me