Can I have a list of Formulas?

These can all be found within the formula builder.

This the easiest way to create formulas within Excel using Allocator data.

ID

Specify an Asset ID to request data from Allocator.

=ALLOCATOR_ID( [Text] ID)

Info Tags

List all supported tags for ALLOCATOR_INFO.

=ALLOCATOR_INFO_TAGS( [Text] Mode, [Text] Tag Type)

Info

Get the specific information [tag] of an identifier [token].

=ALLOCATOR_INFO( [Text] ID, [Text] Tag)

Returns Value

Get a Return value for a specific month.

=ALLOCATOR_RETURNS_VALUE( [Text] ID, [Date] Date, [Text] Time Unit, [Text] Show Estimate)

Returns Array

Get Returns values within a specific period.

=ALLOCATOR_RETURNS_ARRAY( [Text] ID, [Date] Start Date, [Date] End Date, [Text] Time Unit, [Text] Show Estimate, [Text] Show Derived From)

NAV Value

Get the NAV value at a specific date.

=ALLOCATOR_NAV_VALUE( [Text] ID, [Date] Date, [Text] Show Derived, [Text] Show Interpolated)

NAV Array

Get NAV values within a specific time period.

=ALLOCATOR_NAV_ARRAY( [Text] ID, [Date] Start Date, [Date] End Date, [Text] Show Derived, [Text] Show Interpolated)

Cashflows Value

Get a Return value for a specific month.

=ALLOCATOR_CASHFLOWS_VALUE( [Text] ID, [Date] Date, [Text] Metrics)

Cashflows Array

Get Returns values within a specific period.

=ALLOCATOR_CASHFLOWS_ARRAY( [Text] ID, [Date] Start Date, [Date] End Date, [Text] Metrics)

Statistics Value

Get the Statistics Value Data.

=ALLOCATOR_STATISTICS_VALUE( [Text] ID, [Text] Metrics, [Date] Start Date, [Date] End Date, [Text] Benchmarks, [Text] Benchmarks, [Text] Benchmarks, [Text] Benchmarks,….)

Statistics Array

Get the Statistics Data.

=ALLOCATOR_STATISTICS_ARRAY([Text] ID, [Date] Start Date, [Date] End Date, [Text] Benchmarks, [Text] Benchmarks, [Text] Benchmarks, [Text] Benchmarks,….)

AUM Value

Get the Assets Under Management (AUM) as at a specific month.

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

AUM Array

Get Assets Under Management values within a specific period.

=ALLOCATOR_AUM_ARRAY( [Text] ID, [Text] Tag = Fund, [Date] Start Date, [Date] End Date, [Text] ShareClass Name)

Attribution Value

Get an Attribution value for a specific month.

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

Attribution Array

Get the Attributions within a period.

=ALLOCATOR_ATTRIBUTION_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)

Exposure Value

Get the Exposure for a specific month.

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

Exposure Array

Get the Exposure within a period.

=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)

Raw Array

Get Raw values within a specific period.

=ALLOCATOR_RAW_ARRAY( [Text] Fund ID, [Text] Categorization, [Text] Table Type, [Text] Table, [Text] Variable, [Date] Start Date, [Date] End Date, [Text] Categories)

Portfolio Allocations Value

Get a portfolio Allocation value for a specific month.

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

Portfolio Allocations Array

Get the Allocations of a portfolio within a specific period.

=ALLOCATOR_PORTFOLIO_ALLOCATIONS_ARRAY( [Text] Portfolio ID, [Text] Allocation ID, [Date] Start Date, [Date] End Date, [Text] Mode, [Text] Include Estimate)

Assets

Get the IDs and Names of the assets within a portfolio.

=ALLOCATOR_ASSETS( [Text] ID, [Text] Has Allocation On)

Holding Source

Get the source of holdings for Private Equity.

=ALLOCATOR_HOLDINGS_SOURCE( [Text] ID, [Text] Company, [Text] Metrics, [Date] Start Date, [Date] End Date)