6 Messages
Digest #3900
Messages
Thu Jan 26, 2017 12:43 pm (PST) . Posted by:
joshi_mandar
Thank you very much for quick response. Getting the latest version of the add-in worked for me.
Thu Jan 26, 2017 2:00 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I would suspect most of the elements giving you errors are AdvFN elements.
There are some things that need to be set up in order to access them -- see
the FAQs page for more information on that.
I did go through all of them last year, and obsoleted (or fixed) those that
weren't working.
What data sources are giving you all errors?
On Thu, Jan 19, 2017 at 4:04 PM, loukurrelmeyer@
...wrote:
>
> It has been several years since I works with the RCHGetElementNumber
> formulas. I downloaded the RCH_Stock_Market_Functions-2.1.2016.12.03
> version. I am finding a large number of elements not working.
>
> I see 12,358 total elements.
> I see 184 elements marked as obsolete.
> I find 10,686 return "ERROR" with any of several stocks, funds, or ETFs.
>
> Is it possible that most of the web pages are no longer usable? Or am I
> doing something wrong? I find I can use 1,407 of the element numbers, so I
> know I have installed correctly.
>
There are some things that need to be set up in order to access them -- see
the FAQs page for more information on that.
I did go through all of them last year, and obsoleted (or fixed) those that
weren't working.
What data sources are giving you all errors?
On Thu, Jan 19, 2017 at 4:04 PM, loukurrelmeyer@
...wrote:
>
> It has been several years since I works with the RCHGetElementNumber
> formulas. I downloaded the RCH_Stock_Market_
> version. I am finding a large number of elements not working.
>
> I see 12,358 total elements.
> I see 184 elements marked as obsolete.
> I find 10,686 return "ERROR" with any of several stocks, funds, or ETFs.
>
> Is it possible that most of the web pages are no longer usable? Or am I
> doing something wrong? I find I can use 1,407 of the element numbers, so I
> know I have installed correctly.
>
Thu Jan 26, 2017 2:38 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
As with adelgado, they are working here. I would suspect the IE security
cookie doesn't exist. Remember, logging in with FireFox won't help the
add-in at all. The quickest way to check is to use the Web dialog within
EXCEL (keyboard shortcut alt+d+d+w) to see if it believes you are logged
in...
On Wed, Jan 11, 2017 at 4:53 PM, kjtemplin@
...wrote:
> Question: Is there an issue with Morningstar providing SMF data
> elements? I am getting error messages on data elements 886-888 and 890.
> My spreadsheet is properly linked to my premium account at Morningstar and
> there does not appear to be any change to SMF data elements.
>
>
cookie doesn't exist. Remember, logging in with FireFox won't help the
add-in at all. The quickest way to check is to use the Web dialog within
EXCEL (keyboard shortcut alt+d+d+w) to see if it believes you are logged
in...
On Wed, Jan 11, 2017 at 4:53 PM, kjtemplin@
...wrote:
> Question: Is there an issue with Morningstar providing SMF data
> elements? I am getting error messages on data elements 886-888 and 890.
> My spreadsheet is properly linked to my premium account at Morningstar and
> there does not appear to be any change to SMF data elements.
>
>
Thu Jan 26, 2017 2:40 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
This may be the issue that occurred in July of last year because MicroSoft
issued some security updates. It's not letting EXCEL load the add-in when
EXCEL starts up. As a result, you are getting link errors, because EXCEL
can't resolve the links to the add-in.
For a workaround suggested by Microsoft, until they fix the issue, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
Basically, the unblock process pn3069 suggested.
On Sat, Jan 14, 2017 at 8:11 AM, tnmc77@
...wrote:
>
> I am sorry to bother you but I have started having a new problem. I have
> used the smf addin for years without problem. Now, I have started having a
> problem where the add-In does not load automatically. I have gone through
> all the troubleshooting including asking excel to trust the folder where
> the add-in is. The add-in shows the check mark in the list but does not
> load automatically and work like other add-ins I use. In order to make it
> work, I have to uncheck the add-in, go to browse and reload/re-enable it
> before it works.
>
> I am using windows 10 and the version RCH_Stock_Market_Functions-2.
> 1.2016.09.02
>
issued some security updates. It's not letting EXCEL load the add-in when
EXCEL starts up. As a result, you are getting link errors, because EXCEL
can't resolve the links to the add-in.
For a workaround suggested by Microsoft, until they fix the issue, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
Basically, the unblock process pn3069 suggested.
On Sat, Jan 14, 2017 at 8:11 AM, tnmc77@
...wrote:
>
> I am sorry to bother you but I have started having a new problem. I have
> used the smf addin for years without problem. Now, I have started having a
> problem where the add-In does not load automatically. I have gone through
> all the troubleshooting including asking excel to trust the folder where
> the add-in is. The add-in shows the check mark in the list but does not
> load automatically and work like other add-ins I use. In order to make it
> work, I have to uncheck the add-in, go to browse and reload/re-enable it
> before it works.
>
> I am using windows 10 and the version RCH_Stock_Market_
> 1.2016.09.02
>
--------------------------------------------
On Fri, 1/27/17, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Subject: Re: [smf_addin] SMF Does not auto-load
To: smf_addin@yahoogroups.com
Date: Friday, January 27, 2017, 12:40 AM
This may be the issue that occurred
in July of last year because MicroSoft issued some security
updates. It's not letting EXCEL load the add-in when
EXCEL starts up. As a result, you are getting link errors,
because EXCEL can't resolve the links to the add-in.
For a workaround suggested by
Microsoft, until they fix the issue, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
Basically, the unblock process
pn3069 suggested.
On Sat, Jan 14, 2017 at
8:11 AM, tnmc77@...wrote:
I am sorry to bother you but I have started having a new
problem. I
have used the smf addin for years without problem. Now, I
have
started having a problem where the add-In does not load
automatically. I
have gone through all the troubleshooting including asking
excel to
trust the folder where the add-in is. The add-in shows the
check mark in
the list but does not load automatically and work like
other add-ins I
use. In order to make it work, I have to uncheck the add-in,
go to
browse and reload/re-enable it before it works.
I am using windows 10 and the
version RCH_Stock_Market_
#yiv1504140243 #yiv1504140243 --
#yiv1504140243ygrp-
border:1px solid #d8d8d8;font-
0;padding:0 10px;}
#yiv1504140243 #yiv1504140243ygrp-
border:1px solid #d8d8d8;}
#yiv1504140243 #yiv1504140243ygrp-
color:#628c2a;
0;}
#yiv1504140243 #yiv1504140243ygrp-
margin-bottom:
#yiv1504140243 #yiv1504140243ygrp-
padding:0 0;}
#yiv1504140243 #yiv1504140243ygrp-
margin:0;}
#yiv1504140243 #yiv1504140243ygrp-
color:#0000ff;
#yiv1504140243 #yiv1504140243ygrp-
#yiv1504140243ygrp-
font-family:
#yiv1504140243 #yiv1504140243ygrp-
#yiv1504140243ygrp-
margin:10px
0px;font-weight:
#yiv1504140243 #yiv1504140243ygrp-
#yiv1504140243ygrp-
margin-bottom:
#yiv1504140243 #yiv1504140243actio
font-family:
#yiv1504140243 #yiv1504140243activ
background-color:
#yiv1504140243 #yiv1504140243activ
font-weight:
#yiv1504140243 #yiv1504140243activ
text-transform:
#yiv1504140243 #yiv1504140243activ
color:#5085b6;
#yiv1504140243 #yiv1504140243activ
color:#ff7900;
#yiv1504140243 #yiv1504140243activ
.yiv1504140243under
text-decoration:
#yiv1504140243 .yiv1504140243attac
clear:both;display:
0;width:400px;
#yiv1504140243 .yiv1504140243attac
text-decoration:
#yiv1504140243 .yiv1504140243attac
border:none;
#yiv1504140243 .yiv1504140243attac
display:block;
#yiv1504140243 .yiv1504140243attac
text-decoration:
#yiv1504140243 blockquote {
margin:0 0 0 4px;}
#yiv1504140243 .yiv1504140243bold {
font-family:
#yiv1504140243 .yiv1504140243bold a {
text-decoration:
#yiv1504140243 dd.yiv1504140243las
font-family:
#yiv1504140243 dd.yiv1504140243las
margin-right:
#yiv1504140243 dd.yiv1504140243las
span.yiv1504140243y
margin-right:
#yiv1504140243 div.yiv1504140243at
text-decoration:
#yiv1504140243 div.yiv1504140243at
width:400px;
#yiv1504140243 div.yiv1504140243fi
div.yiv1504140243fi
div.yiv1504140243fi
div.yiv1504140243fi
text-decoration:
#yiv1504140243 div.yiv1504140243ph
#yiv1504140243 div.yiv1504140243ph
#yiv1504140243 div.yiv1504140243ph
#yiv1504140243 div.yiv1504140243ph
text-decoration:
#yiv1504140243 div#yiv1504140243yg
#yiv1504140243ygrp-
font-family:
#yiv1504140243 .yiv1504140243green {
color:#628c2a;
#yiv1504140243 .yiv1504140243MsoNo
margin:0 0 0 0;}
#yiv1504140243 o {
font-size:0;
#yiv1504140243 #yiv1504140243photo
float:left;width:
#yiv1504140243 #yiv1504140243photo
border:1px solid
#666666;height:
#yiv1504140243 #yiv1504140243photo
color:#666666;
#yiv1504140243 #yiv1504140243reco-
font-size:77%
#yiv1504140243 #yiv1504140243reco-
font-size:77%
#yiv1504140243 .yiv1504140243replb
margin:4px;}
#yiv1504140243 #yiv1504140243ygrp-
margin-right:
#yiv1504140243 #yiv1504140243ygrp-
font-size:13px;
sans-serif;}
#yiv1504140243 #yiv1504140243ygrp-
font-size:inherit;
#yiv1504140243 #yiv1504140243ygrp-
#yiv1504140243 input, #yiv1504140243 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv1504140243 #yiv1504140243ygrp-
code {
font:115% monospace;}
#yiv1504140243 #yiv1504140243ygrp-
line-height:
#yiv1504140243 #yiv1504140243ygrp-
padding-bottom:
#yiv1504140243 #yiv1504140243ygrp-
font-family:
#yiv1504140243 #yiv1504140243ygrp-
p#yiv1504140243atta
color:#1E66AE;
#yiv1504140243 #yiv1504140243ygrp-
#yiv1504140243reco-
color:#ff7900;
#yiv1504140243 #yiv1504140243ygrp-
margin-bottom:
#yiv1504140243 #yiv1504140243ygrp-
li a {
font-size:130%
#yiv1504140243 #yiv1504140243ygrp-
li {
font-size:77%
#yiv1504140243 #yiv1504140243ygrp-
ul {
margin:0;padding:
#yiv1504140243 #yiv1504140243ygrp-
font-family:
#yiv1504140243 #yiv1504140243ygrp-
margin:0 0 1em 0;}
#yiv1504140243 #yiv1504140243ygrp-
font-size:120%
#yiv1504140243 #yiv1504140243ygrp-
border-right:
}
#yiv1504140243
atina s-a votat legea drumuri or in 1845 in tara Romaneasca iar in 1847 se
--------------------------------------------
On Fri, 1/27/17, goretitus@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Subject: Re: [smf_addin] SMF Does not auto-load
To: smf_addin@yahoogroups.com
Date: Friday, January 27, 2017, 9:22 AM
--------------------------------------------
On Fri, 1/27/17, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
Subject: Re: [smf_addin] SMF Does not auto-load
To: smf_addin@yahoogroups.com
Date: Friday, January 27, 2017, 12:40 AM
This may be the issue that occurred
in July of last year because MicroSoft issued some
security
updates. It's not letting EXCEL load the add-in when
EXCEL starts up. As a result, you are getting link
errors,
because EXCEL can't resolve the links to the add-in.
For a workaround suggested by
Microsoft, until they fix the issue, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
Basically, the unblock process
pn3069 suggested.
On Sat, Jan 14, 2017 at
8:11 AM, tnmc77@...wrote:
I am sorry to bother you but I have started having a new
problem. I
have used the smf addin for years without problem. Now,
I
have
started having a problem where the add-In does not load
automatically. I
have gone through all the troubleshooting including
asking
excel to
trust the folder where the add-in is. The add-in shows
the
check mark in
the list but does not load automatically and work like
other add-ins I
use. In order to make it work, I have to uncheck the
add-in,
go to
browse and reload/re-enable it before it works.
I am using windows 10 and the
version RCH_Stock_Market_
#yiv1504140243 #yiv1504140243 --
#yiv1504140243ygrp-
border:1px solid #d8d8d8;font-
0;padding:0 10px;}
#yiv1504140243 #yiv1504140243ygrp-
border:1px solid #d8d8d8;}
#yiv1504140243 #yiv1504140243ygrp-
color:#628c2a;
0;}
#yiv1504140243 #yiv1504140243ygrp-
{
margin-bottom:
#yiv1504140243 #yiv1504140243ygrp-
padding:0 0;}
#yiv1504140243 #yiv1504140243ygrp-
{
margin:0;}
#yiv1504140243 #yiv1504140243ygrp-
{
color:#0000ff;
#yiv1504140243 #yiv1504140243ygrp-
#yiv1504140243ygrp-
font-family:
#yiv1504140243 #yiv1504140243ygrp-
#yiv1504140243ygrp-
margin:10px
0px;font-weight:
#yiv1504140243 #yiv1504140243ygrp-
#yiv1504140243ygrp-
margin-bottom:
#yiv1504140243 #yiv1504140243actio
font-family:
#yiv1504140243 #yiv1504140243activ
background-color:
#yiv1504140243 #yiv1504140243activ
font-weight:
#yiv1504140243 #yiv1504140243activ
text-transform:
#yiv1504140243 #yiv1504140243activ
color:#5085b6;
#yiv1504140243 #yiv1504140243activ
color:#ff7900;
#yiv1504140243 #yiv1504140243activ
.yiv1504140243under
text-decoration:
#yiv1504140243 .yiv1504140243attac
clear:both;display:
0;width:400px;
#yiv1504140243 .yiv1504140243attac
text-decoration:
#yiv1504140243 .yiv1504140243attac
border:none;
#yiv1504140243 .yiv1504140243attac
display:block;
#yiv1504140243 .yiv1504140243attac
text-decoration:
#yiv1504140243 blockquote {
margin:0 0 0 4px;}
#yiv1504140243 .yiv1504140243bold {
font-family:
#yiv1504140243 .yiv1504140243bold a {
text-decoration:
#yiv1504140243 dd.yiv1504140243las
font-family:
#yiv1504140243 dd.yiv1504140243las
margin-right:
#yiv1504140243 dd.yiv1504140243las
span.yiv1504140243y
margin-right:
#yiv1504140243 div.yiv1504140243at
text-decoration:
#yiv1504140243 div.yiv1504140243at
width:400px;
#yiv1504140243 div.yiv1504140243fi
#yiv1504140243
div.yiv1504140243fi
div.yiv1504140243fi
div.yiv1504140243fi
text-decoration:
#yiv1504140243 div.yiv1504140243ph
#yiv1504140243 div.yiv1504140243ph
#yiv1504140243 div.yiv1504140243ph
#yiv1504140243 div.yiv1504140243ph
text-decoration:
#yiv1504140243 div#yiv1504140243yg
#yiv1504140243ygrp-
{
font-family:
#yiv1504140243 .yiv1504140243green {
color:#628c2a;
#yiv1504140243 .yiv1504140243MsoNo
margin:0 0 0 0;}
#yiv1504140243 o {
font-size:0;
#yiv1504140243 #yiv1504140243photo
float:left;width:
#yiv1504140243 #yiv1504140243photo
border:1px solid
#666666;height:
#yiv1504140243 #yiv1504140243photo
color:#666666;
#yiv1504140243 #yiv1504140243reco-
font-size:77%
#yiv1504140243 #yiv1504140243reco-
font-size:77%
#yiv1504140243 .yiv1504140243replb
margin:4px;}
#yiv1504140243 #yiv1504140243ygrp-
{
margin-right:
#yiv1504140243 #yiv1504140243ygrp-
font-size:13px;
sans-serif;}
#yiv1504140243 #yiv1504140243ygrp-
font-size:inherit;
#yiv1504140243 #yiv1504140243ygrp-
#yiv1504140243 input, #yiv1504140243 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv1504140243 #yiv1504140243ygrp-
#yiv1504140243
code {
font:115% monospace;}
#yiv1504140243 #yiv1504140243ygrp-
line-height:
#yiv1504140243 #yiv1504140243ygrp-
{
padding-bottom:
#yiv1504140243 #yiv1504140243ygrp-
font-family:
#yiv1504140243 #yiv1504140243ygrp-
p#yiv1504140243atta
color:#1E66AE;
#yiv1504140243 #yiv1504140243ygrp-
#yiv1504140243reco-
color:#ff7900;
#yiv1504140243 #yiv1504140243ygrp-
margin-bottom:
#yiv1504140243 #yiv1504140243ygrp-
#yiv1504140243ov
li a {
font-size:130%
#yiv1504140243 #yiv1504140243ygrp-
#yiv1504140243ov
li {
font-size:77%
#yiv1504140243 #yiv1504140243ygrp-
#yiv1504140243ov
ul {
margin:0;padding:
#yiv1504140243 #yiv1504140243ygrp-
font-family:
#yiv1504140243 #yiv1504140243ygrp-
margin:0 0 1em 0;}
#yiv1504140243 #yiv1504140243ygrp-
font-size:120%
#yiv1504140243 #yiv1504140243ygrp-
{
border-right:
}
#yiv1504140243
atina s-a votat legea drumuri or in 1845 in tara
Romaneasca iar in 1847 se
#yiv0317013730 #yiv0317013730 --
#yiv0317013730ygrp-
border:1px solid #d8d8d8;font-
0;padding:0 10px;}
#yiv0317013730 #yiv0317013730ygrp-
border:1px solid #d8d8d8;}
#yiv0317013730 #yiv0317013730ygrp-
color:#628c2a;
0;}
#yiv0317013730 #yiv0317013730ygrp-
margin-bottom:
#yiv0317013730 #yiv0317013730ygrp-
padding:0 0;}
#yiv0317013730 #yiv0317013730ygrp-
margin:0;}
#yiv0317013730 #yiv0317013730ygrp-
color:#0000ff;
#yiv0317013730 #yiv0317013730ygrp-
#yiv0317013730ygrp-
font-family:
#yiv0317013730 #yiv0317013730ygrp-
#yiv0317013730ygrp-
margin:10px
0px;font-weight:
#yiv0317013730 #yiv0317013730ygrp-
#yiv0317013730ygrp-
margin-bottom:
#yiv0317013730 #yiv0317013730actio
font-family:
#yiv0317013730 #yiv0317013730activ
background-color:
#yiv0317013730 #yiv0317013730activ
font-weight:
#yiv0317013730 #yiv0317013730activ
text-transform:
#yiv0317013730 #yiv0317013730activ
color:#5085b6;
#yiv0317013730 #yiv0317013730activ
color:#ff7900;
#yiv0317013730 #yiv0317013730activ
.yiv0317013730under
text-decoration:
#yiv0317013730 .yiv0317013730attac
clear:both;display: