EXCEL Stock Market Functions Add-in Group

2 Messages

Digest #3654

Re: Help on element 884, Bond Rating by "Jose Jacob" pepecan47

Re: Help on element 884, Bond Rating by "Randy Harmelink" rharmelink

Messages

1a

Re: Help on element 884, Bond Rating

Wed Mar 2, 2016 8:34 pm (PST) . Posted by:

"Jose Jacob" pepecan47

Hi Randy - I updated my SMF with the latest smf-elaments-*.txt files.

When using =RCHGetElementNumber($A$2, 884), I get the credit rating with MCD, PG and KO.

I get error with DUK, even as the web page http://www.morningstar.com/stocks/xnys/duk/quote.html
shows BBB as Credit rating.

Same with SO and ED, I get "error".

Regards,
Jose L. Jacob

--------------------------------------------
On Fri, 1/29/16, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Help on element 884, Bond Rating
To: smf_addin@yahoogroups.com
Received: Friday, January 29, 2016, 1:53 AM

Looks like
MorningStar has moved the bond ratings off to a separate
site. I've updated the smf-elements-4.txt file with an
updated element definition. It can be found here:

http://ogres-crypt.com/SMF/Elements/

Warning -- a lot of my
requests for the new bond page took 6 to 10 seconds to
retrieve. So if you're retrieving a number of bond
ratings, be prepared for that.

The new saved formula looks like this:

=RCHGetTableCell(smfStrExtr(RCHGetWebData("http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol=MMM","cID=",250,-100),"src=""","&"),1,"MorningStar
Credit Rating","<tr")

...because the "bond" system
they have uses a different "ticker" symbol, so
that URL needs to be retrieved first. In this case, it looks
like this:

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

On Thu, Jan 28, 2016 at
10:02 PM, augusto727@yahoo.com
[smf_addin] <smf_addin@yahoogroups.com>
wrote:

Hi, I am having trouble getting data using element
884, Bond Rating. Can you help? Thanks

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

#yiv4589319038 #yiv4589319038ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv4589319038 #yiv4589319038ygrp-mkp #yiv4589319038hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv4589319038 #yiv4589319038ygrp-mkp #yiv4589319038ads {
margin-bottom:10px;}

#yiv4589319038 #yiv4589319038ygrp-mkp .yiv4589319038ad {
padding:0 0;}

#yiv4589319038 #yiv4589319038ygrp-mkp .yiv4589319038ad p {
margin:0;}

#yiv4589319038 #yiv4589319038ygrp-mkp .yiv4589319038ad a {
color:#0000ff;text-decoration:none;}
#yiv4589319038 #yiv4589319038ygrp-sponsor
#yiv4589319038ygrp-lc {
font-family:Arial;}

#yiv4589319038 #yiv4589319038ygrp-sponsor
#yiv4589319038ygrp-lc #yiv4589319038hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv4589319038 #yiv4589319038ygrp-sponsor
#yiv4589319038ygrp-lc .yiv4589319038ad {
margin-bottom:10px;padding:0 0;}

#yiv4589319038 #yiv4589319038actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv4589319038 #yiv4589319038activity span {
font-weight:700;}

#yiv4589319038 #yiv4589319038activity span:first-child {
text-transform:uppercase;}

#yiv4589319038 #yiv4589319038activity span a {
color:#5085b6;text-decoration:none;}

#yiv4589319038 #yiv4589319038activity span span {
color:#ff7900;}

#yiv4589319038 #yiv4589319038activity span
.yiv4589319038underline {
text-decoration:underline;}

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

#yiv4589319038 .yiv4589319038attach div a {
text-decoration:none;}

#yiv4589319038 .yiv4589319038attach img {
border:none;padding-right:5px;}

#yiv4589319038 .yiv4589319038attach label {
display:block;margin-bottom:5px;}

#yiv4589319038 .yiv4589319038attach label a {
text-decoration:none;}

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

#yiv4589319038 .yiv4589319038bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv4589319038 .yiv4589319038bold a {
text-decoration:none;}

#yiv4589319038 dd.yiv4589319038last p a {
font-family:Verdana;font-weight:700;}

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

#yiv4589319038 dd.yiv4589319038last p
span.yiv4589319038yshortcuts {
margin-right:0;}

#yiv4589319038 div.yiv4589319038attach-table div div a {
text-decoration:none;}

#yiv4589319038 div.yiv4589319038attach-table {
width:400px;}

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

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

#yiv4589319038 div#yiv4589319038ygrp-mlmsg
#yiv4589319038ygrp-msg p a span.yiv4589319038yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv4589319038 .yiv4589319038green {
color:#628c2a;}

#yiv4589319038 .yiv4589319038MsoNormal {
margin:0 0 0 0;}

#yiv4589319038 o {
font-size:0;}

#yiv4589319038 #yiv4589319038photos div {
float:left;width:72px;}

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

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

#yiv4589319038 #yiv4589319038reco-category {
font-size:77%;}

#yiv4589319038 #yiv4589319038reco-desc {
font-size:77%;}

#yiv4589319038 .yiv4589319038replbq {
margin:4px;}

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

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

#yiv4589319038 #yiv4589319038ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv4589319038 #yiv4589319038ygrp-mlmsg pre, #yiv4589319038
code {
font:115% monospace;}

#yiv4589319038 #yiv4589319038ygrp-mlmsg * {
line-height:1.22em;}

#yiv4589319038 #yiv4589319038ygrp-mlmsg #yiv4589319038logo {
padding-bottom:10px;}

#yiv4589319038 #yiv4589319038ygrp-msg p a {
font-family:Verdana;}

#yiv4589319038 #yiv4589319038ygrp-msg
p#yiv4589319038attach-count span {
color:#1E66AE;font-weight:700;}

#yiv4589319038 #yiv4589319038ygrp-reco
#yiv4589319038reco-head {
color:#ff7900;font-weight:700;}

#yiv4589319038 #yiv4589319038ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv4589319038 #yiv4589319038ygrp-sponsor #yiv4589319038ov
li a {
font-size:130%;text-decoration:none;}

#yiv4589319038 #yiv4589319038ygrp-sponsor #yiv4589319038ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv4589319038 #yiv4589319038ygrp-sponsor #yiv4589319038ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv4589319038 #yiv4589319038ygrp-text {
font-family:Georgia;}

#yiv4589319038 #yiv4589319038ygrp-text p {
margin:0 0 1em 0;}

#yiv4589319038 #yiv4589319038ygrp-text tt {
font-size:120%;}

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

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

1b

Re: Help on element 884, Bond Rating

Thu Mar 3, 2016 12:31 am (PST) . Posted by:

"Randy Harmelink" rharmelink

LOL. They put it right back from where they had removed it before.

I've updated smf-elements-4.txt on the web site.

Thanks for the heads up.

On Wed, Mar 2, 2016 at 9:34 PM, Jose Jacob pepecan47@...wrote:

> Hi Randy - I updated my SMF with the latest smf-elaments-*.txt files.
>
> When using =RCHGetElementNumber($A$2, 884), I get the credit rating with
> MCD, PG and KO.
>
> I get error with DUK, even as the web page
> http://www.morningstar.com/stocks/xnys/duk/quote.html
> shows BBB as Credit rating.
>
> Same with SO and ED, I get "error".
>
>