How Do I Get AUM Value For a Specific Month?

Formula

=ALLOCATOR_AUM_VALUE( [Text] ID, [Text] Tag = Fund, [Date] Month, [Text] ShareClass Name)

Arguments

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

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

Month - Required - Date - Eg: 2021-06-30            The date in YYYY-MM-DD format.

ShareClass Name - Hypothetical - Text                  The Share Class name.

Example

Fund AUM of Fund "fdedb7" for Jun 2021.

=ALLOCATOR_AUM_VALUE( "fdedb7","Fund","2021-06-30")

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.