How Do I Get an Exposure Value for a Specific Month?

Formula

=ALLOCATOR_EXPOSURE_VALUE( [Text] ID, [Text] Categorization, [Text] Table, [Text] Variable, [Text] Category, [Date] Month)

Arguments

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

Categorization - Hypothetical - Text                                     How you want the data to be fetched.

Table - Required - Text - Eg: Overview                                  The table to load.

Variable - Required - Text - Eg: Net                                       The type of data you want.

Category - Hypothetical – Text                                              Category you want value of.

Month - Required - Date - Eg: 2018-06-01                           The date in YYYY-MM-DD format.

Example

The Fund “fdedb7”s exposure to the United States as of December 31st 2021.

= ALLOCATOR_EXPOSURE_VALUE( "fdedb7","Mapped","Geography","Gross","United States","2021-12-31")

Remarks

[Category] This is Required as long as there are categories available.

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

If the dates are ignored, Exposure Value will return everything without any date restriction.

[Categorization] If ID is a Portfolio then Categorization is Ignored and = Mapped.

[Category] In case there is no category available, Category is Ignored and = Variable.