Support Board
Date/Time: Sun, 15 Jun 2025 07:18:27 +0000
[Programming Help] - Problems In Directly Converting Trade Activity Log .data Files to CSV
View Count: 305
[2025-05-13 08:52:39] |
User61576 - Posts: 450 |
I am working on automating the export of trade activity data from Sierra Chart. I understand that the Trade Activity Log can be saved as a text file, which is easy to convert to CSV. However, my supervisor has asked if it is possible to skip the manual step of saving as text and instead directly convert the .data files found in the TradeActivityLogs folder to CSV using code. I have tried reading these .data files directly, but I am encountering several issues: The files contain many non-printable characters. The columns are often blank or do not align with the expected data fields. Is there any official or supported way to directly convert these .data files to CSV, or are these files in a proprietary binary format that is not intended to be parsed outside of Sierra Chart? If direct conversion is not possible, please confirm so I can share your response with my supervisor. Thank you for your help. |
[2025-05-19 07:29:20] |
User558609 - Posts: 4 |
I am very much interested in this as well, would it be possible to have a way to decode the .data binary so that we can work with our trade execution data?
|
[2025-05-19 10:04:52] |
seandunaway - Posts: 352 |
+1, please document the binary format
|
[2025-05-19 13:38:05] |
Sierra_Chart Engineering - Posts: 19916 |
We could add an ACSIL function to do Trade Activity Log to text file exports.
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, use the Teton service: Sierra Chart Teton Futures Order Routing |
[2025-05-19 14:07:59] |
User61576 - Posts: 450 |
Amazing! thanks! looking fwd for this |
[2025-05-19 14:08:30] |
seandunaway - Posts: 352 |
would you please consider documenting the data structures, similar to s_IntradayRecord?
|
[2025-06-12 17:42:30] |
User61576 - Posts: 450 |
any update on this?
|
To post a message in this thread, you need to log in with your Sierra Chart account: