get_investment_splits
Retrieve stock split events with adjustment multipliers and security details from your local cache. Use for narrative or historical analysis.
Instructions
Get stock split events from the local Firestore cache. Returns one row per (security, effective_date) with the adjustment multiplier (e.g. 0.1 for a 10-for-1 split — multiply pre-split prices/quantities by this value to convert to the post-split equivalent). Joined with the securities collection so each row includes ticker and name. IMPORTANT: prices returned by get_investment_prices and get_investment_prices_live are ALREADY split-adjusted by Copilot. Use this tool only when you need the split events themselves (e.g., for narrative or historical-analysis purposes) — you do NOT need to apply these multipliers to the prices yourself. Securities that have never split are not included in the output. Coverage is limited to securities Copilot currently syncs in your local cache (typically currently-held or recently-held).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ticker_symbol | No | Optional. Case-insensitive ticker filter (e.g. "NVDA"). | |
| start_date | No | Optional. Inclusive lower bound on effective_date (YYYY-MM-DD). | |
| end_date | No | Optional. Inclusive upper bound on effective_date (YYYY-MM-DD). | |
| limit | No | Maximum number of rows. Default 100, max 10000. | |
| offset | No | Pagination offset, default 0. |