[smf_addin] Digest Number 3846

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #3846

1a

Re: Bar Chart Template by jterrenceho

2a

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

2b

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

Messages

1a

Re: Bar Chart Template

Fri Nov 18, 2016 7:34 am (PST) . Posted by:

jterrenceho

Randy,

Thank you, it works great!!

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

2a

Re: Debt and Coverage ratios from Morningstar

Fri Nov 18, 2016 9:04 pm (PST) . Posted by:

"Jose Jacob" pepecan47

I have in a spread sheet about 20 US stocks and 20 CDN stocks. The formula works as expected in all of them except the following CDN stocks:

xtse:ala
xtse:ema

I get "Error" for both of them, but I can see the Debt and Coverage ratios from bonds in Morningstar.

The formula I use is:

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

Regards,
Jose L. Jacob

--------------------------------------------
On Thu, 11/17/16, Jose Jacob pepecan47@yahoo.ca [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Debt and Coverage ratios from Morningstar
To: smf_addin@yahoogroups.com
Received: Thursday, November 17, 2016, 6:12 PM


 









Randy, I rebooted my computer and did exactly what
you asked me to do, and IT WORKS!!!!.



Thank you very much to you, Craig and Kermit.



Regards,

Jose L. Jacob



--------------------------------------------

On Thu, 11/17/16, Jose Jacob pepecan47@yahoo.ca [smf_addin]
<smf_addin@yahoogroups.com> wrote:



Subject: Re: [smf_addin] Debt and Coverage ratios from
Morningstar

To: smf_addin@yahoogroups.com

Received: Thursday, November 17, 2016, 5:15 PM





 



















I logged-on to Morningstar, hit alt+d+d+w to visit

the Morningstar website and verified the



"Hello, Jose" was at the top of the page,

canceled out of the EXCEL Web Query dialog, got out of
EXCEL

and tried the formula again.







Is it still possible to decompose the formula in 2
parts?

Just to see which one is failing, smfStrExtr or

RCHGetWebData. Maybe it is my SMF version.







Randy, thank you very much for your patience.







Regards,



Jose L. Jacob







--------------------------------------------



On Thu, 11/17/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: Thursday, November 17, 2016, 4:17 PM











 







































Not sure what to tell you then. I



did get a blank value returned the other day, but I
just

hit



alt+d+d+w to visit the Morningstar website and verify

the



"Hello, Randy" was at the top of the page.



Canceled out of the EXCEL Web Query dialog and hit my

button



to run the smfForceRecalculation macro, and the blank

return



changed to the cID.







On Thu, Nov 17, 2016 at



1:43 PM, Jose Jacob pepecan47@yahoo.ca



[smf_addin] <smf_addin@yahoogroups.com>



wrote:



Yes, I did



























































#yiv2740758260 #yiv2740758260 --



#yiv2740758260ygrp-mkp {



border:1px solid #d8d8d8;font-family:Arial;margin:10px



0;padding:0 10px;}







#yiv2740758260 #yiv2740758260ygrp-mkp hr {



border:1px solid #d8d8d8;}







#yiv2740758260 #yiv2740758260ygrp-mkp #yiv2740758260hd
{




color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px



0;}







#yiv2740758260 #yiv2740758260ygrp-mkp #yiv2740758260ads

{



margin-bottom:10px;}







#yiv2740758260 #yiv2740758260ygrp-mkp .yiv2740758260ad
{



padding:0 0;}







#yiv2740758260 #yiv2740758260ygrp-mkp .yiv2740758260ad
p

{



margin:0;}







#yiv2740758260 #yiv2740758260ygrp-mkp .yiv2740758260ad
a

{



color:#0000ff;text-decoration:none;}



#yiv2740758260 #yiv2740758260ygrp-sponsor



#yiv2740758260ygrp-lc {



font-family:Arial;}







#yiv2740758260 #yiv2740758260ygrp-sponsor



#yiv2740758260ygrp-lc #yiv2740758260hd {



margin:10px



0px;font-weight:700;font-size:78%;line-height:122%;}







#yiv2740758260 #yiv2740758260ygrp-sponsor



#yiv2740758260ygrp-lc .yiv2740758260ad {



margin-bottom:10px;padding:0 0;}







#yiv2740758260 #yiv2740758260actions {



font-family:Verdana;font-size:11px;padding:10px 0;}







#yiv2740758260 #yiv2740758260activity {




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







#yiv2740758260 #yiv2740758260activity span {



font-weight:700;}







#yiv2740758260 #yiv2740758260activity span:first-child
{



text-transform:uppercase;}







#yiv2740758260 #yiv2740758260activity span a {



color:#5085b6;text-decoration:none;}







#yiv2740758260 #yiv2740758260activity span span {



color:#ff7900;}







#yiv2740758260 #yiv2740758260activity span



.yiv2740758260underline {



text-decoration:underline;}







#yiv2740758260 .yiv2740758260attach {




clear:both;display:table;font-family:Arial;font-size:12px;padding:10px



0;width:400px;}







#yiv2740758260 .yiv2740758260attach div a {



text-decoration:none;}







#yiv2740758260 .yiv2740758260attach img {



border:none;padding-right:5px;}







#yiv2740758260 .yiv2740758260attach label {



display:block;margin-bottom:5px;}







#yiv2740758260 .yiv2740758260attach label a {



text-decoration:none;}







#yiv2740758260 blockquote {



margin:0 0 0 4px;}







#yiv2740758260 .yiv2740758260bold {



font-family:Arial;font-size:13px;font-weight:700;}







#yiv2740758260 .yiv2740758260bold a {



text-decoration:none;}







#yiv2740758260 dd.yiv2740758260last p a {



font-family:Verdana;font-weight:700;}







#yiv2740758260 dd.yiv2740758260last p span {



margin-right:10px;font-family:Verdana;font-weight:700;}







#yiv2740758260 dd.yiv2740758260last p



span.yiv2740758260yshortcuts {



margin-right:0;}







#yiv2740758260 div.yiv2740758260attach-table div div a
{



text-decoration:none;}







#yiv2740758260 div.yiv2740758260attach-table {



width:400px;}







#yiv2740758260 div.yiv2740758260file-title a,

#yiv2740758260



div.yiv2740758260file-title a:active, #yiv2740758260



div.yiv2740758260file-title a:hover, #yiv2740758260



div.yiv2740758260file-title a:visited {



text-decoration:none;}







#yiv2740758260 div.yiv2740758260photo-title a,



#yiv2740758260 div.yiv2740758260photo-title a:active,



#yiv2740758260 div.yiv2740758260photo-title a:hover,



#yiv2740758260 div.yiv2740758260photo-title a:visited {



text-decoration:none;}







#yiv2740758260 div#yiv2740758260ygrp-mlmsg



#yiv2740758260ygrp-msg p a span.yiv2740758260yshortcuts

{



font-family:Verdana;font-size:10px;font-weight:normal;}







#yiv2740758260 .yiv2740758260green {



color:#628c2a;}







#yiv2740758260 .yiv2740758260MsoNormal {



margin:0 0 0 0;}







#yiv2740758260 o {



font-size:0;}







#yiv2740758260 #yiv2740758260photos div {



float:left;width:72px;}







#yiv2740758260 #yiv2740758260photos div div {



border:1px solid



#666666;height:62px;overflow:hidden;width:62px;}







#yiv2740758260 #yiv2740758260photos div label {




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







#yiv2740758260 #yiv2740758260reco-category {



font-size:77%;}







#yiv2740758260 #yiv2740758260reco-desc {



font-size:77%;}







#yiv2740758260 .yiv2740758260replbq {



margin:4px;}







#yiv2740758260 #yiv2740758260ygrp-actbar div
a:first-child

