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

ASCII data problem



PureBytes Links

Trading Reference Links

I'm trying to look at some FutureSource data.  A helpful fellow sent 
me some 5min data in ASCII format.  I fixed up a few minor FS 
oddities in the file, and now it looks like this:

Date,Time,Open,High,Low,Close
1999-03-01, 8:30,192597,192597,191816,191848
1999-03-01, 8:35,191789,191789,191116,191292
1999-03-01, 8:40,191394,191866,191227,191511
1999-03-01, 8:45,191958,192078,191663,192000
1999-03-01, 8:50,192048,192048,191622,191647

TS *seems* to accept this format just fine:  it charts the data at 
the right time & date, and the Close is right.  But it's ignoring the 
Open, High, and Low!  If I plot a 5min chart, I just see dots at the 
Close values.

I tried changing it to a more "standard" TS format:

"Date","Time","O","H","L","C","U","D"
03/01/1999, 830,192597,192597,191816,191848,1,1
03/01/1999, 835,191789,191789,191116,191292,1,1
03/01/1999, 840,191394,191866,191227,191511,1,1
03/01/1999, 845,191958,192078,191663,192000,1,1
03/01/1999, 850,192048,192048,191622,191647,1,1

..but that didn't help any.

If I set it up in a Custom Data List, the "Period" for this data is 
"Tick" instead of "Intraday," but I don't know why.  I tried adding 
"U" and "D" fields (upticks and downticks, as above) to match the 
format that TS writes out, but that didn't help either.

Any guesses what I'm doing wrong?

Also, while I'm at it:  is there any way to get TS to scale ASCII 
data like this, so it interprets these values as e.g. 1918.48 instead 
of 191848?  I can always scale it in Excel or vi, but I would think 
TS would have a way to handle these different data formats.

Thanks,
Gary