Rabu, 01 Februari 2017

[smf_addin] Digest Number 3906

10 Messages

Digest #3906
1a
Re: Morningstar stocks credit rating by "Jose Jacob" pepecan47
1b
Re: Morningstar stocks credit rating by "Randy Harmelink" rharmelink
2a
Re: ADVFN Monitor CSV by "Randy Harmelink" rharmelink
3a
XD for ETFs? by tonyestep
3b
Re: XD for ETFs? by "Randy Harmelink" rharmelink
4a
Re: Issue with RCHGetHTML by "Randy Harmelink" rharmelink
4b
Re: Issue with RCHGetHTML by "Gaston Bullrich" gbullr
5a
Re: GetElement 850 -- Industry Classification by "Randy Harmelink" rharmelink

Messages

Mon Jan 30, 2017 9:02 pm (PST) . Posted by:

"Jose Jacob" pepecan47

Hi Randy, the element 884 is not working. The "Credit Rating" info is not in the web page
http://quotes.morningstar.com/stock/c-morningstar-take?t=mcd anymore.

Is it possible to get the Credit rating from
http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol=mcd

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

to get Cashflow Ops/Total Debt from the same page, but I cannot get the Credit Rating, I tried without success.

Regards,
Jose L. Jacob

--------------------------------------------
On Thu, 9/24/15, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Morningstar stocks credit rating
To: smf_addin@yahoogroups.com
Received: Thursday, September 24, 2015, 8:24 PM


 









Thanks. Always love a quick
solution. :)

I've added
your change to smf-elements-4.txt and uploaded the updated
file to the "Works in Progress" folder on the
add-in's web site.

On Thu, Sep 24, 2015 at
4:34 PM, adelgado2367@... wrote:



















I am using the most recent version of
Element Definitions (2015-05-27) and code 884 does not work
for my list of 65 stock symbols.....only getting
"Error" message

However, following your formulas for other
"Morningstar take", I have no problem when I use
the following:

=smfGetTagContent("http://quotes.morningstar.com/stock/c-morningstar-take?t=~~~~~","span",1,"idMstarGradeContent","Morningstar
Credit Rating")

With
the above, I get the M* Credit ratings for stocks for all my
stocks!




















Posted by: Randy Harmelink
<rharmelink@gmail.com>




Tue Jan 31, 2017 1:51 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetTagContent("http://bond.morningstar.com/internal/company.aspx?cID=
"&smfStrExtr(RCHGetWebData("
http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol="&$A4,"?cID="),"?cID=","&"),"td",6,"Morningstar
Credit Rating")

On Mon, Jan 30, 2017 at 10:02 PM, Jose Jacob pepecan47@
​...wrote:

> Hi Randy, the element 884 is not working. The "Credit Rating" info is not
> in the web page
> http://quotes.morningstar.com/stock/c-morningstar-take?t=mcd anymore.
>
> Is it possible to get the Credit rating from
> http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol=mcd
>
> I am using
> =RCHGetTableCell("http://bond.morningstar.com/internal/company.aspx?cID=
> "&smfStrExtr(RCHGetWebData("http://quicktake.morningstar.com/
> StockNet/bonds.aspx?Symbol="&$A4,"?cID="),"?cID=","&"),1,"Cashflow
> Ops/Total Debt")
>
> to get Cashflow Ops/Total Debt from the same page, but I cannot get the
> Credit Rating, I tried without success.
>
>

Mon Jan 30, 2017 9:44 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The point is that there is no "page loaded" state for the add-in. All the
add-in has in the source code a browser uses to build the web page. No
images retrieved. No Javascript run. Nothing.

On Mon, Jan 30, 2017 at 6:49 PM, buckleca@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Yes I guess if I want the CSV file I'll have to do it the hard way!
>
> However, since the CSV file isn't available with the Add-in, then I was
> wondering if there's a method with the add-in to extract all the contents?
>
> When the page loads all the data is visible.
>

Tue Jan 31, 2017 12:26 pm (PST) . Posted by:

tonyestep

I think this may have been mentioned but I can't find it. Anyway, my XD call works fine for individual stocks but returns N/A for ETFs no matter which one I try or when the date is. It used to work, but.....?


Tony Estep

Tue Jan 31, 2017 1:31 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You could try ETF,com. Try something like this:

=smfGetTagContent("http://www.etf.com/"&E7,"span",1,">Next Ex-dividend")

I don't see next ex-dividend dates for ETFs at the normal data sources.

On Tue, Jan 31, 2017 at 1:19 PM, tonyestep@
​...wrote:

> I think this may have been mentioned but I can't find it. Anyway, my XD
> call works fine for individual stocks but returns N/A for ETFs no matter
> which one I try or when the date is. It used to work, but.....?
>

Tue Jan 31, 2017 1:50 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Like a lot of web sites, they've changed to secure web pages. Just change
the "http" to "https" in the URL.

On Mon, Jan 30, 2017 at 2:24 PM, gaston.bullrich@
​...wrote:

>
> RchGetHTML Table error
>
> Not getting anything back and this used to work great.
>
> thoughts?
>
> =rchgethtmltable("http://www. investing.com/rates-bonds/
> world-government-bonds
> <http://www.investing.com/rates-bonds/world-government-bonds>",E2)
>
> E2 = "Switzerland 1Y" w/o the quotes
>
>

Tue Jan 31, 2017 2:04 pm (PST) . Posted by:

"Gaston Bullrich" gbullr

​Really sorry for troubling with such trivial matters.

Thank you for your tireless help on this.

​

On Tue, Jan 31, 2017 at 4:35 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Like a lot of web sites, they've changed to secure web pages. Just change
> the "http" to "https" in the URL.
>
> On Mon, Jan 30, 2017 at 2:24 PM, gaston.bullrich@
> ​...wrote:
>
>>
>> RchGetHTML Table error
>>
>> Not getting anything back and this used to work great.
>>
>> thoughts?
>>
>> =rchgethtmltable("http://www. investing.com/rates-bonds/
>> world-government-bonds
>> <http://www.investing.com/rates-bonds/world-government-bonds>",E2)
>>
>> E2 = "Switzerland 1Y" w/o the quotes
>>
>>
>
>

--
Gaston Bullrich
9 Island Avenue Apt 1406
Miami Beach, Florida 33139
Cel. 917 517 9907

Tue Jan 31, 2017 2:24 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Thanks for the heads up. I just updated the extraction using something
other than the old label.

The new smf-elements-6.txt has been uploaded to the web site.

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

On Fri, Jan 27, 2017 at 6:39 PM, sjagers@
​...wrote:

> FYI... If you're interested to know.... Zack's changed their website
> again.
>
> The word, or label, "Industry" used by GetElements 850 function was
> removed from their "Quote Overview" page. The overview page lists the
> Sector and Industry classification, but the "Industry" label is gone.
> However, that label ("Industry") is still included on their "Comparison to
> Industry" page.
>
>
> Quote Overview: https://www.zacks.com/stock/quote/KR
>
> Comparison to Industry: https://www.zacks.com/stock/research/KR/industry-
> comparison
>
>
> Again, just FYI, if you're interested.
>
>

Wed Feb 1, 2017 1:13 am (PST) . Posted by:


--------------------------------------------
On Wed, 2/1/17, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] GetElement 850 -- Industry Classification
To: smf_addin@yahoogroups.com
Date: Wednesday, February 1, 2017, 12:22 AM


 









Thanks for the heads up. I just
updated the extraction using something other than the old
label.

The new smf-elements-6.txt has been
uploaded to the web site.

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

On Fri,
Jan 27, 2017 at 6:39 PM, sjagers@​...wrote:












FYI... If you're interested to know....
Zack's changed their website again. 
The
word, or label, "Industry" used by GetElements 850
function was removed from their "Quote Overview"
page.  The overview page lists the Sector and Industry
classification, but the "Industry" label is
gone.  However, that label ("Industry") is still
included on their "Comparison to Industry"
page.

Quote Overview:  https://www.zacks.com/stock/
quote/KR
Comparison
to Industry:  https://www.zacks.com/stock/
research/KR/industry- comparison

Again, just FYI, if
you're interested. 













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

#yiv1705988478 #yiv1705988478ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv1705988478 #yiv1705988478ygrp-mkp #yiv1705988478hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv1705988478 #yiv1705988478ygrp-mkp #yiv1705988478ads {
margin-bottom:10px;}

#yiv1705988478 #yiv1705988478ygrp-mkp .yiv1705988478ad {
padding:0 0;}

#yiv1705988478 #yiv1705988478ygrp-mkp .yiv1705988478ad p {
margin:0;}

#yiv1705988478 #yiv1705988478ygrp-mkp .yiv1705988478ad a {
color:#0000ff;text-decoration:none;}
#yiv1705988478 #yiv1705988478ygrp-sponsor
#yiv1705988478ygrp-lc {
font-family:Arial;}

