Structure of the files | Infront Portfolio Manager

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 for Infront Portfolio Manager.

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

Example of an ASCII file: Import.txt

VERSION;1;2

KURSE

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

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

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

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

mmwkn5;01.07.99;501;500000

mmwkn5;02.07.99;502;500000

mmwkn5;04.07.99;503;500000

mmwkn5;05.07.99;504;500000

mmwkn5;06.07.99;505;500000

mmwkn5;07.07.99;506;500000

mmwkn5;08.07.99;507;500000

mmwkn5;09.07.99;508;500000

ENDE

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 KURSE, which marks the start of the block to be imported. Each entry then appears on a separate line. The block ends with the identifier ENDE.
The lines enclosed with KURSE and ENDE contain the actual price information. The lines are structured according to the following scheme:

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

Field	Description
MMWKN	Security identification number to identify the security Alphanumeric value with a maximum of 10 digits Must be specified A security or the corresponding price quote with this MMWKN 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
Spot	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 price 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:

mmwkn5;01.07.99;501;500000

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

mmwkn5;01.07.99;;;;;;501,12