Allocator Excel Add-In
      Back to home
      1. Allocator Knowledge Base
      2. Export Your Data
      3. Allocator Excel Add-In

      How Do I Get The List of Assets In My Portfolio?

      How to pull the IDs and names of assets within a portfolio.

      Formula

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

      Arguments

      ID - Required - Text - Eg: fdedb7                                            The Portfolio ID you want to index.

      Has Allocation On - Optional - Date - Eg: 2021-12-31       The date in YYYY-MM-DD format.

      Example

      The Assets in Portfolio “Ac1b5ea”.

      = ALLOCATOR_ASSETS( "Ac1b5ea")

      Remarks

      [Has Allocation On] The date field is not format sensitive if you input a cell reference.

      If the Has Allocation On is ignored, Assets will return everything without any date restriction.