{



margin-right:2px;padding-right:5px;}







#yiv2740758260 #yiv2740758260ygrp-mlmsg {



font-size:13px;font-family:Arial, helvetica, clean,



sans-serif;}







#yiv2740758260 #yiv2740758260ygrp-mlmsg table {



font-size:inherit;font:100%;}







#yiv2740758260 #yiv2740758260ygrp-mlmsg select,



#yiv2740758260 input, #yiv2740758260 textarea {



font:99% Arial, Helvetica, clean, sans-serif;}







#yiv2740758260 #yiv2740758260ygrp-mlmsg pre,

#yiv2740758260



code {



font:115% monospace;}







#yiv2740758260 #yiv2740758260ygrp-mlmsg * {



line-height:1.22em;}







#yiv2740758260 #yiv2740758260ygrp-mlmsg
#yiv2740758260logo

{



padding-bottom:10px;}











#yiv2740758260 #yiv2740758260ygrp-msg p a {



font-family:Verdana;}







#yiv2740758260 #yiv2740758260ygrp-msg



p#yiv2740758260attach-count span {



color:#1E66AE;font-weight:700;}







#yiv2740758260 #yiv2740758260ygrp-reco



#yiv2740758260reco-head {



color:#ff7900;font-weight:700;}







#yiv2740758260 #yiv2740758260ygrp-reco {



margin-bottom:20px;padding:0px;}







#yiv2740758260 #yiv2740758260ygrp-sponsor

#yiv2740758260ov



li a {



font-size:130%;text-decoration:none;}







#yiv2740758260 #yiv2740758260ygrp-sponsor

#yiv2740758260ov



li {



font-size:77%;list-style-type:square;padding:6px 0;}







#yiv2740758260 #yiv2740758260ygrp-sponsor

#yiv2740758260ov



ul {



margin:0;padding:0 0 0 8px;}







#yiv2740758260 #yiv2740758260ygrp-text {



font-family:Georgia;}







#yiv2740758260 #yiv2740758260ygrp-text p {



margin:0 0 1em 0;}







#yiv2740758260 #yiv2740758260ygrp-text tt {



font-size:120%;}







#yiv2740758260 #yiv2740758260ygrp-vital ul
li:last-child

{



border-right:none !important;



}



#yiv2740758260



























#yiv8791474755 #yiv8791474755 --

#yiv8791474755ygrp-mkp {

border:1px solid #d8d8d8;font-family:Arial;margin:10px

0;padding:0 10px;}



#yiv8791474755 #yiv8791474755ygrp-mkp hr {

border:1px solid #d8d8d8;}



#yiv8791474755 #yiv8791474755ygrp-mkp #yiv8791474755hd {

color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px

0;}



#yiv8791474755 #yiv8791474755ygrp-mkp #yiv8791474755ads
{

margin-bottom:10px;}



#yiv8791474755 #yiv8791474755ygrp-mkp .yiv8791474755ad {

padding:0 0;}



#yiv8791474755 #yiv8791474755ygrp-mkp .yiv8791474755ad p
{

margin:0;}



#yiv8791474755 #yiv8791474755ygrp-mkp .yiv8791474755ad a
{

color:#0000ff;text-decoration:none;}

#yiv8791474755 #yiv8791474755ygrp-sponsor

#yiv8791474755ygrp-lc {

font-family:Arial;}



#yiv8791474755 #yiv8791474755ygrp-sponsor

#yiv8791474755ygrp-lc #yiv8791474755hd {

margin:10px

0px;font-weight:700;font-size:78%;line-height:122%;}



#yiv8791474755 #yiv8791474755ygrp-sponsor

#yiv8791474755ygrp-lc .yiv8791474755ad {

margin-bottom:10px;padding:0 0;}



#yiv8791474755 #yiv8791474755actions {

font-family:Verdana;font-size:11px;padding:10px 0;}



