Skip to content
English
Create a Support Ticket Customer portal
  • There are no suggestions because the search field is empty.

How Do I Get AUM Values Within a Specific Period?

How to pull Asset Under Management values within a specific time period.

Formula

=ALLOCATOR_AUM_ARRAY( [Text] ID, [Text] Tag = Fund, [Date] Start Date, [Date] End Date, [Text] ShareClass Name)

Arguments

ID - Required - Text - Eg: fdedb7                             The Fund, Company, Series, Portfolio ID.

Tag - Optional - Text - Default: Fund                     The Tag.

Start Date - Optional - Date - Eg: 2021-01-01       The start date in YYYY-MM-DD format.

End Date - Optional - Date - Eg: 2021-12-31         The end date in YYYY-MM-DD format.

ShareClass Name - Hypothetical – Text                 The ShareClass name, applies only if the Tag is "ShareClass”.

Example

The Company AUM of Fund “fdedb7” during the year 2021.        

=ALLOCATOR_AUM_ARRAY( "fdedb7","Company","2021-01-01","2021-12-31")

Remarks

If you provide a company token, Tag will be ignored and AUM Value will return values for Tag = Firm.

[ShareClass Name] This apply only if Tag = Share Class.

[Tag] Fund is the default value.

[Month] The date field is not format sensitive if you input a cell reference.

[ShareClass Name] If the class name is not specified, the class name of the default series will be used.