help with errors please

jagmanvdp

I am re configuring where i get my quotes for my data after quite some time. The error file i get is as follows

Could you help me decipher what i am doing wrong please?

15:26:56 --- Starting script CheckPSFiles.ps1
15:26:57 File Dates.csv. Record count: 3247
Dates.csv. Row count - must be at least 2 (header and at least one date) - OK
Dates.csv. First row (file header) should be 'Date' - OK
Dates.csv. All but first row (header) should be in format YYYY-MM-DD - OK
Dates.csv. Minimum date in file should be configured MinDate - OK (2008-12-31)
Dates.csv. Maximum date in file should be today - OK (2017-11-19)
Dates.csv. Dates should be unique - OK
15:26:57 File Dates.csv check completed. No issues found.
15:26:57 File Quotes.csv. Record count: 4096
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 - ERROR. Actual minimum date in file 2007-12-21
Quotes.csv. Maximum date in file should be today or before - ERROR. Actual maximum date in file 2017-07-21
Quotes.csv. Date+Symbol should be unique - OK
15:26:57 File Quotes.csv check completed. Errors found - please review
15:26:57 File Dividends.csv. Record count: 717
Dividends.csv. Row count - must be at least 1 (header) - OK
Dividends.csv. First row (header) should be 'PayDate DividendPerShare Symbol' - OK
Dividends.csv. Each row should have exactly two column separators (' ') - OK
Dividends.csv. All rows should have 'PayDate' column in format YYYY-MM-DD - OK
Dividends.csv. Minimum date in file should be configured MinDate - ERROR. Actual minimum date in file 2007-12-27
Dividends.csv. Maximum date in file should be today or before - ERROR. Actual maximum date in file 2017-03-15
Dividends.csv. Date+Symbol should be unique - OK
15:26:57 File Dividends.csv check completed. Errors found - please review
15:26:57 File CurrencyConv.csv. Record count: 4686
CurrencyConv.csv. Row count - must be at least 1 (header) - OK
CurrencyConv.csv. First row should be 'Date ExchRate CurrencyFrom CurrencyTo' - OK
CurrencyConv.csv. Each row should have exactly three column separators (' ') - OK
CurrencyConv.csv. All rows should have 'Date' column in format YYYY-MM-DD - OK
CurrencyConv.csv. Minimum date in file should be configured MinDate - ERROR. Actual minimum date in file 2007-12-21
CurrencyConv.csv. Maximum date in file should be today or before - ERROR. Actual maximum date in file 2017-04-28
CurrencyConv.csv. Date+CurrencyFrom+CurrencyTo should be unique - OK
15:26:57 File CurrencyConv.csv check completed. Errors found - please review
15:26:57 --- Finished. Duration: 1 sec.

VidasMatelis

Error is in your currency conversion file - you have conversion data before mindate. Solution - review files in currencyConv folder and delete records with dates before mindate

jagmanvdp

Hello;;

changed the min date data and removed what i could prior to min date...still getting all kinds of errors around dates...

is there a file i can send you so that you can see the errors?

jagmanvdp

perhaps this one would explain it

December 2, 2017 1:45:34 PM


=======================================================================================
13:45:34 --- Starting script CheckPSFiles.ps1
13:45:34 File Dates.csv. Record count: 3260
Dates.csv. Row count - must be at least 2 (header and at least one date) - OK
Dates.csv. First row (file header) should be 'Date' - OK
Dates.csv. All but first row (header) should be in format YYYY-MM-DD - OK
Dates.csv. Minimum date in file should be configured MinDate - OK (2008-12-31)
Dates.csv. Maximum date in file should be today - OK (2017-12-02)
Dates.csv. Dates should be unique - OK
13:45:35 File Dates.csv check completed. No issues found.
13:45:35 File Quotes.csv. Record count: 4096
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 - ERROR. Actual minimum date in file 2007-12-21
Quotes.csv. Maximum date in file should be today or before - ERROR. Actual maximum date in file 2017-07-21
Quotes.csv. Date+Symbol should be unique - OK
13:45:35 File Quotes.csv check completed. Errors found - please review
13:45:35 File Dividends.csv. Record count: 717
Dividends.csv. Row count - must be at least 1 (header) - OK
Dividends.csv. First row (header) should be 'PayDate DividendPerShare Symbol' - OK
Dividends.csv. Each row should have exactly two column separators (' ') - OK
Dividends.csv. All rows should have 'PayDate' column in format YYYY-MM-DD - OK
Dividends.csv. Minimum date in file should be configured MinDate - ERROR. Actual minimum date in file 2007-12-27
Dividends.csv. Maximum date in file should be today or before - ERROR. Actual maximum date in file 2017-03-15
Dividends.csv. Date+Symbol should be unique - OK
13:45:35 File Dividends.csv check completed. Errors found - please review
13:45:35 File CurrencyConv.csv. Record count: 4033
CurrencyConv.csv. Row count - must be at least 1 (header) - OK
CurrencyConv.csv. First row should be 'Date ExchRate CurrencyFrom CurrencyTo' - OK
CurrencyConv.csv. Each row should have exactly three column separators (' ') - ERROR. Bad records bellow:
SD


2










CurrencyConv.csv. All rows should have 'Date' column in format YYYY-MM-DD - ERROR. Bad records bellow:
SD,,,

CurrencyConv.csv. Minimum date in file should be configured MinDate - ERROR. Actual minimum date in file 2
CurrencyConv.csv. Maximum date in file should be today or before - ERROR. Actual maximum date in file SD
CurrencyConv.csv. Date+CurrencyFrom+CurrencyTo should be unique - OK
13:45:35 File CurrencyConv.csv check completed. Errors found - please review
13:45:35 --- Finished. Duration: 1 sec.
=======================================================================================

jagmanvdp

i am going through the quote files and deleting any quotes prior to the min date

what other files should I be altering if any)

Darren

jagmanvdp

nevermind...too messed up
going to erase portfolio slicer and start over
thanks

VidasMatelis

As you just staring - it is best to delete all files and keep just Scripts folder and your psConfig.txt. Then delete all other folders, like Quotes, QUotesIntraDay, Dividends, CurrExchIntraDay, CurrExch. Then re-run script. First in psCOnfig.txt include just a few symbols. Then add same symbols into Excel Symbol table, add few transactions and refresh. After you see meaningful data, add few more symbols, more transactions and refresh. First just add buy transactions for all your holding positions. Later add dividends. The more data you will add, the better picture of your investments you will get.

jagmanvdp

thanks
i will try, but i have never been able to get PS to work properly for me..

jagmanvdp

I just wanted to let you know i started over again, and it's working far better now. Thanks for your help.