Reply

Histdata tick data upload

4 replies

vostrushka

Customer, bbp_participant, community, 48 replies.

Visit profile

7 years ago #116368

Could you help me upload Histdata tick datafiles into Data manager?

 

Here is the sample of data:

Date          Time           Bid           Ask         Volume

20160103 170015493,1.087010,1.087510,0

20160103 170038993,1.087030,1.087490,0
20160103 170041493,1.087130,1.087490,0
20160103 170041993,1.087130,1.087450,0
20160103 170044743,1.087030,1.087450,0
20160103 170049243,1.087130,1.087450,0
20160103 170109490,1.087120,1.087450,0
20160103 170153990,1.087120,1.087480,0
20160103 170215740,1.087080,1.087580,0
 
Date format: yyyyMMdd
Time format: HHmmssSSS
 
The Time format is what I have problem with (I think). It has values for fraction of a second (last three characters) and this is what I do not know how to deal with in Data Manager.
For seconds I use “ss”, but there is no format for fraction of seconds.
 
I attached two files from data manager. One with the setup and another with the error message.
 
Regards
Leonid
 
 

0

tomas262

Administrator, sq-ultimate, 2 replies.

Visit profile

7 years ago #141669

Hello,

 

the time value does not make sense to me. I guess the “170015493″ value represents 17 hours, 00 minutes and then I do not know what the rest means ..15493 represents. I would expected it to be 15.493 or 1.5493 possibly

 

You can only use “double s” for seconds i.e. “HHmmss” or similar

0

vostrushka

Customer, bbp_participant, community, 48 replies.

Visit profile

7 years ago #141670

the format of the time field is:

HHmmss

the last three characters is for fraction of a second.

Therefore, the time stamp of “170049243″ meams 17 hours, 00 minutes, 49.243 seconds

Are you saying that there is no way to tell data manager what to do with last three characters?

Does it recognise fraction of a second, somehow?

0

tomas262

Administrator, sq-ultimate, 2 replies.

Visit profile

7 years ago #141672

Is the number of digits always 9 for the time format? You could then try to add the decimal point using Excel for example. The decimal point is necessary for the time recognition

0

vostrushka

Customer, bbp_participant, community, 48 replies.

Visit profile

7 years ago #141682

Solved. I converted all files to Dukas format. Thank you.

0

Viewing 4 replies - 1 through 4 (of 4 total)