How Do I Get a Statistic Value For a Specific Month?

=ALLOCATOR_STATISTICS_VALUE( [Text] ID, [Text] Metrics, [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.

Metrics - Required - Text - Eg: Compound Return              The selected Metric.

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 Compound Return for Hedge Fund ‘fdedb7’ for 2021 compared to the benchmark ‘974b10’.

=ALLOCATOR_STATISTICS_VALUE( "fdedb7","Compound Return","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 Value will return everything before the end date.

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