Skip to main content

File formats for importing model portfolios

Model portfolio details and target shares are imported into FA in semicolon-separated CSV files or XLSX files. The file columns are described in this topic. A model portfolio is imported in two separate files. One file contains the model portfolio information such as name, identifiers, linked portfolio, visibility, and if the target share sum has to be 100%. The second file contains the target shares.

For CSV files, you can define the following properties in Preference → Importing → File format (see Preference - Importing for details):

  • File delimiter. By default, FA is configured to accept semicolon-separated values. You can change it to another character.

  • Encoding: UTF-8 or Windows-1252. To import Scandinavian letters, the files should be Windows-1252 encoded to guarantee the appropriate handling of Scandinavian letters.

Download the file templates:

FAFormat_model_portfolio_details.csv

FAFormat_model_portfolio_target_shares.csv

FAFormat_model_portfolio_details.xlsx

FAFormat_model_portfolio_target_shares.xlsx

Updating or removing model portfolios and target shares

To update existing model portfolios or target shares, you can export the values by opening the Model portfolio window in the Rebalance view, edit the values in the file, and then import the updated model portfolio details or target shares.

To remove target shares, export the model portfolio shares file by opening the Model portfolio window in the Rebalance view, delete the rows containing the target shares or add DELETE in the mps.share column, and then import the model portfolio shares again. Model portfolios can't be removed using the import functionality.

FA Format for importing model portfolio details

#

Code

Required

Name

Description

1

mp.name

Yes

Model portfolio name

Model portfolio name.

2

mp.code

Yes

Model portfolio code

Individual model portfolio code that separates it from other model portfolios.

3

mp.linkedPortfolio

No

Linked portfolio

Code of the linked portfolio.

4

mp.rolesString

No

Restrict this model portfolio to be shown to roles

Roles to which this model portfolio is visible. Define the roles as a semi-colon-separated list without spaces between the roles (for example: BO;A Client;Administration). If empty, the portfolio is visible to all users.

5

mp.sum

No

Allow the sum of model portfolio shares other than 100%

Whether the model portfolio target shares have to add up to 100%. If enabled, individual weights of target shares or the combined weight of target shares can be less than 100%.

Define as a number:

0 = No

1 = Yes

The default value is 0.

FA Format for importing model portfolio target shares

#

Code

Required

Name

Description

1

mps.modelPortfolio

Yes

Model portfolio code

Individual code of the model portfolio that separates it from other model portfolios.

2

mps.date

Yes

Date

Date from which the model portfolio is valid. Define the date in the YYYY-MM-DD format.

3

mps.security

Yes

Security

Security code, ISIN, database ID, trade code, or update code 1-3.

4

mps.share

No

Share %

Weight of the security in the model portfolio. Define the weight as a decimal number (for example: 70.0). To delete the share, enter DELETE here.

5

mps.minShare

No

Minimum share

Minimum weight allowed for the security. Must be equal to or less than the value for Share %. Define the minimum as a decimal number (for example: 60.0).

6

mps.maxShare

No

Maximum share

Maximum weight allowed for the security. Must be equal to or higher than Share %. Define the maximum as a decimal number (for example: 80.0).

In this section: