7 Messages
Digest #4541
Messages
Fri May 10, 2019 7:37 am (PDT) . Posted by:
jimmymc00
Randy. The old browser settings under Clear Browsing Data option show the Cached data and files checked. Is that what you are referring to?
-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Fri, May 10, 2019 3:07 am
Subject: Re: [smf_addin] Slow refreash with new computer
The BarChart function was probably getting a timeout from not finding the requested web resource? It could be you were picking up a cached copy of the web page on your old computer? Did you not have the IE options set to always get a fresh copy of a web page on the old machine?
On Thu, May 9, 2019 at 6:17 PM jmcatee133@... wrote:
Downloaded fresh version of SMF Add-in with no change in lengthy update issue this morning. Started pouring through Excel settings and could find nothing that needed attention. Read a lot on Excel and memory allocation without much help but it and Tom's questions did focus me more on the Excel file itself. So, I copied the data collection sheet into a file by itself to dis associate it from all the activity of the original file that pulled data from it. This newly created data worksheet had the same lengthy update issue. While playing around with it I started deleting the hidden columns associated with the defunct BarChartPortfolioView thinking it was no longer going to re immerge one day. Its previous array had been deleted back when BarChart locked us out but he column of tickers were still there along with the headers. Interestingly enough when all those columns were eliminated the problem went away. Why they suddenly started interfering is a mystery to me after months of not interfering? Something must have gone awry the last time I closed and saved the file before migrating it to new computer. After a couple of reboots for testing I feel pretty good that the file is in good shape and operating properly in both the old and new computer. New computer is opening apps in a fraction of the time it took old one and downloading about 50% faster. Time to look at enhancing the internet speeds. Thanks for your help.
#yiv4010170567 #yiv4010170567 -- #yiv4010170567ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;} #yiv4010170567 #yiv4010170567ygrp-mkp hr { border:1px solid #d8d8d8;} #yiv4010170567 #yiv4010170567ygrp-mkp #yiv4010170567hd { color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;} #yiv4010170567 #yiv4010170567ygrp-mkp #yiv4010170567ads { margin-bottom:10px;} #yiv4010170567 #yiv4010170567ygrp-mkp .yiv4010170567ad { padding:0 0;} #yiv4010170567 #yiv4010170567ygrp-mkp .yiv4010170567ad p { margin:0;} #yiv4010170567 #yiv4010170567ygrp-mkp .yiv4010170567ad a { color:#0000ff;text-decoration:none;} #yiv4010170567 #yiv4010170567ygrp-sponsor #yiv4010170567ygrp-lc { font-family:Arial;} #yiv4010170567 #yiv4010170567ygrp-sponsor #yiv4010170567ygrp-lc #yiv4010170567hd { margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;} #yiv4010170567 #yiv4010170567ygrp-sponsor #yiv4010170567ygrp-lc .yiv4010170567ad { margin-bottom:10px;padding:0 0;} #yiv4010170567 #yiv4010170567actions { font-family:Verdana;font-size:11px;padding:10px 0;} #yiv4010170567 #yiv4010170567activity { background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} #yiv4010170567 #yiv4010170567activity span { font-weight:700;} #yiv4010170567 #yiv4010170567activity span:first-child { text-transform:uppercase;} #yiv4010170567 #yiv4010170567activity span a { color:#5085b6;text-decoration:none;} #yiv4010170567 #yiv4010170567activity span span { color:#ff7900;} #yiv4010170567 #yiv4010170567activity span .yiv4010170567underline { text-decoration:underline;} #yiv4010170567 .yiv4010170567attach { clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;} #yiv4010170567 .yiv4010170567attach div a { text-decoration:none;} #yiv4010170567 .yiv4010170567attach img { border:none;padding-right:5px;} #yiv4010170567 .yiv4010170567attach label { display:block;margin-bottom:5px;} #yiv4010170567 .yiv4010170567attach label a { text-decoration:none;} #yiv4010170567 blockquote { margin:0 0 0 4px;} #yiv4010170567 .yiv4010170567bold { font-family:Arial;font-size:13px;font-weight:700;} #yiv4010170567 .yiv4010170567bold a { text-decoration:none;} #yiv4010170567 dd.yiv4010170567last p a { font-family:Verdana;font-weight:700;} #yiv4010170567 dd.yiv4010170567last p span { margin-right:10px;font-family:Verdana;font-weight:700;} #yiv4010170567 dd.yiv4010170567last p span.yiv4010170567yshortcuts { margin-right:0;} #yiv4010170567 div.yiv4010170567attach-table div div a { text-decoration:none;} #yiv4010170567 div.yiv4010170567attach-table { width:400px;} #yiv4010170567 div.yiv4010170567file-title a, #yiv4010170567 div.yiv4010170567file-title a:active, #yiv4010170567 div.yiv4010170567file-title a:hover, #yiv4010170567 div.yiv4010170567file-title a:visited { text-decoration:none;} #yiv4010170567 div.yiv4010170567photo-title a, #yiv4010170567 div.yiv4010170567photo-title a:active, #yiv4010170567 div.yiv4010170567photo-title a:hover, #yiv4010170567 div.yiv4010170567photo-title a:visited { text-decoration:none;} #yiv4010170567 div#yiv4010170567ygrp-mlmsg #yiv4010170567ygrp-msg p a span.yiv4010170567yshortcuts { font-family:Verdana;font-size:10px;font-weight:normal;} #yiv4010170567 .yiv4010170567green { color:#628c2a;} #yiv4010170567 .yiv4010170567MsoNormal { margin:0 0 0 0;} #yiv4010170567 o { font-size:0;} #yiv4010170567 #yiv4010170567photos div { float:left;width:72px;} #yiv4010170567 #yiv4010170567photos div div { border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;} #yiv4010170567 #yiv4010170567photos div label { color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} #yiv4010170567 #yiv4010170567reco-category { font-size:77%;} #yiv4010170567 #yiv4010170567reco-desc { font-size:77%;} #yiv4010170567 .yiv4010170567replbq { margin:4px;} #yiv4010170567 #yiv4010170567ygrp-actbar div a:first-child { margin-right:2px;padding-right:5px;} #yiv4010170567 #yiv4010170567ygrp-mlmsg { font-size:13px;font-family:Arial, helvetica, clean, sans-serif;} #yiv4010170567 #yiv4010170567ygrp-mlmsg table { font-size:inherit;font:100%;} #yiv4010170567 #yiv4010170567ygrp-mlmsg select, #yiv4010170567 input, #yiv4010170567 textarea { font:99% Arial, Helvetica, clean, sans-serif;} #yiv4010170567 #yiv4010170567ygrp-mlmsg pre, #yiv4010170567 code { font:115% monospace;} #yiv4010170567 #yiv4010170567ygrp-mlmsg * { line-height:1.22em;} #yiv4010170567 #yiv4010170567ygrp-mlmsg #yiv4010170567logo { padding-bottom:10px;} #yiv4010170567 #yiv4010170567ygrp-msg p a { font-family:Verdana;} #yiv4010170567 #yiv4010170567ygrp-msg p#yiv4010170567attach-count span { color:#1E66AE;font-weight:700;} #yiv4010170567 #yiv4010170567ygrp-reco #yiv4010170567reco-head { color:#ff7900;font-weight:700;} #yiv4010170567 #yiv4010170567ygrp-reco { margin-bottom:20px;padding:0px;} #yiv4010170567 #yiv4010170567ygrp-sponsor #yiv4010170567ov li a { font-size:130%;text-decoration:none;} #yiv4010170567 #yiv4010170567ygrp-sponsor #yiv4010170567ov li { font-size:77%;list-style-type:square;padding:6px 0;} #yiv4010170567 #yiv4010170567ygrp-sponsor #yiv4010170567ov ul { margin:0;padding:0 0 0 8px;} #yiv4010170567 #yiv4010170567ygrp-text { font-family:Georgia;} #yiv4010170567 #yiv4010170567ygrp-text p { margin:0 0 1em 0;} #yiv4010170567 #yiv4010170567ygrp-text tt { font-size:120%;} #yiv4010170567 #yiv4010170567ygrp-vital ul li:last-child { border-right:none !important; } #yiv4010170567
-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Fri, May 10, 2019 3:07 am
Subject: Re: [smf_addin] Slow refreash with new computer
The BarChart function was probably getting a timeout from not finding the requested web resource? It could be you were picking up a cached copy of the web page on your old computer? Did you not have the IE options set to always get a fresh copy of a web page on the old machine?
On Thu, May 9, 2019 at 6:17 PM jmcatee133@.
Downloaded fresh version of SMF Add-in with no change in lengthy update issue this morning. Started pouring through Excel settings and could find nothing that needed attention. Read a lot on Excel and memory allocation without much help but it and Tom's questions did focus me more on the Excel file itself. So, I copied the data collection sheet into a file by itself to dis associate it from all the activity of the original file that pulled data from it. This newly created data worksheet had the same lengthy update issue. While playing around with it I started deleting the hidden columns associated with the defunct BarChartPortfolioVi
#yiv4010170567 #yiv4010170567 -- #yiv4010170567ygrp-
Fri May 10, 2019 10:54 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
No. That's a different setting. You need to tell IE to always get a fresh
copy of a web page, instead of using a saved copy of the web page. See this
item from the "Tips and FAQs" page from the website:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/13523
On Fri, May 10, 2019 at 7:37 AM jmcatee133@... wrote:
>
> Randy. The old browser settings under Clear Browsing Data option show the
> Cached data and files checked. Is that what you are referring to?
>
>
copy of a web page, instead of using a saved copy of the web page. See this
item from the "Tips and FAQs" page from the website:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/13523
On Fri, May 10, 2019 at 7:37 AM jmcatee133@.
>
> Randy. The old browser settings under Clear Browsing Data option show the
> Cached data and files checked. Is that what you are referring to?
>
>
Fri May 10, 2019 11:36 am (PDT) . Posted by:
jimmymc00
Thanks Randy. It was set on Automatic. Now changed on both computers.
So, on start up this morning the initial SMF upload went well as did the subsequent uploads. The initial download is about 30% faster and the update about 1 - 2 seconds. Awesome. However, some how during the initial download the system added 4 years and 1day to each Ticker's downloaded dates such as Earnings and Dividend dates. Not only did this occur on the SMF data but on the manually entered dates I record in another section of the Excel file that I use to track performance of my holdings. Weird. Looked at date in computer and it was fine. Used =(Today()) in spread sheet and it returned correct date. Ran virus scan and it didn't find any issues. Rebooting and repeating download didn't help. Went back to old computer and did not experience the issue. Copied Old computer file to New and downloaded SMF data and so far it is working properly.
If you or others know what likely could have caused this please fill me in. Corrupted? Otherwise don't waste any time on it. Seem to be doing well with current file.
Thanks for a great Stock Market tool!!!!
-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Fri, May 10, 2019 1:57 pm
Subject: Re: [smf_addin] Slow refreash with new computer
No. That's a different setting. You need to tell IE to always get a fresh copy of a web page, instead of using a saved copy of the web page. See this item from the "Tips and FAQs" page from the website:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/13523
On Fri, May 10, 2019 at 7:37 AM jmcatee133@... wrote:
Randy. The old browser settings under Clear Browsing Data option show the Cached data and files checked. Is that what you are referring to?
#yiv2740072120 #yiv2740072120 -- #yiv2740072120ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;} #yiv2740072120 #yiv2740072120ygrp-mkp hr { border:1px solid #d8d8d8;} #yiv2740072120 #yiv2740072120ygrp-mkp #yiv2740072120hd { color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;} #yiv2740072120 #yiv2740072120ygrp-mkp #yiv2740072120ads { margin-bottom:10px;} #yiv2740072120 #yiv2740072120ygrp-mkp .yiv2740072120ad { padding:0 0;} #yiv2740072120 #yiv2740072120ygrp-mkp .yiv2740072120ad p { margin:0;} #yiv2740072120 #yiv2740072120ygrp-mkp .yiv2740072120ad a { color:#0000ff;text-decoration:none;} #yiv2740072120 #yiv2740072120ygrp-sponsor #yiv2740072120ygrp-lc { font-family:Arial;} #yiv2740072120 #yiv2740072120ygrp-sponsor #yiv2740072120ygrp-lc #yiv2740072120hd { margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;} #yiv2740072120 #yiv2740072120ygrp-sponsor #yiv2740072120ygrp-lc .yiv2740072120ad { margin-bottom:10px;padding:0 0;} #yiv2740072120 #yiv2740072120actions { font-family:Verdana;font-size:11px;padding:10px 0;} #yiv2740072120 #yiv2740072120activity { background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} #yiv2740072120 #yiv2740072120activity span { font-weight:700;} #yiv2740072120 #yiv2740072120activity span:first-child { text-transform:uppercase;} #yiv2740072120 #yiv2740072120activity span a { color:#5085b6;text-decoration:none;} #yiv2740072120 #yiv2740072120activity span span { color:#ff7900;} #yiv2740072120 #yiv2740072120activity span .yiv2740072120underline { text-decoration:underline;} #yiv2740072120 .yiv2740072120attach { clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;} #yiv2740072120 .yiv2740072120attach div a { text-decoration:none;} #yiv2740072120 .yiv2740072120attach img { border:none;padding-right:5px;} #yiv2740072120 .yiv2740072120attach label { display:block;margin-bottom:5px;} #yiv2740072120 .yiv2740072120attach label a { text-decoration:none;} #yiv2740072120 blockquote { margin:0 0 0 4px;} #yiv2740072120 .yiv2740072120bold { font-family:Arial;font-size:13px;font-weight:700;} #yiv2740072120 .yiv2740072120bold a { text-decoration:none;} #yiv2740072120 dd.yiv2740072120last p a { font-family:Verdana;font-weight:700;} #yiv2740072120 dd.yiv2740072120last p span { margin-right:10px;font-family:Verdana;font-weight:700;} #yiv2740072120 dd.yiv2740072120last p span.yiv2740072120yshortcuts { margin-right:0;} #yiv2740072120 div.yiv2740072120attach-table div div a { text-decoration:none;} #yiv2740072120 div.yiv2740072120attach-table { width:400px;} #yiv2740072120 div.yiv2740072120file-title a, #yiv2740072120 div.yiv2740072120file-title a:active, #yiv2740072120 div.yiv2740072120file-title a:hover, #yiv2740072120 div.yiv2740072120file-title a:visited { text-decoration:none;} #yiv2740072120 div.yiv2740072120photo-title a, #yiv2740072120 div.yiv2740072120photo-title a:active, #yiv2740072120 div.yiv2740072120photo-title a:hover, #yiv2740072120 div.yiv2740072120photo-title a:visited { text-decoration:none;} #yiv2740072120 div#yiv2740072120ygrp-mlmsg #yiv2740072120ygrp-msg p a span.yiv2740072120yshortcuts { font-family:Verdana;font-size:10px;font-weight:normal;} #yiv2740072120 .yiv2740072120green { color:#628c2a;} #yiv2740072120 .yiv2740072120MsoNormal { margin:0 0 0 0;} #yiv2740072120 o { font-size:0;} #yiv2740072120 #yiv2740072120photos div { float:left;width:72px;} #yiv2740072120 #yiv2740072120photos div div { border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;} #yiv2740072120 #yiv2740072120photos div label { color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} #yiv2740072120 #yiv2740072120reco-category { font-size:77%;} #yiv2740072120 #yiv2740072120reco-desc { font-size:77%;} #yiv2740072120 .yiv2740072120replbq { margin:4px;} #yiv2740072120 #yiv2740072120ygrp-actbar div a:first-child { margin-right:2px;padding-right:5px;} #yiv2740072120 #yiv2740072120ygrp-mlmsg { font-size:13px;font-family:Arial, helvetica, clean, sans-serif;} #yiv2740072120 #yiv2740072120ygrp-mlmsg table { font-size:inherit;font:100%;} #yiv2740072120 #yiv2740072120ygrp-mlmsg select, #yiv2740072120 input, #yiv2740072120 textarea { font:99% Arial, Helvetica, clean, sans-serif;} #yiv2740072120 #yiv2740072120ygrp-mlmsg pre, #yiv2740072120 code { font:115% monospace;} #yiv2740072120 #yiv2740072120ygrp-mlmsg * { line-height:1.22em;} #yiv2740072120 #yiv2740072120ygrp-mlmsg #yiv2740072120logo { padding-bottom:10px;} #yiv2740072120 #yiv2740072120ygrp-msg p a { font-family:Verdana;} #yiv2740072120 #yiv2740072120ygrp-msg p#yiv2740072120attach-count span { color:#1E66AE;font-weight:700;} #yiv2740072120 #yiv2740072120ygrp-reco #yiv2740072120reco-head { color:#ff7900;font-weight:700;} #yiv2740072120 #yiv2740072120ygrp-reco { margin-bottom:20px;padding:0px;} #yiv2740072120 #yiv2740072120ygrp-sponsor #yiv2740072120ov li a { font-size:130%;text-decoration:none;} #yiv2740072120 #yiv2740072120ygrp-sponsor #yiv2740072120ov li { font-size:77%;list-style-type:square;padding:6px 0;} #yiv2740072120 #yiv2740072120ygrp-sponsor #yiv2740072120ov ul { margin:0;padding:0 0 0 8px;} #yiv2740072120 #yiv2740072120ygrp-text { font-family:Georgia;} #yiv2740072120 #yiv2740072120ygrp-text p { margin:0 0 1em 0;} #yiv2740072120 #yiv2740072120ygrp-text tt { font-size:120%;} #yiv2740072120 #yiv2740072120ygrp-vital ul li:last-child { border-right:none !important; } #yiv2740072120
So, on start up this morning the initial SMF upload went well as did the subsequent uploads. The initial download is about 30% faster and the update about 1 - 2 seconds. Awesome. However, some how during the initial download the system added 4 years and 1day to each Ticker's downloaded dates such as Earnings and Dividend dates. Not only did this occur on the SMF data but on the manually entered dates I record in another section of the Excel file that I use to track performance of my holdings. Weird. Looked at date in computer and it was fine. Used =(Today()) in spread sheet and it returned correct date. Ran virus scan and it didn't find any issues. Rebooting and repeating download didn't help. Went back to old computer and did not experience the issue. Copied Old computer file to New and downloaded SMF data and so far it is working properly.
If you or others know what likely could have caused this please fill me in. Corrupted? Otherwise don't waste any time on it. Seem to be doing well with current file.
Thanks for a great Stock Market tool!!!!
-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Fri, May 10, 2019 1:57 pm
Subject: Re: [smf_addin] Slow refreash with new computer
No. That's a different setting. You need to tell IE to always get a fresh copy of a web page, instead of using a saved copy of the web page. See this item from the "Tips and FAQs" page from the website:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/13523
On Fri, May 10, 2019 at 7:37 AM jmcatee133@.
Randy. The old browser settings under Clear Browsing Data option show the Cached data and files checked. Is that what you are referring to?
#yiv2740072120 #yiv2740072120 -- #yiv2740072120ygrp-
Fri May 10, 2019 12:28 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Google is your friend. For the date issue, see:
https://www.accountingweb.com/technology/excel/when-excel-dates-mysteriously-shift-by-4-years
Found by simply looking for "date in excel is four years off" on Google.
On Fri, May 10, 2019 at 11:39 AM jmcatee133@... wrote:
>
> Thanks Randy. It was set on Automatic. Now changed on both computers..
>
> So, on start up this morning the initial SMF upload went well as did the
> subsequent uploads. The initial download is about 30% faster and the
> update about 1 - 2 seconds. Awesome. However, some how during the initial
> download the system added 4 years and 1day to each Ticker's downloaded
> dates such as Earnings and Dividend dates. Not only did this occur on the
> SMF data but on the manually entered dates I record in another section of
> the Excel file that I use to track performance of my holdings. Weird.
> Looked at date in computer and it was fine. Used =(Today()) in spread
> sheet and it returned correct date. Ran virus scan and it didn't find any
> issues. Rebooting and repeating download didn't help. Went back to old
> computer and did not experience the issue. Copied Old computer file to New
> and downloaded SMF data and so far it is working properly.
>
> If you or others know what likely could have caused this please fill me
> in. Corrupted? Otherwise don't waste any time on it. Seem to be doing
> well with current file.
>
> Thanks for a great Stock Market tool!!!!
>
https://www.accountingweb.com/technology/excel/when-excel-dates-mysteriously-shift-by-4-years
Found by simply looking for "date in excel is four years off" on Google.
On Fri, May 10, 2019 at 11:39 AM jmcatee133@.
>
> Thanks Randy. It was set on Automatic. Now changed on both computers..
>
> So, on start up this morning the initial SMF upload went well as did the
> subsequent uploads. The initial download is about 30% faster and the
> update about 1 - 2 seconds. Awesome. However, some how during the initial
> download the system added 4 years and 1day to each Ticker's downloaded
> dates such as Earnings and Dividend dates. Not only did this occur on the
> SMF data but on the manually entered dates I record in another section of
> the Excel file that I use to track performance of my holdings. Weird.
> Looked at date in computer and it was fine. Used =(Today()) in spread
> sheet and it returned correct date. Ran virus scan and it didn't find any
> issues. Rebooting and repeating download didn't help. Went back to old
> computer and did not experience the issue. Copied Old computer file to New
> and downloaded SMF data and so far it is working properly.
>
> If you or others know what likely could have caused this please fill me
> in. Corrupted? Otherwise don't waste any time on it. Seem to be doing
> well with current file.
>
> Thanks for a great Stock Market tool!!!!
>
Fri May 10, 2019 5:26 pm (PDT) . Posted by:
jimmymc00
Ha! Randy is my friend!
Yep, there it was - the 1904 date convention was checked. I'm on Google a lot but it didn't occur to me to look at it for Excel answers. The hard part in all of this is going to be trying to figure out how that happened. I know on some level that I must be guilty but I sure don't know how that happened, and to 2 spreadsheets. So, I'm just going to take the 5th.
Thanks!
Note to self: buy some Google stock.
-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Fri, May 10, 2019 3:34 pm
Subject: Re: [smf_addin] Slow refreash with new computer
Google is your friend. For the date issue, see:
https://www.accountingweb.com/technology/excel/when-excel-dates-mysteriously-shift-by-4-years
Found by simply looking for "date in excel is four years off" on Google..
On Fri, May 10, 2019 at 11:39 AM jmcatee133@... wrote:
Thanks Randy. It was set on Automatic. Now changed on both computers.
So, on start up this morning the initial SMF upload went well as did the subsequent uploads. The initial download is about 30% faster and the update about 1 - 2 seconds. Awesome. However, some how during the initial download the system added 4 years and 1day to each Ticker's downloaded dates such as Earnings and Dividend dates. Not only did this occur on the SMF data but on the manually entered dates I record in another section of the Excel file that I use to track performance of my holdings. Weird. Looked at date in computer and it was fine. Used =(Today()) in spread sheet and it returned correct date. Ran virus scan and it didn't find any issues. Rebooting and repeating download didn't help. Went back to old computer and did not experience the issue. Copied Old computer file to New and downloaded SMF data and so far it is working properly.
If you or others know what likely could have caused this please fill me in. Corrupted? Otherwise don't waste any time on it. Seem to be doing well with current file.
Thanks for a great Stock Market tool!!!!
#yiv2723972075 #yiv2723972075 -- #yiv2723972075ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;} #yiv2723972075 #yiv2723972075ygrp-mkp hr { border:1px solid #d8d8d8;} #yiv2723972075 #yiv2723972075ygrp-mkp #yiv2723972075hd { color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;} #yiv2723972075 #yiv2723972075ygrp-mkp #yiv2723972075ads { margin-bottom:10px;} #yiv2723972075 #yiv2723972075ygrp-mkp .yiv2723972075ad { padding:0 0;} #yiv2723972075 #yiv2723972075ygrp-mkp .yiv2723972075ad p { margin:0;} #yiv2723972075 #yiv2723972075ygrp-mkp .yiv2723972075ad a { color:#0000ff;text-decoration:none;} #yiv2723972075 #yiv2723972075ygrp-sponsor #yiv2723972075ygrp-lc { font-family:Arial;} #yiv2723972075 #yiv2723972075ygrp-sponsor #yiv2723972075ygrp-lc #yiv2723972075hd { margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;} #yiv2723972075 #yiv2723972075ygrp-sponsor #yiv2723972075ygrp-lc .yiv2723972075ad { margin-bottom:10px;padding:0 0;} #yiv2723972075 #yiv2723972075actions { font-family:Verdana;font-size:11px;padding:10px 0;} #yiv2723972075 #yiv2723972075activity { background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} #yiv2723972075 #yiv2723972075activity span { font-weight:700;} #yiv2723972075 #yiv2723972075activity span:first-child { text-transform:uppercase;} #yiv2723972075 #yiv2723972075activity span a { color:#5085b6;text-decoration:none;} #yiv2723972075 #yiv2723972075activity span span { color:#ff7900;} #yiv2723972075 #yiv2723972075activity span .yiv2723972075underline { text-decoration:underline;} #yiv2723972075 .yiv2723972075attach { clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;} #yiv2723972075 .yiv2723972075attach div a { text-decoration:none;} #yiv2723972075 .yiv2723972075attach img { border:none;padding-right:5px;} #yiv2723972075 .yiv2723972075attach label { display:block;margin-bottom:5px;} #yiv2723972075 .yiv2723972075attach label a { text-decoration:none;} #yiv2723972075 blockquote { margin:0 0 0 4px;} #yiv2723972075 .yiv2723972075bold { font-family:Arial;font-size:13px;font-weight:700;} #yiv2723972075 .yiv2723972075bold a { text-decoration:none;} #yiv2723972075 dd.yiv2723972075last p a { font-family:Verdana;font-weight:700;} #yiv2723972075 dd.yiv2723972075last p span { margin-right:10px;font-family:Verdana;font-weight:700;} #yiv2723972075 dd.yiv2723972075last p span.yiv2723972075yshortcuts { margin-right:0;} #yiv2723972075 div.yiv2723972075attach-table div div a { text-decoration:none;} #yiv2723972075 div.yiv2723972075attach-table { width:400px;} #yiv2723972075 div.yiv2723972075file-title a, #yiv2723972075 div.yiv2723972075file-title a:active, #yiv2723972075 div.yiv2723972075file-title a:hover, #yiv2723972075 div.yiv2723972075file-title a:visited { text-decoration:none;} #yiv2723972075 div.yiv2723972075photo-title a, #yiv2723972075 div.yiv2723972075photo-title a:active, #yiv2723972075 div.yiv2723972075photo-title a:hover, #yiv2723972075 div.yiv2723972075photo-title a:visited { text-decoration:none;} #yiv2723972075 div#yiv2723972075ygrp-mlmsg #yiv2723972075ygrp-msg p a span.yiv2723972075yshortcuts { font-family:Verdana;font-size:10px;font-weight:normal;} #yiv2723972075 .yiv2723972075green { color:#628c2a;} #yiv2723972075 .yiv2723972075MsoNormal { margin:0 0 0 0;} #yiv2723972075 o { font-size:0;} #yiv2723972075 #yiv2723972075photos div { float:left;width:72px;} #yiv2723972075 #yiv2723972075photos div div { border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;} #yiv2723972075 #yiv2723972075photos div label { color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} #yiv2723972075 #yiv2723972075reco-category { font-size:77%;} #yiv2723972075 #yiv2723972075reco-desc { font-size:77%;} #yiv2723972075 .yiv2723972075replbq { margin:4px;} #yiv2723972075 #yiv2723972075ygrp-actbar div a:first-child { margin-right:2px;padding-right:5px;} #yiv2723972075 #yiv2723972075ygrp-mlmsg { font-size:13px;font-family:Arial, helvetica, clean, sans-serif;} #yiv2723972075 #yiv2723972075ygrp-mlmsg table { font-size:inherit;font:100%;} #yiv2723972075 #yiv2723972075ygrp-mlmsg select, #yiv2723972075 input, #yiv2723972075 textarea { font:99% Arial, Helvetica, clean, sans-serif;} #yiv2723972075 #yiv2723972075ygrp-mlmsg pre, #yiv2723972075 code { font:115% monospace;} #yiv2723972075 #yiv2723972075ygrp-mlmsg * { line-height:1.22em;} #yiv2723972075 #yiv2723972075ygrp-mlmsg #yiv2723972075logo { padding-bottom:10px;} #yiv2723972075 #yiv2723972075ygrp-msg p a { font-family:Verdana;} #yiv2723972075 #yiv2723972075ygrp-msg p#yiv2723972075attach-count span { color:#1E66AE;font-weight:700;} #yiv2723972075 #yiv2723972075ygrp-reco #yiv2723972075reco-head { color:#ff7900;font-weight:700;} #yiv2723972075 #yiv2723972075ygrp-reco { margin-bottom:20px;padding:0px;} #yiv2723972075 #yiv2723972075ygrp-sponsor #yiv2723972075ov li a { font-size:130%;text-decoration:none;} #yiv2723972075 #yiv2723972075ygrp-sponsor #yiv2723972075ov li { font-size:77%;list-style-type:square;padding:6px 0;} #yiv2723972075 #yiv2723972075ygrp-sponsor #yiv2723972075ov ul { margin:0;padding:0 0 0 8px;} #yiv2723972075 #yiv2723972075ygrp-text { font-family:Georgia;} #yiv2723972075 #yiv2723972075ygrp-text p { margin:0 0 1em 0;} #yiv2723972075 #yiv2723972075ygrp-text tt { font-size:120%;} #yiv2723972075 #yiv2723972075ygrp-vital ul li:last-child { border-right:none !important; } #yiv2723972075
Yep, there it was - the 1904 date convention was checked. I'm on Google a lot but it didn't occur to me to look at it for Excel answers. The hard part in all of this is going to be trying to figure out how that happened. I know on some level that I must be guilty but I sure don't know how that happened, and to 2 spreadsheets. So, I'm just going to take the 5th.
Thanks!
Note to self: buy some Google stock.
-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Fri, May 10, 2019 3:34 pm
Subject: Re: [smf_addin] Slow refreash with new computer
Google is your friend. For the date issue, see:
https://www.accountingweb.com/technology/excel/when-excel-dates-mysteriously-shift-by-4-years
Found by simply looking for "date in excel is four years off" on Google..
On Fri, May 10, 2019 at 11:39 AM jmcatee133@.
Thanks Randy. It was set on Automatic. Now changed on both computers.
So, on start up this morning the initial SMF upload went well as did the subsequent uploads. The initial download is about 30% faster and the update about 1 - 2 seconds. Awesome. However, some how during the initial download the system added 4 years and 1day to each Ticker's downloaded dates such as Earnings and Dividend dates. Not only did this occur on the SMF data but on the manually entered dates I record in another section of the Excel file that I use to track performance of my holdings. Weird. Looked at date in computer and it was fine. Used =(Today()) in spread sheet and it returned correct date. Ran virus scan and it didn't find any issues. Rebooting and repeating download didn't help. Went back to old computer and did not experience the issue. Copied Old computer file to New and downloaded SMF data and so far it is working properly.
If you or others know what likely could have caused this please fill me in. Corrupted? Otherwise don't waste any time on it. Seem to be doing well with current file.
Thanks for a great Stock Market tool!!!!
#yiv2723972075 #yiv2723972075 -- #yiv2723972075ygrp-
Fri May 10, 2019 8:38 pm (PDT) . Posted by:
"Omar Jaleel" saanajaleel
Is it possible to retrieve financial data from morningstar anymore?
On Fri, May 10, 2019, 9:37 AM jmcatee133@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Randy. The old browser settings under Clear Browsing Data option show the
> Cached data and files checked. Is that what you are referring to?
>
>
> -----Original Message-----
> From: Randy Harmelink rharmelink@gmail.com [smf_addin] <
> smf_addin@yahoogroups.com>
> To: smf_addin <smf_addin@yahoogroups.com>
> Sent: Fri, May 10, 2019 3:07 am
> Subject: Re: [smf_addin] Slow refreash with new computer
>
>
> The BarChart function was probably getting a timeout from not finding the
> requested web resource? It could be you were picking up a cached copy of
> the web page on your old computer? Did you not have the IE options set to
> always get a fresh copy of a web page on the old machine?
>
> On Thu, May 9, 2019 at 6:17 PM jmcatee133@... wrote:
>
>
> Downloaded fresh version of SMF Add-in with no change in lengthy update
> issue this morning.
> Started pouring through Excel settings and could find nothing that needed
> attention. Read a lot on Excel and memory allocation without much help but
> it and Tom's questions did focus me more on the Excel file itself. So, I
> copied the data collection sheet into a file by itself to dis associate it
> from all the activity of the original file that pulled data from it. This
> newly created data worksheet had the same lengthy update issue. While
> playing around with it I started deleting the hidden columns associated
> with the defunct BarChartPortfolioView thinking it was no longer going to
> re immerge one day. Its previous array had been deleted back when BarChart
> locked us out but he column of tickers were still there along with the
> headers. Interestingly enough when all those columns were eliminated the
> problem went away. Why they suddenly started interfering is a mystery to
> me after months of not interfering? Something must have gone awry the last
> time I closed and saved the file before migrating it to new computer.
> After a couple of reboots for testing I feel pretty good that the file is
> in good shape and operating properly in both the old and new computer.
> New computer is opening apps in a fraction of the time it took old one and
> downloading about 50% faster. Time to look at enhancing the internet
> speeds. Thanks for your help.
>
>
>
On Fri, May 10, 2019, 9:37 AM jmcatee133@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Randy. The old browser settings under Clear Browsing Data option show the
> Cached data and files checked. Is that what you are referring to?
>
>
> -----Original Message-----
> From: Randy Harmelink rharmelink@gmail.com [smf_addin] <
> smf_addin@yahoogroups.com>
> To: smf_addin <smf_addin@yahoogroups.com>
> Sent: Fri, May 10, 2019 3:07 am
> Subject: Re: [smf_addin] Slow refreash with new computer
>
>
> The BarChart function was probably getting a timeout from not finding the
> requested web resource? It could be you were picking up a cached copy of
> the web page on your old computer? Did you not have the IE options set to
> always get a fresh copy of a web page on the old machine?
>
> On Thu, May 9, 2019 at 6:17 PM jmcatee133@.
>
>
> Downloaded fresh version of SMF Add-in with no change in lengthy update
> issue this morning.
> Started pouring through Excel settings and could find nothing that needed
> attention. Read a lot on Excel and memory allocation without much help but
> it and Tom's questions did focus me more on the Excel file itself. So, I
> copied the data collection sheet into a file by itself to dis associate it
> from all the activity of the original file that pulled data from it. This
> newly created data worksheet had the same lengthy update issue. While
> playing around with it I started deleting the hidden columns associated
> with the defunct BarChartPortfolioVi
> re immerge one day. Its previous array had been deleted back when BarChart
> locked us out but he column of tickers were still there along with the
> headers. Interestingly enough when all those columns were eliminated the
> problem went away. Why they suddenly started interfering is a mystery to
> me after months of not interfering? Something must have gone awry the last
> time I closed and saved the file before migrating it to new computer.
> After a couple of reboots for testing I feel pretty good that the file is
> in good shape and operating properly in both the old and new computer.
> New computer is opening apps in a fraction of the time it took old one and
> downloading about 50% faster. Time to look at enhancing the internet
> speeds. Thanks for your help.
>
>
>
Fri May 10, 2019 11:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, their CSV files now require credentials.
On Fri, May 10, 2019 at 8:39 PM Omar Jaleel omar.jaleel@... wrote:
>
> Is it possible to retrieve financial data from morningstar anymore?
>
>
>
On Fri, May 10, 2019 at 8:39 PM Omar Jaleel omar.jaleel@
>
> Is it possible to retrieve financial data from morningstar anymore?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar