etf
Analyze fund holdings, profiles, tracking, concentration, overlap, liquidity, valuation, and contribution metrics by ticker to compare funds and assess exposures.
Instructions
Analysis of ETFs and other funds. Requires tickers='VOO' — use comma-separated values for several funds; tickers that are not an ETF or fund return no data. get_holdings: the 25 largest holdings of each fund by weight (shares, weight and market value) unless limit= asks for more, limit=-10 for the smallest; the holdings carry no sector or country, so use get_sector_weightings and get_country_weightings for those breakdowns, or the Finance Database server to classify the holdings. get_information: everything published about each fund, including its identifiers, description and website. get_profile: name, issuer, asset class, domicile, inception date, expense ratio, assets under management, NAV, latest price, premium/discount to NAV (the close of the NAV's own date against the NAV; empty for a NAV that is not current unless stale_nav=true), holdings count and average (dollar) volume. get_tracking: tracking difference (annualized return gap, about minus the expense ratio for an index fund), tracking error, correlation, beta and R Squared against benchmark_ticker (set it to the fund's index or another fund of the same index, e.g. benchmark_ticker='SPY' for VOO); yearly=true gives the gap per calendar year. get_concentration: number of holdings, largest holding, top 10 weight, Herfindahl-Hirschman index and effective number of holdings. get_overlap: the overlap of every pair of funds (sum of the smaller weight over shared holdings). get_active_share: the active share of every pair of funds (half the sum of the absolute weight differences, 0 for identical and 1 for unrelated holdings; e.g. tickers='MGK,VOO' for a fund against its index). get_look_through_valuation: weighted (harmonic) P/E, P/B, P/S and P/FCF, dividend yield and net margin of the largest holdings (holdings=25) with the coverage. get_liquidity: average volume and dollar volume, dollar volume to assets and the price impact per $100 million traded (Amihud). get_contribution: how much every holding (group_by='sector' for every sector) added to or took off the fund's price return from the close before start_date to end_date, as Start Weight, Return, Contribution and Points (of the fund's price, or of an index with index='^GSPC' for SPY), largest first, then the Remainder (cash, unpriced holdings) and the Total; the weights are the current holdings rolled back to the start, so short recent periods are the most precise. get_return_excluding: the fund's return without its largest holding, or without the holdings or sectors of exclude= (e.g. exclude='NVDA,Technology'), next to the return of all priced holdings. Both price the holdings one request each (holdings= limits that to the largest).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"indicator": "<indicator>"
},
"name": "etf"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rank | No | true ranks the tickers (or countries) within every period, from the highest value (rank 1) to the lowest, and compares each with its neighbour toward the middle of the ranking: the Difference (in points for returns) and the Multiple (only when both have the same sign), so the first and last rank show how far the best and the worst stand apart, e.g. a fall more than twice as large as the next one. Needs a value per period and ticker; pick one field with show_columns where there are more. | |
| index | No | The ticker of an index whose level at the start of the period converts the contributions into index points, e.g. "^GSPC" for SPY. | |
| limit | No | The rows to return, like head and tail: 5 for the first five, -5 for the last five (the most recent of a time series). A table with its periods as columns (financial statements, ratios) keeps its first or last periods instead, and rows per ticker (an earnings calendar) are selected per ticker. For ETF holdings the largest (or, negative, the smallest) by weight, and for a list (e.g. news or a screener) its length. 0 returns every row. Leave unset to use the default of the indicator you selected. Defaults are 25 for get_holdings. | |
| period | No | Observation frequency, e.g. 'daily', 'weekly', 'monthly', 'quarterly', or 'annual' (supported values differ per method). | daily |
| yearly | No | Whether to return the tracking difference per year. | |
| exclude | No | The holdings (tickers, e.g. "NVDA") and sectors (e.g. "Technology", as the companies' profiles name them) to leave out. | |
| tickers | No | Comma-separated ticker symbols, e.g. 'AAPL,MSFT,GOOGL'. | |
| end_date | No | End of the date range in YYYY-MM-DD format; left empty, today (or the indicator's own window). | |
| group_by | No | "holding" for every holding or "sector" for every sector (from the holdings' company profiles). | holding |
| holdings | No | For get_contribution: The number of largest holdings (by weight) to price, one request each; the rest counts towards the Remainder. For get_look_through_valuation: The number of largest holdings to value per fund. For get_return_excluding: The number of largest holdings (by weight) to price, one request each; the rest counts towards the rest of the fund. Leave unset to use the default of the indicator you selected. Defaults are 500 for get_contribution, get_return_excluding; 25 for get_look_through_valuation. | |
| indicator | Yes | Name of the specific metric to calculate, one of the listed values. Required — search_metrics finds the indicator (and its tool) for a metric by name. | |
| quarterly | No | Return quarterly data instead of annual when True. | |
| stale_nav | No | Whether to give the premium for a NAV that is not current, comparing it with the nearest close available. | |
| start_date | No | Start of the date range in YYYY-MM-DD format; left empty, five years before today (or the indicator's own window). | |
| show_columns | No | Comma-separated names to filter the output. For historical data use the key names visible in any response record (e.g. 'Close,Volume,Return'). For financial statements use the 'metric' field values from the response (e.g. 'Revenue,Net Income,EBITDA'). Call the tool once without this parameter to see all available names, then repeat with show_columns to reduce response size and token usage. | |
| benchmark_ticker | No | Ticker used as the market benchmark, e.g. 'SPY' or '^GSPC'; 'None' for no benchmark. | SPY |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |