15 Messages
Digest #4038
1d
Re: Shift f9 nothing happens, hit calculate sheet nothing happens. by "Randy Harmelink" rharmelink
1f
Re: Shift f9 nothing happens, hit calculate sheet nothing happens. by "Randy Harmelink" rharmelink
Messages
Sun May 28, 2017 5:52 am (PDT) . Posted by:
sjagers
I tried the PlugIn Detect tool (http://www.pinlady.net/PluginDetect/IE/ http://www.pinlady.net/PluginDetect/IE/) to see what it revealed:
Using Internet Explorer, I get:
Your browser is IE: true
Your IE browser version: 9
----------------------------------------------------------
True IE browser version (independent of userAgent, document mode, or browser mode): 9.0.8112.16421
IE browser version (derived from navigator.userAgent): 9
IE browser document mode: 9
From within EXCEL (alt+d+d+w), I get:
Your browser is IE: true
Your IE browser version: 9
----------------------------------------------------------
True IE browser version (independent of userAgent, document mode, or browser mode): 9.0.8112.16421
IE browser version (derived from navigator.userAgent): 7
IE browser document mode: 7
So, does this mean the IE object used by my Excel (Office 2007) is IE 7? Is that the same version of IE object that your Excel is using? Can you open Zacks website from within Excel (alt + d + d + w)?
Those GetElementNumbers for Zacks quit working for me sometime after Saturday, 5/13/17. They worked just fine prior to that.
Could Zacks be blocking my access somehow? I cleared my IE cookies, history, web cache, etc. and that did not help. I can't access their website using Internet Explorer, or Excel's web query (alt + d + d + w), but I CAN get there with Firefox.
Thanks for your interest.
Using Internet Explorer, I get:
Your browser is IE: true
Your IE browser version: 9
------------
True IE browser version (independent of userAgent, document mode, or browser mode): 9.0.8112.16421
IE browser version (derived from navigator.userAgent
IE browser document mode: 9
From within EXCEL (alt+d+d+w), I get:
Your browser is IE: true
Your IE browser version: 9
------------
True IE browser version (independent of userAgent, document mode, or browser mode): 9.0.8112.16421
IE browser version (derived from navigator.userAgent
IE browser document mode: 7
So, does this mean the IE object used by my Excel (Office 2007) is IE 7? Is that the same version of IE object that your Excel is using? Can you open Zacks website from within Excel (alt + d + d + w)?
Those GetElementNumbers for Zacks quit working for me sometime after Saturday, 5/13/17. They worked just fine prior to that.
Could Zacks be blocking my access somehow? I cleared my IE cookies, history, web cache, etc. and that did not help. I can't access their website using Internet Explorer, or Excel's web query (alt + d + d + w), but I CAN get there with Firefox.
Thanks for your interest.
Sun May 28, 2017 9:01 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't they are blocking YOUR access. That should be by IP address, and
would probably affect all your devices. More likely, Zacks did something
that is preventing your version of IE that EXCEL is using.
What do you get, if anything, with:
=RCHGetWebData("https://www.zacks.com/stock/quote/mmm")
=RCHGetWebData("https://www.zacks.com/stock/quote/mmm","MMM")
I said it had been working on my old machine, under Vista, but that was
last done well over a month ago, before when your access stopped working.
So it could be they now detect the type of browser or unit agent and stop
it from rendering.
On Sun, May 28, 2017 at 5:52 AM, sjagers@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I tried the PlugIn Detect tool (http://www.pinlady.net/PluginDetect/IE/)
> to see what it revealed:
>
> Using Internet Explorer, I get:
>
> Your browser is IE: true
> Your IE browser version: 9
> ----------------------------------------------------------
> ----------------
> True IE browser version (independent of userAgent, document mode, or
> browser mode): 9.0.8112.16421
> IE browser version (derived from navigator.userAgent): 9
> IE browser document mode: 9
>
> From within EXCEL (alt+d+d+w), I get:
>
> Your browser is IE: true
> Your IE browser version: 9
> ----------------------------------------------------------
> ----------------
> True IE browser version (independent of userAgent, document mode, or
> browser mode): 9.0.8112.16421
> IE browser version (derived from navigator.userAgent): 7
> IE browser document mode: 7
>
> So, does this mean the IE object used by my Excel (Office 2007) is IE 7?
> Is that the same version of IE object that your Excel is using? Can you
> open Zacks website from within Excel (alt + d + d + w)?
>
> Those GetElementNumbers for Zacks quit working for me sometime after
> Saturday, 5/13/17. They worked just fine prior to that.
>
> Could Zacks be blocking my access somehow? I cleared my IE cookies,
> history, web cache, etc. and that did not help. I can't access their
> website using Internet Explorer, or Excel's web query (alt + d + d + w),
> but I CAN get there with Firefox.
>
> Thanks for your interest.
>
would probably affect all your devices. More likely, Zacks did something
that is preventing your version of IE that EXCEL is using.
What do you get, if anything, with:
=RCHGetWebData("https://www.zacks.com/stock/quote/mmm")
=RCHGetWebData("https://www.zacks.com/stock/quote/mmm","MMM")
I said it had been working on my old machine, under Vista, but that was
last done well over a month ago, before when your access stopped working.
So it could be they now detect the type of browser or unit agent and stop
it from rendering.
On Sun, May 28, 2017 at 5:52 AM, sjagers@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I tried the PlugIn Detect tool (http://www.pinlady.net/PluginDetect/IE/)
> to see what it revealed:
>
> Using Internet Explorer, I get:
>
> Your browser is IE: true
> Your IE browser version: 9
> ------------
> ------------
> True IE browser version (independent of userAgent, document mode, or
> browser mode): 9.0.8112.16421
> IE browser version (derived from navigator.userAgent
> IE browser document mode: 9
>
> From within EXCEL (alt+d+d+w), I get:
>
> Your browser is IE: true
> Your IE browser version: 9
> ------------
> ------------
> True IE browser version (independent of userAgent, document mode, or
> browser mode): 9.0.8112.16421
> IE browser version (derived from navigator.userAgent
> IE browser document mode: 7
>
> So, does this mean the IE object used by my Excel (Office 2007) is IE 7?
> Is that the same version of IE object that your Excel is using? Can you
> open Zacks website from within Excel (alt + d + d + w)?
>
> Those GetElementNumbers for Zacks quit working for me sometime after
> Saturday, 5/13/17. They worked just fine prior to that.
>
> Could Zacks be blocking my access somehow? I cleared my IE cookies,
> history, web cache, etc. and that did not help. I can't access their
> website using Internet Explorer, or Excel's web query (alt + d + d + w),
> but I CAN get there with Firefox.
>
> Thanks for your interest.
>
Sun May 28, 2017 9:50 am (PDT) . Posted by:
"Joe" jtassielli2003
Hi Randy,
my version is. downloaded the beta version. However when I hit recalculate, nothing happens. I know the add in is working. Just no recalc.
Trust center set to "enable all Macros" and I unblocked the add in.
Puzzled!
| Stock Market Functions add-in, Version 2.1.2017.05.
Sun May 28, 2017 10:26 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
What are you trying to recalculate?
F9 and shift-F9 don't do anything with most add-in functions. That's
because data is extracted from saved copies of web pages. You need to force
the add-in to get new copies of those web pages. That's done by running the
smfForceRecalculation macro (see the "Tips and FAQs" page for more info).
On Sun, May 28, 2017 at 9:46 AM, Joe jtassielli2003@
...
wrote:
>
> my version is. downloaded the beta version. However when I hit
> recalculate, nothing happens. I know the add in is working. Just no
> recalc.
>
> Trust center set to "enable all Macros" and I unblocked the add in.
>
> Puzzled!
>
> Stock Market Functions add-in, Version 2.1.2017.05.25 (C:\SMF Add-In;
> Windows (32-bit) NT 6.02; 14.0; ; ; 1)
>
>
>
F9 and shift-F9 don't do anything with most add-in functions. That's
because data is extracted from saved copies of web pages. You need to force
the add-in to get new copies of those web pages. That's done by running the
smfForceRecalculati
On Sun, May 28, 2017 at 9:46 AM, Joe jtassielli2003@
...
wrote:
>
> my version is. downloaded the beta version. However when I hit
> recalculate, nothing happens. I know the add in is working. Just no
> recalc.
>
> Trust center set to "enable all Macros" and I unblocked the add in.
>
> Puzzled!
>
> Stock Market Functions add-in, Version 2.1.2017.05.
> Windows (32-bit) NT 6.02; 14.0; ; ; 1)
>
>
>
Sun May 28, 2017 10:47 am (PDT) . Posted by:
"Joe" jtassielli2003
Hi Randy,
I tried recalculating the worksheet. Always worked before. Tried Developer/Tools/Macros/smf force calculation.
Nothing happens.
Joe
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, May 28, 2017 1:27 PM
Subject: Re: [smf_addin] Shift f9 nothing happens, hit calculate sheet nothing happens.
What are you trying to recalculate?
F9 and shift-F9 don't do anything with most add-in functions. That's because data is extracted from saved copies of web pages. You need to force the add-in to get new copies of those web pages. That's done by running the smfForceRecalculation macro (see the "Tips and FAQs" page for more info).
On Sun, May 28, 2017 at 9:46 AM, Joe jtassielli2003@... wrote:
my version is. downloaded the beta version. However when I hit recalculate, nothing happens. I know the add in is working. Just no recalc.
Trust center set to "enable all Macros" and I unblocked the add in.
Puzzled!
| Stock Market Functions add-in, Version 2.1.2017.05.25 (C:\SMF Add-In; Windows (32-bit) NT 6.02; 14.0; ; ; 1) |
#yiv5564985413 #yiv5564985413 -- #yiv5564985413ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5564985413 #yiv5564985413ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5564985413 #yiv5564985413ygrp-mkp #yiv5564985413hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5564985413 #yiv5564985413ygrp-mkp #yiv5564985413ads {margin-bottom:10px;}#yiv5564985413 #yiv5564985413ygrp-mkp .yiv5564985413ad {padding:0 0;}#yiv5564985413 #yiv5564985413ygrp-mkp .yiv5564985413ad p {margin:0;}#yiv5564985413 #yiv5564985413ygrp-mkp .yiv5564985413ad a {color:#0000ff;text-decoration:none;}#yiv5564985413 #yiv5564985413ygrp-sponsor #yiv5564985413ygrp-lc {font-family:Arial;}#yiv5564985413 #yiv5564985413ygrp-sponsor #yiv5564985413ygrp-lc #yiv5564985413hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5564985413 #yiv5564985413ygrp-sponsor #yiv5564985413ygrp-lc .yiv5564985413ad {margin-bottom:10px;padding:0 0;}#yiv5564985413 #yiv5564985413actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5564985413 #yiv5564985413activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5564985413 #yiv5564985413activity span {font-weight:700;}#yiv5564985413 #yiv5564985413activity span:first-child {text-transform:uppercase;}#yiv5564985413 #yiv5564985413activity span a {color:#5085b6;text-decoration:none;}#yiv5564985413 #yiv5564985413activity span span {color:#ff7900;}#yiv5564985413 #yiv5564985413activity span .yiv5564985413underline {text-decoration:underline;}#yiv5564985413 .yiv5564985413attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5564985413 .yiv5564985413attach div a {text-decoration:none;}#yiv5564985413 .yiv5564985413attach img {border:none;padding-right:5px;}#yiv5564985413 .yiv5564985413attach label {display:block;margin-bottom:5px;}#yiv5564985413 .yiv5564985413attach label a {text-decoration:none;}#yiv5564985413 blockquote {margin:0 0 0 4px;}#yiv5564985413 .yiv5564985413bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5564985413 .yiv5564985413bold a {text-decoration:none;}#yiv5564985413 dd.yiv5564985413last p a {font-family:Verdana;font-weight:700;}#yiv5564985413 dd.yiv5564985413last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5564985413 dd.yiv5564985413last p span.yiv5564985413yshortcuts {margin-right:0;}#yiv5564985413 div.yiv5564985413attach-table div div a {text-decoration:none;}#yiv5564985413 div.yiv5564985413attach-table {width:400px;}#yiv5564985413 div.yiv5564985413file-title a, #yiv5564985413 div.yiv5564985413file-title a:active, #yiv5564985413 div.yiv5564985413file-title a:hover, #yiv5564985413 div.yiv5564985413file-title a:visited {text-decoration:none;}#yiv5564985413 div.yiv5564985413photo-title a, #yiv5564985413 div.yiv5564985413photo-title a:active, #yiv5564985413 div.yiv5564985413photo-title a:hover, #yiv5564985413 div.yiv5564985413photo-title a:visited {text-decoration:none;}#yiv5564985413 div#yiv5564985413ygrp-mlmsg #yiv5564985413ygrp-msg p a span.yiv5564985413yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5564985413 .yiv5564985413green {color:#628c2a;}#yiv5564985413 .yiv5564985413MsoNormal {margin:0 0 0 0;}#yiv5564985413 o {font-size:0;}#yiv5564985413 #yiv5564985413photos div {float:left;width:72px;}#yiv5564985413 #yiv5564985413photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5564985413 #yiv5564985413photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5564985413 #yiv5564985413reco-category {font-size:77%;}#yiv5564985413 #yiv5564985413reco-desc {font-size:77%;}#yiv5564985413 .yiv5564985413replbq {margin:4px;}#yiv5564985413 #yiv5564985413ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5564985413 #yiv5564985413ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5564985413 #yiv5564985413ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5564985413 #yiv5564985413ygrp-mlmsg select, #yiv5564985413 input, #yiv5564985413 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5564985413 #yiv5564985413ygrp-mlmsg pre, #yiv5564985413 code {font:115% monospace;}#yiv5564985413 #yiv5564985413ygrp-mlmsg * {line-height:1.22em;}#yiv5564985413 #yiv5564985413ygrp-mlmsg #yiv5564985413logo {padding-bottom:10px;}#yiv5564985413 #yiv5564985413ygrp-msg p a {font-family:Verdana;}#yiv5564985413 #yiv5564985413ygrp-msg p#yiv5564985413attach-count span {color:#1E66AE;font-weight:700;}#yiv5564985413 #yiv5564985413ygrp-reco #yiv5564985413reco-head {color:#ff7900;font-weight:700;}#yiv5564985413 #yiv5564985413ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5564985413 #yiv5564985413ygrp-sponsor #yiv5564985413ov li a {font-size:130%;text-decoration:none;}#yiv5564985413 #yiv5564985413ygrp-sponsor #yiv5564985413ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5564985413 #yiv5564985413ygrp-sponsor #yiv5564985413ov ul {margin:0;padding:0 0 0 8px;}#yiv5564985413 #yiv5564985413ygrp-text {font-family:Georgia;}#yiv5564985413 #yiv5564985413ygrp-text p {margin:0 0 1em 0;}#yiv5564985413 #yiv5564985413ygrp-text tt {font-size:120%;}#yiv5564985413 #yiv5564985413ygrp-vital ul li:last-child {border-right:none !important;}#yiv5564985413
I tried recalculating the worksheet. Always worked before. Tried Developer/Tools/Macros/smf force calculation.
Nothing happens.
Joe
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, May 28, 2017 1:27 PM
Subject: Re: [smf_addin] Shift f9 nothing happens, hit calculate sheet nothing happens.
What are you trying to recalculate?
F9 and shift-F9 don't do anything with most add-in functions. That's because data is extracted from saved copies of web pages. You need to force the add-in to get new copies of those web pages. That's done by running the smfForceRecalculati
On Sun, May 28, 2017 at 9:46 AM, Joe jtassielli2003@... wrote:
my version is. downloaded the beta version. However when I hit recalculate, nothing happens. I know the add in is working. Just no recalc.
Trust center set to "enable all Macros" and I unblocked the add in.
Puzzled!
| Stock Market Functions add-in, Version 2.1.2017.05.
#yiv5564985413 #yiv5564985413 -- #yiv5564985413ygrp-
Sun May 28, 2017 12:06 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Example of formula please.
On Sun, May 28, 2017 at 10:43 AM, Joe jtassielli2003@
...wrote:
>
> I tried recalculating the worksheet. Always worked before. Tried
> Developer/Tools/Macros/smf force calculation.
>
> Nothing happens.
>
On Sun, May 28, 2017 at 10:43 AM, Joe jtassielli2003@
...wrote:
>
> I tried recalculating the worksheet. Always worked before. Tried
> Developer/Tools/
>
> Nothing happens.
>
Sun May 28, 2017 4:11 pm (PDT) . Posted by:
sjagers
Both functions that you asked about (RCHGetWebData) return "Error". Maybe their website doesn't support IE9 or lower any more. I'll keep searching for a solution.
Sun May 28, 2017 10:03 am (PDT) . Posted by:
"Gerard Trofub" trofub
Randy,
Thank you again for all the time you spend to help all "smf add-in community".I don't catch correct value with the new function smfgetyahoohistory based on beta xla function dated May 25th)
Where is my misunderstanding ?In case I indicated a wrong ticker, the date is disappearing.
Tks
Gerard,
Thank you again for all the time you spend to help all "smf add-in community"
Where is my misunderstanding ?In case I indicated a wrong ticker, the date is disappearing.
Tks
Gerard,
Attachment(s) from Gerard Trofub
1 of 1 Photo(s)
Sun May 28, 2017 10:30 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Date and number conversions in VBA are based on U.S. regional settings, so
usually won't work for others.
On Sun, May 28, 2017 at 10:03 AM, Gerard Trofub trofub@
...wrote:
> Thank you again for all the time you spend to help all "smf add-in
> community".
> I don't catch correct value with the new function smfgetyahoohistory based
> on beta xla function dated May 25th)
>
> [image: Image en ligne]
>
> Where is my misunderstanding ?
> In case I indicated a wrong ticker, the date is disappearing.
>
>
>
usually won't work for others.
On Sun, May 28, 2017 at 10:03 AM, Gerard Trofub trofub@
...wrote:
> Thank you again for all the time you spend to help all "smf add-in
> community"
> I don't catch correct value with the new function smfgetyahoohistory based
> on beta xla function dated May 25th)
>
> [image: Image en ligne]
>
> Where is my misunderstanding ?
> In case I indicated a wrong ticker, the date is disappearing.
>
>
>
Sun May 28, 2017 11:33 am (PDT) . Posted by:
"Yahoo!" lewglenn
The documentation in http://ogres-crypt.com/SMF doesn't appear to include the latest smfGetYahooHistory call; is there a location that details where the parameters for pRows and pCols go in the call argument?
Thanks.
On Saturday, May 27, 2017, 7:02:14 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Just pass the pRows and pCols parameters as 20000,2. The function was only filling up as much of the range as it had data to fill and left the rest alone (causing the #N/A). If you tell it to return a 20000x2 range, it will blank fill the unused portion of the range.
On Sat, May 27, 2017 at 5:47 PM, lewglenn@...wrote:
When I issue the vba command:
Range("A1:B20000") = smfGetYahooHistory("IEF", , , "d", "dc", , 1)
I get correctly the serial dates in column 1 and adjusted close in column 2. The last row today (5/27/2017) is row number 3735.
However, when I look down my worksheet I see, beginning in row 17317, #N/A appearing in columns 1 and 2 and extending to row 20000.
Randy, Can you tell me why this is happening and what I might need to do to eliminate?
#yiv7879014325 #yiv7879014325 -- #yiv7879014325ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7879014325 #yiv7879014325ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7879014325 #yiv7879014325ygrp-mkp #yiv7879014325hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7879014325 #yiv7879014325ygrp-mkp #yiv7879014325ads {margin-bottom:10px;}#yiv7879014325 #yiv7879014325ygrp-mkp .yiv7879014325ad {padding:0 0;}#yiv7879014325 #yiv7879014325ygrp-mkp .yiv7879014325ad p {margin:0;}#yiv7879014325 #yiv7879014325ygrp-mkp .yiv7879014325ad a {color:#0000ff;text-decoration:none;}#yiv7879014325 #yiv7879014325ygrp-sponsor #yiv7879014325ygrp-lc {font-family:Arial;}#yiv7879014325 #yiv7879014325ygrp-sponsor #yiv7879014325ygrp-lc #yiv7879014325hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7879014325 #yiv7879014325ygrp-sponsor #yiv7879014325ygrp-lc .yiv7879014325ad {margin-bottom:10px;padding:0 0;}#yiv7879014325 #yiv7879014325actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7879014325 #yiv7879014325activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7879014325 #yiv7879014325activity span {font-weight:700;}#yiv7879014325 #yiv7879014325activity span:first-child {text-transform:uppercase;}#yiv7879014325 #yiv7879014325activity span a {color:#5085b6;text-decoration:none;}#yiv7879014325 #yiv7879014325activity span span {color:#ff7900;}#yiv7879014325 #yiv7879014325activity span .yiv7879014325underline {text-decoration:underline;}#yiv7879014325 .yiv7879014325attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7879014325 .yiv7879014325attach div a {text-decoration:none;}#yiv7879014325 .yiv7879014325attach img {border:none;padding-right:5px;}#yiv7879014325 .yiv7879014325attach label {display:block;margin-bottom:5px;}#yiv7879014325 .yiv7879014325attach label a {text-decoration:none;}#yiv7879014325 blockquote {margin:0 0 0 4px;}#yiv7879014325 .yiv7879014325bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7879014325 .yiv7879014325bold a {text-decoration:none;}#yiv7879014325 dd.yiv7879014325last p a {font-family:Verdana;font-weight:700;}#yiv7879014325 dd.yiv7879014325last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7879014325 dd.yiv7879014325last p span.yiv7879014325yshortcuts {margin-right:0;}#yiv7879014325 div.yiv7879014325attach-table div div a {text-decoration:none;}#yiv7879014325 div.yiv7879014325attach-table {width:400px;}#yiv7879014325 div.yiv7879014325file-title a, #yiv7879014325 div.yiv7879014325file-title a:active, #yiv7879014325 div.yiv7879014325file-title a:hover, #yiv7879014325 div.yiv7879014325file-title a:visited {text-decoration:none;}#yiv7879014325 div.yiv7879014325photo-title a, #yiv7879014325 div.yiv7879014325photo-title a:active, #yiv7879014325 div.yiv7879014325photo-title a:hover, #yiv7879014325 div.yiv7879014325photo-title a:visited {text-decoration:none;}#yiv7879014325 div#yiv7879014325ygrp-mlmsg #yiv7879014325ygrp-msg p a span.yiv7879014325yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7879014325 .yiv7879014325green {color:#628c2a;}#yiv7879014325 .yiv7879014325MsoNormal {margin:0 0 0 0;}#yiv7879014325 o {font-size:0;}#yiv7879014325 #yiv7879014325photos div {float:left;width:72px;}#yiv7879014325 #yiv7879014325photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7879014325 #yiv7879014325photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7879014325 #yiv7879014325reco-category {font-size:77%;}#yiv7879014325 #yiv7879014325reco-desc {font-size:77%;}#yiv7879014325 .yiv7879014325replbq {margin:4px;}#yiv7879014325 #yiv7879014325ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7879014325 #yiv7879014325ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7879014325 #yiv7879014325ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7879014325 #yiv7879014325ygrp-mlmsg select, #yiv7879014325 input, #yiv7879014325 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7879014325 #yiv7879014325ygrp-mlmsg pre, #yiv7879014325 code {font:115% monospace;}#yiv7879014325 #yiv7879014325ygrp-mlmsg * {line-height:1.22em;}#yiv7879014325 #yiv7879014325ygrp-mlmsg #yiv7879014325logo {padding-bottom:10px;}#yiv7879014325 #yiv7879014325ygrp-msg p a {font-family:Verdana;}#yiv7879014325 #yiv7879014325ygrp-msg p#yiv7879014325attach-count span {color:#1E66AE;font-weight:700;}#yiv7879014325 #yiv7879014325ygrp-reco #yiv7879014325reco-head {color:#ff7900;font-weight:700;}#yiv7879014325 #yiv7879014325ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7879014325 #yiv7879014325ygrp-sponsor #yiv7879014325ov li a {font-size:130%;text-decoration:none;}#yiv7879014325 #yiv7879014325ygrp-sponsor #yiv7879014325ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7879014325 #yiv7879014325ygrp-sponsor #yiv7879014325ov ul {margin:0;padding:0 0 0 8px;}#yiv7879014325 #yiv7879014325ygrp-text {font-family:Georgia;}#yiv7879014325 #yiv7879014325ygrp-text p {margin:0 0 1em 0;}#yiv7879014325 #yiv7879014325ygrp-text tt {font-size:120%;}#yiv7879014325 #yiv7879014325ygrp-vital ul li:last-child {border-right:none !important;}#yiv7879014325
Thanks.
On Saturday, May 27, 2017, 7:02:14 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Just pass the pRows and pCols parameters as 20000,2. The function was only filling up as much of the range as it had data to fill and left the rest alone (causing the #N/A). If you tell it to return a 20000x2 range, it will blank fill the unused portion of the range.
On Sat, May 27, 2017 at 5:47 PM, lewglenn@...wrote:
When I issue the vba command:
Range("
I get correctly the serial dates in column 1 and adjusted close in column 2. The last row today (5/27/2017) is row number 3735.
However, when I look down my worksheet I see, beginning in row 17317, #N/A appearing in columns 1 and 2 and extending to row 20000.
Randy, Can you tell me why this is happening and what I might need to do to eliminate?
#yiv7879014325 #yiv7879014325 -- #yiv7879014325ygrp-
Sun May 28, 2017 12:04 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Only documentation is in the previously cited message:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
VBA should let you know the parameters as you are entering them.
On Sun, May 28, 2017 at 11:33 AM, Yahoo! lewglenn@
...wrote:
>
> The documentation in http://ogres-crypt.com/SMF doesn't appear to include
> the latest smfGetYahooHistory call; is there a location that details where
> the parameters for pRows and pCols go in the call argument?
>
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
VBA should let you know the parameters as you are entering them.
On Sun, May 28, 2017 at 11:33 AM, Yahoo! lewglenn@
...wrote:
>
> The documentation in http://ogres-crypt.com/SMF doesn't appear to include
> the latest smfGetYahooHistory call; is there a location that details where
> the parameters for pRows and pCols go in the call argument?
>
>
>
Sun May 28, 2017 12:01 pm (PDT) . Posted by:
raffrobb@gmail.com
Hi Randy:
So, is there a way to to get historical stock prices from Yahoo using VBA or SMF add-in after Yahoo changed things.
Is there still a way to get Financial Statements from Yahoo?
Thanks,
Robb
So, is there a way to to get historical stock prices from Yahoo using VBA or SMF add-in after Yahoo changed things.
Is there still a way to get Financial Statements from Yahoo?
Thanks,
Robb
Sun May 28, 2017 12:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yes. And yes. :)
Being worked on. The new experimental beta smfGetYahooHistory() has been
discussed here for many weeks. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32343
The financial statements items can be retrieved from their JSON feeds. For
example, something like:
=smfGetYahooJSONField("MMM","incomeStatementHistory","quoteSummary.result.0.incomeStatementHistory.incomeStatementHistory.0.totalRevenue.raw")
...which is:
=smfGetYahooJSONField(ticker,module,field-name)
I've identified a number of module and field name combinations:
http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Stock-Keyname-Database.xls
http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Mutual-Fund-Keyname-Database.xls
Note that the above formula doesn't work right now, but the Yahoo financial
web pages aren't loading data either, so must be a database problem on the
Yahoo side.
OR THEY ARE CHANGING THINGS AGAIN! :(
On Sun, May 28, 2017 at 10:55 AM, raffrobb@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> So, is there a way to to get historical stock prices from Yahoo using VBA
> or SMF add-in after Yahoo changed things.
>
> Is there still a way to get Financial Statements from Yahoo?
>
>
Being worked on. The new experimental beta smfGetYahooHistory() has been
discussed here for many weeks. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32343
The financial statements items can be retrieved from their JSON feeds. For
example, something like:
=smfGetYahooJSONField("MMM","incomeStatementHistory","quoteSummary.result.0.incomeStatementHistory.incomeStatementHistory.0.totalRevenue.raw")
...which is:
=smfGetYahooJSONField(ticker,module,field-name)
I've identified a number of module and field name combinations:
http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Stock-Keyname-Database.xls
http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Mutual-Fund-Keyname-Database.xls
Note that the above formula doesn't work right now, but the Yahoo financial
web pages aren't loading data either, so must be a database problem on the
Yahoo side.
OR THEY ARE CHANGING THINGS AGAIN! :(
On Sun, May 28, 2017 at 10:55 AM, raffrobb@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> So, is there a way to to get historical stock prices from Yahoo using VBA
> or SMF add-in after Yahoo changed things.
>
> Is there still a way to get Financial Statements from Yahoo?
>
>
Sun May 28, 2017 1:34 pm (PDT) . Posted by:
mthmu3uhchaa4cu3fj53vppa7f2ab7cx7srhngvp
I've discovered a work-around for the problem. My older version of Excel may be caching the add-in and loading it from a cache when starting (??) The only way to flush such an assumed cache is to DELETE the add-in (and not just disable it) so that it disappears from the shown list of add-ins. Excel does not offer such a delete operation, but the following will do:
1. Close Excel.
2. Rename the add-in (I changed the filetype to 'alx' instead of 'xla').
3. Open the spreadsheet, ignoring any complaints.
4. Check that the add-in now does not appear on the list of add-ins.
5. Close Excel.
6. Restore the add-in's filename.
7. Open the spreadsheet.
8. Reload the latest add-in version and check that it's enabled on the list of add-ins.
9. Close Excel.
It should work now.
1. Close Excel.
2. Rename the add-in (I changed the filetype to 'alx' instead of 'xla'
3. Open the spreadsheet, ignoring any complaints.
4. Check that the add-in now does not appear on the list of add-ins.
5. Close Excel.
6. Restore the add-in's filename.
7. Open the spreadsheet.
8. Reload the latest add-in version and check that it's enabled on the list of add-ins.
9. Close Excel.
It should work now.
Sun May 28, 2017 3:19 pm (PDT) . Posted by:
lewglenn
I'm trying to get the 50-day moving average with the new smfGetYahooHistory call; my code looks like:
'Now reset 50-day SMA because above call uses 50 calendar days rather than market days
For r = 2 To rowmax
If IsEmpty(Cells(r, "P")) Then
Res = Cells(r, "A")
' Cells(r, "I") = Application.WorksheetFunction.Average(RCHGetYahooHistory(Res, , , , , , , , "a", 0, , , 50, 1))
Cells(r, "I") = Application.WorksheetFunction.Average(smfGetYahooHistory(Res, , , "d", "dc", , 1, 50, 1))
End If
Next r
The old RCHGetYahooHistory call is commented out but this loop worked fine when it was operable. I'm attempting to emulate this call with the new smfGetYahooHistory call but I must have some of the arguments wrong because I 'm getting nonsense for the 50-day moving average in column "I" the way I'm using the new call. Can you please correct my error?
Thanks.
'Now reset 50-day SMA because above call uses 50 calendar days rather than market days
For r = 2 To rowmax
If IsEmpty(Cells(
Res = Cells(r, "A"
' Cells(r, "I"
Cells(r, "I"
End If
Next r
The old RCHGetYahooHistory call is commented out but this loop worked fine when it was operable. I'm attempting to emulate this call with the new smfGetYahooHistory call but I must have some of the arguments wrong because I 'm getting nonsense for the 50-day moving average in column "I" the way I'm using the new call. Can you please correct my error?
Thanks.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar