EXCEL Stock Market Functions Add-in Group

2 Messages

Digest #3258

Re: Anyone tried getting key ratio from Morningstar successfully? by tzewei_79

Re: Morningstar Key Ratios by "Jose Jacob" pepecan47

Messages

1a

Re: Anyone tried getting key ratio from Morningstar successfully?

Thu Dec 4, 2014 6:03 am (PST) . Posted by:

tzewei_79

taking it didn't help. it's still showing #value. But I remove for cells that does calculation and reopen the file and it works.

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

2a

Hi Randy - thank you very much, it works.

Regards,
Jose L. Jacob

--------------------------------------------
On Wed, 12/3/14, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Morningstar Key Ratios
To: smf_addin@yahoogroups.com
Received: Wednesday, December 3, 2014, 11:04 PM

That means you've
accessed the 1000 web page limit per session of the add-in.
You'll need to exit EXCEL and restart it, then try the
functions I've given you again. Or, use the
smfForceRecalculation macro to purge all of the 1000 saved
web pages and start over.

How come you're accessing so many web
pages?

On Wed, Dec 3, 2014 at 8:37
PM, Jose Jacob pepecan47@yahoo.ca
[smf_addin] <smf_addin@yahoogroups.com>
wrote:
=RCHGetWebData("http://financials.morningstar.com/financials/getFinancePart.html?t=MCD",1,100)

Error--too many wep page retrievals

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

#yiv9025404140 #yiv9025404140ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv9025404140 #yiv9025404140ygrp-mkp #yiv9025404140hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv9025404140 #yiv9025404140ygrp-mkp #yiv9025404140ads {
margin-bottom:10px;}

#yiv9025404140 #yiv9025404140ygrp-mkp .yiv9025404140ad {
padding:0 0;}

#yiv9025404140 #yiv9025404140ygrp-mkp .yiv9025404140ad p {
margin:0;}

#yiv9025404140 #yiv9025404140ygrp-mkp .yiv9025404140ad a {
color:#0000ff;text-decoration:none;}
#yiv9025404140 #yiv9025404140ygrp-sponsor
#yiv9025404140ygrp-lc {
font-family:Arial;}

#yiv9025404140 #yiv9025404140ygrp-sponsor
#yiv9025404140ygrp-lc #yiv9025404140hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv9025404140 #yiv9025404140ygrp-sponsor
#yiv9025404140ygrp-lc .yiv9025404140ad {
margin-bottom:10px;padding:0 0;}

#yiv9025404140 #yiv9025404140actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv9025404140 #yiv9025404140activity span {
font-weight:700;}

#yiv9025404140 #yiv9025404140activity span:first-child {
text-transform:uppercase;}

#yiv9025404140 #yiv9025404140activity span a {
color:#5085b6;text-decoration:none;}

#yiv9025404140 #yiv9025404140activity span span {
color:#ff7900;}

#yiv9025404140 #yiv9025404140activity span
.yiv9025404140underline {
text-decoration:underline;}

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

#yiv9025404140 .yiv9025404140attach div a {
text-decoration:none;}

#yiv9025404140 .yiv9025404140attach img {
border:none;padding-right:5px;}

#yiv9025404140 .yiv9025404140attach label {
display:block;margin-bottom:5px;}

#yiv9025404140 .yiv9025404140attach label a {
text-decoration:none;}

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

#yiv9025404140 .yiv9025404140bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv9025404140 .yiv9025404140bold a {
text-decoration:none;}

#yiv9025404140 dd.yiv9025404140last p a {
font-family:Verdana;font-weight:700;}

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

#yiv9025404140 dd.yiv9025404140last p
span.yiv9025404140yshortcuts {
margin-right:0;}

#yiv9025404140 div.yiv9025404140attach-table div div a {
text-decoration:none;}

#yiv9025404140 div.yiv9025404140attach-table {
width:400px;}

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

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

#yiv9025404140 div#yiv9025404140ygrp-mlmsg
#yiv9025404140ygrp-msg p a span.yiv9025404140yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv9025404140 .yiv9025404140green {
color:#628c2a;}

#yiv9025404140 .yiv9025404140MsoNormal {
margin:0 0 0 0;}

#yiv9025404140 o {
font-size:0;}

#yiv9025404140 #yiv9025404140photos div {
float:left;width:72px;}

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

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

#yiv9025404140 #yiv9025404140reco-category {
font-size:77%;}

#yiv9025404140 #yiv9025404140reco-desc {
font-size:77%;}

#yiv9025404140 .yiv9025404140replbq {
margin:4px;}

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

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

#yiv9025404140 #yiv9025404140ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv9025404140 #yiv9025404140ygrp-mlmsg pre, #yiv9025404140
code {
font:115% monospace;}

#yiv9025404140 #yiv9025404140ygrp-mlmsg * {
line-height:1.22em;}

#yiv9025404140 #yiv9025404140ygrp-mlmsg #yiv9025404140logo {
padding-bottom:10px;}

#yiv9025404140 #yiv9025404140ygrp-msg p a {
font-family:Verdana;}

#yiv9025404140 #yiv9025404140ygrp-msg
p#yiv9025404140attach-count span {
color:#1E66AE;font-weight:700;}

#yiv9025404140 #yiv9025404140ygrp-reco
#yiv9025404140reco-head {
color:#ff7900;font-weight:700;}

#yiv9025404140 #yiv9025404140ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv9025404140 #yiv9025404140ygrp-sponsor #yiv9025404140ov
li a {
font-size:130%;text-decoration:none;}

#yiv9025404140 #yiv9025404140ygrp-sponsor #yiv9025404140ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv9025404140 #yiv9025404140ygrp-sponsor #yiv9025404140ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv9025404140 #yiv9025404140ygrp-text {
font-family:Georgia;}

#yiv9025404140 #yiv9025404140ygrp-text p {
margin:0 0 1em 0;}

#yiv9025404140 #yiv9025404140ygrp-text tt {
font-size:120%;}

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