Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Duplicate entries in Quotes.csv
When I run the external data scripts (latest version), 3 or 4 dates of data keep coming up as duplicates and are always found at the end of list of all quotes and before the list of today's quotes. Here is today's version:
2019-06-07 16230.96 ^GSPTSE
2019-06-07 2873.34 ^GSPC
2019-06-07 27.53 BAC
2019-06-07 10.55 BB.TO
2019-06-07 2.0700 BBD-B.TO
2019-06-07 19.45 BBD-PC.TO
2019-06-07 17.39 BPF-UN.TO
2019-06-07 5.97 CLIQ.TO
2019-06-07 103.48 CM.TO
2019-06-07 135.40 CTC-A.TO
2019-06-07 28.34 CWB.TO
2019-06-07 51.87 FTS.TO
2019-06-07 44.06 LNR.TO
2019-06-07 130.28 MCK
2019-06-07 13.25 MRD.TO
2019-06-07 131.40 MSFT
2019-06-07 26.72 REI-UN.TO
2019-06-07 RIM.TO
2019-06-07 27.71 SJR-B.TO
2019-06-07 31.95 STN.TO
2019-06-07 40.52 SU.TO
2019-06-07 37.17 TOL
2019-06-07 51.97 WBA
2019-06-07 45.63 WFC
2019-09-06 16535.33 ^GSPTSE
2019-09-06 2978.71 ^GSPC
2019-09-06 27.73 BAC
2019-09-06 9.48 BB.TO
2019-09-06 1.7800 BBD-B.TO
2019-09-06 0.1050 BRY.TO
2019-09-06 5.77 CLIQ.TO
2019-09-06 103.54 CM.TO
2019-09-06 COS.TO
2019-09-06 137.71 CTC-A.TO
2019-09-06 55.62 FTS.TO
2019-09-06 LIQ.TO
2019-09-06 12.30 MRD.TO
2019-09-06 139.10 MSFT
2019-09-06 26.15 SJR-B.TO
2019-09-06 36.70 TOL
2019-09-06 52.56 WBA
2019-09-06 47.15 WFC
2019-05-24 16230.04 ^GSPTSE
2019-05-24 2826.06 ^GSPC
2019-05-24 28.18 BAC
2019-05-24 10.83 BB.TO
2019-05-24 2.0700 BBD-B.TO
2019-05-24 19.42 BBD-PC.TO
2019-05-24 17.10 BPF-UN.TO
2019-05-24 5.32 CLIQ.TO
2019-05-24 104.56 CM.TO
2019-05-24 138.60 CTC-A.TO
2019-05-24 28.11 CWB.TO
2019-05-24 50.78 FTS.TO
2019-05-24 45.06 LNR.TO
2019-05-24 129.92 MCK
2019-05-24 13.50 MRD.TO
2019-05-24 126.24 MSFT
2019-05-24 26.59 REI-UN.TO
2019-05-24 RIM.TO
2019-05-24 27.30 SJR-B.TO
2019-05-24 32.01 STN.TO
2019-05-24 41.81 SU.TO
2019-05-24 36.31 TOL
2019-05-24 51.77 WBA
2019-05-24 46.17 WFC
2019-07-02 16471.29 ^GSPTSE
2019-07-02 2973.01 ^GSPC
2019-07-02 29.15 BAC
2019-07-02 9.76 BB.TO
2019-07-02 2.1500 BBD-B.TO
2019-07-02 19.62 BBD-PC.TO
2019-07-02 17.48 BPF-UN.TO
2019-07-02 0.1300 BRY.TO
2019-07-02 5.80 CLIQ.TO
2019-07-02 104.15 CM.TO
2019-07-02 COS.TO
2019-07-02 140.85 CTC-A.TO
2019-07-02 29.72 CWB.TO
2019-07-02 52.00 FTS.TO
2019-07-02 LIQ.TO
2019-07-02 48.71 LNR.TO
2019-07-02 135.86 MCK
2019-07-02 12.75 MRD.TO
2019-07-02 136.58 MSFT
2019-07-02 26.23 REI-UN.TO
2019-07-02 RIM.TO
2019-07-02 26.86 SJR-B.TO
2019-07-02 31.80 STN.TO
2019-07-02 40.85 SU.TO
2019-07-02 36.93 TOL
2019-07-02 WAG
2019-07-02 54.96 WBA
2019-07-02 47.23 WFC
So that I do not get incorrect ending values for those days and the day before or after, I edit Quotes.csv to delete them before I run the Update All on the Excel spreadsheet.
Any thoughts as to what I should do?
2019-06-07 16230.96 ^GSPTSE
2019-06-07 2873.34 ^GSPC
2019-06-07 27.53 BAC
2019-06-07 10.55 BB.TO
2019-06-07 2.0700 BBD-B.TO
2019-06-07 19.45 BBD-PC.TO
2019-06-07 17.39 BPF-UN.TO
2019-06-07 5.97 CLIQ.TO
2019-06-07 103.48 CM.TO
2019-06-07 135.40 CTC-A.TO
2019-06-07 28.34 CWB.TO
2019-06-07 51.87 FTS.TO
2019-06-07 44.06 LNR.TO
2019-06-07 130.28 MCK
2019-06-07 13.25 MRD.TO
2019-06-07 131.40 MSFT
2019-06-07 26.72 REI-UN.TO
2019-06-07 RIM.TO
2019-06-07 27.71 SJR-B.TO
2019-06-07 31.95 STN.TO
2019-06-07 40.52 SU.TO
2019-06-07 37.17 TOL
2019-06-07 51.97 WBA
2019-06-07 45.63 WFC
2019-09-06 16535.33 ^GSPTSE
2019-09-06 2978.71 ^GSPC
2019-09-06 27.73 BAC
2019-09-06 9.48 BB.TO
2019-09-06 1.7800 BBD-B.TO
2019-09-06 0.1050 BRY.TO
2019-09-06 5.77 CLIQ.TO
2019-09-06 103.54 CM.TO
2019-09-06 COS.TO
2019-09-06 137.71 CTC-A.TO
2019-09-06 55.62 FTS.TO
2019-09-06 LIQ.TO
2019-09-06 12.30 MRD.TO
2019-09-06 139.10 MSFT
2019-09-06 26.15 SJR-B.TO
2019-09-06 36.70 TOL
2019-09-06 52.56 WBA
2019-09-06 47.15 WFC
2019-05-24 16230.04 ^GSPTSE
2019-05-24 2826.06 ^GSPC
2019-05-24 28.18 BAC
2019-05-24 10.83 BB.TO
2019-05-24 2.0700 BBD-B.TO
2019-05-24 19.42 BBD-PC.TO
2019-05-24 17.10 BPF-UN.TO
2019-05-24 5.32 CLIQ.TO
2019-05-24 104.56 CM.TO
2019-05-24 138.60 CTC-A.TO
2019-05-24 28.11 CWB.TO
2019-05-24 50.78 FTS.TO
2019-05-24 45.06 LNR.TO
2019-05-24 129.92 MCK
2019-05-24 13.50 MRD.TO
2019-05-24 126.24 MSFT
2019-05-24 26.59 REI-UN.TO
2019-05-24 RIM.TO
2019-05-24 27.30 SJR-B.TO
2019-05-24 32.01 STN.TO
2019-05-24 41.81 SU.TO
2019-05-24 36.31 TOL
2019-05-24 51.77 WBA
2019-05-24 46.17 WFC
2019-07-02 16471.29 ^GSPTSE
2019-07-02 2973.01 ^GSPC
2019-07-02 29.15 BAC
2019-07-02 9.76 BB.TO
2019-07-02 2.1500 BBD-B.TO
2019-07-02 19.62 BBD-PC.TO
2019-07-02 17.48 BPF-UN.TO
2019-07-02 0.1300 BRY.TO
2019-07-02 5.80 CLIQ.TO
2019-07-02 104.15 CM.TO
2019-07-02 COS.TO
2019-07-02 140.85 CTC-A.TO
2019-07-02 29.72 CWB.TO
2019-07-02 52.00 FTS.TO
2019-07-02 LIQ.TO
2019-07-02 48.71 LNR.TO
2019-07-02 135.86 MCK
2019-07-02 12.75 MRD.TO
2019-07-02 136.58 MSFT
2019-07-02 26.23 REI-UN.TO
2019-07-02 RIM.TO
2019-07-02 26.86 SJR-B.TO
2019-07-02 31.80 STN.TO
2019-07-02 40.85 SU.TO
2019-07-02 36.93 TOL
2019-07-02 WAG
2019-07-02 54.96 WBA
2019-07-02 47.23 WFC
So that I do not get incorrect ending values for those days and the day before or after, I edit Quotes.csv to delete them before I run the Update All on the Excel spreadsheet.
Any thoughts as to what I should do?
Comments
My email is posted on this page: http://www.portfolioslicer.com/contact.html
Thanks for sending me your files.
Each line in Quotes.csv file should have Date followed by TAB symbol followed by price followed by TAB symbol and then followed by Symbol. These lines you identified does not have TAB symbol, but have SPACE symbol between values - that is not right.
I suspect that somewhere in Quotes folder you have subfolder(s) with these values that are appended to Quotes.csv file. Could you please check each subfoloder in Quotes FOLDER and if cannot find anything, please zip and send me your Quotes FOLDER (not file, but FOLDER)