Updating fund data
In the Data Management menu navigate to Fund Data Input.
Navigation Tabs
 |
|
Bulk Lock/ Unlock
This form allows an entire year or individual quarter to be locked or unlocked for either the entire portfolio or groupings of funds (e.g. single holding, multiple holding).
before attempting to load data the fund/quarter combination must be unlocked. For an individual fund input this can be done on the form itself by clicking the “”Unlock” field. This action can also be performed in bulk for multiple funds and periods via the “Bulk Lock/Unlock” screen. The convention in the Apliqo LPPM web application is to display writable fields with a grey background. Read only fields have a white background. Therefore it is easy to see as a user if you have write access to a field.
Fund Data Input
The “Fund data input” screen allows to
enter manually or
using the Excel upload
API Solutions are also possible, currently supported is Canoe
The data can be feed
for a individual fund
for all funds
For Direct/GmbH Input: As the input is done on with investment data for the “template investor”, it is necessary to manually initiate the “update data” calculation for the holdings of the other investors.
The fund data input is very similar for the different fund categories:
Infidem input
Direct/GmbH input
The only difference to Infidem input is that from a database perspective the data is input to a “template investor” and then transformed via matrix multiplication of the shareholding table into individual investor statements for the remaining investors. (see below for instructions)SMA input
The same “template investor” should be used as was used for the “parent” fund.
For SMA inputs you may also need to ensure that the SMA “sub-fund” fund ID has been set up in the database as records will not be able to be loaded to any fund ID which the database does not recognize.
Input for a single fund
Updating a single fund can be easily done via copy/paste from Excel into the web form.
Check if investment is unlocked for reporting quarter
Turn off zero suppression (to unhide the quarters which don’t yet have data)
Add additional quarters (if necessary)
Copy/Paste from Excel into input sheet (column order should match Excel template)
Upload from Excel is also possible for an individual quarter or multiple quarters. Requires a specially formatted excel file.
Single fund upload template
Input for multiple funds
Using the Upload from Excel facility it is however possible to upload data for multiple funds all at once using the Multiple fund upload form. This would allow for all funds with single holding to be updated in one action for a single quarter or multiple quarters. (Upload template attached below).
Upload from Excel is also possible for an individual quarter or multiple quarters. Requires a specially formatted excel file.
Multi fund upload template
For upload via Excel template the required format of the Excel files is identical for “Infidem Input”, “Direct/GmbH input” and “SMA input” All that is required is to ensure the correct fund name is used in the fund ID column.
Special Case: “Template Investor” for Direct/GmbH input
Updating manually the investment information for Direct/GmbH funds only for one investor, so called “template investor”, is required. The data for the other investors are calculated on the “Split”/Shareholding information of the fund.
when updating or uploading investment data for “direct/GmbH input” it is critical that the same “template investor” is used consistently for all funds. Individual investor and the corresponding GmbH entity can be used interchangeably.
The matrix multiplication and entry of individual investor statements into the portfolio occurs only when clicking the “Update Data” button
when updating multiple when clicking on the “Update Data” function in the multi-fund upload form all funds with multiple holdings are updated! Before running this function ensure that all funds (with multiple holding) have been included in the upload, the same template investor has been used for all and the time period selection is correct. If when running the “Update Data” function some funds have missing data, or some funds are using a different “template investor” for data entry then data will be corrupted.
Check the successful calculation per investor in the “value by investor” report
Check the successful execution with “values by investor” report
Values by investor
The “Values by Investor” screen is read only and does not accept data input. This screen is provided to check data input and displays the final values which have been committed to the database for use in all following portfolio calculations, reports and projection calculations. The format in terms of the column layout is identical to the previous input sheets and also matches the Excel format used and should therefore be easy to reconcile.
On this screen you can review statements per investor per quarter for any fund (including SMA investments) regardless of the investment vehicle type.
For Direct/GmbH investments as individual investor statements are produced via matrix multiplication of the shareholding table there may be small rounding differences versus individual investor statements. However, these are immaterial for portfolio reporting purposes.
If the data is loaded by the API approach, the rounding difference will not appear.
Projections & Splits
The “Projection and Splits” screen is used to monitor and adjust the assumptions for cashflow projections and regional and sector splits.
If a fund has asset level company data loaded then the country and industry classifications at company level will always take precedence over the manual entry for region and industry splits. For funds with asset level data you can select whether regional and industry split calculations should be performed on the basis of either unrealized value (default if empty) or invested capital.
