Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Script creates duplicates in Quotes.csv
Running the scripts, I get some 2.000 duplicate records for quotes in Quotes.CSV:
" Quotes.csv. Date+Symbol should be unique - ERROR. Duplicate records: "
Consequently in the Excel worksheet, the Total Value is over estimated (2x what it should be) overtime and Capital Gain is underestimated on the last day (a very big negative number, half of the Total Value).
Can you please help me correct this?
" Quotes.csv. Date+Symbol should be unique - ERROR. Duplicate records: "
Consequently in the Excel worksheet, the Total Value is over estimated (2x what it should be) overtime and Capital Gain is underestimated on the last day (a very big negative number, half of the Total Value).
Can you please help me correct this?
Comments
1. Do you have any subfolders in that Quotes folder, because when Quotes.csv is built, all subfolders are included?
2. Your error message lists symbol(s) with problem - investigate all similarly named files.
3. You might have renames setup (psConfig.txt file, area) happening, for example you get quotes for TD.TO and TD symbols, but you also have renames configures for TD.TO to TD.
LEt me know here if you still have issues after checking above.