#yiv1705988478 #yiv1705988478ygrp-sponsor
#yiv1705988478ygrp-lc #yiv1705988478hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv1705988478 #yiv1705988478ygrp-sponsor
#yiv1705988478ygrp-lc .yiv1705988478ad {
margin-bottom:10px;padding:0 0;}

#yiv1705988478 #yiv1705988478actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv1705988478 #yiv1705988478activity span {
font-weight:700;}

#yiv1705988478 #yiv1705988478activity span:first-child {
text-transform:uppercase;}

#yiv1705988478 #yiv1705988478activity span a {
color:#5085b6;text-decoration:none;}

#yiv1705988478 #yiv1705988478activity span span {
color:#ff7900;}

#yiv1705988478 #yiv1705988478activity span
.yiv1705988478underline {
text-decoration:underline;}

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

#yiv1705988478 .yiv1705988478attach div a {
text-decoration:none;}

#yiv1705988478 .yiv1705988478attach img {
border:none;padding-right:5px;}

#yiv1705988478 .yiv1705988478attach label {
display:block;margin-bottom:5px;}

#yiv1705988478 .yiv1705988478attach label a {
text-decoration:none;}

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

#yiv1705988478 .yiv1705988478bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv1705988478 .yiv1705988478bold a {
text-decoration:none;}

#yiv1705988478 dd.yiv1705988478last p a {
font-family:Verdana;font-weight:700;}

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

#yiv1705988478 dd.yiv1705988478last p
span.yiv1705988478yshortcuts {
margin-right:0;}

#yiv1705988478 div.yiv1705988478attach-table div div a {
text-decoration:none;}

#yiv1705988478 div.yiv1705988478attach-table {
width:400px;}

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

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

#yiv1705988478 div#yiv1705988478ygrp-mlmsg
#yiv1705988478ygrp-msg p a span.yiv1705988478yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv1705988478 .yiv1705988478green {
color:#628c2a;}

#yiv1705988478 .yiv1705988478MsoNormal {
margin:0 0 0 0;}

#yiv1705988478 o {
font-size:0;}

#yiv1705988478 #yiv1705988478photos div {
float:left;width:72px;}

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

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

#yiv1705988478 #yiv1705988478reco-category {
font-size:77%;}

#yiv1705988478 #yiv1705988478reco-desc {
font-size:77%;}

#yiv1705988478 .yiv1705988478replbq {
margin:4px;}

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

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

#yiv1705988478 #yiv1705988478ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv1705988478 #yiv1705988478ygrp-mlmsg pre, #yiv1705988478
code {
font:115% monospace;}

#yiv1705988478 #yiv1705988478ygrp-mlmsg * {
line-height:1.22em;}

#yiv1705988478 #yiv1705988478ygrp-mlmsg #yiv1705988478logo {
padding-bottom:10px;}


#yiv1705988478 #yiv1705988478ygrp-msg p a {
font-family:Verdana;}

#yiv1705988478 #yiv1705988478ygrp-msg
p#yiv1705988478attach-count span {
color:#1E66AE;font-weight:700;}

#yiv1705988478 #yiv1705988478ygrp-reco
#yiv1705988478reco-head {
color:#ff7900;font-weight:700;}

#yiv1705988478 #yiv1705988478ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv1705988478 #yiv1705988478ygrp-sponsor #yiv1705988478ov
li a {
font-size:130%;text-decoration:none;}

#yiv1705988478 #yiv1705988478ygrp-sponsor #yiv1705988478ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv1705988478 #yiv1705988478ygrp-sponsor #yiv1705988478ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv1705988478 #yiv1705988478ygrp-text {
font-family:Georgia;}

#yiv1705988478 #yiv1705988478ygrp-text p {
margin:0 0 1em 0;}

#yiv1705988478 #yiv1705988478ygrp-text tt {
font-size:120%;}

#yiv1705988478 #yiv1705988478ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv1705988478
9 nov. - Alegeri parlamentare falsificate de catre comunisti. 20 dec. - Legea pentru etatizarea Bancii Nationale a Romaniei.194610 ian. - Prima sesiune a Adunarii Generale a O.N.U. la Londra.

Wed Feb 1, 2017 4:15 pm (PST) . Posted by:

waterboy5555

To all,


Thanks for the add in. I've been using it for a couple years now and it has been working great. Recently, something has changed and the add-in does not seem to be pulling in numbers from Morningstar. For some reason, when I disabled the add in, numbers would pull in from Morningstar. Now, nothing is happening at all, even when I press Alt F8 and type in smfforcerecalculation or when I resign in to morningstar or when I try and access data via excel. I tried putting in the newer add in versions, but nothing seems to be helping. What could I be doing wrong?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 18.08

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)