Kamis, 07 Agustus 2014

[smf_addin] Digest Number 3142

9 Messages

Digest #3142
2a
Data Inconsistencies by justy_sports
2b
2c
Re: Data Inconsistencies by "Randy Harmelink" rharmelink
2d
2e
Re: Data Inconsistencies by "Randy Harmelink" rharmelink
3b
Re: Morningstar elements 889, 890, get "Error" by "Randy Harmelink" rharmelink
3c
Re: Morningstar elements 889, 890, get "Error" by "Randy Harmelink" rharmelink

Messages

Wed Aug 6, 2014 7:35 am (PDT) . Posted by:

justy_sports

I'm noticing a few inconsistencies when using RCHGetElementNumber


=RCHGetElementNumber("GGP","9") - this returns a value of 33.13



http://investing.money.msn.com/investments/institutional-ownership?symbol=ggp http://investing.money.msn.com/investments/institutional-ownership?symbol=ggp - this shows a value of 33.07 (I believe this page is the source for element #9)



I have tried smfforcerecalculation. It almost looks like it is pulling in an "old" value. This example is a small difference but I've seen other values that are more significant. Anyone else seen issues like this?


Thanks!


Wed Aug 6, 2014 8:23 am (PDT) . Posted by:

justy_sports

The more I play around with it, the more it seems like the smfForceRecalculation is not successfully clearing out the saved data pages. This is resulting in an "old-value" being pulled through.

Relative newbie so if anyone has any insight, that would be greatly appreciated.

Wed Aug 6, 2014 8:54 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Data for most MSN items comes from their print page:

http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=GGP

..which indeed is different from the web page you cite. So the discrepancy
is from MSN.

Oddly enough, I couldn't get the above web page to show any data in FireFox
or Chrome. Just IE. Hopefully, that's just a temporary issue on MSN's part.
Unless MicroSoft is doing something to prevent other company's browsers
from accessing the web page.

On Wed, Aug 6, 2014 at 7:35 AM, justy_sports@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I'm noticing a few inconsistencies when using RCHGetElementNumber
>
> =RCHGetElementNumber("GGP","9") - this returns a value of 33.13
>
>
> http://investing.money.msn.com/investments/institutional-ownership?symbol=ggp -
> this shows a value of 33.07 (I believe this page is the source for element
> #9)
>
> I have tried smfforcerecalculation. It almost looks like it is pulling in
> an "old" value. This example is a small difference but I've seen other
> values that are more significant. Anyone else seen issues like this?
>

Wed Aug 6, 2014 9:20 am (PDT) . Posted by:

justy_sports

Is Yahoo data similar (where it comes from the print page)?

Wed Aug 6, 2014 9:29 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yahoo doesn't have a print page. But I wouldn't be surprised to see similar
discrepancies on various data services, between web pages.

You can usually see the mask for the source page for an element number with
either:

=RCHGetElementNumber("P-URL",9)

...or the raw element definition:

=smfGetAParms(9)

On Wed, Aug 6, 2014 at 9:19 AM, justy_sports@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Is Yahoo data similar (where it comes from the print page)?
>
>

Wed Aug 6, 2014 7:49 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

Hi Randy - when I logged on from the EXCEL Web Query dialog to Morningstar, elements 889 and 890 started working. It seems that now the cookie is there, I don't need to login with the Web Query anymore, only with IE.

Now I am having another problem with M*, I am getting "Error" with element 884, Credit Rating. Would you please check it?

I have to thank you very much for all your effort and dedication!!

Regards,
Jose L. Jacob

--------------------------------------------
On Tue, 8/5/14, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Morningstar elements 889, 889, get "Error"
To: smf_addin@yahoogroups.com
Received: Tuesday, August 5, 2014, 11:23 AM


 









In such a case, I suspect
that the IE object used by EXCEL is a different version of
IE than the browser. It's why I say it's preferred
to use the EXCEL Web Query dialog versus the browser.
Because it's within EXCEL, the add-in would use all the
same objects that EXCEL does.


On
Tue, Aug 5, 2014 at 7:52 AM, Jose Jacob pepecan47...
wrote:
Hi Randy - I only use Internet Explorer.




When using the EXCEL Web Query dialog, the first thing I get
is a "Security Warning" pop-up. It says "Do
you want to view only the webpage content that was delivered
secured?" I pressed "NO" to continue.




But in the Web Query dialog I see "Welcome", not
"Welcome Jose". And I am already logged-on to
Morningstar in another IE session.!!



Then, if I logon to M* inside the Web Query, my spreadsheet
works



Do you have any clue what is going on?



ps. If I answer "YES" to the Security Warning
pop-up, I get a script error and I have to cancel the
dialog.














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

#yiv3062361491 #yiv3062361491ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv3062361491 #yiv3062361491ygrp-mkp #yiv3062361491hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv3062361491 #yiv3062361491ygrp-mkp #yiv3062361491ads {
margin-bottom:10px;}

#yiv3062361491 #yiv3062361491ygrp-mkp .yiv3062361491ad {
padding:0 0;}

#yiv3062361491 #yiv3062361491ygrp-mkp .yiv3062361491ad p {
margin:0;}

#yiv3062361491 #yiv3062361491ygrp-mkp .yiv3062361491ad a {
color:#0000ff;text-decoration:none;}
#yiv3062361491 #yiv3062361491ygrp-sponsor
#yiv3062361491ygrp-lc {
font-family:Arial;}

#yiv3062361491 #yiv3062361491ygrp-sponsor
#yiv3062361491ygrp-lc #yiv3062361491hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv3062361491 #yiv3062361491ygrp-sponsor
#yiv3062361491ygrp-lc .yiv3062361491ad {
margin-bottom:10px;padding:0 0;}

#yiv3062361491 #yiv3062361491actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv3062361491 #yiv3062361491activity span {
font-weight:700;}

#yiv3062361491 #yiv3062361491activity span:first-child {
text-transform:uppercase;}

#yiv3062361491 #yiv3062361491activity span a {
color:#5085b6;text-decoration:none;}

#yiv3062361491 #yiv3062361491activity span span {
color:#ff7900;}

#yiv3062361491 #yiv3062361491activity span
.yiv3062361491underline {
text-decoration:underline;}

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

#yiv3062361491 .yiv3062361491attach div a {
text-decoration:none;}

#yiv3062361491 .yiv3062361491attach img {
border:none;padding-right:5px;}

#yiv3062361491 .yiv3062361491attach label {
display:block;margin-bottom:5px;}

#yiv3062361491 .yiv3062361491attach label a {
text-decoration:none;}

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

#yiv3062361491 .yiv3062361491bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv3062361491 .yiv3062361491bold a {
text-decoration:none;}

#yiv3062361491 dd.yiv3062361491last p a {
font-family:Verdana;font-weight:700;}

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

#yiv3062361491 dd.yiv3062361491last p
span.yiv3062361491yshortcuts {
margin-right:0;}

#yiv3062361491 div.yiv3062361491attach-table div div a {
text-decoration:none;}

#yiv3062361491 div.yiv3062361491attach-table {
width:400px;}

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

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

#yiv3062361491 div#yiv3062361491ygrp-mlmsg
#yiv3062361491ygrp-msg p a span.yiv3062361491yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv3062361491 .yiv3062361491green {
color:#628c2a;}

#yiv3062361491 .yiv3062361491MsoNormal {
margin:0 0 0 0;}

#yiv3062361491 o {
font-size:0;}

#yiv3062361491 #yiv3062361491photos div {
float:left;width:72px;}

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

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

#yiv3062361491 #yiv3062361491reco-category {
font-size:77%;}

#yiv3062361491 #yiv3062361491reco-desc {
font-size:77%;}

#yiv3062361491 .yiv3062361491replbq {
margin:4px;}

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

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

#yiv3062361491 #yiv3062361491ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv3062361491 #yiv3062361491ygrp-mlmsg pre, #yiv3062361491
code {
font:115% monospace;}

#yiv3062361491 #yiv3062361491ygrp-mlmsg * {
line-height:1.22em;}

#yiv3062361491 #yiv3062361491ygrp-mlmsg #yiv3062361491logo {
padding-bottom:10px;}


#yiv3062361491 #yiv3062361491ygrp-msg p a {
font-family:Verdana;}

#yiv3062361491 #yiv3062361491ygrp-msg
p#yiv3062361491attach-count span {
color:#1E66AE;font-weight:700;}

#yiv3062361491 #yiv3062361491ygrp-reco
#yiv3062361491reco-head {
color:#ff7900;font-weight:700;}

#yiv3062361491 #yiv3062361491ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv3062361491 #yiv3062361491ygrp-sponsor #yiv3062361491ov
li a {
font-size:130%;text-decoration:none;}

#yiv3062361491 #yiv3062361491ygrp-sponsor #yiv3062361491ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv3062361491 #yiv3062361491ygrp-sponsor #yiv3062361491ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv3062361491 #yiv3062361491ygrp-text {
font-family:Georgia;}

#yiv3062361491 #yiv3062361491ygrp-text p {
margin:0 0 1em 0;}

#yiv3062361491 #yiv3062361491ygrp-text tt {
font-size:120%;}

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


Wed Aug 6, 2014 8:03 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Element #884 worked fine with ticker MMM for me...

That element was last updated on 2014-01-30, though, so if you have an
older version of the add-in or element definitions, it won't work. The data
comes from a different web page than the others as well:

http://quicktake.morningstar.com/stocknet/bonds.aspx?symbol=MMM

Can you view that web page in the EXCEL Web Query dialog?

On Wed, Aug 6, 2014 at 7:49 PM, Jose Jacob pepecan47@... wrote:

>
> Now I am having another problem with M*, I am getting "Error" with element
> 884, Credit Rating. Would you please check it?
>

Wed Aug 6, 2014 8:06 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. The element was updated AFTER I released the 2014-01-30 ZIP file.

Try the latest smf-elements-1.txt from the "Works in Progress" web page.

On Wed, Aug 6, 2014 at 8:03 PM, Randy Harmelink <rharmelink@gmail.com>
wrote:

> Element #884 worked fine with ticker MMM for me...
>
> That element was last updated on 2014-01-30, though, so if you have an
> older version of the add-in or element definitions, it won't work. The data
> comes from a different web page than the others as well:
>
> http://quicktake.morningstar.com/stocknet/bonds.aspx?symbol=MMM
>
> Can you view that web page in the EXCEL Web Query dialog?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 01.32

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)