Support Board
Date/Time: Thu, 26 Dec 2024 05:05:42 +0000
Post From: Text/CSV Data Format - UNIXDateTime / Timestamp
| [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. |