Support Board

Date/Time: Sat, 20 Apr 2024 05:46:32 +0000

Post From: Python for Sierra Chart

[2021-06-18 20:09:53] Link To Thread - Link To Post [Go To First Post]
biconoid - Posts: 5
As per https://docs.python.org/3/library/struct.html there are only three options to unpack 64 bits (8 bytes), i.e. q, Q and d. What would be correct structure to unpack? Format C Python Standard Type Type Size(bytes) --------------------------------------------------- Q unsigned long long integer 8 q long long integer 8 d double float 8 Also Sierra documentation mentions Versions prior to 2151, use a double precision floating point type variable to represent Date-Time values. Just for testing purposes i've tested using q and Q. $ cat files/data.tsv Date Open High Low Close Volume NumberOfTrades BidVolume AskVolume 3795467579000000.0 2623.0 0.0 2623.0 2623.0 1 1 1 0 3795948047000000.0 2717.0 0.0 2717.0 2717.0 1 1 1 0 3796150099000000.0 2750.0 0.0 2750.0 2750.0 1 1 1 0 3796636617000000.0 2742.5 2757.75 2742.5 2742.5 1 1 1 0 When unpacking using Q or q. >>> datetime.fromtimestamp(3795467579) datetime.datetime(2090, 4, 9, 20, 32, 59) >>> and >>> datetime.fromtimestamp(3795467579000000.0 ) Traceback (most recent call last): File "<stdin>", line 1, in <module> ValueError: year 120275549 == out of range >>> Date Time Of Last Edit: 2021-06-18 20:26:19