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

Re: CSV EOD data - strange behavior 4.0 build 27



PureBytes Links

Trading Reference Links


The problem is in the very first "date" you provide.

If that date is something like "1/1/1999", then TS has the chance of
mixing up the month and day - which will screw up the loading of
the ascii file.

try enforce the first date in your data to be something like
"1/13/1999" where the 2nd field cannot be a month at all (1 to 12)
then your file should load fine.

this problem exists all the time, even with dates in 2000.

-Lawrence Chan

----- Original Message ----- 
From: . <jmurphy1@xxxxxxxxxxxxx>
> 
> I'm using a DOP file with the following parameters:
> 
> "Other","Date","O","H","L","C","V"
> 
> sample of data:
> 
> HWP,2/1/2000,109.375,109.375,104.000,105.812,3254500
> HWP,2/2/2000,107.188,112.688,106.438,110.562,3417500
> HWP,2/3/2000,111.000,116.500,111.000,113.500,3966700
> HWP,2/4/2000,114.500,119.625,114.375,118.000,4607000
> 
> TIA for any ideas
> 
> JM
> 
>