Investment Holdings

A Holding in Quiltt represents an investment position such as a stock, bond, ETF, or mutual fund held in an investment account.

Link to this section#GraphQL Queries

Quiltt provides holdings at two levels:

1. Profile level - Aggregated positions across all investment accounts via the holdings query.
2. Account level - Individual positions for a specific account via account.holdings.

Link to this section#When to Use Each

Use the holdings query when you want:

• Consolidated portfolio view across all accounts
• Total exposure to a specific security
• Overall investment performance
• Aggregate portfolio analytics

Use account-level holdings (account.holdings) when you want:

• Positions broken down by account
• Access to provider-specific remote data
• Account-specific cost basis for reconciliation

Link to this section#Profile-Level Holdings

Use the holdings query to fetch aggregated positions across all investment accounts belonging to the Profile. This provides a consolidated portfolio view.

query GetHoldings {
  holdings {
    nodes {
      id
      quantity
      price
      value
      costBasis
      at
      security {
        id
        name
        ticker
        type
      }
    }
  }
}

{
  "data": {
    "holdings": {
      "nodes": [
        {
          "id": "hld_12xBsJKrI455PNcaCkqpGk",
          "quantity": 250.75,
          "price": 178.32,
          "value": 44713.74,
          "costBasis": 38542.50,
          "at": "2024-06-09T12:34:56Z",
          "security": {
            "id": "sec_12xBsJKrI455PNcaCkqpGj",
            "name": "Apple Inc.",
            "ticker": "AAPL",
            "type": "EQUITY"
          }
        }
      ]
    }
  }
}

Profile-level holdings are calculated after each sync completes and the profile.ready event is fired. When you own the same investment across multiple accounts, positions are combined:

• Quantity: Total shares across all accounts
• Value: Total market value across all accounts
• Cost Basis: Your average cost per share across all accounts

Link to this section#Account-Level Holdings

Account-level holdings are available through Accounts. Use account.holdings when you need positions for a specific investment account, including access to provider-specific remote data.

query GetAccountHoldings {
  account(id: "acct_12tgD1YP33AwEvbdmSrcRY") {
    id
    name
    holdings {
      nodes {
        id
        quantity
        price
        value
        costBasis
        at
        security {
          id
          name
          ticker
          type
        }
      }
    }
  }
}

{
  "data": {
    "account": {
      "id": "acct_12tgD1YP33AwEvbdmSrcRY",
      "name": "Individual Brokerage",
      "holdings": {
        "nodes": [
          {
            "id": "achld_12xBsJKrI455PNcaCkqpGh",
            "quantity": 150.5,
            "price": 178.32,
            "value": 26837.16,
            "costBasis": 22542.00,
            "at": "2024-06-09T12:34:56Z",
            "security": {
              "id": "sec_12xBsJKrI455PNcaCkqpGj",
              "name": "Apple Inc.",
              "ticker": "AAPL",
              "type": "EQUITY"
            }
          }
        ]
      }
    }
  }
}

Link to this section#Accessing Remote Data

Account-level holdings include raw provider data via the remoteData field:

query AccountHoldingRemoteData {
  account(id: "acct_12tgD1YP33AwEvbdmSrcRY") {
    holdings {
      nodes {
        id
        remoteData {
          plaid {
            holding {
              response {
                security_id
                latest_price
              }
            }
          }
        }
      }
    }
  }
}