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

Fw: Import ASCII data into TS2k GS



PureBytes Links

Trading Reference Links

I was told by TS support that you cannot do that.  You may VIEW ascii data
in TS2ki, but NOT put it into the GS.
(TS2Ki, i dont know about the ts6or7)
Best Wishes,
Marc Miller

----- Original Message ----- 
From: "Gray, Gabriel" <Gabriel.Gray@xxxxxxxxxxxxxxxxx>
To: "Gary Fritz" <fritz@xxxxxxxx>; <omega-list@xxxxxxxxxx>
Sent: Thursday, January 29, 2004 12:07 PM
Subject: RE: Import ASCII data into TS2k GS


> Gary,
> I have run into problems importing before, it can be quite finicky. Do
> you have quotes around "Date", "O",..,"C"?
> Below is an example of a format that worked for me on intraday.
>
> "Date","Time","Open","High","Low","Close"
> 1/3/2000,8:31 AM,25,211,25,211
> 1/3/2000,8:32 AM,268,465,268,465
> 1/3/2000,8:33 AM,501,667,501,667
> 1/3/2000,8:34 AM,692,817,692,817
> 1/3/2000,8:35 AM,846,953,846,953
> 1/3/2000,8:36 AM,969,1039,969,1039
> 1/3/2000,8:37 AM,1048,1100,1048,1100
> 1/3/2000,8:38 AM,1115,1179,1115,1179
> 1/3/2000,8:39 AM,1187,1207,1187,1207
> 1/3/2000,8:40 AM,1214,1248,1214,1248
> 1/3/2000,8:41 AM,1251,1262,1250,1262
> 1/3/2000,8:42 AM,1264,1273,1264,1270
> 1/3/2000,8:43 AM,1272,1280,1268,1280
>
>
>
> Gabriel
>
> -----Original Message-----
> From: Gary Fritz [mailto:fritz@xxxxxxxx]
> Sent: Thursday, January 29, 2004 1:55 PM
> To: omega-list@xxxxxxxxxx
> Subject: Import ASCII data into TS2k GS
>
>
> I've never tried importing EOD data into TS before, but I knew it
> was supposed to work.  I just tried it and *I* can't get it to
> work.  Any help?
>
> The file looks like this:
>
> Date,O,H,L,C
> 9/1/2003,3202.9,3217.2,3202.9,3212.1
> 9/2/2003,3212.1,3223.9,3212.1,3223.9
> 9/3/2003,3223.9,3237.3,3218.9,3219.2
> 9/4/2003,3219.2,3243.8,3219.2,3233.8
> 9/5/2003,3233.8,3234.2,3214.2,3220.1
>
> I created the symbol, selected the symbol, File -> Import ->
> ASCII, chose the file, OK, chose the format, and it won't take
> it.  It shows an "Ascii data file error" dialog and tells me to
> verify that the field order I selected matches the field order in
> the file.  It does.
>
> I've tried deleting the first line and specifying Date-Open-
> High-Low-Close-Vol-Openint as the format (even adding ",0,0" for
> the vol and OI).  I tried reformatting the date to YYYYMMDD.  No
> go.  I dunno what the problem is.
>
> Gary
>