4 Messages
Digest #3101
Messages
Mon Jun 23, 2014 11:38 am (PDT) . Posted by:
rogacox
Randy, I'm sure this is dumb. I updated the smf_addin and am getting errors when I load the templates. The Yahoo templates gives me #NAME? errors in all cells when I input a stock symbol even though enabled the spreadsheet data links. I am still getting good numbers when I run my own spreadsheet with the smf_addin functions. Sorry for such a dumb question.
Roger
Roger
Mon Jun 23, 2014 12:09 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Probably just location errors. Check out the location errors item on the
"Tips and FAQs" web page. Or just try the smfFixLinks macro.
On Mon, Jun 23, 2014 at 11:38 AM, rogacox@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Randy, I'm sure this is dumb. I updated the smf_addin and am getting
> errors when I load the templates. The Yahoo templates gives me #NAME?
> errors in all cells when I input a stock symbol even though enabled the
> spreadsheet data links. I am still getting good numbers when I run my own
> spreadsheet with the smf_addin functions. Sorry for such a dumb question.
>
"Tips and FAQs" web page. Or just try the smfFixLinks macro.
On Mon, Jun 23, 2014 at 11:38 AM, rogacox@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Randy, I'm sure this is dumb. I updated the smf_addin and am getting
> errors when I load the templates. The Yahoo templates gives me #NAME?
> errors in all cells when I input a stock symbol even though enabled the
> spreadsheet data links. I am still getting good numbers when I run my own
> spreadsheet with the smf_addin functions. Sorry for such a dumb question.
>
Mon Jun 23, 2014 1:56 pm (PDT) . Posted by:
rogacox
Thanks. That took care of most of the problems, but in the Reuters Template the Performance (at the top) show 2 columns of #VALUE! and 2 columns of undefined. The remainder of the spreadsheet below has Error in the last column under S&P 500. Any ideas. Thanks in advance.
Mon Jun 23, 2014 4:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sounds like you have old element definitions. I just opened up
SMF-Template-Reuters-Ratios-Comparison.xls from the website. For ticker
symbol MMM, all of the performance items are there. They are new statistics
I added in February of this year. For me, the S&P 500 column has "Obsolete"
because Reuters removed that data from their web pages. See the "Works In
Progress" web page for updated element definitions since the last official
release.
On Mon, Jun 23, 2014 at 1:56 PM, rogacox@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks. That took care of most of the problems, but in the Reuters
> Template the Performance (at the top) show 2 columns of #VALUE! and 2
> columns of undefined. The remainder of the spreadsheet below has Error in
> the last column under S&P 500. Any ideas. Thanks in advance.
>
SMF-Template-Reuters-Ratios-Comparison.xls from the website. For ticker
symbol MMM, all of the performance items are there. They are new statistics
I added in February of this year. For me, the S&P 500 column has "Obsolete"
because Reuters removed that data from their web pages. See the "Works In
Progress" web page for updated element definitions since the last official
release.
On Mon, Jun 23, 2014 at 1:56 PM, rogacox@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks. That took care of most of the problems, but in the Reuters
> Template the Performance (at the top) show 2 columns of #VALUE! and 2
> columns of undefined. The remainder of the spreadsheet below has Error in
> the last column under S&P 500. Any ideas. Thanks in advance.
>
Tidak ada komentar:
Posting Komentar