#yiv8791474755 #yiv8791474755activity {

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



#yiv8791474755 #yiv8791474755activity span {

font-weight:700;}



#yiv8791474755 #yiv8791474755activity span:first-child {

text-transform:uppercase;}



#yiv8791474755 #yiv8791474755activity span a {

color:#5085b6;text-decoration:none;}



#yiv8791474755 #yiv8791474755activity span span {

color:#ff7900;}



#yiv8791474755 #yiv8791474755activity span

.yiv8791474755underline {

text-decoration:underline;}



#yiv8791474755 .yiv8791474755attach {

clear:both;display:table;font-family:Arial;font-size:12px;padding:10px

0;width:400px;}



#yiv8791474755 .yiv8791474755attach div a {

text-decoration:none;}



#yiv8791474755 .yiv8791474755attach img {

border:none;padding-right:5px;}



#yiv8791474755 .yiv8791474755attach label {

display:block;margin-bottom:5px;}



#yiv8791474755 .yiv8791474755attach label a {

text-decoration:none;}



#yiv8791474755 blockquote {

margin:0 0 0 4px;}



#yiv8791474755 .yiv8791474755bold {

font-family:Arial;font-size:13px;font-weight:700;}



#yiv8791474755 .yiv8791474755bold a {

text-decoration:none;}



#yiv8791474755 dd.yiv8791474755last p a {

font-family:Verdana;font-weight:700;}



#yiv8791474755 dd.yiv8791474755last p span {

margin-right:10px;font-family:Verdana;font-weight:700;}



#yiv8791474755 dd.yiv8791474755last p

span.yiv8791474755yshortcuts {

margin-right:0;}



#yiv8791474755 div.yiv8791474755attach-table div div a {

text-decoration:none;}



#yiv8791474755 div.yiv8791474755attach-table {

width:400px;}



#yiv8791474755 div.yiv8791474755file-title a,
#yiv8791474755

div.yiv8791474755file-title a:active, #yiv8791474755

div.yiv8791474755file-title a:hover, #yiv8791474755

div.yiv8791474755file-title a:visited {

text-decoration:none;}



#yiv8791474755 div.yiv8791474755photo-title a,

#yiv8791474755 div.yiv8791474755photo-title a:active,

#yiv8791474755 div.yiv8791474755photo-title a:hover,

#yiv8791474755 div.yiv8791474755photo-title a:visited {

text-decoration:none;}



#yiv8791474755 div#yiv8791474755ygrp-mlmsg

#yiv8791474755ygrp-msg p a span.yiv8791474755yshortcuts
{

font-family:Verdana;font-size:10px;font-weight:normal;}



#yiv8791474755 .yiv8791474755green {

color:#628c2a;}



#yiv8791474755 .yiv8791474755MsoNormal {

margin:0 0 0 0;}



#yiv8791474755 o {

font-size:0;}



#yiv8791474755 #yiv8791474755photos div {

float:left;width:72px;}



#yiv8791474755 #yiv8791474755photos div div {

border:1px solid

#666666;height:62px;overflow:hidden;width:62px;}



#yiv8791474755 #yiv8791474755photos div label {

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



#yiv8791474755 #yiv8791474755reco-category {

font-size:77%;}



#yiv8791474755 #yiv8791474755reco-desc {

font-size:77%;}



#yiv8791474755 .yiv8791474755replbq {

margin:4px;}



#yiv8791474755 #yiv8791474755ygrp-actbar div a:first-child
{

margin-right:2px;padding-right:5px;}



#yiv8791474755 #yiv8791474755ygrp-mlmsg {

font-size:13px;font-family:Arial, helvetica, clean,

sans-serif;}



#yiv8791474755 #yiv8791474755ygrp-mlmsg table {

font-size:inherit;font:100%;}



#yiv8791474755 #yiv8791474755ygrp-mlmsg select,

#yiv8791474755 input, #yiv8791474755 textarea {

