Support Board
Date/Time: Tue, 13 May 2025 22:01:47 +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
|