Infront Portfolio Manager
Infront Portfolio Manager
Breadcrumbs

Structure of the files

  1. First create the ASCII file to be imported. It must have the extension ".txt".

  2. 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;2COURSESwkn1;09.07.99;101;100000;102,02;106,03;100,04;105,05wkn2;09.07.99;201;200000;202,02;206,03;200,04;205,05wkn3;09.07.99;301;300000;302,02;306,03;300,04;305,05wkn4;09.07.99;401;400000;402,02;406,03;400,04;405,05;1000;2000wkn5;01.07.99;501;500000wkn5;02.07.99;502;500000wkn5;04.07.99;503;500000wkn5;05.07.99;504;500000wkn5;06.07.99;505;500000wkn5;07.07.99;506;500000wkn5;08.07.99;507;500000wkn5;09.07.99;508;500000END


  • 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