|
PureBytes Links
Trading Reference Links
|
Please send script. But the problem remains. How should I format the data
so that GS can import the ticks?
There are just 3 fields required - Date, Time, Price.
Thanks.
-a1
----- Original Message -----
From: Jim Michael <genepool@xxxxxxxxxx>
To: Axiom One <axiom1@xxxxxxxxx>
Cc: Omega List <omega-list@xxxxxxxxxx>
Sent: Saturday, July 17, 1999 12:39 AM
Subject: Re: HELP NEEDED: IMPORT ASCII INTRADAY DATA INTO GLOBAL SERVER
>
> 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.
> >
> >
>
|