Skip to main content

Export positions for Bloomberg PORT

Important

You need to install this report separately as described in Set up Bloomberg PORT export.

You can use the Bloomberg PORT export report to get a CSV file of positions that you can import into Bloomberg PORT. You should save it as a report package to get the file with the correct naming and format.

To define the report package:

  1. Open the Report window (New → New report).

    bloomberg_port_report_package.png
  2. Select Bloomberg PORT export from the report list and define the report parameters on the right:

    • Customer, Group, Portfolio: Portfolios to include.

    • Report date: Position date. Use one of the dynamic selections, such as “D0: Current day” or “D1: Previous day”.

    • File format: CSV.

    • Output type: One report (background).

    • Folder nameoutbound/Bloomberg. Enter it if you want to send the report to Bloomberg automatically.

  3. Click Save as a new report package.

  4. Give the package a descriptive name, such as Bloomberg PORT export and (optionally) share it with others.

  5. Click Save.

Now that your report package is saved, you can easily use it by selecting the package from the list or schedule it for automatic generation.

The report contains the following data about the positions and account balances for the selected portfolios:

Field in report

Field in FA

Client

Bloomberg PORT client code defined under the portfolio IDs tab with name Bloomberg PORT.

Date

Report date

Portfolio ID

Portfolio ID

Portfolio name

Portfolio name

ISIN

Security ISIN code (blank for accounts)

Security code

Security code (account number for accounts)

Security name

Security name (account name for accounts)

Amount of units

Amount (balance in account currency for accounts)

Currency

Security or account currency

Market price (LC)

Market price per unit in portfolio currency

Cost price (LC)

Purchase price per unit in portfolio currency

Class 1

Security (or account currency) Class 1

Class 2

Security (or account currency) Class 2

Class 3

Security (or account currency) Class 3

Class 4

Security (or account currency) Class 4

Class 5

Security (or account currency) Class 5