Login Page - Create Account

Support Board


Date/Time: Wed, 15 Jan 2025 21:47:12 +0000



Date format and importing data

View Count: 991

[2017-09-17 07:42:34]
User521791 - Posts: 12
Hello, I'm trying to import data from a text file.

The fields format is as follows:

"Date","Time","Price","Volume"
20/03/2017,23:00:00.418,2374.25,2

The import goes thru but the dates are incorrect, I'm assuming Sierra was expecting to see 03/20/2017 instead of the above. Is there a way to fix this inside Sierra? The file is a single ES contract, size 757 Mb, Excel shows an error msg there are too many records.
[2017-09-18 17:27:58]
Sierra Chart Engineering - Posts: 104368
The supported Date formats are documented here:
Text/CSV Data Format: Date Format

We will see if we can quickly and support for this other date format but we do not want to make any promises. We are overly busy at this time.
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:

Login

Login Page - Create Account