Check Data Files returns Error, I can't find the problem

xcerik

When I update, I get the following errors.
Quotes.csv. Minimum date in file should be after configured MinDate
- ERROR. Actual minimum date in file
Quotes.csv. Maximum date in file should be today or before
- ERROR. Actual maximum date in file 2018-03-23

Today's date is 2018-03-24, so the max date checks out. I also checked that there is no date earlier than my min date 2014-12-31.

A refresh still works fine, but I'm just curious why I get this error.

VidasMatelis

Can you send me all files from psdata folder and your psconfig.txt file. My email is on contact us page.

VidasMatelis

Hi, thanks for the files. Please check quotes file (Quotes folder) for symbol F00000WA4T.TO. It is very likely at the end of the file there is empty line that has tab symbol in it - delete that line and it should be good.
In your quotes.csv file there are lines:

2017-04-28	11.13	F00000WA4T.TO
2017-05-24	10.97	F00000WA4T.TO
		
2014-12-31	12.516300	BTG774
2015-01-30	13.208700	BTG774

And empty line should not be there.

xcerik

Thanks, it turns out the line at the top of the quotes file from BTG774 just had two commas.

Does the make data files script include all files in the Quotes folder, even if they are not listed in psConfig.txt ?

VidasMatelis

Yes, includes all *.txt files from Quotes folder and subfolders. If you do not want to include files, change extension from .txt to .txt2.