›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Quotes.csv error

Comments

  • MatMat
    It works. Thanks.
    However, when downloading, I got the error messages below. How can I fix it?
    The reports in Portfolio Slicer seem okay though.


    02:05:14 File Quotes.csv. Record count: 864
    Quotes.csv. Row count - must be at least 2 (header and at least one record) - OK
    Quotes.csv. First row (file header) should be 'Date Close Symbol' - OK
    Quotes.csv. Each row should have exactly two column separators (' ') - OK
    Quotes.csv. All rows should have 'Date' column in format YYYY-MM-DD - OK
    Quotes.csv. Minimum date in file should be after configured MinDate - OK (2014-12-31)
    Quotes.csv. Maximum date in file should be today or before - OK (2017-09-08)
    Quotes.csv. Date+Symbol should be unique - ERROR. Duplicate records:
    2017-09-08,30.350000,HXT.TO
    2017-09-08,30.350000,HXT.TO
    2017-09-08,30.350000,HXT.TO
    2017-09-08,30.350000,HXT.TO
    2017-09-08,30.350000,HXT.TO
    2017-09-08,15.540000,RIT.TO
    2017-09-08,15.540000,RIT.TO
    2017-09-08,15.540000,RIT.TO
    2017-09-08,15.540000,RIT.TO
    2017-09-08,15.540000,RIT.TO
    2017-09-08,25.059999,VAB.TO
    2017-09-08,25.059999,VAB.TO
    2017-09-08,25.059999,VAB.TO
    2017-09-08,25.059999,VAB.TO
    2017-09-08,25.059999,VAB.TO
    2017-09-08,22.490000,XAW.TO
    2017-09-08,22.490000,XAW.TO
    2017-09-08,22.490000,XAW.TO
    2017-09-08,22.490000,XAW.TO
    2017-09-08,22.490000,XAW.TO
  • VidasMatelisVidasMatelis
    This error tells you that you have duplicates for these quotes. Please check your quotes subfolder and review files and try to find where you have error. If you cannot, delete all data and re-run scripts. If that does not help, delete all date, leave in psConfig.txt just one symbol and extract data for that symbol. If that works OK, keep adding symbols to psConfig.txt.
  • shawnishawni
    I have a similar issue. I can't get portfolio slicer to update since September 6th. I tried something with the scripts and I think I made it worse. Not sure what to do at this point. Any suggestions?
  • VidasMatelisVidasMatelis
    Review files in quotes subfolder and delete duplicate records. You can see symbols affected in psdata\error.txt file.
  • shawnishawni
    Should I just download the newest version of portfolio slicer and start over?
  • VidasMatelisVidasMatelis
    Last update to the script GetQuotesYahoo.ps1 was on 2017-09-08 2:06pm. If you have earlier timestamp, then please re-download script.
Sign In or Register to comment.