8 Messages
Digest #4139
1c
Re: 2 formula just stopped working right and now give me "error"..wh by "Randy Harmelink" rharmelink
Messages
Mon Sep 4, 2017 11:17 pm (PDT) . Posted by:
zbgb952
Hello Randy,
I just started getting "error" for 2 columns in my spreadsheets using the following formulae:
1. =IF($D12="","", RCHGetYahooQuotes($D12,G$9) )
Where $D12 is the stock ticker symbol, And G$9 is "I1". This should give me the last closing
price, but it now gives me "error"
2. IF($D12="","",RCHGetYahooQuotes($D12,E$9) )
Where $D12 is the stock ticker symbol, and E$9 is "n" . This should give me the name of the
company, but it now is giving me "error"
Both of these worked earlier today (it is now 11:16 PM on Monday)..but aren't now.
Any advise on these?
Thanks.
Morey
I just started getting "error" for 2 columns in my spreadsheets using the following formulae:
1. =IF($D12="
Where $D12 is the stock ticker symbol, And G$9 is "I1"
price, but it now gives me "error"
2. IF($D12="
Where $D12 is the stock ticker symbol, and E$9 is "n" . This should give me the name of the
company, but it now is giving me "error"
Both of these worked earlier today (it is now 11:16 PM on Monday)..but aren't now.
Any advise on these?
Thanks.
Morey
Mon Sep 4, 2017 11:36 pm (PDT) . Posted by:
zbgb952
Interesting. I just deleted the formulas and retyped them in and it worked. Didn't change anything.
Tue Sep 5, 2017 6:36 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just tried this:
=RCHGetYahooQuotes("MMM","l1")
...and it's working fine here. Not sure what could be causing your issue.
Does the above formula work for you? Have you tried exiting and restarting
EXCEL? What ticker symbol were you using?
On Mon, Sep 4, 2017 at 11:17 PM, mb0329@
...
wrote:
> I just started getting "error" for 2 columns in my spreadsheets using the
> following formulae:
>
> 1. =IF($D12="","", RCHGetYahooQuotes($D12,G$9) )
>
> Where $D12 is the stock ticker symbol, And G$9 is "I1". This
> should give me the last closing
>
> price, but it now gives me "error"
>
> 2. IF($D12="","",RCHGetYahooQuotes($D12,E$9) )
>
> Where $D12 is the stock ticker symbol, and E$9 is "n" . This should
> give me the name of the
>
> company, but it now is giving me "error"
>
> Both of these worked earlier today (it is now 11:16 PM on Monday)..but
> aren't now.
>
> Any advise on these?
>
>
>
=RCHGetYahooQuotes(
...and it's working fine here. Not sure what could be causing your issue.
Does the above formula work for you? Have you tried exiting and restarting
EXCEL? What ticker symbol were you using?
On Mon, Sep 4, 2017 at 11:17 PM, mb0329@
...
wrote:
> I just started getting "error" for 2 columns in my spreadsheets using the
> following formulae:
>
> 1. =IF($D12="
>
> Where $D12 is the stock ticker symbol, And G$9 is "I1"
> should give me the last closing
>
> price, but it now gives me "error"
>
> 2. IF($D12="
>
> Where $D12 is the stock ticker symbol, and E$9 is "n" . This should
> give me the name of the
>
> company, but it now is giving me "error"
>
> Both of these worked earlier today (it is now 11:16 PM on Monday)..but
> aren't now.
>
> Any advise on these?
>
>
>
Tue Sep 5, 2017 1:54 am (PDT) . Posted by:
grobbiebrink
Again, thanks for a great add-in!
Is the Reuters data still not working?
All my Reuters company specific functions still return 0.
13626
13630
13634
13646
13666
13678
13690
13718
13762
13794
13798
Am I doing something wrong is this still a Reuters issue?
Is the Reuters data still not working?
All my Reuters company specific functions still return 0.
13626
13630
13634
13646
13666
13678
13690
13718
13762
13794
13798
Am I doing something wrong is this still a Reuters issue?
Tue Sep 5, 2017 2:24 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Reuters is still populating with "-", which the add-in converts to a zero
value:
http://www.reuters.com/finance/stocks/financial-highlights/MMM
On Tue, Sep 5, 2017 at 1:22 AM, grobbiebrink@
...
wrote:
> Is the Reuters data still not working?
>
> All my Reuters company specific functions still return 0.
>
> 13626
>
> 13630
>
> 13634
>
> 13646
>
> 13666
>
> 13678
>
> 13690
>
> 13718
>
> 13762
>
> 13794
>
> 13798
>
> Am I doing something wrong is this still a Reuters issue?
>
value:
http://www.reuters.com/finance/stocks/financial-highlights/MMM
On Tue, Sep 5, 2017 at 1:22 AM, grobbiebrink@
...
wrote:
> Is the Reuters data still not working?
>
> All my Reuters company specific functions still return 0.
>
> 13626
>
> 13630
>
> 13634
>
> 13646
>
> 13666
>
> 13678
>
> 13690
>
> 13718
>
> 13762
>
> 13794
>
> 13798
>
> Am I doing something wrong is this still a Reuters issue?
>
Tue Sep 5, 2017 3:39 pm (PDT) . Posted by:
for30sqn
Success at last. The problem turned out to be that two firewalls were turned on, an AVG firewall, and a Windows firewall. I shut down the AVG firewall and everything worked great, even better than it did before all the trouble with Yahoo started.
I'm a bit embarrassed to admit this and want to thank you for all your patience. Your continued support to this group is most appreciated.
I'm a bit embarrassed to admit this and want to thank you for all your patience. Your continued support to this group is most appreciated.
Tue Sep 5, 2017 6:14 pm (PDT) . Posted by:
"Dale Williams" dalewms2
Randy,
I added the the SMF add in to Excel. It is listed as active. For some reason a spreadsheet that worked yesterday doesn't. I am hoping you can help me. I have sent inquiries to the originator.
Thank you
On Monday, September 4, 2017, 2:53:41 PM EDT, Dale Williams <dalewms2@yahoo.com> wrote:
Thanks for responding Randy. I was able to figure it out.
On Monday, September 4, 2017, 1:08:19 PM EDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Sorry, but I can't help you. This is a support forum for the SMF add-in. No products are sold here. I have no idea what you're referring to.
On Mon, Sep 4, 2017 at 5:54 AM, dalewms2@... wrote:
I just purchased the Trend Exhaustion Spreadsheet. I changed the period from m to d and got an error message. Please help.
#yiv2754378873 -- #yiv2754378873ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2754378873 #yiv2754378873ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2754378873 #yiv2754378873ygrp-mkp #yiv2754378873hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2754378873 #yiv2754378873ygrp-mkp #yiv2754378873ads {margin-bottom:10px;}#yiv2754378873 #yiv2754378873ygrp-mkp .yiv2754378873ad {padding:0 0;}#yiv2754378873 #yiv2754378873ygrp-mkp .yiv2754378873ad p {margin:0;}#yiv2754378873 #yiv2754378873ygrp-mkp .yiv2754378873ad a {color:#0000ff;text-decoration:none;}#yiv2754378873 #yiv2754378873ygrp-sponsor #yiv2754378873ygrp-lc {font-family:Arial;}#yiv2754378873 #yiv2754378873ygrp-sponsor #yiv2754378873ygrp-lc #yiv2754378873hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2754378873 #yiv2754378873ygrp-sponsor #yiv2754378873ygrp-lc .yiv2754378873ad {margin-bottom:10px;padding:0 0;}#yiv2754378873 #yiv2754378873actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2754378873 #yiv2754378873activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2754378873 #yiv2754378873activity span {font-weight:700;}#yiv2754378873 #yiv2754378873activity span:first-child {text-transform:uppercase;}#yiv2754378873 #yiv2754378873activity span a {color:#5085b6;text-decoration:none;}#yiv2754378873 #yiv2754378873activity span span {color:#ff7900;}#yiv2754378873 #yiv2754378873activity span .yiv2754378873underline {text-decoration:underline;}#yiv2754378873 .yiv2754378873attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2754378873 .yiv2754378873attach div a {text-decoration:none;}#yiv2754378873 .yiv2754378873attach img {border:none;padding-right:5px;}#yiv2754378873 .yiv2754378873attach label {display:block;margin-bottom:5px;}#yiv2754378873 .yiv2754378873attach label a {text-decoration:none;}#yiv2754378873 blockquote {margin:0 0 0 4px;}#yiv2754378873 .yiv2754378873bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2754378873 .yiv2754378873bold a {text-decoration:none;}#yiv2754378873 dd.yiv2754378873last p a {font-family:Verdana;font-weight:700;}#yiv2754378873 dd.yiv2754378873last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2754378873 dd.yiv2754378873last p span.yiv2754378873yshortcuts {margin-right:0;}#yiv2754378873 div.yiv2754378873attach-table div div a {text-decoration:none;}#yiv2754378873 div.yiv2754378873attach-table {width:400px;}#yiv2754378873 div.yiv2754378873file-title a, #yiv2754378873 div.yiv2754378873file-title a:active, #yiv2754378873 div.yiv2754378873file-title a:hover, #yiv2754378873 div.yiv2754378873file-title a:visited {text-decoration:none;}#yiv2754378873 div.yiv2754378873photo-title a, #yiv2754378873 div.yiv2754378873photo-title a:active, #yiv2754378873 div.yiv2754378873photo-title a:hover, #yiv2754378873 div.yiv2754378873photo-title a:visited {text-decoration:none;}#yiv2754378873 div#yiv2754378873ygrp-mlmsg #yiv2754378873ygrp-msg p a span.yiv2754378873yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2754378873 .yiv2754378873green {color:#628c2a;}#yiv2754378873 .yiv2754378873MsoNormal {margin:0 0 0 0;}#yiv2754378873 o {font-size:0;}#yiv2754378873 #yiv2754378873photos div {float:left;width:72px;}#yiv2754378873 #yiv2754378873photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2754378873 #yiv2754378873photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2754378873 #yiv2754378873reco-category {font-size:77%;}#yiv2754378873 #yiv2754378873reco-desc {font-size:77%;}#yiv2754378873 .yiv2754378873replbq {margin:4px;}#yiv2754378873 #yiv2754378873ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2754378873 #yiv2754378873ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2754378873 #yiv2754378873ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2754378873 #yiv2754378873ygrp-mlmsg select, #yiv2754378873 input, #yiv2754378873 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2754378873 #yiv2754378873ygrp-mlmsg pre, #yiv2754378873 code {font:115% monospace;}#yiv2754378873 #yiv2754378873ygrp-mlmsg * {line-height:1.22em;}#yiv2754378873 #yiv2754378873ygrp-mlmsg #yiv2754378873logo {padding-bottom:10px;}#yiv2754378873 #yiv2754378873ygrp-msg p a {font-family:Verdana;}#yiv2754378873 #yiv2754378873ygrp-msg p#yiv2754378873attach-count span {color:#1E66AE;font-weight:700;}#yiv2754378873 #yiv2754378873ygrp-reco #yiv2754378873reco-head {color:#ff7900;font-weight:700;}#yiv2754378873 #yiv2754378873ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2754378873 #yiv2754378873ygrp-sponsor #yiv2754378873ov li a {font-size:130%;text-decoration:none;}#yiv2754378873 #yiv2754378873ygrp-sponsor #yiv2754378873ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2754378873 #yiv2754378873ygrp-sponsor #yiv2754378873ov ul {margin:0;padding:0 0 0 8px;}#yiv2754378873 #yiv2754378873ygrp-text {font-family:Georgia;}#yiv2754378873 #yiv2754378873ygrp-text p {margin:0 0 1em 0;}#yiv2754378873 #yiv2754378873ygrp-text tt {font-size:120%;}#yiv2754378873 #yiv2754378873ygrp-vital ul li:last-child {border-right:none !important;}#yiv2754378873
I added the the SMF add in to Excel. It is listed as active. For some reason a spreadsheet that worked yesterday doesn't. I am hoping you can help me. I have sent inquiries to the originator.
Thank you
On Monday, September 4, 2017, 2:53:41 PM EDT, Dale Williams <dalewms2@yahoo.com> wrote:
Thanks for responding Randy. I was able to figure it out.
On Monday, September 4, 2017, 1:08:19 PM EDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Sorry, but I can't help you. This is a support forum for the SMF add-in. No products are sold here. I have no idea what you're referring to.
On Mon, Sep 4, 2017 at 5:54 AM, dalewms2@... wrote:
I just purchased the Trend Exhaustion Spreadsheet. I changed the period from m to d and got an error message. Please help.
#yiv2754378873 -- #yiv2754378873ygrp-
Attachment(s) from Dale Williams
1 of 1 File(s)
Tue Sep 5, 2017 7:06 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
What is not working for you? Specifically?
I don't see how this would have worked yesterday if you added the add-in
later...an add-in function should return the #NAME? error if the add-in
hasn't been installed.
On Tue, Sep 5, 2017 at 6:14 PM, Dale Williams dalewms2@
...
wrote:
>
> I added the the SMF add in to Excel. It is listed as active. For some
> reason a spreadsheet that worked yesterday doesn't. I am hoping you can
> help me. I have sent inquiries to the originator.
>
>
I don't see how this would have worked yesterday if you added the add-in
later...an add-in function should return the #NAME? error if the add-in
hasn't been installed.
On Tue, Sep 5, 2017 at 6:14 PM, Dale Williams dalewms2@
...
wrote:
>
> I added the the SMF add in to Excel. It is listed as active. For some
> reason a spreadsheet that worked yesterday doesn't. I am hoping you can
> help me. I have sent inquiries to the originator.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar