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

How Do I Get a Specific Attribution value?

How to pull an attribution value for a specific month.

Formula

=ALLOCATOR_ATTRIBUTION_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: Long & Short             The table to load.

Variable - Hypothetical - Text - Eg: Short               The type of data you want.

Category - Hypothetical – Text                                Path to the category you want the value of.

Month - Required - Date - Eg: 2021-12-31            The date in YYYY-MM-DD format.

Example

The attribution value for fund “fdedb7” as of December 31st 2021.

=ALLOCATOR_ATTRIBUTION_VALUE( "fdedb7","Mapped","Long & Short","Long", ,"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, Attribution 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.