This article will guide you through the steps on how you can create an AUM/Track Record table for an entity (Firm/Strategy/Product/Vehicle).
Update: As of October 2022, you will now also be able to bulk update tables so maintence of data just got that much easier!
Individually add a table to an entity
To add an AUM/TR table individually, open up the project or entity (Firm/Strategy/Project/Vehicle) and click on the "AUM & Track Record" tab. From here, you can either choose to: (a) create and add a new table manually or (b) upload a table from an existing excel spreadsheet.
Video guide on how to create a table manually
Video guide on how to upload a table
To differentiate between AUM and Track Record table, an AUM table consists of values, while a Track Record table consists of percentages.
Bulk Upload to multiple entities
Under the new "Excel Sync > Manage AUM & TR" page, you will now be able to easily manage existing AUM/Track Record data by downloading and uploading the latest data.
- Download existing AUM & Track Record data and
- Bulk Upload AUM & Track Record data
How to Download existing AUM & Track Record data
To search for the relevant AUM/TR data that you would like to update, utilise the filters as seen above to narrow down the search for the relevant entities:
- Years
- Table Types - AUM, TR or both
- Period - Monthly, Quaterly or both
- Entities
Protip: You can choose different entity types to download at the same time.
Once you have selected the list of AUM/TR data that you would like to update, click on the Download button.