TickerInside

CompareStock twocomparison USand stocks,weight orin a stock and an ETFfund

TwoUse this when the user asks how two US stocks: marketcompare capon size, valuation, returns, therisk coveredor UScorrelation, ETFsor holdingwhat both,weight and withrank threeone yearsstock ofhas pricesinside theirone worstnamed fallETF, volatilityfor example META in QQQ. For two stocks it returns market cap, betaP/E and dividend yield from market data, returns, volatility, worst fall, beta, the correlation of their weekly returns.returns Aover fundup tickerto worksthree onyears oneand sidethe covered ETFs holding both. For a stock and a fund it returns whether the fund holds the stock, at what weight and rank.rank among the shares it holds outright, with the date of the fund's holdings; a derivative-based fund's swaps, futures and options are in its profile (fund_profile), not here. A stock is in the data with about two years of US prices, and sooner for a recent listing a covered fund holds. Returns are past, not a forecast. Not for comparing two ETFs (compare_funds), or a company's business or products.

 ⟨9 unchanged words⟩ , for example NVDA. An ETF ticker also works.works on one side, for example QQQ.","type":"string"},"b":{"description":"The other ticker.ticker, for example AMD.","type":"string"}},"required": ⟨4 unchanged words⟩ 

 ⟨4 unchanged words⟩ openWorldHint":false,"readOnlyHint":true,"title":"CompareStock twocomparison USand stocks,weight orin a stock and an ETFfund"}

HowETF muchownership of a US stock the covered ETFs own

For oneUse USthis stock,when the shareuser asks how much of itsa sharesUS outstandingcompany heldETFs byown, theor coveredwhat USshare ETFs,of asits stock sits in ETFs. Returns a lower bound: at least this percent of the shares outstanding is held by the covered US ETFs, from this many funds. Itfunds, giveswith the shares held, the SEC's count of shares outstanding and its date, the holdings dates and, the method. The basis saysmethod, whether the percent is of the whole company, every class counted, or of the ticker's class alone., Alsoand where the figure ranks by percent among those measured, and the share ofstocks themeasured. coveredIt USis stocka ETFs'lower moneybound inbecause theETFs tenoutside largestthe UScoverage companiesare theynot hold,counted. aA companystock without a stockfigure filecomes hereback included.with Athe stockreason. withoutNot afor figurethe comeslist backof withfunds that hold the reason.stock (stock_exposure).

 ⟨4 unchanged words⟩ openWorldHint":false,"readOnlyHint":true,"title":"HowETF muchownership of a US stock the covered ETFs own"}

What a US ETF added, droppedFund andholdings reweightedchanges

TheUse changesthis inwhen onethe user asks what a US ETF'sETF bought, sold, added or dropped, or how the weights of its holdings changed, recently or since a date. Returns, for each step from one issuer file to the next:, the lines that entered and exited with their weights, largest first, and the lines whose weight moved by 0.05 points or more, before and after.after, Itwhich coversincludes everyprice stepmoves sinceand anot dateonly trades, orwith the turnover measures; the latest step when no date is given. Each stepKept namesfor the filestock itETFs isread comparedfrom withtheir issuers' own files, daily for most and givesmonthly itsfor turnoverVanguard; measures.another Linesfund heldcomes twoback fileswith earlierthe arereason markedit ashas reverted;no ahistory. A step across a change of the keys orin ofhow the readingfiles ofare thekeyed fileor read is marked restated and lists no trades. Not for a fund's holdings on one date (fund_profile) or its overlap over time (fund_history).

 ⟨41 unchanged words⟩  file dated on or after this date, YYYY-MM-DD.written YYYY-MM-DD, for example 2026-09-15.","pattern":"^\\d{4}-\\d{2}-\\d ⟨6 unchanged words⟩ ":"A US ETF ticker, for example VOO.VOO or SCHD. Case does not matter.","type":"string ⟨4 unchanged words⟩ 

 ⟨4 unchanged words⟩ openWorldHint":false,"readOnlyHint":true,"title":"What a US ETF added, droppedFund andholdings reweightedchanges"}

A US ETF'sFund holdings history, file by file

