Portfolio composition data can be updated manually or through a structured portfolio data import. Both methods support repeatable portfolio composition reporting in automated fund factsheets.
1. Manual input
Use this option to update portfolio composition data for one program. Select the program, open Portfolio Composition in the right-hand panel, select the required section, enter the values, and save.
2. Prepare and upload an Excel file
Use Mass Portfolio Composition Import to update one or more programs. If you are not familiar with mass imports, see Import performance data for multiple programs.
Prepare the import file
The Portfolio Composition import file uses a different structure from other mass imports: program codes are listed at the beginning of each row rather than at the top of each column. We recommend starting with the sample file available on the Mass Portfolio Composition Import page.
The main columns are:
- Code – a unique program identifier.
- Category – the Portfolio Composition section to update. Supported categories include Stock Sectors, Futures Sectors, REIT Sectors, Other Sectors, Investment Exposure, Strategy Exposure, Geographic Exposure, Geographic Exposure Regions, Market Cap Exposure, Credit Rating, Instruments, Top Instruments, ESG Score, and Bond Metrics.
- Field – the item within the selected category. For Strategy Exposure, enter the strategy name.
- Value – the numeric value. For Strategy Exposure, enter the numeric allocation.
- Date – optional date for historical values. If it is empty or omitted, the data is imported as current values.
For ESG data, use the ESG Score category and the field names provided in the current sample file. See ESG ratings and factsheet controls for related program-level ESG ratings.
See Available fields for Mass Portfolio Composition Import for supported values and examples.
Related topics
Import performance data for multiple programs
Creating Import file / Mass import file
Available fields for Mass Portfolio Composition Import
Asset allocation reporting in a fund factsheet
Continue your fund reporting workflow
Use this guidance as part of a controlled fund factsheet data import and validation workflow. Continue with Update or import fund data and Contact Fundpeak.