font:99% Arial, Helvetica, clean, sans-serif;}



#yiv8791474755 #yiv8791474755ygrp-mlmsg pre,
#yiv8791474755

code {

font:115% monospace;}



#yiv8791474755 #yiv8791474755ygrp-mlmsg * {

line-height:1.22em;}



#yiv8791474755 #yiv8791474755ygrp-mlmsg #yiv8791474755logo
{

padding-bottom:10px;}





#yiv8791474755 #yiv8791474755ygrp-msg p a {

font-family:Verdana;}



#yiv8791474755 #yiv8791474755ygrp-msg

p#yiv8791474755attach-count span {

color:#1E66AE;font-weight:700;}



#yiv8791474755 #yiv8791474755ygrp-reco

#yiv8791474755reco-head {

color:#ff7900;font-weight:700;}



#yiv8791474755 #yiv8791474755ygrp-reco {

margin-bottom:20px;padding:0px;}



#yiv8791474755 #yiv8791474755ygrp-sponsor
#yiv8791474755ov

li a {

font-size:130%;text-decoration:none;}



#yiv8791474755 #yiv8791474755ygrp-sponsor
#yiv8791474755ov

li {

font-size:77%;list-style-type:square;padding:6px 0;}



#yiv8791474755 #yiv8791474755ygrp-sponsor
#yiv8791474755ov

ul {

margin:0;padding:0 0 0 8px;}



#yiv8791474755 #yiv8791474755ygrp-text {

font-family:Georgia;}



#yiv8791474755 #yiv8791474755ygrp-text p {

margin:0 0 1em 0;}



#yiv8791474755 #yiv8791474755ygrp-text tt {

font-size:120%;}



#yiv8791474755 #yiv8791474755ygrp-vital ul li:last-child
{

border-right:none !important;

}

#yiv8791474755













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

#yiv5583348211 #yiv5583348211ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv5583348211 #yiv5583348211ygrp-mkp #yiv5583348211hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv5583348211 #yiv5583348211ygrp-mkp #yiv5583348211ads {
margin-bottom:10px;}

#yiv5583348211 #yiv5583348211ygrp-mkp .yiv5583348211ad {
padding:0 0;}

#yiv5583348211 #yiv5583348211ygrp-mkp .yiv5583348211ad p {
margin:0;}

#yiv5583348211 #yiv5583348211ygrp-mkp .yiv5583348211ad a {
color:#0000ff;text-decoration:none;}
#yiv5583348211 #yiv5583348211ygrp-sponsor
#yiv5583348211ygrp-lc {
font-family:Arial;}

#yiv5583348211 #yiv5583348211ygrp-sponsor
#yiv5583348211ygrp-lc #yiv5583348211hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv5583348211 #yiv5583348211ygrp-sponsor
#yiv5583348211ygrp-lc .yiv5583348211ad {
margin-bottom:10px;padding:0 0;}

#yiv5583348211 #yiv5583348211actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv5583348211 #yiv5583348211activity span {
font-weight:700;}

#yiv5583348211 #yiv5583348211activity span:first-child {
text-transform:uppercase;}

#yiv5583348211 #yiv5583348211activity span a {
color:#5085b6;text-decoration:none;}

#yiv5583348211 #yiv5583348211activity span span {
color:#ff7900;}

#yiv5583348211 #yiv5583348211activity span
.yiv5583348211underline {
text-decoration:underline;}

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

#yiv5583348211 .yiv5583348211attach div a {
text-decoration:none;}

#yiv5583348211 .yiv5583348211attach img {
border:none;padding-right:5px;}

#yiv5583348211 .yiv5583348211attach label {
display:block;margin-bottom:5px;}

#yiv5583348211 .yiv5583348211attach label a {
text-decoration:none;}

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

#yiv5583348211 .yiv5583348211bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv5583348211 .yiv5583348211bold a {
text-decoration:none;}