OneUse this when the user asks how a US ETFETF's readholdings fromevolved over time, how often its issuer'sholdings ownfile files:changes, or how its overlap with its closest funds moved. Returns every archived file date theof archivethe holds,fund with theits position count and the top 10 weight.weight, Eacheach step from a file towith the next says howcount manyof lines that entered, exited and movedchanged weight and its turnover measures, and the overlap by weight ofover thethose namesdates thatwith changedits andten theclosest weightfunds. thatKept moved.for Thethe share-countstock turnoverETFs followsread oncefrom enoughtheir issuers' own files, carryfrom shareeach counts.fund's Itfirst alsoarchived showsfile: how1 September 2026 at the fund'searliest overlapfor bythe weightdaily withfiles, its31 tenJuly closest2026 fundsfor movedVanguard's overmonthly thosefiles; dates.another Eachfund stepcomes namesback with the filereason it ishas comparedno with;history. aA step across a change ofin how the keysfiles are keyed or ofread theis readingmarked ofrestated, not traded. Not for the filelines isone markedstep restated.added or dropped (fund_changes).

 ⟨10 unchanged words⟩  file dated on or after this date, YYYY-MM-DD.written YYYY-MM-DD, for example 2026-09-15.","pattern":"^\\d{4}-\\d{2}-\\d ⟨6 unchanged words⟩ ":"A US ETF ticker, for example VOO.VOO or SCHD. Case does not matter.","type":"string ⟨4 unchanged words⟩ 

 ⟨4 unchanged words⟩ openWorldHint":false,"readOnlyHint":true,"title":"A US ETF'sFund holdings history, file by file"}

US ETFFund holdings and profile

OneUse this when the user asks what one US ETF: itsholds, holdingsor withits weightscost, size, returns and risk. Returns the holdings largest first with their weights, andthe itsexpense costratio, assets, top 10 weight, returns over one, three and five years, volatility, beta, and worst fall, andwith concentration.each Everyfile's figuredate; carriesmost thefunds dateread offrom theSEC issuerfilings file,have SECno filingreturn or pricesrisk itfigures camehere. from.Returns Aare fixedpast, incomenot ETFa forecast. A bond fund gives its lines by issuer, coupon, and maturity, andwith duration; a derivative-basedfund ETFread from SEC filings that is leveraged, inverse, under half in stock or half in swaps and futures lists its shares, and its contracts apart as notional exposure,exposure; neveran sharesoption held;income fund read as a truststock orfund pool(JEPI, QYLD) lists its stocks, not its options or notes; a trust gives what its filing says it holds.holds; a prospectus-only fund its objective. Not for comparing funds (compare_funds) or the funds holding a stock (stock_exposure).

 ⟨7 unchanged words⟩ :"How many of the largest holdings to return.return, from 0 forto none.500; 25 when left out. 0 returns the figures without holdings.","maximum":500,"minimum":0,"type ⟨3 unchanged words⟩ ":"A US ETF ticker, for example VOO.VOO or SCHD. Case does not matter.","type":"string ⟨4 unchanged words⟩ 

 ⟨4 unchanged words⟩ openWorldHint":false,"readOnlyHint":true,"title":"US ETFFund holdings and profile"}

ListCoverage coveredand USfund ETFssearch

The ETFsUse this serverwhen canthe answeruser forasks whether a US ETF is covered, withwants theto datefind ofa fund by name or ticker, or asks how many ETFs the data covers and how manyrecent it is. Returns the date of the US-listeddata ETFsand thatthe is.count Holdingsof comecovered fromfunds by source: the issuers' own dailyholdings files (tickers), from SEC filingsForm (tickers_sec_nport,N-PORT tickers_bondfilings, tickers_multi_asset,trusts' tickers_derivative)filings, fromsponsors' afiles trust'sand ownprospectuses, filingand (tickers_trust)how ormany fromof athe sponsorUS-listed (tickers_sponsor).ETFs that is. With query, it returns onlyup theto 50 matching funds whosewith their names and sources; without query, it also lists every covered ticker orby namesource matches;unless include_tickers is false, leavesa outlong answer. Mutual funds, closed-end funds and funds listed outside the lists.US are not covered. Not for a fund's holdings or figures (fund_profile).

 ⟨3 unchanged words⟩ "include_tickers":{"default":true,"description":"falseWhether leavesan answer without query lists every covered ticker, by source, and only those of source when it is given. true or left out adds the tickerlists, lists.a long answer; false returns the counts and dates alone.","type":"boolean"},"query":{ ⟨89 unchanged words⟩ 

 ⟨4 unchanged words⟩ openWorldHint":false,"readOnlyHint":true,"title":"ListCoverage coveredand USfund ETFssearch"}

LookCompanies throughinside a portfolio of ETFs to its holdings

LookUse throughthis when the user gives a listportfolio of US ETFs toand theasks which companies underneath:they own, how much of eachone company they hold, or how concentrated it is. Returns the portfoliocompanies holdsunderneath, ineach with its percent andof inwhat moneyis looked through, its value when amounts are given, and whichthe funds it comes through.through, plus the company count and top 10 weight; for one company, raise top until it shows, up to 200. It measures diversification by single companies, not by how funds move together. Without amounts, every fund counts equally. Uncovered tickers (US stocks among them), bond, commodity, multi-asset, sponsor-file and prospectus-only funds, and funds read from SEC filings that are listedleveraged, inverse, under half in stock or half in swaps and futures are named and left out of the percentages.percentages and the value. Amounts are not stored. Not for duplicate funds (overlap_matrix) or risk (risk_decomposition).

 ⟨5 unchanged words⟩ "The currency of the amounts, for example USD.USD or EUR. Echoed back;back with the values; nothing is converted. Left out, the amounts still weigh the funds and the currency reads unstated.","type":"string"},"positions":{"description":"The funds inof the portfolio.portfolio, Amounts1 areto optional;60, for example [{\"ticker\": \"VOO\", \"amount\": 40000}, {\"ticker\": \"QQQ\", \"amount\": 25000}] with \"currency\": \"USD\" beside it. Give an amount for every position or for none; with none, every fund counts equally.","items": ⟨5 unchanged words⟩ ":"What this line is worth, in onethe currencysame

 ⟨4 unchanged words⟩ openWorldHint":false,"readOnlyHint":true,"title":"LookCompanies throughinside a portfolio of ETFs to its holdings"}

ETF overlapOverlap across a list ofmany funds

EveryUse pairthis inwhen athe listuser oflists 2three to 30thirty US ETFs, often a portfolio, and asks which of them duplicate each other or whether the list is diversified across companies; two give one pair. Returns every pair ranked by overlap by weight, towith seethe whichshare fundsof each fund held in acommon portfolioand duplicatethe count of companies in both, and the holdings date and source of each other.fund Fixedin incomethose pairs. It measures diversification by the holdings the funds share, not by how their returns move together. Bond funds are paired by issuer overlap, and listed apart. Uncovered tickers are listednamed and skipped.skipped; commodity, multi-asset, sponsor-file and prospectus-only funds and funds read from SEC filings that are leveraged, inverse, under half in stock or half in swaps and futures are listed as not comparable, each with its reason. Not for the companies underneath (look_through) or how funds move together (risk_decomposition).

 ⟨4 unchanged words⟩ {"description":"2 to 30 US ETF tickers.tickers, for example [\"VOO\", \"QQQ\", \"SCHD\"]: three or more give the matrix, two give one pair.","items":{"description":"A US ETF ticker, for example VOO.VOO or SCHD. Case does not matter.","type":"string ⟨10 unchanged words⟩ 

 ⟨4 unchanged words⟩ openWorldHint":false,"readOnlyHint":true,"title":"ETF overlapOverlap across a list ofmany funds"}

Where an ETF portfolio'sPortfolio risk comes frombreakdown

ForUse this when the user gives a listportfolio of US ETFs: portfolioand asks where its risk comes from or how its funds move together. Returns the portfolio's volatility, each position's share of the risk (Euler decomposition,and summingof tothe 100)capital, the diversification ratio, independent bets, the beta to the S&P 500, and the correlation and covariance matrices of weekly returns over up to three years. It measures diversification by how the funds move together, not by companies held. Every fund needs a year of weekly prices, which most funds read from SEC filings do not have here. Uncovered tickers are named and skipped. A portfolio with a bond, commodity, multi-asset, sponsor-file or prospectus-only fund, or a fund read from SEC filings that is leveraged, inverse, under half in stock or half in swaps and futures, comes back without figures, naming each. Past, not a forecast. Not for the companies held (look_through).

 ⟨5 unchanged words⟩ "The currency of the amounts, for example USD.USD or EUR. Echoed back;back with the values; nothing is converted. Left out, the amounts still weigh the funds and the currency reads unstated.","type":"string"},"positions":{"description":"The funds inof the portfolio.portfolio, Amounts1 areto optional;60, for example [{\"ticker\": \"VOO\", \"amount\": 40000}, {\"ticker\": \"QQQ\", \"amount\": 25000}] with \"currency\": \"USD\" beside it. Give an amount for every position or for none; with none, every fund counts equally.","items": ⟨5 unchanged words⟩ ":"What this line is worth, in onethe currencysame

 ⟨4 unchanged words⟩ openWorldHint":false,"readOnlyHint":true,"title":"Where an ETF portfolio'sPortfolio risk comes frombreakdown"}

Which US ETFs that hold a stock, and at what weight

ForUse onethis stock,when the covereduser USasks ETFswhich thatETFs hold ita andstock, which fund holds the weightmost inof eachit, heaviesthow first.many Eachfunds holderhold carriesit, itsor holdingswhether date,it itsis sourcein (theVOO, issuer'sSPY, dailyIVV, fileQQQ, VTI or anSCHD. SECReturns filing)the covered US ETFs that hold it, sorted by the stock's rankweight in theeach fund, andlargest thefirst, dollarseach held.with Returnsits theweight, largestrank, holdersdollars, holdings date and thesource, totalplus the count, how many funds havehold it as their largest holdingposition, and the funds and issuers with the most dollars in it.it, Itand alsoone sayssentence whetherto thequote. stockThe islist inkeeps VOO,the SPY,heaviest IVVholders, QQQ,so VTI,a SCHDbroad andfund where the largeststock sectorweighs funds.little Itcan addsfall theoutside issuersit; holdingwhether the most,six thefunds cheapestabove exposurehold perit $1,000,is fundsin whoseevery nameanswer onlyfor sharesa thestock company's,with andits oneown sentencestock tofile, quote.whatever Leveraged,top inverseis, andunless option-incomecompact fundsis thattrue. referenceFunds theholding stockit through swaps, futures or options are listed apart, as notional exposure,exposure. neverNot sharesfor held.one stock's weight in another fund (compare_stocks) or the share ETFs own (etf_ownership).

 ⟨4 unchanged words⟩ {"default":false,"description":"true for an answer about half the length. It keeps the counts, rank_summary (how many funds hold the stock as their largest or a top 10 position), name_collision (funds whose name contains the company's name) and the sentence to quote,quote. withoutIt leaves out top_by_value (the funds holding the most dollars of it), membership (whether VOO, by_issuerSPY, IVV, QQQ, VTI and fee_per_1000SCHD hold it, and withoutits eachweight fund'sin rankthe three largest sector or industry funds that hold it)

 ⟨4 unchanged words⟩ openWorldHint":false,"readOnlyHint":true,"title":"Which US ETFs that hold a stock, and at what weight"}

Every USThe ETFETFs this server can answer for, with the date of the data.data and how many of the US-listed ETFs that is. Holdings come from the issuers' own daily files (tickers) or, from SEC filings for the other US stock ETFs (tickers_sec_nport)., Ittickers_bond, alsotickers_multi_asset, tellstickers_derivative) whetheror from a giventrust's fundown isfiling covered.(tickers_trust). With query it returns only the funds whose ticker or name matches, with their names;matches; include_tickers false returns the countsleaves andout datesthe alone.lists.

 ⟨44 unchanged words⟩  funds read from the issuers' own files, or only thosethe stock ETFs from SEC filings.filings, only the fixed income funds, only the multi-asset funds, only the derivative-based funds, or only the trusts and pools.","enum":["issuer_files","sec_nport","sec_nport_bonds","sec_nport_multi_asset","sec_nport_derivatives","trust_filings"],"type":"string"}},"type":"object"}

 ⟨18 unchanged words⟩ which funds in a portfolio duplicate each other. Fixed income funds are paired by issuer overlap, listed apart. Uncovered tickers are listed and skipped.

 ⟨105 unchanged words⟩ shares the company's, and one sentence to quote. Leveraged, inverse and option-income funds that reference the stock through swaps, futures or options are listed apart, as notional exposure, never shares held.

 ⟨7 unchanged words⟩ own files: every file date the archive holds, with the position count and the top 10 weight, one lineweight. perEach step from a file to the next (says how many lines entered, exited and moved, the weight carried byof the names that changed, and the weight that moved, andmoved. theThe share-count turnover follows once enough files carry share counts),counts. andIt also shows how itsthe fund's overlap by weight with its ten closest funds ⟨31 unchanged words⟩ 

 ⟨6 unchanged words⟩  answer for, with the date of the data and where thedata. holdingsHoldings come from: the issuers' own daily files (tickers), or from SEC filings for the other US stock ETFs (tickers_sec_nport), so. itIt also tells whether a given fund is covered. ⟨23 unchanged words⟩ 

 ⟨9 unchanged words⟩  it and the weight in each, heaviest first,first. withEach eachholder fund'scarries its holdings date, whether it comesits fromsource (the issuer's daily file or an SEC filing), the stock's rank in the fund and  ⟨13 unchanged words⟩  funds have it as their largest holding, and the funds with the most dollars in it,it. It also says whether itthe stock is in VOO, SPY, IVV, QQQ, VTI, SCHD and the largest sector funds,funds. It adds the issuers holding the most, the cheapest  ⟨16 unchanged words⟩