15 Messages
Digest #4162
Messages
Mon Oct 2, 2017 6:01 am (PDT) . Posted by:
yongyap
Hi Randy,
I came up with an excel file on smfgetgurufocus with mulitple stocks. it used to work fine. but today when I reopened this file, it shows error massage "window has stopped working. after windows attempt to repair, it still can't be opened.
What is the caused?
1. Is it because of too many data retrieve from gurufocus? I retrieved all data on yearly and monthly for about 70 stocks at one go. yearly for 10 years historical data.
2. Or is it because of virus?
Thanks and best regards,
Joseph Chua
I came up with an excel file on smfgetgurufocus with mulitple stocks. it used to work fine. but today when I reopened this file, it shows error massage "window has stopped working. after windows attempt to repair, it still can't be opened.
What is the caused?
1. Is it because of too many data retrieve from gurufocus? I retrieved all data on yearly and monthly for about 70 stocks at one go. yearly for 10 years historical data.
2. Or is it because of virus?
Thanks and best regards,
Joseph Chua
Mon Oct 2, 2017 11:09 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not a clue here. That isn't an EXCEL message. You could try turning off
automatic calculation and try opening the file, to see if it's a file
problem or a calculation problem.
I am confused by your comment about "yearly and monthly".
And retrieving "all data" for 70 stocks would take a reeeeaaaalllll long
time to calculate. For me, the template can take a minute or so just for
one stock, because it's so many extractions from such a large web page.
On Mon, Oct 2, 2017 at 6:01 AM, yongyap@
...
wrote:
> I came up with an excel file on smfgetgurufocus with mulitple stocks. it
> used to work fine. but today when I reopened this file, it shows error
> massage "window has stopped working. after windows attempt to repair, it
> still can't be opened.
>
> What is the caused?
>
> 1. Is it because of too many data retrieve from gurufocus? I retrieved all
> data on yearly and monthly for about 70 stocks at one go. yearly for 10
> years historical data.
>
> 2. Or is it because of virus?
>
>
>
automatic calculation and try opening the file, to see if it's a file
problem or a calculation problem.
I am confused by your comment about "yearly and monthly"
And retrieving "all data" for 70 stocks would take a reeeeaaaalllll long
time to calculate. For me, the template can take a minute or so just for
one stock, because it's so many extractions from such a large web page.
On Mon, Oct 2, 2017 at 6:01 AM, yongyap@
...
wrote:
> I came up with an excel file on smfgetgurufocus with mulitple stocks. it
> used to work fine. but today when I reopened this file, it shows error
> massage "window has stopped working. after windows attempt to repair, it
> still can't be opened.
>
> What is the caused?
>
> 1. Is it because of too many data retrieve from gurufocus? I retrieved all
> data on yearly and monthly for about 70 stocks at one go. yearly for 10
> years historical data.
>
> 2. Or is it because of virus?
>
>
>
Mon Oct 2, 2017 9:39 am (PDT) . Posted by:
"Yahoo!" lewglenn
The version I've been using is dated May 22, 2017. Can you give me the url for the latest (July 12) version?
Many thanks, Randy.
On Sunday, October 1, 2017, 6:03:53 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Again, working fine here (without specifying a start or end date). What version of the add-in are you using?
The last change was on 2017.07.12 and involved the swapping of close and unadjusted close, since Yahoo changed their meaning in the JSON code (it used to be close and unadjusted close and they changed it to be close and adjusted close).
On Sun, Oct 1, 2017 at 5:41 PM, lewglenn@... wrote:
When I use the vba code:
Range("C1:D20000") = smfGetYahooHistory("SPY", StartDate, EndDate, "d", "dc", , 1, 20000, 2)
to get adjusted closing prices for SPY, with StartDate of 7/30/2002 and EndDate of 9/29/2017 I get what appear to be unadjusted closing prices (when I compare the results to those I get by downloading the data directly to a csv file from the Yahoo Finance site). Am I using an outdated version of the RCH_Stock_Market_Functions.xla file? Or am I using the wrong parameters to get adjusted close results?
#yiv9750884822 #yiv9750884822 -- #yiv9750884822ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9750884822 #yiv9750884822ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9750884822 #yiv9750884822ygrp-mkp #yiv9750884822hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9750884822 #yiv9750884822ygrp-mkp #yiv9750884822ads {margin-bottom:10px;}#yiv9750884822 #yiv9750884822ygrp-mkp .yiv9750884822ad {padding:0 0;}#yiv9750884822 #yiv9750884822ygrp-mkp .yiv9750884822ad p {margin:0;}#yiv9750884822 #yiv9750884822ygrp-mkp .yiv9750884822ad a {color:#0000ff;text-decoration:none;}#yiv9750884822 #yiv9750884822ygrp-sponsor #yiv9750884822ygrp-lc {font-family:Arial;}#yiv9750884822 #yiv9750884822ygrp-sponsor #yiv9750884822ygrp-lc #yiv9750884822hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9750884822 #yiv9750884822ygrp-sponsor #yiv9750884822ygrp-lc .yiv9750884822ad {margin-bottom:10px;padding:0 0;}#yiv9750884822 #yiv9750884822actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9750884822 #yiv9750884822activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9750884822 #yiv9750884822activity span {font-weight:700;}#yiv9750884822 #yiv9750884822activity span:first-child {text-transform:uppercase;}#yiv9750884822 #yiv9750884822activity span a {color:#5085b6;text-decoration:none;}#yiv9750884822 #yiv9750884822activity span span {color:#ff7900;}#yiv9750884822 #yiv9750884822activity span .yiv9750884822underline {text-decoration:underline;}#yiv9750884822 .yiv9750884822attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9750884822 .yiv9750884822attach div a {text-decoration:none;}#yiv9750884822 .yiv9750884822attach img {border:none;padding-right:5px;}#yiv9750884822 .yiv9750884822attach label {display:block;margin-bottom:5px;}#yiv9750884822 .yiv9750884822attach label a {text-decoration:none;}#yiv9750884822 blockquote {margin:0 0 0 4px;}#yiv9750884822 .yiv9750884822bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9750884822 .yiv9750884822bold a {text-decoration:none;}#yiv9750884822 dd.yiv9750884822last p a {font-family:Verdana;font-weight:700;}#yiv9750884822 dd.yiv9750884822last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9750884822 dd.yiv9750884822last p span.yiv9750884822yshortcuts {margin-right:0;}#yiv9750884822 div.yiv9750884822attach-table div div a {text-decoration:none;}#yiv9750884822 div.yiv9750884822attach-table {width:400px;}#yiv9750884822 div.yiv9750884822file-title a, #yiv9750884822 div.yiv9750884822file-title a:active, #yiv9750884822 div.yiv9750884822file-title a:hover, #yiv9750884822 div.yiv9750884822file-title a:visited {text-decoration:none;}#yiv9750884822 div.yiv9750884822photo-title a, #yiv9750884822 div.yiv9750884822photo-title a:active, #yiv9750884822 div.yiv9750884822photo-title a:hover, #yiv9750884822 div.yiv9750884822photo-title a:visited {text-decoration:none;}#yiv9750884822 div#yiv9750884822ygrp-mlmsg #yiv9750884822ygrp-msg p a span.yiv9750884822yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9750884822 .yiv9750884822green {color:#628c2a;}#yiv9750884822 .yiv9750884822MsoNormal {margin:0 0 0 0;}#yiv9750884822 o {font-size:0;}#yiv9750884822 #yiv9750884822photos div {float:left;width:72px;}#yiv9750884822 #yiv9750884822photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9750884822 #yiv9750884822photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9750884822 #yiv9750884822reco-category {font-size:77%;}#yiv9750884822 #yiv9750884822reco-desc {font-size:77%;}#yiv9750884822 .yiv9750884822replbq {margin:4px;}#yiv9750884822 #yiv9750884822ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9750884822 #yiv9750884822ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9750884822 #yiv9750884822ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9750884822 #yiv9750884822ygrp-mlmsg select, #yiv9750884822 input, #yiv9750884822 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9750884822 #yiv9750884822ygrp-mlmsg pre, #yiv9750884822 code {font:115% monospace;}#yiv9750884822 #yiv9750884822ygrp-mlmsg * {line-height:1.22em;}#yiv9750884822 #yiv9750884822ygrp-mlmsg #yiv9750884822logo {padding-bottom:10px;}#yiv9750884822 #yiv9750884822ygrp-msg p a {font-family:Verdana;}#yiv9750884822 #yiv9750884822ygrp-msg p#yiv9750884822attach-count span {color:#1E66AE;font-weight:700;}#yiv9750884822 #yiv9750884822ygrp-reco #yiv9750884822reco-head {color:#ff7900;font-weight:700;}#yiv9750884822 #yiv9750884822ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9750884822 #yiv9750884822ygrp-sponsor #yiv9750884822ov li a {font-size:130%;text-decoration:none;}#yiv9750884822 #yiv9750884822ygrp-sponsor #yiv9750884822ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9750884822 #yiv9750884822ygrp-sponsor #yiv9750884822ov ul {margin:0;padding:0 0 0 8px;}#yiv9750884822 #yiv9750884822ygrp-text {font-family:Georgia;}#yiv9750884822 #yiv9750884822ygrp-text p {margin:0 0 1em 0;}#yiv9750884822 #yiv9750884822ygrp-text tt {font-size:120%;}#yiv9750884822 #yiv9750884822ygrp-vital ul li:last-child {border-right:none !important;}#yiv9750884822
Many thanks, Randy.
On Sunday, October 1, 2017, 6:03:53 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Again, working fine here (without specifying a start or end date). What version of the add-in are you using?
The last change was on 2017.07.12 and involved the swapping of close and unadjusted close, since Yahoo changed their meaning in the JSON code (it used to be close and unadjusted close and they changed it to be close and adjusted close).
On Sun, Oct 1, 2017 at 5:41 PM, lewglenn@... wrote:
When I use the vba code:
Range("
to get adjusted closing prices for SPY, with StartDate of 7/30/2002 and EndDate of 9/29/2017 I get what appear to be unadjusted closing prices (when I compare the results to those I get by downloading the data directly to a csv file from the Yahoo Finance site). Am I using an outdated version of the RCH_Stock_Market_
#yiv9750884822 #yiv9750884822 -- #yiv9750884822ygrp-
Mon Oct 2, 2017 10:06 am (PDT) . Posted by:
"Craig Passow" passow
There's a link at the bottom of every smf_addin email.
On 10/2/2017 11:39 AM, Yahoo! lewglenn@yahoo.com [smf_addin] wrote:
>
> The version I've been using is dated May 22, 2017. Can you give me the
> url for the latest (July 12) version?
>
> Many thanks, Randy.
>
>
> On Sunday, October 1, 2017, 6:03:53 PM PDT, Randy Harmelink
> rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
>
> Again, working fine here (without specifying a start or end date).
> What version of the add-in are you using?
>
> The last change was on 2017.07.12 and involved the swapping of close
> and unadjusted close, since Yahoo changed their meaning in the JSON
> code (it used to be close and unadjusted close and they changed it to
> be close and adjusted close).
>
> On Sun, Oct 1, 2017 at 5:41 PM, lewglenn@
> ...
> wrote:
>
>
> When I use the vba code:
>
>
> Range("C1:D20000") = smfGetYahooHistory("SPY", StartDate, EndDate,
> "d", "dc", , 1, 20000, 2)
>
> to get adjusted closing prices for SPY, with StartDate of
> 7/30/2002 and EndDate of 9/29/2017 I get what appear to be
> unadjusted closing prices (when I compare the results to those I
> get by downloading the data directly to a csv file from the Yahoo
> Finance site). Am I using an outdated version of the
> RCH_Stock_Market_Functions.xla file? Or am I using the wrong
> parameters to get adjusted close results?
>
>
On 10/2/2017 11:39 AM, Yahoo! lewglenn@yahoo.com [smf_addin] wrote:
>
> The version I've been using is dated May 22, 2017. Can you give me the
> url for the latest (July 12) version?
>
> Many thanks, Randy.
>
>
> On Sunday, October 1, 2017, 6:03:53 PM PDT, Randy Harmelink
> rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
>
> Again, working fine here (without specifying a start or end date).
> What version of the add-in are you using?
>
> The last change was on 2017.07.12 and involved the swapping of close
> and unadjusted close, since Yahoo changed their meaning in the JSON
> code (it used to be close and unadjusted close and they changed it to
> be close and adjusted close).
>
> On Sun, Oct 1, 2017 at 5:41 PM, lewglenn@
> ...
> wrote:
>
>
> When I use the vba code:
>
>
> Range("
> "d"
>
> to get adjusted closing prices for SPY, with StartDate of
> 7/30/2002 and EndDate of 9/29/2017 I get what appear to be
> unadjusted closing prices (when I compare the results to those I
> get by downloading the data directly to a csv file from the Yahoo
> Finance site). Am I using an outdated version of the
> RCH_Stock_Market_
> parameters to get adjusted close results?
>
>
Mon Oct 2, 2017 10:06 am (PDT) . Posted by:
"Yahoo!" lewglenn
I found the version dated 9/17/2017; I assume that's the latest? Anyway, when I use that one I get the adjusted close data. Thanks again, Randy.
On Sunday, October 1, 2017, 6:03:53 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Again, working fine here (without specifying a start or end date). What version of the add-in are you using?
The last change was on 2017.07.12 and involved the swapping of close and unadjusted close, since Yahoo changed their meaning in the JSON code (it used to be close and unadjusted close and they changed it to be close and adjusted close).
On Sun, Oct 1, 2017 at 5:41 PM, lewglenn@... wrote:
When I use the vba code:
Range("C1:D20000") = smfGetYahooHistory("SPY", StartDate, EndDate, "d", "dc", , 1, 20000, 2)
to get adjusted closing prices for SPY, with StartDate of 7/30/2002 and EndDate of 9/29/2017 I get what appear to be unadjusted closing prices (when I compare the results to those I get by downloading the data directly to a csv file from the Yahoo Finance site). Am I using an outdated version of the RCH_Stock_Market_Functions.xla file? Or am I using the wrong parameters to get adjusted close results?
#yiv4413625775 #yiv4413625775 -- #yiv4413625775ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4413625775 #yiv4413625775ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4413625775 #yiv4413625775ygrp-mkp #yiv4413625775hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4413625775 #yiv4413625775ygrp-mkp #yiv4413625775ads {margin-bottom:10px;}#yiv4413625775 #yiv4413625775ygrp-mkp .yiv4413625775ad {padding:0 0;}#yiv4413625775 #yiv4413625775ygrp-mkp .yiv4413625775ad p {margin:0;}#yiv4413625775 #yiv4413625775ygrp-mkp .yiv4413625775ad a {color:#0000ff;text-decoration:none;}#yiv4413625775 #yiv4413625775ygrp-sponsor #yiv4413625775ygrp-lc {font-family:Arial;}#yiv4413625775 #yiv4413625775ygrp-sponsor #yiv4413625775ygrp-lc #yiv4413625775hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4413625775 #yiv4413625775ygrp-sponsor #yiv4413625775ygrp-lc .yiv4413625775ad {margin-bottom:10px;padding:0 0;}#yiv4413625775 #yiv4413625775actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4413625775 #yiv4413625775activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4413625775 #yiv4413625775activity span {font-weight:700;}#yiv4413625775 #yiv4413625775activity span:first-child {text-transform:uppercase;}#yiv4413625775 #yiv4413625775activity span a {color:#5085b6;text-decoration:none;}#yiv4413625775 #yiv4413625775activity span span {color:#ff7900;}#yiv4413625775 #yiv4413625775activity span .yiv4413625775underline {text-decoration:underline;}#yiv4413625775 .yiv4413625775attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4413625775 .yiv4413625775attach div a {text-decoration:none;}#yiv4413625775 .yiv4413625775attach img {border:none;padding-right:5px;}#yiv4413625775 .yiv4413625775attach label {display:block;margin-bottom:5px;}#yiv4413625775 .yiv4413625775attach label a {text-decoration:none;}#yiv4413625775 blockquote {margin:0 0 0 4px;}#yiv4413625775 .yiv4413625775bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4413625775 .yiv4413625775bold a {text-decoration:none;}#yiv4413625775 dd.yiv4413625775last p a {font-family:Verdana;font-weight:700;}#yiv4413625775 dd.yiv4413625775last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4413625775 dd.yiv4413625775last p span.yiv4413625775yshortcuts {margin-right:0;}#yiv4413625775 div.yiv4413625775attach-table div div a {text-decoration:none;}#yiv4413625775 div.yiv4413625775attach-table {width:400px;}#yiv4413625775 div.yiv4413625775file-title a, #yiv4413625775 div.yiv4413625775file-title a:active, #yiv4413625775 div.yiv4413625775file-title a:hover, #yiv4413625775 div.yiv4413625775file-title a:visited {text-decoration:none;}#yiv4413625775 div.yiv4413625775photo-title a, #yiv4413625775 div.yiv4413625775photo-title a:active, #yiv4413625775 div.yiv4413625775photo-title a:hover, #yiv4413625775 div.yiv4413625775photo-title a:visited {text-decoration:none;}#yiv4413625775 div#yiv4413625775ygrp-mlmsg #yiv4413625775ygrp-msg p a span.yiv4413625775yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4413625775 .yiv4413625775green {color:#628c2a;}#yiv4413625775 .yiv4413625775MsoNormal {margin:0 0 0 0;}#yiv4413625775 o {font-size:0;}#yiv4413625775 #yiv4413625775photos div {float:left;width:72px;}#yiv4413625775 #yiv4413625775photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4413625775 #yiv4413625775photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4413625775 #yiv4413625775reco-category {font-size:77%;}#yiv4413625775 #yiv4413625775reco-desc {font-size:77%;}#yiv4413625775 .yiv4413625775replbq {margin:4px;}#yiv4413625775 #yiv4413625775ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4413625775 #yiv4413625775ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4413625775 #yiv4413625775ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4413625775 #yiv4413625775ygrp-mlmsg select, #yiv4413625775 input, #yiv4413625775 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4413625775 #yiv4413625775ygrp-mlmsg pre, #yiv4413625775 code {font:115% monospace;}#yiv4413625775 #yiv4413625775ygrp-mlmsg * {line-height:1.22em;}#yiv4413625775 #yiv4413625775ygrp-mlmsg #yiv4413625775logo {padding-bottom:10px;}#yiv4413625775 #yiv4413625775ygrp-msg p a {font-family:Verdana;}#yiv4413625775 #yiv4413625775ygrp-msg p#yiv4413625775attach-count span {color:#1E66AE;font-weight:700;}#yiv4413625775 #yiv4413625775ygrp-reco #yiv4413625775reco-head {color:#ff7900;font-weight:700;}#yiv4413625775 #yiv4413625775ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4413625775 #yiv4413625775ygrp-sponsor #yiv4413625775ov li a {font-size:130%;text-decoration:none;}#yiv4413625775 #yiv4413625775ygrp-sponsor #yiv4413625775ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4413625775 #yiv4413625775ygrp-sponsor #yiv4413625775ov ul {margin:0;padding:0 0 0 8px;}#yiv4413625775 #yiv4413625775ygrp-text {font-family:Georgia;}#yiv4413625775 #yiv4413625775ygrp-text p {margin:0 0 1em 0;}#yiv4413625775 #yiv4413625775ygrp-text tt {font-size:120%;}#yiv4413625775 #yiv4413625775ygrp-vital ul li:last-child {border-right:none !important;}#yiv4413625775
On Sunday, October 1, 2017, 6:03:53 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Again, working fine here (without specifying a start or end date). What version of the add-in are you using?
The last change was on 2017.07.12 and involved the swapping of close and unadjusted close, since Yahoo changed their meaning in the JSON code (it used to be close and unadjusted close and they changed it to be close and adjusted close).
On Sun, Oct 1, 2017 at 5:41 PM, lewglenn@... wrote:
When I use the vba code:
Range("
to get adjusted closing prices for SPY, with StartDate of 7/30/2002 and EndDate of 9/29/2017 I get what appear to be unadjusted closing prices (when I compare the results to those I get by downloading the data directly to a csv file from the Yahoo Finance site). Am I using an outdated version of the RCH_Stock_Market_
#yiv4413625775 #yiv4413625775 -- #yiv4413625775ygrp-
Mon Oct 2, 2017 11:59 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
http://ogres-crypt.com/SMF/
On Mon, Oct 2, 2017 at 9:39 AM, Yahoo! lewglenn@
...
wrote:
>
> The version I've been using is dated May 22, 2017. Can you give me the url
> for the latest (July 12) version?
>
>
>
On Mon, Oct 2, 2017 at 9:39 AM, Yahoo! lewglenn@
...
wrote:
>
> The version I've been using is dated May 22, 2017. Can you give me the url
> for the latest (July 12) version?
>
>
>
Mon Oct 2, 2017 9:43 am (PDT) . Posted by:
mthmu3uhchaa4cu3fj53vppa7f2ab7cx7srhngvp
smfPricesbyDates is returning the same data for 9/28/2017 and 9/29/2017. Tried many different tickers. Anybody else experiencing this?
Mon Oct 2, 2017 10:09 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not seeing that:
2017-09-28 2017-09-29
MMM $209.55 $209.90
IBM $145.66 $145.08
ED $80.71 $80.68
On Mon, Oct 2, 2017 at 9:41 AM, mthmu3uhchaa4cu3fj53vppa7f2ab7cx7srhngvp@
...
wrote:
> smfPricesbyDates is returning the same data for 9/28/2017 and 9/29/2017.
> Tried many different tickers. Anybody else experiencing this?
>
2017-09-28 2017-09-29
MMM $209.55 $209.90
IBM $145.66 $145.08
ED $80.71 $80.68
On Mon, Oct 2, 2017 at 9:41 AM, mthmu3uhchaa4cu3fj5
...
wrote:
> smfPricesbyDates is returning the same data for 9/28/2017 and 9/29/2017.
> Tried many different tickers. Anybody else experiencing this?
>
Mon Oct 2, 2017 10:37 am (PDT) . Posted by:
mthmu3uhchaa4cu3fj53vppa7f2ab7cx7srhngvp
I am getting the same results for those two dates. Could replicated databases be involved (with DNS picking up a different server)?
Mon Oct 2, 2017 11:24 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Exit and restart EXCEL and try again.
Which version of the add-in are you using?
=RCHGetElementNumber("Version")
Do you see the same results using a plain old smfGetYahooHistory() function?
Do you have your Internet options set to always get fresh copies of web
pages?
Do you get the same results when you go to the Yahoo historical quotes web
page?
On Mon, Oct 2, 2017 at 10:37 AM, mth
...
wrote:
>
> I am getting the same results for those two dates. Could replicated
> databases be involved (with DNS picking up a different server)?
>
Which version of the add-in are you using?
=RCHGetElementNumbe
Do you see the same results using a plain old smfGetYahooHistory(
Do you have your Internet options set to always get fresh copies of web
pages?
Do you get the same results when you go to the Yahoo historical quotes web
page?
On Mon, Oct 2, 2017 at 10:37 AM, mth
...
wrote:
>
> I am getting the same results for those two dates. Could replicated
> databases be involved (with DNS picking up a different server)?
>
Mon Oct 2, 2017 3:00 pm (PDT) . Posted by:
mthmu3uhchaa4cu3fj53vppa7f2ab7cx7srhngvp
I get the following results:
mmm ibm ed
9/28/2017 209.55 145.66 80.71
9/29/2017 209.55 145.66 80.68 Stock Market Functions add-in, Version
Stock Market Functions add-in, Version 2.1.2017.09.17
(C:\SMF Add-in; Windows (32-bit) NT :.00; 15.0; ; ; 1)
mmm ibm ed
9/28/2017 209.55 145.66 80.71
9/29/2017 209.55 145.66 80.68 Stock Market Functions add-in, Version
Stock Market Functions add-in, Version 2.1.2017.09.
(C:\SMF Add-in; Windows (32-bit) NT :.00; 15.0; ; ; 1)
Mon Oct 2, 2017 3:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Did you check your Internet options, or try smfForceRecalculation? I would
suspect either a cached web page by the add-in or in the "Temporary
Internet Files" folder for IE...?
On Mon, Oct 2, 2017 at 3:00 PM, mth
,,,,
wrote:
>
> I get the following results:
>
> mmm ibm ed
> 9/28/2017 209.55 145.66 80.71
> 9/29/2017 209.55 145.66 80.68 Stock Market Functions add-in, Version
>
> Stock Market Functions add-in, Version 2.1.2017.09.17
> (C:\SMF Add-in; Windows (32-bit) NT :.00; 15.0; ; ; 1)
>
suspect either a cached web page by the add-in or in the "Temporary
Internet Files" folder for IE...?
On Mon, Oct 2, 2017 at 3:00 PM, mth
,,,,
wrote:
>
> I get the following results:
>
> mmm ibm ed
> 9/28/2017 209.55 145.66 80.71
> 9/29/2017 209.55 145.66 80.68 Stock Market Functions add-in, Version
>
> Stock Market Functions add-in, Version 2.1.2017.09.
> (C:\SMF Add-in; Windows (32-bit) NT :.00; 15.0; ; ; 1)
>
Mon Oct 2, 2017 11:17 am (PDT) . Posted by:
ehstats
Is there a way to get historical (last 5 years) monthly or daily PE ratios on indices such as S&P 500, S&P 400, and Russell 2000?
Mon Oct 2, 2017 11:37 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not aware of a source off-hand, but you could do some Google searches
to see what might be available. You will probably find some for the S&P
500, but I'm not sure about other indexes.
On Mon, Oct 2, 2017 at 11:17 AM, ericstats@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Is there a way to get historical (last 5 years) monthly or daily PE ratios
> on indices such as S&P 500, S&P 400, and Russell 2000?
>
to see what might be available. You will probably find some for the S&P
500, but I'm not sure about other indexes.
On Mon, Oct 2, 2017 at 11:17 AM, ericstats@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Is there a way to get historical (last 5 years) monthly or daily PE ratios
> on indices such as S&P 500, S&P 400, and Russell 2000?
>
Mon Oct 2, 2017 2:43 pm (PDT) . Posted by:
gbullr
Randy:
Where do I load this file or or do I just load the latest versin of the addin?
Where do I load this file or or do I just load the latest versin of the addin?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar