get_investment_prices
Retrieve historical investment prices for stocks, ETFs, mutual funds, and crypto to track portfolio value. Filter by ticker, date range, or price type; request full time series only when needed.
Instructions
Get investment price history for portfolio tracking. Returns one row per (security, period) for stocks, ETFs, mutual funds, and crypto. Filter by ticker symbol, date range, or price type (daily/hf). By default each row is TERSE: the security, the period, and its latest price (latest_price / latest_at) — enough to answer "what is this worth". The full price series (prices, an epoch-millis map) is most of a full row and roughly quadruples response size, so it is omitted unless requested via fields; ask for it only when you need the time series itself, not a current value.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "get_investment_prices"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum number of results (default: 100, max: 10000) | |
| fields | No | Return only these fields per row. Default when omitted: a terse row (security_id, ticker_symbol, price_type, date/month, latest_price, latest_at). The full intraday/daily series lives in `prices`, which is EXCLUDED by default because it is most of a row and multiplies response size several-fold — request it explicitly with fields: ["default", "prices"], or use "all" / "*" for full rows. Unknown names are omitted and reported via _field_warning. | |
| offset | No | Number of results to skip for pagination (default: 0) | |
| end_date | No | End date (YYYY-MM-DD) | |
| price_type | No | Filter by price type: daily (monthly aggregates) or hf (high-frequency intraday) | |
| start_date | No | Start date (YYYY-MM-DD) | |
| ticker_symbol | No | Filter by ticker symbol (e.g., "AAPL", "BTC-USD", "VTSAX") |