15 Messages
Digest #3971
1.9
Fw: [smf_addin] Re: Recent File updates on the SMF Add-in Website by "Michael Thomas" thomas91112
1.10
Re: Fw: [smf_addin] Re: Recent File updates on the SMF Add-in Websit by "Randy Harmelink" rharmelink
1.12
Re: Fw: [smf_addin] Re: Recent File updates on the SMF Add-in Websit by "Michael Thomas" thomas91112
Messages
Mon Apr 17, 2017 7:54 pm (PDT) . Posted by:
eadamy
Thank you for the heavy lifting and sharing your code. I fear that one of these days, V is going to pull the plug on Yahoo Historical Quotes for economic reasons.
Earl Adamy
Earl Adamy
Tue Apr 18, 2017 6:34 am (PDT) . Posted by:
"Madhu Khemani" madhu_98
blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px #715FFA solid !important; padding-left:1ex !important; background-color:white !important; } Is there a Plan B if (when) Yahoo Historical Quotes goes dark?
Sent from Yahoo Mail for iPhone
On Monday, April 17, 2017, 10:54 PM, earladamy@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Thank you for the heavy lifting and sharing your code. I fear that one of these days, V is going to pull the plug on Yahoo Historical Quotes for economic reasons.
Earl Adamy #yiv6519995346 #yiv6519995346 -- #yiv6519995346ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6519995346 #yiv6519995346ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6519995346 #yiv6519995346ygrp-mkp #yiv6519995346hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6519995346 #yiv6519995346ygrp-mkp #yiv6519995346ads {margin-bottom:10px;}#yiv6519995346 #yiv6519995346ygrp-mkp .yiv6519995346ad {padding:0 0;}#yiv6519995346 #yiv6519995346ygrp-mkp .yiv6519995346ad p {margin:0;}#yiv6519995346 #yiv6519995346ygrp-mkp .yiv6519995346ad a {color:#0000ff;text-decoration:none;}#yiv6519995346 #yiv6519995346ygrp-sponsor #yiv6519995346ygrp-lc {font-family:Arial;}#yiv6519995346 #yiv6519995346ygrp-sponsor #yiv6519995346ygrp-lc #yiv6519995346hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6519995346 #yiv6519995346ygrp-sponsor #yiv6519995346ygrp-lc .yiv6519995346ad {margin-bottom:10px;padding:0 0;}#yiv6519995346 #yiv6519995346actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6519995346 #yiv6519995346activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6519995346 #yiv6519995346activity span {font-weight:700;}#yiv6519995346 #yiv6519995346activity span:first-child {text-transform:uppercase;}#yiv6519995346 #yiv6519995346activity span a {color:#5085b6;text-decoration:none;}#yiv6519995346 #yiv6519995346activity span span {color:#ff7900;}#yiv6519995346 #yiv6519995346activity span .yiv6519995346underline {text-decoration:underline;}#yiv6519995346 .yiv6519995346attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6519995346 .yiv6519995346attach div a {text-decoration:none;}#yiv6519995346 .yiv6519995346attach img {border:none;padding-right:5px;}#yiv6519995346 .yiv6519995346attach label {display:block;margin-bottom:5px;}#yiv6519995346 .yiv6519995346attach label a {text-decoration:none;}#yiv6519995346 blockquote {margin:0 0 0 4px;}#yiv6519995346 .yiv6519995346bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6519995346 .yiv6519995346bold a {text-decoration:none;}#yiv6519995346 dd.yiv6519995346last p a {font-family:Verdana;font-weight:700;}#yiv6519995346 dd.yiv6519995346last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6519995346 dd.yiv6519995346last p span.yiv6519995346yshortcuts {margin-right:0;}#yiv6519995346 div.yiv6519995346attach-table div div a {text-decoration:none;}#yiv6519995346 div.yiv6519995346attach-table {width:400px;}#yiv6519995346 div.yiv6519995346file-title a, #yiv6519995346 div.yiv6519995346file-title a:active, #yiv6519995346 div.yiv6519995346file-title a:hover, #yiv6519995346 div.yiv6519995346file-title a:visited {text-decoration:none;}#yiv6519995346 div.yiv6519995346photo-title a, #yiv6519995346 div.yiv6519995346photo-title a:active, #yiv6519995346 div.yiv6519995346photo-title a:hover, #yiv6519995346 div.yiv6519995346photo-title a:visited {text-decoration:none;}#yiv6519995346 div#yiv6519995346ygrp-mlmsg #yiv6519995346ygrp-msg p a span.yiv6519995346yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6519995346 .yiv6519995346green {color:#628c2a;}#yiv6519995346 .yiv6519995346MsoNormal {margin:0 0 0 0;}#yiv6519995346 o {font-size:0;}#yiv6519995346 #yiv6519995346photos div {float:left;width:72px;}#yiv6519995346 #yiv6519995346photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6519995346 #yiv6519995346photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6519995346 #yiv6519995346reco-category {font-size:77%;}#yiv6519995346 #yiv6519995346reco-desc {font-size:77%;}#yiv6519995346 .yiv6519995346replbq {margin:4px;}#yiv6519995346 #yiv6519995346ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6519995346 #yiv6519995346ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6519995346 #yiv6519995346ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6519995346 #yiv6519995346ygrp-mlmsg select, #yiv6519995346 input, #yiv6519995346 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6519995346 #yiv6519995346ygrp-mlmsg pre, #yiv6519995346 code {font:115% monospace;}#yiv6519995346 #yiv6519995346ygrp-mlmsg * {line-height:1.22em;}#yiv6519995346 #yiv6519995346ygrp-mlmsg #yiv6519995346logo {padding-bottom:10px;}#yiv6519995346 #yiv6519995346ygrp-msg p a {font-family:Verdana;}#yiv6519995346 #yiv6519995346ygrp-msg p#yiv6519995346attach-count span {color:#1E66AE;font-weight:700;}#yiv6519995346 #yiv6519995346ygrp-reco #yiv6519995346reco-head {color:#ff7900;font-weight:700;}#yiv6519995346 #yiv6519995346ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6519995346 #yiv6519995346ygrp-sponsor #yiv6519995346ov li a {font-size:130%;text-decoration:none;}#yiv6519995346 #yiv6519995346ygrp-sponsor #yiv6519995346ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6519995346 #yiv6519995346ygrp-sponsor #yiv6519995346ov ul {margin:0;padding:0 0 0 8px;}#yiv6519995346 #yiv6519995346ygrp-text {font-family:Georgia;}#yiv6519995346 #yiv6519995346ygrp-text p {margin:0 0 1em 0;}#yiv6519995346 #yiv6519995346ygrp-text tt {font-size:120%;}#yiv6519995346 #yiv6519995346ygrp-vital ul li:last-child {border-right:none !important;}#yiv6519995346
Sent from Yahoo Mail for iPhone
On Monday, April 17, 2017, 10:54 PM, earladamy@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Thank you for the heavy lifting and sharing your code. I fear that one of these days, V is going to pull the plug on Yahoo Historical Quotes for economic reasons.
Earl Adamy #yiv6519995346 #yiv6519995346 -- #yiv6519995346ygrp-
Tue Apr 18, 2017 10:34 am (PDT) . Posted by:
pjwdoyle
Hi, many thanks to Randy for all the hard work, but I still see the 2017.04.15 version of the file on ogres-crypt. Should it be updated to 2017.04.17?
Thanks!
Thanks!
Tue Apr 18, 2017 10:38 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You mean the old 2017.03.15? You're probably seeing a cached version of the
web page. Try a Ctrl+F5 to do a force cache refresh...
On Tue, Apr 18, 2017 at 10:34 AM, pjwdoyle@
...wrote:
>
> Hi, many thanks to Randy for all the hard work, but I still see the
> 2017.04.15 version of the file on ogres-crypt. Should it be updated to
> 2017.04.17?
>
web page. Try a Ctrl+F5 to do a force cache refresh...
On Tue, Apr 18, 2017 at 10:34 AM, pjwdoyle@
...wrote:
>
> Hi, many thanks to Randy for all the hard work, but I still see the
> 2017.04.15 version of the file on ogres-crypt. Should it be updated to
> 2017.04.17?
>
Tue Apr 18, 2017 3:14 pm (PDT) . Posted by:
"Michael Thomas" thomas91112
Have tried the update and ran GetElement to check and received back
| Stock Market Functions add-in, Version 2.1.2017.04.17 (C:\SMF Add-In; Windows (32-bit) NT 6.02; 12.0; ; ; 1)
|
Yet, all RCHGetYahooHistory values are #NAME? Have run SMFForceRecalculation with same results.
What to do?ThanksMike
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, April 18, 2017 10:38 AM
Subject: Re: [smf_addin] Re: Recent File updates on the SMF Add-in Website
You mean the old 2017.03.15? You're probably seeing a cached version of the web page. Try a Ctrl+F5 to do a force cache refresh...
On Tue, Apr 18, 2017 at 10:34 AM, pjwdoyle@...wrote:
Hi, many thanks to Randy for all the hard work, but I still see the 2017.04.15 version of the file on ogres-crypt. Should it be updated to 2017.04.17?
#yiv9439638521 #yiv9439638521 -- #yiv9439638521ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9439638521 #yiv9439638521ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9439638521 #yiv9439638521ygrp-mkp #yiv9439638521hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9439638521 #yiv9439638521ygrp-mkp #yiv9439638521ads {margin-bottom:10px;}#yiv9439638521 #yiv9439638521ygrp-mkp .yiv9439638521ad {padding:0 0;}#yiv9439638521 #yiv9439638521ygrp-mkp .yiv9439638521ad p {margin:0;}#yiv9439638521 #yiv9439638521ygrp-mkp .yiv9439638521ad a {color:#0000ff;text-decoration:none;}#yiv9439638521 #yiv9439638521ygrp-sponsor #yiv9439638521ygrp-lc {font-family:Arial;}#yiv9439638521 #yiv9439638521ygrp-sponsor #yiv9439638521ygrp-lc #yiv9439638521hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9439638521 #yiv9439638521ygrp-sponsor #yiv9439638521ygrp-lc .yiv9439638521ad {margin-bottom:10px;padding:0 0;}#yiv9439638521 #yiv9439638521actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9439638521 #yiv9439638521activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9439638521 #yiv9439638521activity span {font-weight:700;}#yiv9439638521 #yiv9439638521activity span:first-child {text-transform:uppercase;}#yiv9439638521 #yiv9439638521activity span a {color:#5085b6;text-decoration:none;}#yiv9439638521 #yiv9439638521activity span span {color:#ff7900;}#yiv9439638521 #yiv9439638521activity span .yiv9439638521underline {text-decoration:underline;}#yiv9439638521 .yiv9439638521attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9439638521 .yiv9439638521attach div a {text-decoration:none;}#yiv9439638521 .yiv9439638521attach img {border:none;padding-right:5px;}#yiv9439638521 .yiv9439638521attach label {display:block;margin-bottom:5px;}#yiv9439638521 .yiv9439638521attach label a {text-decoration:none;}#yiv9439638521 blockquote {margin:0 0 0 4px;}#yiv9439638521 .yiv9439638521bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9439638521 .yiv9439638521bold a {text-decoration:none;}#yiv9439638521 dd.yiv9439638521last p a {font-family:Verdana;font-weight:700;}#yiv9439638521 dd.yiv9439638521last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9439638521 dd.yiv9439638521last p span.yiv9439638521yshortcuts {margin-right:0;}#yiv9439638521 div.yiv9439638521attach-table div div a {text-decoration:none;}#yiv9439638521 div.yiv9439638521attach-table {width:400px;}#yiv9439638521 div.yiv9439638521file-title a, #yiv9439638521 div.yiv9439638521file-title a:active, #yiv9439638521 div.yiv9439638521file-title a:hover, #yiv9439638521 div.yiv9439638521file-title a:visited {text-decoration:none;}#yiv9439638521 div.yiv9439638521photo-title a, #yiv9439638521 div.yiv9439638521photo-title a:active, #yiv9439638521 div.yiv9439638521photo-title a:hover, #yiv9439638521 div.yiv9439638521photo-title a:visited {text-decoration:none;}#yiv9439638521 div#yiv9439638521ygrp-mlmsg #yiv9439638521ygrp-msg p a span.yiv9439638521yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9439638521 .yiv9439638521green {color:#628c2a;}#yiv9439638521 .yiv9439638521MsoNormal {margin:0 0 0 0;}#yiv9439638521 o {font-size:0;}#yiv9439638521 #yiv9439638521photos div {float:left;width:72px;}#yiv9439638521 #yiv9439638521photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9439638521 #yiv9439638521photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9439638521 #yiv9439638521reco-category {font-size:77%;}#yiv9439638521 #yiv9439638521reco-desc {font-size:77%;}#yiv9439638521 .yiv9439638521replbq {margin:4px;}#yiv9439638521 #yiv9439638521ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9439638521 #yiv9439638521ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9439638521 #yiv9439638521ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9439638521 #yiv9439638521ygrp-mlmsg select, #yiv9439638521 input, #yiv9439638521 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9439638521 #yiv9439638521ygrp-mlmsg pre, #yiv9439638521 code {font:115% monospace;}#yiv9439638521 #yiv9439638521ygrp-mlmsg * {line-height:1.22em;}#yiv9439638521 #yiv9439638521ygrp-mlmsg #yiv9439638521logo {padding-bottom:10px;}#yiv9439638521 #yiv9439638521ygrp-msg p a {font-family:Verdana;}#yiv9439638521 #yiv9439638521ygrp-msg p#yiv9439638521attach-count span {color:#1E66AE;font-weight:700;}#yiv9439638521 #yiv9439638521ygrp-reco #yiv9439638521reco-head {color:#ff7900;font-weight:700;}#yiv9439638521 #yiv9439638521ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9439638521 #yiv9439638521ygrp-sponsor #yiv9439638521ov li a {font-size:130%;text-decoration:none;}#yiv9439638521 #yiv9439638521ygrp-sponsor #yiv9439638521ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9439638521 #yiv9439638521ygrp-sponsor #yiv9439638521ov ul {margin:0;padding:0 0 0 8px;}#yiv9439638521 #yiv9439638521ygrp-text {font-family:Georgia;}#yiv9439638521 #yiv9439638521ygrp-text p {margin:0 0 1em 0;}#yiv9439638521 #yiv9439638521ygrp-text tt {font-size:120%;}#yiv9439638521 #yiv9439638521ygrp-vital ul li:last-child {border-right:none !important;}#yiv9439638521
| Stock Market Functions add-in, Version 2.1.2017.04.17 (C:\SMF Add-In; Windows (32-bit) NT 6.02; 12.0; ; ; 1)
|
Yet, all RCHGetYahooHistory values are #NAME? Have run SMFForceRecalculation with same results.
What to do?ThanksMike
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, April 18, 2017 10:38 AM
Subject: Re: [smf_addin] Re: Recent File updates on the SMF Add-in Website
You mean the old 2017.03.15? You're probably seeing a cached version of the web page. Try a Ctrl+F5 to do a force cache refresh...
On Tue, Apr 18, 2017 at 10:34 AM, pjwdoyle@...wrote:
Hi, many thanks to Randy for all the hard work, but I still see the 2017.04.15 version of the file on ogres-crypt. Should it be updated to 2017.04.17?
#yiv9439638521 #yiv9439638521 -- #yiv9439638521ygrp-
Tue Apr 18, 2017 3:32 pm (PDT) . Posted by:
"Michael Thomas" thomas91112
Haven't seen this before! With the update today, ALL SMF functions have a new tag added onto them, for example, my old RCHGetYahooHistory tag for the Dow Jones Average now reads='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooHistory(DL1,DL4,DL5,1,B2,B3,B4,"m","A",0,0,1)
C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla' has been added to ALL entries whether absolute or array entered.
Any ideas on how to remedy this?
Mike
----- Forwarded Message -----
From: "Michael Thomas thomas91112@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com>
To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
Sent: Tuesday, April 18, 2017 3:14 PM
Subject: Re: [smf_addin] Re: Recent File updates on the SMF Add-in Website
Have tried the update and ran GetElement to check and received back
| Stock Market Functions add-in, Version 2.1.2017.04.17 (C:\SMF Add-In; Windows (32-bit) NT 6.02; 12.0; ; ; 1)
|
Yet, all RCHGetYahooHistory values are #NAME? Have run SMFForceRecalculation with same results.
What to do?ThanksMike
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, April 18, 2017 10:38 AM
Subject: Re: [smf_addin] Re: Recent File updates on the SMF Add-in Website
You mean the old 2017.03.15? You're probably seeing a cached version of the web page. Try a Ctrl+F5 to do a force cache refresh...
On Tue, Apr 18, 2017 at 10:34 AM, pjwdoyle@...wrote:
Hi, many thanks to Randy for all the hard work, but I still see the 2017.04.15 version of the file on ogres-crypt. Should it be updated to 2017.04.17?
#yiv9179427220 #yiv9179427220 -- #yiv9179427220ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9179427220 #yiv9179427220ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9179427220 #yiv9179427220ygrp-mkp #yiv9179427220hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9179427220 #yiv9179427220ygrp-mkp #yiv9179427220ads {margin-bottom:10px;}#yiv9179427220 #yiv9179427220ygrp-mkp .yiv9179427220ad {padding:0 0;}#yiv9179427220 #yiv9179427220ygrp-mkp .yiv9179427220ad p {margin:0;}#yiv9179427220 #yiv9179427220ygrp-mkp .yiv9179427220ad a {color:#0000ff;text-decoration:none;}#yiv9179427220 #yiv9179427220ygrp-sponsor #yiv9179427220ygrp-lc {font-family:Arial;}#yiv9179427220 #yiv9179427220ygrp-sponsor #yiv9179427220ygrp-lc #yiv9179427220hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9179427220 #yiv9179427220ygrp-sponsor #yiv9179427220ygrp-lc .yiv9179427220ad {margin-bottom:10px;padding:0 0;}#yiv9179427220 #yiv9179427220actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9179427220 #yiv9179427220activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9179427220 #yiv9179427220activity span {font-weight:700;}#yiv9179427220 #yiv9179427220activity span:first-child {text-transform:uppercase;}#yiv9179427220 #yiv9179427220activity span a {color:#5085b6;text-decoration:none;}#yiv9179427220 #yiv9179427220activity span span {color:#ff7900;}#yiv9179427220 #yiv9179427220activity span .yiv9179427220underline {text-decoration:underline;}#yiv9179427220 .yiv9179427220attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9179427220 .yiv9179427220attach div a {text-decoration:none;}#yiv9179427220 .yiv9179427220attach img {border:none;padding-right:5px;}#yiv9179427220 .yiv9179427220attach label {display:block;margin-bottom:5px;}#yiv9179427220 .yiv9179427220attach label a {text-decoration:none;}#yiv9179427220 blockquote {margin:0 0 0 4px;}#yiv9179427220 .yiv9179427220bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9179427220 .yiv9179427220bold a {text-decoration:none;}#yiv9179427220 dd.yiv9179427220last p a {font-family:Verdana;font-weight:700;}#yiv9179427220 dd.yiv9179427220last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9179427220 dd.yiv9179427220last p span.yiv9179427220yshortcuts {margin-right:0;}#yiv9179427220 div.yiv9179427220attach-table div div a {text-decoration:none;}#yiv9179427220 div.yiv9179427220attach-table {width:400px;}#yiv9179427220 div.yiv9179427220file-title a, #yiv9179427220 div.yiv9179427220file-title a:active, #yiv9179427220 div.yiv9179427220file-title a:hover, #yiv9179427220 div.yiv9179427220file-title a:visited {text-decoration:none;}#yiv9179427220 div.yiv9179427220photo-title a, #yiv9179427220 div.yiv9179427220photo-title a:active, #yiv9179427220 div.yiv9179427220photo-title a:hover, #yiv9179427220 div.yiv9179427220photo-title a:visited {text-decoration:none;}#yiv9179427220 div#yiv9179427220ygrp-mlmsg #yiv9179427220ygrp-msg p a span.yiv9179427220yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9179427220 .yiv9179427220green {color:#628c2a;}#yiv9179427220 .yiv9179427220MsoNormal {margin:0 0 0 0;}#yiv9179427220 o {font-size:0;}#yiv9179427220 #yiv9179427220photos div {float:left;width:72px;}#yiv9179427220 #yiv9179427220photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9179427220 #yiv9179427220photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9179427220 #yiv9179427220reco-category {font-size:77%;}#yiv9179427220 #yiv9179427220reco-desc {font-size:77%;}#yiv9179427220 .yiv9179427220replbq {margin:4px;}#yiv9179427220 #yiv9179427220ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9179427220 #yiv9179427220ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9179427220 #yiv9179427220ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9179427220 #yiv9179427220ygrp-mlmsg select, #yiv9179427220 input, #yiv9179427220 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9179427220 #yiv9179427220ygrp-mlmsg pre, #yiv9179427220 code {font:115% monospace;}#yiv9179427220 #yiv9179427220ygrp-mlmsg * {line-height:1.22em;}#yiv9179427220 #yiv9179427220ygrp-mlmsg #yiv9179427220logo {padding-bottom:10px;}#yiv9179427220 #yiv9179427220ygrp-msg p a {font-family:Verdana;}#yiv9179427220 #yiv9179427220ygrp-msg p#yiv9179427220attach-count span {color:#1E66AE;font-weight:700;}#yiv9179427220 #yiv9179427220ygrp-reco #yiv9179427220reco-head {color:#ff7900;font-weight:700;}#yiv9179427220 #yiv9179427220ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9179427220 #yiv9179427220ygrp-sponsor #yiv9179427220ov li a {font-size:130%;text-decoration:none;}#yiv9179427220 #yiv9179427220ygrp-sponsor #yiv9179427220ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9179427220 #yiv9179427220ygrp-sponsor #yiv9179427220ov ul {margin:0;padding:0 0 0 8px;}#yiv9179427220 #yiv9179427220ygrp-text {font-family:Georgia;}#yiv9179427220 #yiv9179427220ygrp-text p {margin:0 0 1em 0;}#yiv9179427220 #yiv9179427220ygrp-text tt {font-size:120%;}#yiv9179427220 #yiv9179427220ygrp-vital ul li:last-child {border-right:none !important;}#yiv9179427220
C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla' has been added to ALL entries whether absolute or array entered.
Any ideas on how to remedy this?
Mike
----- Forwarded Message -----
From: "Michael Thomas thomas91112@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com>
To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
Sent: Tuesday, April 18, 2017 3:14 PM
Subject: Re: [smf_addin] Re: Recent File updates on the SMF Add-in Website
Have tried the update and ran GetElement to check and received back
| Stock Market Functions add-in, Version 2.1.2017.04.17 (C:\SMF Add-In; Windows (32-bit) NT 6.02; 12.0; ; ; 1)
|
Yet, all RCHGetYahooHistory values are #NAME? Have run SMFForceRecalculation with same results.
What to do?ThanksMike
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, April 18, 2017 10:38 AM
Subject: Re: [smf_addin] Re: Recent File updates on the SMF Add-in Website
You mean the old 2017.03.15? You're probably seeing a cached version of the web page. Try a Ctrl+F5 to do a force cache refresh...
On Tue, Apr 18, 2017 at 10:34 AM, pjwdoyle@...wrote:
Hi, many thanks to Randy for all the hard work, but I still see the 2017.04.15 version of the file on ogres-crypt. Should it be updated to 2017.04.17?
#yiv9179427220 #yiv9179427220 -- #yiv9179427220ygrp-
Tue Apr 18, 2017 3:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It looks like you have location errors. You must have moved the location
of the add-in.
The prefixes on your formulas are a result of the workbook being saved with
the add-in in the cited location. That is:
>> C:\Program Files\SMF Add-In
However, your "Version" result says the add-in is in this location:
>> C:\SMF Add-In
Since the add-in is now in a different location, EXCEL flags those formulas
as having unresolved links, and deactivates them until the links are fixed.
A quick fix SHOULD be to simply run the smfFixLinks macro that is located
in the add-in.
On Tue, Apr 18, 2017 at 3:14 PM, Michael Thomas thomas91112@
...wrote:
>
> Have tried the update and ran GetElement to check and received back
> Stock Market Functions add-in, Version 2.1.2017.04.17 (
>
> C:\SMF Add-In; Windows (32-bit) NT 6.02; 12.0; ; ; 1)
> Yet, all RCHGetYahooHistory values are #NAME? Have run
> SMFForceRecalculation with same results.
> What to do?
>
On Tue, Apr 18, 2017 at 3:32 PM, Michael Thomas thomas91112@
...wrote:
>
> Haven't seen this before! With the update today, ALL SMF functions have a
> new tag added onto them, for example, my old RCHGetYahooHistory tag for the
> Dow Jones Average now reads
> ='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!
> RCHGetYahooHistory(DL1,DL4,DL5,1,B2,B3,B4,"m","A",0,0,1)
>
>
>
> ' has been added to ALL entries whether absolute or array entered.
>
> Any ideas on how to remedy this?
>
>
>
of the add-in.
The prefixes on your formulas are a result of the workbook being saved with
the add-in in the cited location. That is:
>> C:\Program Files\SMF Add-In
However, your "Version" result says the add-in is in this location:
>> C:\SMF Add-In
Since the add-in is now in a different location, EXCEL flags those formulas
as having unresolved links, and deactivates them until the links are fixed.
A quick fix SHOULD be to simply run the smfFixLinks macro that is located
in the add-in.
On Tue, Apr 18, 2017 at 3:14 PM, Michael Thomas thomas91112@
...wrote:
>
> Have tried the update and ran GetElement to check and received back
> Stock Market Functions add-in, Version 2.1.2017.04.
>
> C:\SMF Add-In; Windows (32-bit) NT 6.02; 12.0; ; ; 1)
> Yet, all RCHGetYahooHistory values are #NAME? Have run
> SMFForceRecalculati
> What to do?
>
On Tue, Apr 18, 2017 at 3:32 PM, Michael Thomas thomas91112@
...wrote:
>
> Haven't seen this before! With the update today, ALL SMF functions have a
> new tag added onto them, for example, my old RCHGetYahooHistory tag for the
> Dow Jones Average now reads
> ='C:\
> RCHGetYahooHistory(
>
>
>
> ' has been added to ALL entries whether absolute or array entered.
>
> Any ideas on how to remedy this?
>
>
>
Tue Apr 18, 2017 3:52 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
No plan B at this point. I haven't seen another data source I find
acceptable.
On Tue, Apr 18, 2017 at 6:30 AM, Madhu Khemani madhu_98@
...wrote:
>
> Is there a Plan B if (when) Yahoo Historical Quotes goes dark?
>
>
acceptable.
On Tue, Apr 18, 2017 at 6:30 AM, Madhu Khemani madhu_98@
...wrote:
>
> Is there a Plan B if (when) Yahoo Historical Quotes goes dark?
>
>
Tue Apr 18, 2017 4:27 pm (PDT) . Posted by:
"Michael Thomas" thomas91112
smfFixLinks did the job, suggest you include it in your Documentation section with instructions on how to use it - I had to find a Youtube video to find out how to locate and use it. It wasn't difficult but it would be nice to see it included in Documentation.Thanks for creating such a wonderful service.Mike
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, April 18, 2017 3:51 PM
Subject: Re: Fw: [smf_addin] Re: Recent File updates on the SMF Add-in Website
It looks like you have location errors. You must have moved the location of the add-in.
The prefixes on your formulas are a result of the workbook being saved with the add-in in the cited location. That is:
>> C:\Program Files\SMF Add-In
However, your "Version" result says the add-in is in this location:
>> C:\SMF Add-In
Since the add-in is now in a different location, EXCEL flags those formulas as having unresolved links, and deactivates them until the links are fixed.
A quick fix SHOULD be to simply run the smfFixLinks macro that is located in the add-in.
On Tue, Apr 18, 2017 at 3:14 PM, Michael Thomas thomas91112@...wrote:
Have tried the update and ran GetElement to check and received back
| Stock Market Functions add-in, Version 2.1.2017.04.17 (C:\SMF Add-In; Windows (32-bit) NT 6.02; 12.0; ; ; 1)
|
| Yet, all RCHGetYahooHistory values are #NAME? Have run SMFForceRecalculation with same results.
What to do? |
On Tue, Apr 18, 2017 at 3:32 PM, Michael Thomas thomas91112@...wrote:
Haven't seen this before! With the update today, ALL SMF functions have a new tag added onto them, for example, my old RCHGetYahooHistory tag for the Dow Jones Average now reads='C:\Program Files\SMF Add-In\RCH_Stock_Market_ Functions.xla'! RCHGetYahooHistory(DL1,DL4, DL5,1,B2,B3,B4,"m","A",0,0,1)
' has been added to ALL entries whether absolute or array entered.
Any ideas on how to remedy this?
#yiv0350761317 #yiv0350761317 -- #yiv0350761317ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0350761317 #yiv0350761317ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0350761317 #yiv0350761317ygrp-mkp #yiv0350761317hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0350761317 #yiv0350761317ygrp-mkp #yiv0350761317ads {margin-bottom:10px;}#yiv0350761317 #yiv0350761317ygrp-mkp .yiv0350761317ad {padding:0 0;}#yiv0350761317 #yiv0350761317ygrp-mkp .yiv0350761317ad p {margin:0;}#yiv0350761317 #yiv0350761317ygrp-mkp .yiv0350761317ad a {color:#0000ff;text-decoration:none;}#yiv0350761317 #yiv0350761317ygrp-sponsor #yiv0350761317ygrp-lc {font-family:Arial;}#yiv0350761317 #yiv0350761317ygrp-sponsor #yiv0350761317ygrp-lc #yiv0350761317hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0350761317 #yiv0350761317ygrp-sponsor #yiv0350761317ygrp-lc .yiv0350761317ad {margin-bottom:10px;padding:0 0;}#yiv0350761317 #yiv0350761317actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0350761317 #yiv0350761317activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0350761317 #yiv0350761317activity span {font-weight:700;}#yiv0350761317 #yiv0350761317activity span:first-child {text-transform:uppercase;}#yiv0350761317 #yiv0350761317activity span a {color:#5085b6;text-decoration:none;}#yiv0350761317 #yiv0350761317activity span span {color:#ff7900;}#yiv0350761317 #yiv0350761317activity span .yiv0350761317underline {text-decoration:underline;}#yiv0350761317 .yiv0350761317attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0350761317 .yiv0350761317attach div a {text-decoration:none;}#yiv0350761317 .yiv0350761317attach img {border:none;padding-right:5px;}#yiv0350761317 .yiv0350761317attach label {display:block;margin-bottom:5px;}#yiv0350761317 .yiv0350761317attach label a {text-decoration:none;}#yiv0350761317 blockquote {margin:0 0 0 4px;}#yiv0350761317 .yiv0350761317bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0350761317 .yiv0350761317bold a {text-decoration:none;}#yiv0350761317 dd.yiv0350761317last p a {font-family:Verdana;font-weight:700;}#yiv0350761317 dd.yiv0350761317last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0350761317 dd.yiv0350761317last p span.yiv0350761317yshortcuts {margin-right:0;}#yiv0350761317 div.yiv0350761317attach-table div div a {text-decoration:none;}#yiv0350761317 div.yiv0350761317attach-table {width:400px;}#yiv0350761317 div.yiv0350761317file-title a, #yiv0350761317 div.yiv0350761317file-title a:active, #yiv0350761317 div.yiv0350761317file-title a:hover, #yiv0350761317 div.yiv0350761317file-title a:visited {text-decoration:none;}#yiv0350761317 div.yiv0350761317photo-title a, #yiv0350761317 div.yiv0350761317photo-title a:active, #yiv0350761317 div.yiv0350761317photo-title a:hover, #yiv0350761317 div.yiv0350761317photo-title a:visited {text-decoration:none;}#yiv0350761317 div#yiv0350761317ygrp-mlmsg #yiv0350761317ygrp-msg p a span.yiv0350761317yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0350761317 .yiv0350761317green {color:#628c2a;}#yiv0350761317 .yiv0350761317MsoNormal {margin:0 0 0 0;}#yiv0350761317 o {font-size:0;}#yiv0350761317 #yiv0350761317photos div {float:left;width:72px;}#yiv0350761317 #yiv0350761317photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0350761317 #yiv0350761317photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0350761317 #yiv0350761317reco-category {font-size:77%;}#yiv0350761317 #yiv0350761317reco-desc {font-size:77%;}#yiv0350761317 .yiv0350761317replbq {margin:4px;}#yiv0350761317 #yiv0350761317ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0350761317 #yiv0350761317ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0350761317 #yiv0350761317ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0350761317 #yiv0350761317ygrp-mlmsg select, #yiv0350761317 input, #yiv0350761317 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0350761317 #yiv0350761317ygrp-mlmsg pre, #yiv0350761317 code {font:115% monospace;}#yiv0350761317 #yiv0350761317ygrp-mlmsg * {line-height:1.22em;}#yiv0350761317 #yiv0350761317ygrp-mlmsg #yiv0350761317logo {padding-bottom:10px;}#yiv0350761317 #yiv0350761317ygrp-msg p a {font-family:Verdana;}#yiv0350761317 #yiv0350761317ygrp-msg p#yiv0350761317attach-count span {color:#1E66AE;font-weight:700;}#yiv0350761317 #yiv0350761317ygrp-reco #yiv0350761317reco-head {color:#ff7900;font-weight:700;}#yiv0350761317 #yiv0350761317ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0350761317 #yiv0350761317ygrp-sponsor #yiv0350761317ov li a {font-size:130%;text-decoration:none;}#yiv0350761317 #yiv0350761317ygrp-sponsor #yiv0350761317ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0350761317 #yiv0350761317ygrp-sponsor #yiv0350761317ov ul {margin:0;padding:0 0 0 8px;}#yiv0350761317 #yiv0350761317ygrp-text {font-family:Georgia;}#yiv0350761317 #yiv0350761317ygrp-text p {margin:0 0 1em 0;}#yiv0350761317 #yiv0350761317ygrp-text tt {font-size:120%;}#yiv0350761317 #yiv0350761317ygrp-vital ul li:last-child {border-right:none !important;}#yiv0350761317
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, April 18, 2017 3:51 PM
Subject: Re: Fw: [smf_addin] Re: Recent File updates on the SMF Add-in Website
It looks like you have location errors. You must have moved the location of the add-in.
The prefixes on your formulas are a result of the workbook being saved with the add-in in the cited location. That is:
>> C:\Program Files\SMF Add-In
However, your "Version" result says the add-in is in this location:
>> C:\SMF Add-In
Since the add-in is now in a different location, EXCEL flags those formulas as having unresolved links, and deactivates them until the links are fixed.
A quick fix SHOULD be to simply run the smfFixLinks macro that is located in the add-in.
On Tue, Apr 18, 2017 at 3:14 PM, Michael Thomas thomas91112@...wrote:
Have tried the update and ran GetElement to check and received back
| Stock Market Functions add-in, Version 2.1.2017.04.
|
| Yet, all RCHGetYahooHistory values are #NAME? Have run SMFForceRecalculati
What to do? |
On Tue, Apr 18, 2017 at 3:32 PM, Michael Thomas thomas91112@...wrote:
Haven't seen this before! With the update today, ALL SMF functions have a new tag added onto them, for example, my old RCHGetYahooHistory tag for the Dow Jones Average now reads='C:
' has been added to ALL entries whether absolute or array entered.
Any ideas on how to remedy this?
#yiv0350761317 #yiv0350761317 -- #yiv0350761317ygrp-
Tue Apr 18, 2017 2:23 pm (PDT) . Posted by:
kjtemplin
I am using Morningstar data elements 886-888 and 890 for some of my analysis and only a few results are valid with most showing "error". For example, for symbol AFSI I get valid results but for symbol AMT, I get an "error" in each pf the 4 cells. The "error" results have been increasing over time.
Question: Is Morningstar changing its addresses internally that renders the old data element obsolete?
Thanks,
Ken Templin
Question: Is Morningstar changing its addresses internally that renders the old data element obsolete?
Thanks,
Ken Templin
Tue Apr 18, 2017 3:48 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It looks like the new beta site for Morningstar is using a protected API to
get the data. That may mean the add-in can't grab the data. For now, it
just looks like files from the old site aren't being kept current?
What I find strange is I get results the opposite of yours -- AFSI has no
valid values, but AMT does:
https://quotes.morningstar.com/stock/c-morningstar-take?t=AMT
https://quotes.morningstar.com/stock/c-morningstar-take?t=AFSI
On Tue, Apr 18, 2017 at 2:23 PM, kjtemplin@
...wrote:
> I am using Morningstar data elements 886-888 and 890 for some of my
> analysis and only a few results are valid with most showing "error". For
> example, for symbol AFSI I get valid results but for symbol AMT, I get an
> "error" in each pf the 4 cells. The "error" results have been increasing
> over time.
>
> Question: Is Morningstar changing its addresses internally that renders
> the old data element obsolete?
>
>
get the data. That may mean the add-in can't grab the data. For now, it
just looks like files from the old site aren't being kept current?
What I find strange is I get results the opposite of yours -- AFSI has no
valid values, but AMT does:
https://quotes.morningstar.com/stock/c-morningstar-take?t=AMT
https://quotes.morningstar.com/stock/c-morningstar-take?t=AFSI
On Tue, Apr 18, 2017 at 2:23 PM, kjtemplin@
...wrote:
> I am using Morningstar data elements 886-888 and 890 for some of my
> analysis and only a few results are valid with most showing "error"
> example, for symbol AFSI I get valid results but for symbol AMT, I get an
> "error" in each pf the 4 cells. The "error" results have been increasing
> over time.
>
> Question: Is Morningstar changing its addresses internally that renders
> the old data element obsolete?
>
>
Tue Apr 18, 2017 3:46 pm (PDT) . Posted by:
bizmark_ee
I am trying to use an older sheet that I used to use the following to grab after-hours quotes from Yahoo and Google (formulas below), but they appear not to work. Can anyone point me to a formula that does work, or an alternative method of grabbing these prices within SMF? (I have just updated to the latest version of the add-in). Thanks.
=smfGetTagContent("http://finance.yahoo.com/q?s="&D40,"span",-1,"yfs_l86_","")
=smfGetTagContent("http://www.google.com/finance?q="&D40,"span",-1,"_el"">")
=smfGetTagContent("http://finance.yahoo.com/q?s="&D40,"span",-1,"yfs_l86_","")
=smfGetTagContent("http://www.google.com/finance?q="&D40,"
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar