2 Messages
Digest #4582
Messages
Sat Jul 20, 2019 3:08 pm (PDT) . Posted by:
"Jose Jacob" pepecan47
Hello Randy - there is an "export to Excel" button when viewing my portfolio in Morningstar. Is it possible to use the SMF to get the portfolio into a spreadsheet? By doing that I can get the premium items.
Regards,
Jose L. Jacob On Friday, July 19, 2019, 10:55:51 a.m. EDT, 'Jim Morlock' JimMorlock@optonline.net [smf_addin] <smf_addin@yahoogroups.com> wrote:
Morningstar recently rolled out changes to their website. There are numerous user complaints about the changes which include data elements being dropped. It may take a while for things to settle down.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, July 19, 2019 4:38 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Morningstar items stopped working
I wasn't able to get it to work here. The login process has changed, and I get a message that the method the EXCEL IE object is using is not allowed. So I don't see any way to actually log in for EXCEL and the add-in to use the premium items.
On Thu, Jul 18, 2019 at 9:35 PM Jose Jacob pepecan47@... wrote:
Hello Randy - suddenly several Morningstar items stopped working.
I have a M* premium membership, logged on with the browser. When entering alt D-D-W to login in excel, the screen I get is different than before, only text.. Don't know if it is related.
The items that used to work a couple of days ago:
Fair value uncertainty
=RCHGetElementNumber($A8,889)
Economic Moat
=RCHGetElementNumber($A8,890)
Fair value
=RCHGetElementNumber($A4, 886)
Stars
=smfConvertData(smfStrExtr(RCHGetWebData("http://financials.morningstar.com/company-profile/c.action?t="&A4,"r_star"),"r_star","'"))&"*"
#yiv0840010478 #yiv0840010478 -- #yiv0840010478ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0840010478 #yiv0840010478ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0840010478 #yiv0840010478ygrp-mkp #yiv0840010478hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0840010478 #yiv0840010478ygrp-mkp #yiv0840010478ads {margin-bottom:10px;}#yiv0840010478 #yiv0840010478ygrp-mkp .yiv0840010478ad {padding:0 0;}#yiv0840010478 #yiv0840010478ygrp-mkp .yiv0840010478ad p {margin:0;}#yiv0840010478 #yiv0840010478ygrp-mkp .yiv0840010478ad a {color:#0000ff;text-decoration:none;}#yiv0840010478 #yiv0840010478ygrp-sponsor #yiv0840010478ygrp-lc {font-family:Arial;}#yiv0840010478 #yiv0840010478ygrp-sponsor #yiv0840010478ygrp-lc #yiv0840010478hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0840010478 #yiv0840010478ygrp-sponsor #yiv0840010478ygrp-lc .yiv0840010478ad {margin-bottom:10px;padding:0 0;}#yiv0840010478 #yiv0840010478actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0840010478 #yiv0840010478activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0840010478 #yiv0840010478activity span {font-weight:700;}#yiv0840010478 #yiv0840010478activity span:first-child {text-transform:uppercase;}#yiv0840010478 #yiv0840010478activity span a {color:#5085b6;text-decoration:none;}#yiv0840010478 #yiv0840010478activity span span {color:#ff7900;}#yiv0840010478 #yiv0840010478activity span .yiv0840010478underline {text-decoration:underline;}#yiv0840010478 .yiv0840010478attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0840010478 .yiv0840010478attach div a {text-decoration:none;}#yiv0840010478 .yiv0840010478attach img {border:none;padding-right:5px;}#yiv0840010478 .yiv0840010478attach label {display:block;margin-bottom:5px;}#yiv0840010478 .yiv0840010478attach label a {text-decoration:none;}#yiv0840010478 blockquote {margin:0 0 0 4px;}#yiv0840010478 .yiv0840010478bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0840010478 .yiv0840010478bold a {text-decoration:none;}#yiv0840010478 dd.yiv0840010478last p a {font-family:Verdana;font-weight:700;}#yiv0840010478 dd.yiv0840010478last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0840010478 dd.yiv0840010478last p span.yiv0840010478yshortcuts {margin-right:0;}#yiv0840010478 div.yiv0840010478attach-table div div a {text-decoration:none;}#yiv0840010478 div.yiv0840010478attach-table {width:400px;}#yiv0840010478 div.yiv0840010478file-title a, #yiv0840010478 div.yiv0840010478file-title a:active, #yiv0840010478 div.yiv0840010478file-title a:hover, #yiv0840010478 div.yiv0840010478file-title a:visited {text-decoration:none;}#yiv0840010478 div.yiv0840010478photo-title a, #yiv0840010478 div.yiv0840010478photo-title a:active, #yiv0840010478 div.yiv0840010478photo-title a:hover, #yiv0840010478 div.yiv0840010478photo-title a:visited {text-decoration:none;}#yiv0840010478 div#yiv0840010478ygrp-mlmsg #yiv0840010478ygrp-msg p a span.yiv0840010478yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0840010478 .yiv0840010478green {color:#628c2a;}#yiv0840010478 .yiv0840010478MsoNormal {margin:0 0 0 0;}#yiv0840010478 o {font-size:0;}#yiv0840010478 #yiv0840010478photos div {float:left;width:72px;}#yiv0840010478 #yiv0840010478photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0840010478 #yiv0840010478photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0840010478 #yiv0840010478reco-category {font-size:77%;}#yiv0840010478 #yiv0840010478reco-desc {font-size:77%;}#yiv0840010478 .yiv0840010478replbq {margin:4px;}#yiv0840010478 #yiv0840010478ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0840010478 #yiv0840010478ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0840010478 #yiv0840010478ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0840010478 #yiv0840010478ygrp-mlmsg select, #yiv0840010478 input, #yiv0840010478 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0840010478 #yiv0840010478ygrp-mlmsg pre, #yiv0840010478 code {font:115% monospace;}#yiv0840010478 #yiv0840010478ygrp-mlmsg * {line-height:1.22em;}#yiv0840010478 #yiv0840010478ygrp-mlmsg #yiv0840010478logo {padding-bottom:10px;}#yiv0840010478 #yiv0840010478ygrp-msg p a {font-family:Verdana;}#yiv0840010478 #yiv0840010478ygrp-msg p#yiv0840010478attach-count span {color:#1E66AE;font-weight:700;}#yiv0840010478 #yiv0840010478ygrp-reco #yiv0840010478reco-head {color:#ff7900;font-weight:700;}#yiv0840010478 #yiv0840010478ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0840010478 #yiv0840010478ygrp-sponsor #yiv0840010478ov li a {font-size:130%;text-decoration:none;}#yiv0840010478 #yiv0840010478ygrp-sponsor #yiv0840010478ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0840010478 #yiv0840010478ygrp-sponsor #yiv0840010478ov ul {margin:0;padding:0 0 0 8px;}#yiv0840010478 #yiv0840010478ygrp-text {font-family:Georgia;}#yiv0840010478 #yiv0840010478ygrp-text p {margin:0 0 1em 0;}#yiv0840010478 #yiv0840010478ygrp-text tt {font-size:120%;}#yiv0840010478 #yiv0840010478ygrp-vital ul li:last-child {border-right:none !important;}#yiv0840010478
Regards,
Jose L. Jacob On Friday, July 19, 2019, 10:55:51 a.m. EDT, 'Jim Morlock' JimMorlock@optonline.net [smf_addin] <smf_addin@yahoogroups.com> wrote:
Morningstar recently rolled out changes to their website. There are numerous user complaints about the changes which include data elements being dropped. It may take a while for things to settle down.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, July 19, 2019 4:38 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Morningstar items stopped working
I wasn't able to get it to work here. The login process has changed, and I get a message that the method the EXCEL IE object is using is not allowed. So I don't see any way to actually log in for EXCEL and the add-in to use the premium items.
On Thu, Jul 18, 2019 at 9:35 PM Jose Jacob pepecan47@... wrote:
Hello Randy - suddenly several Morningstar items stopped working.
I have a M* premium membership, logged on with the browser. When entering alt D-D-W to login in excel, the screen I get is different than before, only text.. Don't know if it is related.
The items that used to work a couple of days ago:
Fair value uncertainty
=RCHGetElementNumber($A8,889)
Economic Moat
=RCHGetElementNumber($A8,890)
Fair value
=RCHGetElementNumber($A4, 886)
Stars
=smfConvertData(smfStrExtr(RCHGetWebData("http://financials.morningstar.com/company-profile/c.action?t="&A4,"
#yiv0840010478 #yiv0840010478 -- #yiv0840010478ygrp-
Sat Jul 20, 2019 4:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, no. That link creates the file, so there's nothing that already
exists for the add-in to grab.
On Sat, Jul 20, 2019 at 3:08 PM Jose Jacob pepecan47@... wrote:
>
> Hello Randy - there is an "export to Excel" button when viewing my
> portfolio in Morningstar. Is it possible to use the SMF to get the
> portfolio into a spreadsheet? By doing that I can get the premium items.
>
>
>
exists for the add-in to grab.
On Sat, Jul 20, 2019 at 3:08 PM Jose Jacob pepecan47@..
>
> Hello Randy - there is an "export to Excel" button when viewing my
> portfolio in Morningstar. Is it possible to use the SMF to get the
> portfolio into a spreadsheet? By doing that I can get the premium items.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar