Support Board
Date/Time: Thu, 28 Nov 2024 07:16:39 +0000
CSV format problem
View Count: 1350
| [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,,, |
| [2013-11-06 02:28:01] |
| |
|
This format looks correct. So the chart is blank? Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2013-11-06 06:11:01] |
| plaforte - Posts: 13 |
|
yes the chart is blank.
|
| [2013-11-06 21:54:24] |
| |
|
Make sure the data file is stored in the Global Settings >>General Settings >> Data Files Folder. Most likely that is the problem because it is not in that folder.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: