• Registered: 2016-05-26
  • Posts: 96

Topic: Data file shows date

Hello

i have an issue with the numbers inside the CSV file.
Some of the numbers are recognized as dates. Is that because of the excel that i have on the PC?

how can i change it and is it affecting the back-tests?

Post's attachments

history data as date.PNG
history data as date.PNG 24.5 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.
  • Popov
  • Popov
  • Lead Developer
  • Offline
  • From: Bulgaria
  • Registered: 2006-11-30
  • Posts: 7,986

Re: Data file shows date

Right click on the column and select Format Cells...

http://s32.postimg.org/81yksmtad/screenshot_1882.png


Than select Number:

http://s32.postimg.org/a5900at39/screenshot_1881.png

Popov's Website

  • Registered: 2016-05-26
  • Posts: 96

Re: Data file shows date

hello i have tried that, but then it shows some number that definitely is wrong:

Post's attachments

data file.PNG
data file.PNG 19.43 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.
  • Popov
  • Popov
  • Lead Developer
  • Offline
  • From: Bulgaria
  • Registered: 2006-11-30
  • Posts: 7,986

Re: Data file shows date

Your Excel is set to work in Bulgarian. It doesn't accept numbers with dot '.' as numbers. If you see your screenshot, it prints the numbers in the left side of the cells. That means it accept the values as strings. This is the reason it thinks that 1.11 is November 1st.
A solution is to change the localisation settings of your windows to GB or USA.

Popov's Website

  • Registered: 2016-05-26
  • Posts: 96

Re: Data file shows date

Thank you for the help!!!