Home >> Support Board

Support Board

Date/Time: Sun, 12 Jan 2025 09:20:05 +0000

How to Post a Message for Support

unixdatetime import issues

View Count: 950

[2017-02-10 21:38:59] #1 [Go To First Post]
Joe Hobart - Posts: 89
when i try to import this data, the ticks import correctly, but the timestamps are all broken to 0:00 UNIXDateTime, Price, Volume 1486650600000,18.81,200 1486650600000,18.81,206 1486650600000,18.81,100 1486650600000,18.81,200 1486650600000,18.81,100 1486650600000,18.81,100 1486650600000,18.81,100 1486650600000,18.81,100 1486650600000,18.81,400 1486650600000,18.81,200 1486650600000,18.81,400 1486650600000,18.81,200 1486650600000,18.81,400 1486650600000,18.81,100 1486650600000,18.81,300 1486650600000,18.81,200 1486650600000,18.81,200 1486650600000,18.805,100 1486650601000,18.8,352 1486650601000,18.81,100 1486650601000,18.81,200 1486650601000,18.8,161 1486650601000,18.8,300 1486650601000,18.8,352 1486650602000,18.8,100 1486650602000,18.8,543 1486650602000,18.8,300

[2017-02-11 23:57:02] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
There are too many zeros in these UNIX timestamps. What exactly is the format? Is this in milliseconds? Or seconds? 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: 2017-02-11 23:57:51

[2017-02-12 03:04:18] #3 [Go To First Post]
Joe Hobart - Posts: 89
this is straight from IQFeed. this is tick data from a stock, so i assume the extra digits are for milliseconds

[2017-02-12 03:32:01] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We checked and these values are simply not valid. Refer to: https://en.wikipedia.org/wiki/Unix_time Contact IQ feed and have them correct them. 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: 2017-02-12 03:49:49

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