[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: HELP NEEDED: IMPORT ASCII INTRADAY DATA INTO GLOBAL SERVER



PureBytes Links

Trading Reference Links


If you need a perl script to slice this data let me know. It would only
be a few lines of code.

Cheers,

Jim     

On Fri, 16 Jul 1999, Axiom One wrote:

> 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.
> 
>