Structure of the files

First create the ASCII file to be imported. It must have the extension ".txt".
Copy this file to the \DOWNLOAD directory.

You can find the directory in your local settings, usually <C:\Documents and settings\All Users\Application data>.

The course data must be stored in the ASCII file in a specific format, which is explained below using an example:

Beispiel einer ASCII–Datei: Import.txt

VERSION;1;2

COURSES

wkn1;09.07.99;101;100000;102,02;106,03;100,04;105,05

wkn2;09.07.99;201;200000;202,02;206,03;200,04;205,05

wkn3;09.07.99;301;300000;302,02;306,03;300,04;305,05

wkn4;09.07.99;401;400000;402,02;406,03;400,04;405,05;1000;2000

wkn5;01.07.99;501;500000

wkn5;02.07.99;502;500000

wkn5;04.07.99;503;500000

wkn5;05.07.99;504;500000

wkn5;06.07.99;505;500000

wkn5;07.07.99;506;500000

wkn5;08.07.99;507;500000

wkn5;09.07.99;508;500000

END

The first line of the file must be VERSION;1;2 for the file to be accepted by the Infront Portfolio Manager.
The second line contains the identifier COURSE, which marks the start of the block to be imported. The block ends with the identifier END.
The lines enclosed with COURSE and END contain the actual course information. The lines are structured according to the following scheme:

Wkn;Date;Spot;Volume;Open;High;Low;Close;Contracts;OpenInterest;EvaluationPrice

Field	Description
WKN	Security identification number to identify the security Alphanumeric value with a maximum of 10 digits Must be specified A security with this WKN must already be created in the Infront Portfolio Manager, otherwise the price information will be ignored
Date	Date for which the course information is saved Format must be dd.mm.yy Must be specified
Cash desk	Spot rate Decimal number, decimal places separated by decimal point Optional
Volume	Daily turnover Whole number Optional
Open	Daily opening price Decimal number, decimal places separated by decimal point Optional
High	Daily maximum price Decimal number, decimal places separated by decimal point Optional
Low	Daily low Decimal number, decimal places separated by decimal point Optional
Close	Daily closing price Decimal number, decimal places separated by decimal point Optional
Contracts	Number of contracts Whole number Optional
OpenInterest	Number of open contracts on the futures exchange Whole number Optional
EvaluationPrice	Valuation rate Decimal number, decimal places separated by decimal point Optional

The course details are optional, i.e. they do not have to be entered. Nevertheless, you must separate the unspecified fields with a semicolon unless they are the last fields in the list.

Beispiele

For example, if you only want to enter the spot rate and the turnover, you can simply omit the remaining fields:

wkn5;01.07.99;501;500000

If you only want to enter the close rate, the leading fields must be left blank. You can omit the remaining fields:

wkn5;01.07.99;;;;;;501,12