#yiv5583348211 dd.yiv5583348211last p a {
font-family:Verdana;font-weight:700;}

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

#yiv5583348211 dd.yiv5583348211last p
span.yiv5583348211yshortcuts {
margin-right:0;}

#yiv5583348211 div.yiv5583348211attach-table div div a {
text-decoration:none;}

#yiv5583348211 div.yiv5583348211attach-table {
width:400px;}

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

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

#yiv5583348211 div#yiv5583348211ygrp-mlmsg
#yiv5583348211ygrp-msg p a span.yiv5583348211yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv5583348211 .yiv5583348211green {
color:#628c2a;}

#yiv5583348211 .yiv5583348211MsoNormal {
margin:0 0 0 0;}

#yiv5583348211 o {
font-size:0;}

#yiv5583348211 #yiv5583348211photos div {
float:left;width:72px;}

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

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

#yiv5583348211 #yiv5583348211reco-category {
font-size:77%;}

#yiv5583348211 #yiv5583348211reco-desc {
font-size:77%;}

#yiv5583348211 .yiv5583348211replbq {
margin:4px;}

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

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

#yiv5583348211 #yiv5583348211ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv5583348211 #yiv5583348211ygrp-mlmsg pre, #yiv5583348211
code {
font:115% monospace;}

#yiv5583348211 #yiv5583348211ygrp-mlmsg * {
line-height:1.22em;}

#yiv5583348211 #yiv5583348211ygrp-mlmsg #yiv5583348211logo {
padding-bottom:10px;}


#yiv5583348211 #yiv5583348211ygrp-msg p a {
font-family:Verdana;}

#yiv5583348211 #yiv5583348211ygrp-msg
p#yiv5583348211attach-count span {
color:#1E66AE;font-weight:700;}

#yiv5583348211 #yiv5583348211ygrp-reco
#yiv5583348211reco-head {
color:#ff7900;font-weight:700;}

#yiv5583348211 #yiv5583348211ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv5583348211 #yiv5583348211ygrp-sponsor #yiv5583348211ov
li a {
font-size:130%;text-decoration:none;}

#yiv5583348211 #yiv5583348211ygrp-sponsor #yiv5583348211ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv5583348211 #yiv5583348211ygrp-sponsor #yiv5583348211ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv5583348211 #yiv5583348211ygrp-text {
font-family:Georgia;}

#yiv5583348211 #yiv5583348211ygrp-text p {
margin:0 0 1em 0;}

#yiv5583348211 #yiv5583348211ygrp-text tt {
font-size:120%;}

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

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

2b

Re: Debt and Coverage ratios from Morningstar

Sat Nov 19, 2016 1:09 am (PST) . Posted by:

"Randy Harmelink" rharmelink

There is no normal bond page available for either of those ticker symbols:

http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol=xtse:ala
http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol=​xtse:ema

They bring up a search page for a ticker symbol.

PS: Can you trim what you're replying to when you send a reply? All of your
messages have a whole bunch of extraneous code at the end of them. Must
make the digests huge. :(

On Fri, Nov 18, 2016 at 10:04 PM, Jose Jacob pepecan47@yahoo.ca [smf_addin]
<smf_addin@yahoogroups.com> wrote:

> I have in a spread sheet about 20 US stocks and 20 CDN stocks. The formula
> works as expected in all of them except the following CDN stocks:
>
> xtse:ala
> ​​
> xtse:ema
>
> I get "Error" for both of them, but I can see the Debt and Coverage ratios
> from bonds in Morningstar.
>
> The formula I use is:
>
> =RCHGetTableCell("http://bond.morningstar.com/internal/company.aspx?cID=
> "&smfStrExtr(RCHGetWebData("
> ​​
> ​​
> http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol="&
> A24,"?cID="),"?cID=","&"),1,"Cashflow Ops/Total Debt")
>
>

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

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

Visit Your Group

• New Members 20

• Privacy • Unsubscribe • Terms of Use