Login Page - Create Account

Support Board


Date/Time: Sat, 11 Jan 2025 14:59:51 +0000



Exporting Data Without Milliseconds

View Count: 620

[2016-12-13 00:48:54]
User760942 - Posts: 120
Hi SC,

When exporting data to CSV using the feature in the link below, is it possible to have the resulting CSV file not include milliseconds?

Edit Menu: Edit >> Export Bar and Study Data to Text File

For instance, instead of the timestamps in the CSV looking like this:

Date, Time, Open, High, Low, Last, Volume, NumberOfTrades, BidVolume, AskVolume
2016/6/16, 16:30:00, 2079.25, 2079.25, 2079.25, 2079.25, 31, 1, 0, 31
2016/6/16, 16:30:00.1, 2078.75, 2078.75, 2078.75, 2078.75, 1, 1, 1, 0
2016/6/16, 16:30:00.2, 2078.75, 2078.75, 2078.75, 2078.75, 2, 1, 2, 0

I would like them to look like this:
Date, Time, Open, High, Low, Last, Volume, NumberOfTrades, BidVolume, AskVolume
2016/6/16, 16:30:00, 2079.25, 2079.25, 2079.25, 2079.25, 31, 1, 0, 31
2016/6/16, 16:30:00, 2078.75, 2078.75, 2078.75, 2078.75, 1, 1, 1, 0
2016/6/16, 16:30:00, 2078.75, 2078.75, 2078.75, 2078.75, 2, 1, 2, 0
[2016-12-13 08:32:52]
Sierra Chart Engineering - Posts: 104368
No it is not. You would need to do additional processing through a Spreadsheet program to remove that.
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:

Login

Login Page - Create Account