get_holdings
Retrieve current investment holdings with position-level details, including ticker, quantity, price, equity value, average cost, and total return; filter results by account or ticker symbol.
Instructions
Get current investment holdings with position-level detail. Returns ticker, name, quantity, current price, equity value, average cost, and total return per holding. Joins data from account holdings, securities, and optionally historical snapshots. Filter by account or ticker symbol. Note: cost_basis may be unavailable for cash-equivalent positions. Positions on hidden and merged accounts are EXCLUDED by default, matching get_accounts — pass include_hidden: true for them. Do NOT sum holdings as portfolio value: unvested stock-plan shares are reported as holdings, so the sum can far exceed the investment balance; with --live-reads use get_investment_balance_live for the total.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum number of results (default: 100, max: 10000) | |
| offset | No | Number of results to skip for pagination (default: 0) | |
| account_id | No | Filter by investment account ID. Returns empty for a hidden or merged account unless include_hidden is also set. | |
| ticker_symbol | No | Filter by ticker symbol, case-insensitive (e.g., "AAPL", "SCHX"). The cash sleeve is CUR:USD here and USD in live mode; either spelling matches it in both modes (CUR:USD matches only cash; a bare USD also matches a security tickered USD). | |
| include_hidden | No | Include positions on hidden and merged accounts (default: false). Same flag, same default as get_accounts — leave it off and the two tools agree on which accounts exist. | |
| include_history | No | Include monthly price/quantity snapshots per holding (default: false) |