Equibles

Record a user-confirmed purchase or sale in the caller's portfolio. Never infer or guess the instrument, quantity, price or date. For stock, pass ticker; a listing on another exchange is its MIC:TICKER symbol (e.g. XPAR:AIR, as ScreenStocks returns it). For an option, pass both its underlying ticker (MIC:TICKER for a Canadian contract, e.g. XTSE:RY) and verified OCC symbol from GetOptionChain; unknown or expired contracts are rejected. quantity is signed: positive for long shares/contracts, negative for short stock or written options. costPerUnit is always the positive per-share price or option premium, never the per-contract total, in the currency the listing trades in and in major units (London prices in pounds, not pence). Identical retries within the duplicate window return the existing lot instead of adding another.

Record that the USER sold (or covered, or let expire) all or part of a lot, at a price and on a date. The lot moves out of the open positions and its realized profit is kept. Ask the user for the closing price and date; never guess them from a market quote. Closing PART of a lot splits it: the closed part keeps the original cost basis and the rest stays open on that same basis, so a later sale is still priced against what was actually paid. An option that expired worthless closes at a price of 0. An option that was exercised or assigned closes here too, and the resulting shares are a separate AddPortfolioLot.

Compare one financial concept across several companies for the same fiscal period — peer comparison. Returns one row per ticker with the latest-restated value; tickers with no data for the period are listed separately. Fiscal year/period follow each company's OWN fiscal calendar (e.g. NVDA's fiscal 2025 ended January 2025), so peer rows can cover very different calendar months — check the Period End column.

Compare two institutions' 13F portfolios on their latest common report date. Returns Jaccard and dollar-weighted overlap, portfolio totals, and shared or unique positions. Published values normally use report-date closing prices, may fall back to filer values, and can be zero when unavailable. Resolve filer names with SearchInstitutions. For mutual-fund or ETF NPORT portfolios, use GetFundProfile.

Create a new, empty portfolio in the USER's own Equibles account, then add holdings to it with AddPortfolioLot. Ask the user before creating one, since it is their account. Names are unique within an account, and re-creating a name that already exists is rejected rather than merged. Totals are reported in the portfolio's currency; each holding stays in the currency its listing trades in.

Permanently delete one of the USER's own portfolios and every lot in it, open and closed. This cannot be undone and it destroys the recorded cost basis and realized-profit history. ALWAYS confirm with the user first, naming the portfolio and how many lots it holds. Call GetMyPortfolio if you do not already know.

Get every disclosed holder of a stock or ETF listing in one table: 13F institutions, Schedule 13D and 13G filers, insiders (Forms 3, 4, 5) and registered funds (N-PORT). The default view shows one row per holder from its freshest filing, with its other filings and the 13D/G, insider and fund disclosures its 13F report contains nested under it, matched by CIK and SEC reporting links, never by name. Shares are restated onto today's split basis, change is against the same holder's previous filing in the same source, and % Out is of shares outstanding. Funds are never summed: their shares sit inside their advisers' 13F reports. view=all lists every row flat, stale ones included; view=ultimate groups the summed holders under their ultimate parent and lists each parent's members with the link that put them there. Use GetOwnershipSummary for the totals.

Read analyst consensus forecasts for a company, including revenue, EPS, product, segment and operating metrics. Prefers consensus the company publishes itself through its investor-relations sources and falls back to a compiled consensus; every answer states which kind answered. Returns original units, accounting basis, mean/median/range/count labels, snapshot history and publication dates. Coverage varies by issuer. This reads stored verified data and never scrapes on demand.

Get a company's at-the-market (ATM) equity offering programs — original agreement date and stated precision, latest amendment, money and/or share capacity, cumulative sales, remaining availability with per-figure as-of dates, expiry, derived exhausted/expired status, and source filings. Bare table figures are normalized only from an exact grounded filing scale header. ATM programs have no tagged XBRL equivalent, so figures come from verified extractions of the company's own 10-K, 10-Q and 8-K filings; only filings from roughly the last 13 months are scanned, so an empty result means no program was captured there — not proof the company runs no ATM program. Nothing is estimated.

Average True Range (ATR) for a stock. Wilder's volatility measure built from the True Range (max of high-low, |high-prev_close|, |low-prev_close|) and smoothed recursively. Higher ATR means wider daily moves; commonly used for position sizing and stop placement. ATR is denominated in the stock's price units (USD for a US listing, the listing's own quote unit otherwise). The smoothing is warmed up on price history fetched before startDate, so values do not depend on the requested range's left edge.

Get the Schedule 13D and 13G beneficial-ownership record of a stock or ETF listing: each filer's latest 13D or 13G, its event date, the block's shares (restated onto today's split basis) and percent of class, the change since the filer's previous 13D or 13G, and every reporting person on the cover pages with their own amount, percent and sole or shared voting and dispositive power. Reporting persons on one filing each claim the same block, so never add them together. Largest block first.

Bollinger Bands for a stock. A middle band (simple moving average of close) with upper and lower bands set a number of standard deviations above and below it. Bands widen when volatility rises and contract when it falls; price touching the upper/lower band is a common overbought/oversold cue. Includes %B ((close-lower)/(upper-lower)) and bandwidth ((upper-lower)/middle) columns. The moving-average window is warmed up on price history fetched before startDate, so values do not depend on the requested range's left edge.

Get a company's share-repurchase (buyback) picture: tracked repurchase programs (announcement date, authorized total, remaining availability, expiry, source filings), the latest program-authorization figures, and the repurchase history — cash spent, shares repurchased, and average price per fiscal year and recent quarters. Figures come from the company's own XBRL facts plus verified extractions of filings' narrative text; nothing is estimated, and figures a company stopped restating carry an explicit staleness label. For the dilution mirror-image — at-the-market (ATM) equity offering programs — use GetAtmPrograms.

Get the Canadian exchange-traded funds holding one Canadian listing, written MIC:TICKER (e.g. XTSE:RY), from each fund's own newest published portfolio, largest position first: the fund's ticker and name, the portfolio's date, shares, value and the position's percentage of the fund. Each fund states its own date, some daily and others monthly. Only funds with a machine-readable portfolio are covered, and a fund that holds other funds is left out so the same shares are never counted twice. For US registered funds use GetFundsHoldingStock; for Swedish funds use GetEuropeanFundHoldings.

Get the insider transactions filed on SEDI, Canada's insider disclosure system, for the issuer of one Canadian listing, written MIC:TICKER (e.g. XTSE:ATD, XTSX:..., XCNQ:..., NEOE:...), newest first. Each row gives the transaction date, the insider and their relationship to the issuer, the registered holder for indirect holdings, the SEDI transaction type, the security (options, share units and warrants included, with the underlying where filed), the signed amount (negative for a disposition) in units of that security, the price and its currency, the holding after the transaction and the filing date. An amended transaction appears once, at its newest amendment. Capture began with about the year before it first ran and grows daily, so older history is missing. For US Form 4 filings use GetInsiderTransactions; for European director dealings use GetEuropeanDirectorTransactions.

Get the aggregate short positions in one Canadian listing, written MIC:TICKER (e.g. XTSE:RY, XTSX:..., XCNQ:..., NEOE:...), from CIRO's Consolidated Short Position Report, newest first. CIRO, the Canadian Investment Regulatory Organization, publishes one report as of the 15th and one as of the last day of each month, a few days later. Each row gives the as-of date, the short position in shares, CIRO's net change since its previous report, and the listing's average daily volume over the trading days since the previous as-of date with the days to cover it implies, both from our own daily volume for that listing, and the shares CIRO reports sold short over the period with their percentage of all shares traded, as first reported. Capture began with the reports CIRO still served at its first read, about a year back. For US short interest use GetShortInterest; for European short positions use GetEuropeanShortPositions.

Get Commitments of Traders (COT) positioning data for a specific futures contract. Shows commercial and non-commercial positions over time. Values are contract counts from the legacy futures-only COT report (positions as of each Tuesday, published Friday). Use SearchCftcMarkets to find available market codes.

Get company-stated operational and non-GAAP KPIs extracted from written 8-K earnings releases and 10-K/10-Q MD&A, with period, filing date, source quote and exactly comparable year-over-year change. Omit metric for each series' latest reading; pass a company metric label for its full history. Values retain the company's stated scale. Earnings-call transcripts are not figure sources. A disclosed GAAP-to-non-GAAP reconciliation includes its stated bridge.

Get congressional securities transactions for a specific ticker (newest first, last year by default). Shows which members of Congress reported a purchase or sale, with transaction and filing dates; amounts are disclosed ranges, not exact values, and Asset identifies the filed instrument (such as stock, option, or bond). Use GetMemberTrades for one member's transactions across all tickers.

Get the stocks whose daily price returns are most (or least) correlated with one stock — Pearson correlation of daily log returns on comparable raw closes (dividends excluded), computed over the trading days both stocks priced, never on raw price levels. Scope picks the candidate universe: Industry (default) ranks the subject's direct industry peers; Sector widens to sibling industries; Market ranges across the ~1,500 largest listed names and surfaces cross-industry relationships the classification misses (suppliers, commodity proxies). direction=Negative flips the ranking to the strongest inverse movers (hedge candidates). Candidates need a $100M market cap and enough overlapping trading days with the subject; each row reports the observation count behind its coefficient. Use GetStockPrices for the underlying series and the screener for fundamentals-based peer sets.

Get a company's customer-concentration risk disclosure — statements like "one customer accounted for 31% of revenue": each disclosed figure's basis (revenue or receivables), customer count, percentage, and period, with the source filing. Untagged disclosures come from verified narrative extraction with a verbatim quote; issuers that tag ConcentrationRiskPercentage in structured XBRL (e.g. NVDA, AAPL) return those customer-specific dimensioned facts directly. A miss is never a statement of no risk. Pass maxFilings > 1 to also see earlier filings' disclosures (the concentration trend).

Get one durable debt instrument by its Equibles identifier. Returns current balances, linked filing observation, verified covenant bullets, exact source quotes, and governing or amending SEC documents. History, covenants, and documents are independently paged. Use GetDebtProfile first to obtain the instrument identifier.

Get a company's source-linked reported debt balances, total debt history, and identified notes, loans, and revolving credit facilities. The latest annual report establishes the baseline; subsequent interim reports and event disclosures update durable instrument records instead of creating a new instrument from a similar-looking row. Results summarize each instrument and provide its ID; use GetDebtInstrument for paged covenants, filing observations, exact evidence, and governing SEC exhibits. Unmatched observations are disclosed and excluded.

Get the stored declared cash dividends of an exact stock or ETF listing, newest first. Each row gives the ex-dividend date and cash amount per share: in USD for a US listing, and in the listing's trading currency for a listing on another exchange (MIC:TICKER). Date filters apply to the ex-dividend date. Future ex-dates can appear after a dividend is declared. Each listing reports its own payments: a share class (BRK-A beside BRK-B) or a fund series sharing its trust's filer (SCHD beside FNDA) never inherits another listing's dividends.

Get the AI 'Earnings Brief' for a company's recent earnings calls — a verifier-approved TL;DR, bullish and bearish points, and verbatim pull-quotes, plus a deterministic narrative shift against the immediately older available approved brief. When available, it also shows company guidance issued at the call, how that range changed from management's prior update, and the reported quarter versus the operative company guidance that preceded it. This is company guidance, not analyst consensus; actual comparisons use filed GAAP XBRL facts, never estimates. The shift is derived from approved bullets and is not separately verifier-approved. Newest quarter first. Only calls with an approved brief appear, so quarters can be missing from the sequence.

Get the earnings-call event for a company's fiscal quarter: one record grouping the call's audio, transcript, slide deck and 8-K earnings release. Returns the event id, title, call date, status, each artefact's status (available, pending, notPublished, failed, notAttempted, noCallHeld) with its reason and capture times, the transcript and release document ids, and approved guidance rows from the 8-K. Omit the fiscal period for the latest call; read the transcript with GetEarningsCallTranscript.

Get the analyst questions asked in a call's Q&A, one entry per analyst turn at the microphone, follow-ups included: the analyst and firm, the full question text, who answered, the turn range to read the exchange with GetEarningsCallTranscript or GetInvestorEventTranscript, and audio offsets for calls transcribed from audio. Names appear only for trusted identity resolutions. Pass a ticker with an optional fiscal period, or an eventId.

Track how a company's earnings-call themes move quarter over quarter: a theme by fiscal-quarter table of mention counts and tone across its last scored calls, oldest first, with each theme's status on the latest call (new, recurring, dropped, or unknown where an unscored quarter sits between the calls compared). Themes are paired across calls by name or shared keywords. Verifier-approved reads only; GetEarningsCallToneAndThemes gives one call's scores and keywords.

Get the AI-scored insights for a company's recent earnings calls — the management-tone read (a net tone score and a hedging score) and the call's key themes with their computed mention counts and per-theme tone. Newest call first. Verifier-approved — only scored and approved calls appear, so quarters can be missing from the sequence (a gap note flags non-consecutive quarters). Use it to gauge how confident or guarded management sounded and what they talked about most.

Get the speaker-labelled transcript of a company's earnings call for a fiscal quarter — every speaker turn in order, attributed to the real person (executive or sell-side analyst) with their role at the time. Identities appear only when the resolution is trusted (auto-resolved or human-reviewed); unverified voices show as a role label (e.g. Operator) or a neutral speaker number. Use GetEarningsCallEvent first to check a transcript exists.

Get the economic release calendar — scheduled (upcoming) and recent publication dates of US macro data releases, with the FRED series each release updates and an importance tier per release (High = the tier-1 scheduled market movers: CPI, PPI, Employment Situation, GDP, PCE, retail sales; Medium = other genuine scheduled prints; Low = daily rate/market levels like SOFR or VIX). FOMC meetings are NOT included — FRED's release feed has no real FOMC meeting dates; use the Federal Reserve's published meeting calendar for those. Defaults to the next 30 days. Use minImportance=high to see only the market movers, and GetEconomicIndicator to fetch a series' data after it prints.

Get time series data for a FRED economic indicator. Returns historical observations for indicators like FEDFUNDS (fed funds rate), CPIAUCSL (CPI inflation), UNRATE (unemployment), GDP, T10Y2Y (yield spread), VIXCLS (VIX), SP500, MORTGAGE30US, M2SL (money supply), and more. Covers the curated set Equibles tracks, not the full FRED catalog, including Canadian series from the Bank of Canada (BOC-V39079 policy rate, CORRA, 2- and 10-year bond yields) and Statistics Canada (STATCAN-V41690973 CPI, CPI-trim and CPI-median, unemployment, employment, real GDP) — use SearchEconomicIndicators to find available series.

Get an ETF's stored portfolio holdings, largest position first: a US fund's latest SEC Form NPORT-P report (coverage full, partial, or unknown when counts are missing or inconsistent), or, for a fund on another exchange named MIC:TICKER, the fund sponsor's published portfolio file as of its stated date, every row as filed with its weight. Use offset to continue through broad portfolios.

Get ETF settled performance, SEC assets, allocation and top holdings. For this same exact ETF ticker, use GetStockPrices or GetLatestClosingPrices for prices, GetLiveQuote for entitled intraday quotes, GetOptionExpirations/GetOptionChain/GetOptionContract for options, GetShortInterest for reported short interest and days to cover, GetShortVolume/GetOffExchangeVolume/GetFailsToDeliver for trading and settlement data, GetTopHolders/GetInstitutionalOwnershipHistory/GetTopInstitutionalBuyersSellers for 13F institutional exposure, GetFundsHoldingStock for funds owning the ETF, GetDividendHistory for its own declared distributions, and GetCongressionalTrades for congressional trades. These are shared stock-and-ETF tools; GetEtfHoldings instead returns investments inside the ETF. ListFilings/SearchDocuments select the SEC registrant and may include sibling funds, not just this ETF series. Issuer-trained short-interest forecasts and squeeze scores are not ETF analytics.

Get the director and related-person (PDMR) transactions a regulator published for one listing outside the US, written MIC:TICKER (e.g. XSTO:VOLV-B). Coverage today is Sweden's Finansinspektionen register, matched by the issuer's LEI or the security's ISIN, so rows can include the issuer's other instruments. Each row gives the transaction date, the person and role, a related person where reported, the transaction type, the instrument and ISIN, volume, price and currency, and the source status including amendments. Only captured publication days are covered, and the register is not a complete insider-ownership record. For US Form 4 filings use GetInsiderTransactions.

Get the European investment funds reporting a position in one listing outside the US, written MIC:TICKER (e.g. XSTO:VOLV-B), matched by that security's ISIN. Coverage today is Swedish UCITS quarterly portfolios published by Finansinspektionen with about a two-month delay; special funds are excluded. Each row gives the fund, its manager, the reported quantity, the market value in SEK and the position's weight in the fund's assets, which is not a share of the company. Not comprehensive European ownership and not merged with SEC filings. For US registered funds use GetFundsHoldingStock.

Get the net short positions disclosed to European regulators for one listing outside the US, written MIC:TICKER (e.g. XPAR:UBI, XAMS:ASML), matched by that security's ISIN, or the issuer's LEI for issuer-level sources: individual holder disclosures from registers such as France's AMF, the Netherlands' AFM and the Spanish, German, Belgian, Irish, Polish, Finnish and Danish registers, plus published aggregates such as Norway's and Sweden's. Values are percentage points of issued share capital. Each register is listed separately and never summed; these are dated disclosures, not total short interest, current holdings or short volume, and a register without a row is not a zero position. Registers checked without a match, not captured yet or out of date are named at the end. For US listings use GetShortInterest.

Get a company's executive and director changes — CEO/CFO/officer/board appointments, resignations, terminations, and retirements — as disclosed in its 8-K Item 5.02 filings, newest filing first. Each change carries the person's name, the role text exactly as filed, a separate normalized role classification, the action, the effective date when stated, the verbatim disclosure, and the source filing (form + link). Changes are extracted from the filings' narrative text and verified before publication. Coverage is still back-filling: the output names the oldest covered filing date, and an empty answer distinguishes 'covered filings disclose no changes' from 'filings not yet processed'.

Get a company's named-executive compensation as disclosed in its DEF 14A proxy statements' Summary Compensation Table — salary, bonus, stock and option awards, non-equity incentive, other compensation, and the company-reported total per executive per fiscal year, newest year first. Figures are exactly as the company disclosed them; Total is the filer's own figure, never a recomputation. Coverage is limited to US DEF 14A filers (foreign private issuers file 20-F and are not covered) and is still back-filling: the output states the newest proxy on file next to the newest imported year, so stale coverage is visible.

Get fails-to-deliver (FTD) data for an exact listed stock or exchange-traded fund from the SEC's twice-monthly FTD files. Quantity is the aggregate net fail-to-deliver position OUTSTANDING on each settlement date — a balance, not that day's new fails, so never sum Quantity across dates. Price is the previous trading day's closing price (SEC file convention, not a settlement price) and Value = Quantity × Price. Within the covered window (the output names the earliest fully covered settlement date), dates absent from the table had no reported fails; earlier dates are only partially covered, so their absence is not evidence of no fails. The SEC publishes each half-month batch with roughly a two-week lag, so the newest rows trail today. High or persistent FTD balances may indicate naked short selling or settlement issues.

Get scheduled FDA advisory-committee (AdComm) meetings, sourced from the FDA.gov advisory-committee calendar, each with a link to its FDA meeting page. Defaults to meetings in the next 90 days; pass a date range to look further ahead. This is a forward-looking calendar of announced meetings, not a historical archive — coverage starts in late 2025 — and entries are the FDA's own listings, not linked to stock tickers.

Get a single financial concept (e.g. revenue, net income, diluted EPS, total assets, operating cash flow) over time for a company, sourced from SEC Company Facts (structured XBRL), or from the issuer's regulatory filings for a listing outside the US. Returns a time series using the latest restated value unless asOriginallyReported is set: one row per fiscal period for flows, one row per as-of date for balances and share counts. Each row carries its actual period start/end; fiscal years/quarters follow the company's own fiscal calendar. Warns when the selected alias ends materially before the company's other structured facts, which can indicate an XBRL tag change. Dimensioned disclosures such as customer concentration are outside this consolidated-series tool. For a full statement use GetFinancialStatement; to compare peers use CompareFinancialFact.

Get a company's income statement, balance sheet, or cash-flow statement for a given fiscal year and period, sourced from SEC Company Facts (structured XBRL), or from the issuer's regulatory filings for a listing outside the US. Returns the standard line items (e.g. revenue, net income, total assets, operating cash flow) with the latest-restated value for one exact statement period end. Quarterly flow rows are always discrete quarters: when the filer reports only cumulative year-to-date values in a currency, the quarter is derived by exact subtraction from the preceding cumulative period and marked Derived. Company-specific dimensional facts (e.g. product-segment revenue) are not included — use GetRevenueBreakdown for segment/geographic revenue, and GetFinancialFact or CompareFinancialFact for one line item across periods or across companies.

Get recent proposed insider sales for a stock from SEC Form 144 notices. Each Form 144 is an affiliate's declaration of intent to sell restricted or control securities, showing the seller, their relationship to the company, the number of shares and aggregate market value to be sold, the proposed sale as a share of the issuer's current shares outstanding, the approximate sale date, the broker, and the filer's remarks (including any stated 10b5-1 plan). Results are the most recent notices first and a note flags when more exist than were returned; use fromDate/toDate to scope a period (heavy 10b5-1 filers can flood the recency window with small daily notices). A proposal may never execute; a completed sale may later appear on Form 4 or 5 only when it is reportable there.

Get recent exempt securities offerings (private placements) for a company from SEC Form D notices. Each Form D reports a Regulation D offering, showing the issuer, the date of first sale, the total offering amount (a dollar figure or "Indefinite"), the amounts sold and remaining, the minimum investment, the number of investors, the claimed exemptions, whether the notice is an amendment (D/A), and its SEC accession number. Ongoing offerings are re-noticed through D/A amendments that RESTATE the same offering — group rows by first-sale date and offering amount and use only the latest notice of each chain, or capital raised will be counted several times over. Use this to track how a company is raising private capital alongside its public filings.

Get operational data for a registered investment company from its SEC Form N-CEN annual reports. Accepts an exchange-listed ticker or an exact fund identifier from SearchFunds, including a profile id, SEC series id, stored series ticker, or verified share-class alias. Each N-CEN shows the registrant's classification, Investment Company Act file number, reporting period, first/last-filing flags, latest service providers, and an exact filed-name provider history. N-CEN is filed at registrant level; this dataset currently ingests it through tracked issuer feeds, so a series inside an untracked multi-series trust can resolve correctly but still have no N-CEN report on record. Only registered funds file N-CEN; operating companies return no data.

Get a registered fund's profile and largest stored holdings from its latest SEC Form NPORT-P report. Accepts a profile ID, SEC series ID, stored ticker, or verified alias from SearchFunds. Returns registrant, series, assets, reported and stored holding counts, and the largest stored positions. Some multi-series trusts store only tracked-stock positions; reported counts and asset totals still describe the full filing. Use GetFundsHoldingStock for the inverse lookup.

Get the registered investment companies (mutual funds and ETFs) holding an exact stock or ETF listing, from SEC Form NPORT-P portfolio reports. The listed security's authoritative CUSIP (or, for a listing on another exchange written MIC:TICKER, its ISIN) is matched against the holding rows on each fund series' most recent report (series that stopped filing more than 18 months ago are excluded), so an exited position never shows as current. Returns the fund's registrant and series, the reporting period, the position size, its U.S.-dollar value, its share of the fund's net assets and the payoff profile (Long/Short), largest positions first. Report dates differ per fund series (each files on its own fiscal quarter), so values are as of each row's report date and cross-row totals mix as-of dates.

Get a company's going-concern doubt status: whether its latest examined SEC filing states substantial doubt about the company's ability to continue as a going concern, with the verbatim disclosure, the filing it came from, and the history of examined filings showing when doubt appeared, was alleviated, or cleared. Flags are extracted from each company's newest 10-K/10-Q narrative text and verified before publication; a filing without going-concern language counts as no doubt. Coverage starts when the extraction lane first examined the company — earlier filings are not analyzed, so absence from the history does not rule out prior doubt episodes.

Get federal government contract awards won by a specific public company: US federal awards (from USAspending.gov) or Government of Canada contracts (from its proactive publication of contracts over C$10,000). Shows the award (action) date, recipient named by the government, awarding agency or department, total value (US: obligated dollars plus unexercised ceiling; Canada: contract value including amendments, in Canadian dollars; never revenue received), outlays when reported, end date, and description. Coverage: US prime contract awards of $1M or more, and Canadian contracts reported from fiscal 2017-2018 (April 2017) whose vendor name exactly matches a company listed on a Canadian exchange, so sums understate government revenue. Use GetTopGovernmentContractors to rank companies market-wide.