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

Re: Importing Excel data



PureBytes Links

Trading Reference Links


you need to manipulate the file first and
save it in text format before you can import
data into TS.

1. convert date into a format matching your
   windows setting, or, all numbers with no
   separator yyyymmdd.

2. add a header line for each column.
   e.g. date open high low

3. ensure the data is in chronological order,
   not in reverse. If in reverse, sort it with
   Excel.

4. save the file in csv format, or,
   copy and paste the selection data into
   notepad.

5. for some locale, you will need to open the
   newly saved text file to do a global replace
   of the line feed character with blank.

6. the rest is in TS manual on import ascii data.

good luck.

-Lawrence

--- Russ Norwood <trte@xxxxxxxxxx> wrote:
> I have some data in excel format that I would like
> to import into TS 2000i.
> How would I go about doing that?
> 
> 
> Thanks in advance.
> 
> Russ
>