How Do I Get An Exposure Value Within a Specific Period?

Formula

=ALLOCATOR_EXPOSURE_ARRAY([Text] ID, [Text] Categorization, [Text] Table, [Text] Variable, [Text] Category, [Text] Mode, [Date] Start Date, [Date] End Date, [Text] Include Funds, [Text] Level, [Text] Trim)

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 the values of.

Mode - Required - Text - Eg: Wide                          How you want the output ("Wide" or "Narrow").

Start Date - Hypothetical - Date                              The start date in YYYY-MM-DD format.

End Date - Hypothetical - Date                                The end date in YYYY-MM-DD format.

Include Funds - Optional - Text                               Include funds or not.

Level- Hypothetical - Text                                         The level of depth of Attribution.

Trim- Optional - Text                                                 Trim leading and trailing months if no  categories other than unexplained are populated.

Example

The Geographic Exposure values for fund “fdedb7” for the year 2021.

= ALLOCATOR_ATTRIBUTION_ARRAY( "fdedb7","Mapped","Geography","Total", ,"Wide","2021-01-01","2021-12-31")

Remarks

[Start Date] This argument is Required if Mode = Narrow and act as the month you want data of.

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

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

In case Mode = Wide, dates are Optional.

[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.

[End Date] This argument is Ignored if Mode = Narrow.