PureBytes Links
Trading Reference Links
|
I am trying to import intraday data into ts2k global server (GS).
A sample:
1997121214420215875.00
1997121514271615910.00
1997121614265815925.00
1997121714283716395.00
1997121814324315965.00
1997121914280415275.00
Translation:
Date, Time, Price
19971212,144202,15875.00
The cleaning of data may not be do-able in Excel because of the 65500 rows
restriction.
I did some cleaning for a few rows and tried to import into GS using the
'field in first row' option. Unfortunately, GS does not recognize the tick
data. I am not sure what the correct time format should be. hhmmss? or
hh:mm:ss?
Please advice.
|