How Do I Get Statistics Values Within a Specific Period?

Formula

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

Arguments

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

Start Date - Optional - Date - Eg: 2021-01-01                     The start date in YYYY-MM-DD format.

End Date - Optional - Date - Eg: 2021-12-31                       The end date in YYYY-MM-DD format.

Benchmarks - Optional - Text – Eg: 10 Yr Treasury rate    The Benchmark which you want to compare the fund to.

Example

The statistics values for Hedge Fund ‘fdedb7’ for the year 2021 compared with Benchmark ‘974b10’.

=ALLOCATOR_STATISTICS_ARRAY(“fdedb7”,”2021-01-01”,”2021-12-31”,”974b10”)

Remarks

[ID] If a Fund ID is given, the Default series will be used.

[Start Date] If you don't specify the start date, Statistics Array will return everything before the end date.

[End Date] If you don't specify the end date, Statistics Array will return everything after the start date.