You can import external data to the TeleTrader WorkStation local database. The data can be in Metastock or ASCII format (text file, or comma separated values file).

The symbols in the local database can be found with Symbol Search and used in charts. You can work with all symbols that are available in your local database even if you do not have a live connection to the Internet. To do this, you have to switch to offline mode before disconnecting from the Internet: See Using Charts Offline.

Note             The data in the import file must be ordered chronologically, with the oldest data first.

To import external data to the local database

▪       On the File menu, click Security Data Wizard.

▪       On the first page of the Security Data Wizard, click Next.

▪       On the Action Selection page, select Data import from the list and click Next.

▪       On the Import Data Source page, select the data format that you want to import: Metastock format will search for files in the Metastock data format, ASCII format will search for files in a text format (also comma separated values files).

▪       In the Select data folder list, choose the location of your import file, click on the file that you want to import and click Next.

▪       On the Import settings page, you see a preview of the data that will be imported. The import settings on this page will help TeleTrader WorkStation correctly identify the data format used in your import file. Data columns that could not be correctly identified by TeleTrader WorkStation are marked in red. Adapt the settings to your needs, and click Apply every time you change something:

Control

Description

Date

Choose the date format used in the import data file

Century in date

Check if the import data file uses a date format with the century in the date (for example 2009-01-01)

Clear if the import data file uses a date format without the century (for example 09-01-01)

Time

Choose the time format used in the import data file

Decimal

Choose the decimal separator used in the import data file

Thousands

Choose the thousands separator used in the import data file

Rename column

Click on a column header in the preview and choose a new name here to rename a column

Column separator

Choose the column separator (for comma separated values files)

▪       Click Next when you are finished.

Note             The Next button will be disabled as long as TeleTrader WorkStation cannot correctly identify all data columns. These columns are highlighted in red. Adapt the settings until all columns are shown with a white background to proceed.

▪       On the next page, enter the security information that will be used to identify the new symbol in the local database and click Next:

Control

Description

Enter security’s symbol

Enter a local symbol ID with at most 14 characters

Enter security’s description name

Enter a symbol description (name) with at most 16 characters

Conflict options

This setting is used when you choose a symbol ID that already exists in the local database.

Select an option when you are asked to do so:

Append to existing data                Add imported data to the existing symbol

Replace existing data                   Replace the existing symbol

Choose data periodicity

Select the data compression for the imported data

Number of decimals

Choose how many decimals you want to import

Copy data to local database

Check to insert the imported data to the local database

Clear to make the data available only temporarily (it will be deleted as soon as TeleTrader WorkStation is closed)

▪       On the Completing Security Data Wizard page, a summary of the import options is displayed. Review this summary – if you want to make changes to the import settings, click Back.

▪       When you are satisfied with the settings, click Finish.

▪       The wizard will close automatically when all data is imported. You can now find the imported symbol with Symbol Search under the ID and name that you have chosen for it. The symbol is automatically added to the exchange <Local>.