I have a .csv file like this:
Date,Open(BP.L),High(BP.L),Low(BP.L),Close(BP.L),VOL(BP.L)
06/09/2022 15:00,451.3,451.6,451.1,451.55,135887
06/09/2022 14:55,453.35,453.4,451.05,451.4,305238
06/09/2022 14:50,454.75,454.9,453.3,453.3,397478
but get this error:
where is my mistake?
PS I converted (saved as) an .xls file into csv (not sure makes any difference)
Date,Open(BP.L),High(BP.L),Low(BP.L),Close(BP.L),VOL(BP.L)
06/09/2022 15:00,451.3,451.6,451.1,451.55,135887
06/09/2022 14:55,453.35,453.4,451.05,451.4,305238
06/09/2022 14:50,454.75,454.9,453.3,453.3,397478
but get this error:
where is my mistake?
PS I converted (saved as) an .xls file into csv (not sure makes any difference)
Rename
Although on the surface your settings match the sample data, there must be some 'bad' line in the actual data.
Are you sure that it's dd/MM/yyyy and not MM/dd/yyyy?
It's not clear from the sample data.
It's not clear from the sample data.
Email us the problem file (support@wealth-lab.com) and we can figure this out.
thanks! I will ... my C:drive on the workstation just failed, so it's gonna take me sometime though ;-(
Your Response
Post
Edit Post
Login is required