How Do I Get Raw Data For a Specific Period?

Formula

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

Arguments

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

Categorization - Required - Text                            How you want the data to be fetched.

Type - Required - Text - Eg: Exposure                    Attribution or Exposure.

Table - Required - Text - Eg: Long & Short             The table to load.

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

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.

Categories - Optional - Text                                     Categories.

Example

The Raw Exposure Data captured for Fund “fdedb7”in the year 2021.

= ALLOCATOR_RAW_ARRAY( "fdedb7","Unmapped","Exposure","Other","Long","2021-01-01","2021-12-31","Amazon.com, Inc.", "Apple Inc.", "Anglo American plc", "Currency Trade - EUR", "Currency Trade - GBP")

Remarks

If the dates are ignored, Raw Array will return everything without any date restriction.

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

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

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