Support Board
Date/Time: Fri, 07 Feb 2025 18:22:32 +0000
Extracting transactional data as a CSV or Excel file
View Count: 2477
| [2019-02-18 21:36:29] |
| Sabahudin - Posts: 2 |
|
Hi, I am wondering if I am able to extract historical transactional data through Sierra Chart as a CSV or Excel file? If so, how do I do it? I am using AMP Futures as my broker. Thank you! Kind regards, |
| [2019-02-19 18:25:52] |
| |
|
Have a look at the Trade Activity Log: Trade Activity Log You can export data from that log: Trade Activity Log: Importing and Exporting Data 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 |
| [2020-06-07 02:00:50] |
| User144295 - Posts: 70 |
|
Hi, would you please know why some of the transactions are exported like this: 3.6.2020 16:11 and some of them like this? 2020-06-03 16:17:09.069 Thank you |
| [2020-06-08 01:38:35] |
| |
|
Precisely how do you come to that conclusion and observation? The first format does not make any sense to us and is a 110% impossibility.
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: 2020-06-08 01:38:54
|
| [2020-06-08 02:15:31] |
| User144295 - Posts: 70 |
|
1. exported from sierra to txt delimited. no problem. 2. opened by excel as tab delimited. no problem in small preview window all looks good. (now i realized i had to switch DateTime column to text as importing. 3. finish and opened in excel sheet. looks good now. observation (if i import DateTime as general or date/time column it is importing in 90% as this 3.6.2020 16:11 and 10% as this 2020-06-03 16:17:09.069) as text, it looks 100% as this 2020-06-03 16:17:09.069 we can close the issue now. i just wanted to reply with observation. thanks, bye |
To post a message in this thread, you need to log in with your Sierra Chart account: