Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 12:07:35 +0000



Trade Activity Log - Date Time format after export to Excel

View Count: 1973

[2017-01-19 11:08:06]
Marmany - Posts: 301
This is an observation rather than a complaint.
When Trades tab is exported to Excel using Edit/Copy All/Paste the format in Entry & Exit Date Time columns changes from YYY-MM-DD HH:MM:SS.xyz to MM:SS.0
When the Excel columns are manually re-formatted to the full format all the data is visible.
Prior to a SC update I applied last December the full format was retained in Excel as the data was imported.
When Trades tab is saved as a txt file and opened as a Sierra spreadsheet the full format is retained. However on copying that file and pasting into Excel the columns are formatted MM:SS.0
For info Copy All/Paste into either MS Notepad or Word and the full format is retained. Nothing has been changed on my Excel settings since the formatting was retained last November.

Obviously it is not a big deal for me to re-format a couple of Excel columns.
Please advise if this makes sense to you and there is a simple way to revert so that data imports directly to Excel in the full format.
Many thanks
[2017-01-19 18:19:40]
Sierra Chart Engineering - Posts: 104368
You really have to look at Excel for a solution.

If you see the full format when pasting into a text editor, then the data is correct. It is nothing more than plaintext 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
[2017-01-19 18:59:26]
Marmany - Posts: 301
Looked into situation in more detail. From last Nov Sierra stated to transmit time value down to millisecond level. For some reason this was not handled correctly in Excel which was only set with default level to seconds.
I have altered default format in Excel to accept milliseconds and problem is solved!

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account