Portfolio file


An essential part of the Rapptr implementation process is setting up the company structure. The company structure determines how the rules engine aggregates positions and at which level the rules will trigger potential disclosures. 

Like with almost everything else in Rapptr the company structure can be set up directly in the UI via Main Menu - Portfolios. This is the preferred method when monitoring a handful of funds/accounts that all aggregate up to one legal entity (manager).

However, for complex structures we recommend importing this structure in our specified file format. This article describes that format and the properties that should be included when setting up the file.

Company Structure and Aggregation

The most important aspect of the Portfolio File is the aggregation. The aggregation is modeled in the file in the columns called LegalParentID, VotingParentID and ManagementParentID (for detail on what the Management, Voting, and Legal structures represent, please see the article: Rapptr Aggregation Framework). This column dictates which assets/portfolios should aggregate up to which entities/managers. It is further used to model corporate structures.

The setup uses PortfolioId to specify which entity a portfolio should aggregate up to, i.e. the parent of the portfolio. An example of the setup is displayed below: 


When uploading this file to Rapptr the aggregation structure will look like the following.  


It is important that the aggregation structure is set up correctly, as this determines at which level the disclosures will trigger. See the article: Rapptr Aggregation Framework for further details.

For a deeper description of the values accepted for these properties, please see our documentation page here.

Required vs. Optional

When modeling the company structure, the columns in the first figure are sufficient. These columns (except RuleFolders) are required for the file to pass the Rapptr validation procedure and successfully upload. 

However, there are also "Rule Properties" and "Form Properties" that should be set to enable the full functionality of the Rapptr engine and document generator. These can be set up in the UI by viewing the portfolio details under the tabs displayed below.


The Rule Properties and Form Properties can also be uploaded in the portfolio file. Uploading them in the file is simple - you should create a column in the .csv file with the name displayed in Rapptr and fill in the information in this column.

Here is an example of a portfolio file. As the portfolios file is in .csv format, the ordering of the columns does not matter (e.g. if PortfolioName was sorted before PortfolioId). Portfolios can only be uploaded via the Portfolios screen by selecting Import and cannot be uploaded via Admin > Upload > Upload Positions.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Article is closed for comments.