Support Board
Date/Time: Thu, 23 Jan 2025 09:53:44 +0000
Trade Activity Log Export
View Count: 3724
| [2018-11-21 18:26:27] |
| User489862 - Posts: 14 |
|
Hi, I am currently trying to export the 'Trades' tab from the 'Trade Activity Log' however I am not being given the option to export it. Why is this? Also, if I copy the log and paste it into Excel, the format of the 'Entry Date Time' and 'Exit Date Time' fields are not being copied as they show in SC. For example, instead of the 'Entry Date Time' being 18-03-19 11:33:01.006, it is instead being copied into Excel as 33.01.0 (i.e. just a small extract of what it should be. It is very important for me to be able to extract information from the Trade Activity Log and analyse it in Microsoft Excel so could you please help me sort this issue out? Many Thanks, Shayaan |
| [2018-11-21 19:55:25] |
| |
|
The only tab that can be Exported and Imported is the Trade Activity Tab. This is explained here: Trade Activity Log: Importing and Exporting Data You can always save the data from each tab (except for the Trade Statistics For Charts tab). To do this, follow the instructions here: Trade Activity Log: Saving to a Text File The reason you are seeing what you are in Excel is due to how Excel tries to automatically determine the data type. Just select those cells and select Format Cells. Then change to Time and scroll to the bottom of the list and select the Date/Time display you prefer. 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 |
| [2018-11-21 19:55:27] |
| |
|
The only tab that can be Exported and Imported is the Trade Activity Tab. This is explained here: Trade Activity Log: Importing and Exporting Data You can always save the data from each tab (except for the Trade Statistics For Charts tab). To do this, follow the instructions here: Trade Activity Log: Saving to a Text File The reason you are seeing what you are in Excel is due to how Excel tries to automatically determine the data type. Just select those cells and select Format Cells. Then change to Time and scroll to the bottom of the list and select the Date/Time display you prefer. 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: