How Do I Get Portfolio Allocations For a Specific Month?

Formula

=ALLOCATOR_PORTFOLIO_ALLOCATIONS_VALUE( [Text] Portfolio ID, [Text] Allocation ID, [Date] Month)

Arguments

Portfolio ID - Required - Text - Eg: 9c26e7            The Portfolio ID.

Allocation ID - Required - Text - Eg: bfc244          The Allocation ID.

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

Example

The Portfolio Allocation of fund “fdedb7” in Portfolio “Ac1b5ea” as of December 31st 2021

=ALLOCATOR_PORTFOLIO_ALLOCATIONS_VALUE( "Ac1b5ea","fdedb7","2021-12-31")

Remarks

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