Login Page - Create Account

Support Board


Date/Time: Thu, 19 Sep 2024 00:56:05 +0000



Post From: import intraday data / time format wt ms

[2014-06-23 14:42:48]
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