Support Board
Date/Time: Wed, 25 Dec 2024 17:33:39 +0000
Text/CSV Data Format - UNIXDateTime / Timestamp
View Count: 884
[2015-11-29 13:21:15] |
User553714 - Posts: 184 |
Hi, I am trying to open a chartbook with some locally stored intraday data (first line is the header) which has the following format but get an error saying "Download error"; UNIXDateTime, Open, High, Low, Close, Volume 1444690859,28.37,28.38,28.35,28.36,110200 1444690909,28.39,28.39,28.38,28.38,3900 1444690973,28.39,28.39,28.38,28.38,11000 1444691035,28.39,28.40,28.38,28.39,8100 1444691098,28.44,28.44,28.40,28.40,11400 1444691156,28.46,28.48,28.43,28.44,25000 1444691219,28.49,28.49,28.48,28.48,6600 After exporting some SC real time data the text file produced represented separate date/time in the following format Date, Time, Open, High, Low, Last, Volume, NumberOfTrades, BidVolume, AskVolume 2015/5/24, 19:04:00, 0.78297, 0.78297, 0.78297, 0.78297, 1, 1, 1, 0 I could convert my date into the format above but that still doesn't explain to me what format the "UNIXDateTime" needs to be in. My question is, can you please provide an example of the data format that the header descriptor "UNIXDateTime" needs to be in so that the data can be displayed, I get the feeling I will have to convert the timestamps into something else? Might I suggest you include an example of "UNIXDateTime" format in the online documentation section - Text/CSV Data Format>>Example for Intraday Data (example-2)? NB: I am new to SC and still finding my way around, I put in a substantial effort to try and resolve this myself before posting for help. Thanks for your help. |
[2015-11-30 09:17:21] |
Sierra Chart Engineering - Posts: 104368 |
This data format is correct: UNIXDateTime, Open, High, Low, Close, Volume
1444690859,28.37,28.38,28.35,28.36,110200 1444690909,28.39,28.39,28.38,28.38,3900 1444690973,28.39,28.39,28.38,28.38,11000 1444691035,28.39,28.40,28.38,28.39,8100 1444691098,28.44,28.44,28.40,28.40,11400 1444691156,28.46,28.48,28.43,28.44,25000 1444691219,28.49,28.49,28.48,28.48,6600 When following the instructions here we could import it without a problem: https://www.sierrachart.com/index.php?page=doc/doc_ImportExport.html#ImportLoadIntradayData We will update the documentation with a sample line with the UNIX time format. 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 Date Time Of Last Edit: 2015-11-30 09:19:39
|
To post a message in this thread, you need to log in with your Sierra Chart account: