Support Board
Date/Time: Thu, 28 Nov 2024 09:37:31 +0000
Post From: CSV format problem
| [2013-11-04 23:13:16] |
| plaforte - Posts: 13 |
|
Hello, I have an excel file of historical data. The date format is DD/MM/YYYY, when I reformat this column to make it as per SC valid format, the excel closest format is YYYY-MM-DD when I make the change to this format and save my excel as CSV, excel automatically changes back to the original DD/MM/YYYY format. I tried many times and could not get excel to not change the format. So I opened the CSV file in notepad and could and modified to the below format, which seems ok but that won't load in a new chart, I get download failed error. Any idea what is wrong with the below format ? I attached this notepad file. Date,Open,High,Low,Close,,, 1973/08/17,69.25,69.5,69.03,69.45,,, 1973/08/20,70.3,70.4,69.65,69.65,,, |