Use Cases


Portfolio Data

Export data to external systems

Leverage a single source of data for your workflows. Use the Portfolio or Transactions API to deliver up-to-date portfolio data and analytics to external systems such as CRM, financial planning, trading & rebalancing, client portal, and more.

Steps

  1. Identify the list of entities to query
  2. Decide if you're looking up transactions or portfolio data. Portfolio - determine required columns, groupings, and filters. Transactions - determine required columns, filters, and sortings.
  3. Submit a request with the Portfolio Query or Transactions Query API

Portfolio Query
Transactions Query

Export portfolio or transactions data for offline analysis

Reduce manual steps and import Addepar data directly into Excel for offline analysis. Easily import data from any existing Addepar view by connecting PowerQuery to the Portfolio or Transactions View API and update existing worksheets with a single click.

Steps

  1. Construct your desired view within the Analysis or Transactions tab in Addepar
  2. On the top-right corner of the table, click the three-dots '...' and select Access View via API (Portfolio) or Generate API URL (Transactions)
  3. Paste the API URL into the Power Query URL field in Excel

Portfolio Analysis Views
Transaction Analysis Views

Asynchronously export large portfolio data sets

Perform asynchronous requests for large data exports to a data warehouse or repository. Use the Jobs API to reliably export and download portfolio data and analytics any time within 24-hours of the initial request.

Steps

  1. Identify the list of entities to query
  2. Determine required columns, groupings, filters
  3. Submit a request with the Jobs API
  4. Query for job status, once 100%, you can download the file

Jobs

Entity Management

Automate ownership structure management

Automatically construct and maintain portfolio ownership structures. Create and update clients, legal entities, financial accounts, and holdings, and manage respective entity relationships to accurately model financial ownership.

Steps

  1. Define the ownership structure and model
  2. Create and manage entities with the Entities API
  3. Create and manage relationships between entities with the Positions API

Entities
Positions

Manage entity attributes

Enrich analyses by incorporating classifications, market data, and other attributes. Connect Addepar to your security master or other third-party data providers to manage attributes for legal entities, accounts, and individual holdings.

Steps

  1. Identify entities and attributes to manage
  2. Update entities using the Entities API

Entities

Manage households and bespoke reporting groups

Create and maintain households and other reporting groups in coordination with internal systems. Leverage the Groups API to automate the process, saving time, and ensuring accurate reporting.

Steps

  1. Create households and other reporting groups using the Groups API
  2. Add and manage group members with the Groups API

Groups

Administration

Onboard and manage users

Seamlessly onboard new users and maintain permissions for existing users. Integrate with HR and entitlement systems to automate user creation and role assignments. Roles must be configured within Addepar prior to the assignment.

Steps

  1. Ensure required roles are created in Addepar
  2. Create new users with the Users API
  3. Assign roles to respective users with the Users API

Users

Audit users and roles

Easily export lists of users and respective roles for auditing and compliance. Use the Roles or Users API to request the desired information.

Roles

Steps

  1. Identify list of roles to query by role ID (full list and role IDs can be requested using the Roles API)
  2. Use the Roles API to request a list of assigned members based on role ID

Roles

Users

Steps

  1. Identify list of users to query by user ID (full list and user IDs can be requested using the Users API)
  2. Use the Users API to request a list of assigned roles based on user ID

Users

Manage data access permissions

Ensure all of your advisors have access to their client data and respective books of business. Automatically synchronize client permission groups in Addepar with internal rep code systems and assign access to each user.

Steps

  1. Create permission groups with the Groups API
  2. Add and manage members of permission groups with the Groups API
  3. Assign users to permission groups with the Users API

Groups
Users

Audit group members

Easily export lists of groups and respective members for auditing and compliance. Use the Groups API to request the desired information.

Steps

  1. Identify the list of groups to query by group ID (full list and group IDs can be requested using the Groups API)
  2. Use the Groups API to request a list of members based on the group ID

Groups

Document Management

Export files to external systems

Instantly deliver reports and other files to external systems with the Files API. Distribute files through a client portal or archive them in your document management system.

Steps

  1. Use the Files API to request a list of file IDs based on your desired criteria
  2. Download files using selected file IDs

Files

Import files for distribution through Addepar

Import fund fact sheets, distribution notices, and other files for management and distribution through Addepar with the Files API. Users can publish files to the client portal from within Addepar.

Steps

  1. Create and import files into Addepar with the Files API
  2. Associate files to a specific group or entity

Files