Home >> Support Board

Support Board

Date/Time: Mon, 16 Sep 2024 19:07:21 +0000

How to Post a Message for Support

import intraday data / time format wt ms

View Count: 1795

[2014-06-19 16:06:28] #1 [Go To First Post]
ganz - Posts: 1048
Hello SC Support I need to import some intraday data (csv). a timestamp contains a millisecond part could you pls adjust this info http://www.sierrachart.com/index.php?l=doc/doc_TextCSVDataFormat.html#TimeFormat thnx

[2014-06-19 18:02:13] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Provide us an example of the time that contains milliseconds. 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

[2014-06-19 18:20:56] #3 [Go To First Post]
ganz - Posts: 1048
SC Support Date, Time, Open, High, Low, Close, Volume, NumberofTrades, BidVolume, AskVolume 20140619, 12:30:09.992, 34880, 34880, 34880, 34880, 6, 1, 0, 6 20140619, 12:30:10.069, 34880, 34880, 34880, 34880, 6, 1, 0, 6 20140619, 12:30:10.451, 34877, 34877, 34877, 34877, 2, 1, 2, 0 20140619, 12:30:11.763, 34879, 34879, 34879, 34879, 5, 1, 0, 5 20140619, 12:30:11.964, 34880, 34880, 34880, 34880, 2, 1, 0, 2 20140619, 12:30:13.224, 34880, 34880, 34880, 34880, 2, 1, 0, 2 20140619, 12:30:13.224, 34880, 34880, 34880, 34880, 3, 1, 0, 3 20140619, 12:30:13.306, 34880, 34880, 34880, 34880, 3, 1, 0, 3

[2014-06-21 08:36:39] #4 [Go To First Post]
ganz - Posts: 1048
SC Support Hm...m I'm able to build a time format as it should be so why you are asking for an example? Pls set the time format you want and I'll use it. thnx

[2014-06-23 14:42:48] #5 [Go To First Post]
ganz - Posts: 1048
SC Support there was my post ... also ... I'm trying to store a tick's datetime = 41813.000 it displays as 2014-06-23 00:00:00.500 say 1 ms = 1 day / 86400 000 = 0,000000012 if datetime = 41813.000000012 then it displays as 2014-06-23 00:00:00.501 if datetime = 41813.000000024 then it displays as 2014-06-23 00:00:00.502 so the question is: why 500 ms is already there or it's because of me? thnx another case: pls take the exmpl from post #3, remove all ms-parts and import the data Date, Time, Open, High, Low, Close, Volume, NumberofTrades, BidVolume, AskVolume 20140619, 12:30:09, 34880, 34880, 34880, 34880, 6, 1, 0, 6 20140619, 12:30:10, 34880, 34880, 34880, 34880, 6, 1, 0, 6 20140619, 12:30:10, 34877, 34877, 34877, 34877, 2, 1, 2, 0 20140619, 12:30:11, 34879, 34879, 34879, 34879, 5, 1, 0, 5 20140619, 12:30:11, 34880, 34880, 34880, 34880, 2, 1, 0, 2 20140619, 12:30:13, 34880, 34880, 34880, 34880, 2, 1, 0, 2 20140619, 12:30:13, 34880, 34880, 34880, 34880, 3, 1, 0, 3 20140619, 12:30:13, 34880, 34880, 34880, 34880, 3, 1, 0, 3 Edit --> Import and Load intraday Data so ... as you can see the 500 ms is already there http://s13.postimg.org/ns7hu9azb/test4ms1.png go the one tick back and you'll see 499ms as an unexpected part the question is the same: why 499ms or 500ms are already there? thnx Date Time Of Last Edit: 2014-06-23 14:43:27

[2014-06-25 07:12:02] #6 [Go To First Post]
ganz - Posts: 1048
SC Support As we can see the issue is related to a chart /status bar/. Tools Value Window displays the proper values of milliseconds. Date Time Of Last Edit: 2014-06-25 07:12:53

[2014-06-25 07:45:19] #7 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We have not had a chance to review the recent posts and also the code and also do testing. 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

[2014-06-25 10:03:40] #8 [Go To First Post]
ganz - Posts: 1048
SC Support The case is the status bar displays wrong numbers instead of milliseconds. That's it. So this is your choice to correct the issue or to leave it as is. I don't care.

[2014-06-26 04:31:56] #9 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
There is no problem with the status bar. We imported this data: Date, Time, Open, High, Low, Close, Volume, NumberofTrades, BidVolume, AskVolume 20140619, 12:30:09, 34880, 34880, 34880, 34880, 6, 1, 0, 6 20140619, 12:30:10, 34880, 34880, 34880, 34880, 6, 1, 0, 6 20140619, 12:30:10, 34877, 34877, 34877, 34877, 2, 1, 2, 0 20140619, 12:30:11, 34879, 34879, 34879, 34879, 5, 1, 0, 5 20140619, 12:30:11, 34880, 34880, 34880, 34880, 2, 1, 0, 2 20140619, 12:30:13, 34880, 34880, 34880, 34880, 2, 1, 0, 2 20140619, 12:30:13, 34880, 34880, 34880, 34880, 3, 1, 0, 3 20140619, 12:30:13, 34880, 34880, 34880, 34880, 3, 1, 0, 3 There were no milliseconds in the Intraday Data Editor, in the Tool Values Window or on the Status Bar. The milliseconds were 0 in each of these. The Intraday data importing function does not have support for milliseconds. We will see about adding this. 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

[2014-06-26 05:07:24] #10 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
In the next release of Sierra Chart, when importing data, there will be support for reading milliseconds from the time according to the format you give above. 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

[2014-06-28 16:17:48] #11 [Go To First Post]
ganz - Posts: 1048
SC Support There were no milliseconds in the Intraday Data Editor, in the Tool Values Window or on the Status Bar. The milliseconds were 0 in each of these. My eyes says me you are wrong: http://s28.postimg.org/3kl6j3spp/wrong_ms.png when importing data, there will be support for reading milliseconds from the time according to the format you give above. Very good. Thnx.

[2014-06-28 18:27:48] #12 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
My eyes says me you are wrong We simply do not see this from the imported data. Do you see the same timestamp in Edit >>Edit/Download Data-Intraday Chart. What time zone do you have Sierra Chart set to? 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: 2014-06-28 18:28:27

[2014-06-28 19:00:27] #13 [Go To First Post]
ganz - Posts: 1048
SC Support Do you see the same timestamp in Edit >>Edit/Download Data-Intraday Chart. The tool displays proper numbers. There is no problem with it. What time zone do you have Sierra Chart set to? DTS: Chicago Chart: Use Global TZ

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