EdgarStack

Summarize SEC-reported operating cash flow, capital expenditures, dividends, common-share repurchases, and shares outstanding by annual or TTM period. Calculates free cash flow, cash returns as a share of positive free cash flow when source inputs are complete, and date-aligned share-count changes. Missing values remain unavailable; outputs describe reported flows and do not judge management decisions or provide financial advice.

Two screening views on a company's SEC XBRL numbers:

• view="indicators" (default): accruals, cash conversion, working-capital days trends, and revenue versus receivables growth, with the thresholds and methodology used.

• view="anomalies": flags the latest annual or reported-quarterly growth in up to 8 metrics (default revenue, operatingIncome, netIncome, operatingCashFlow, capex) when it falls outside the company's own history. A review signal requires at least four earlier comparable growth observations and a latest value beyond the historical 1.5× IQR fence by at least 10 percentage points; limit 6–10 observations per metric, default 8. Unavailable values are null. Results are indicators and prompts to review the source filings, not findings or verdicts; they can be affected by industry, seasonality, acquisitions, factoring, and reporting changes. Not financial advice.

Check how far the SEC numbers for a company can be trusted and traced. Two checks:

• check="coverage" (default): SEC XBRL coverage, stale line-item flags, filing accession provenance, and period-end alignment for up to 12 metrics (default revenue, netIncome, totalAssets, totalLiabilities, operatingCashFlow, capex). Annual, quarterly or TTM; limit 1–12, default 5.

• check="balance_sheet": compares total assets with total liabilities plus total equity for exact matching annual or quarterly period ends, returning the arithmetic residual, source tags, filing accessions and missing components. Annual or quarterly only; limit 1–12, default 8. Missing facts remain unavailable rather than zero. Findings describe coverage and traceability; a residual is a review signal, not proof of an accounting error. Not financial advice.

Generate a formula-driven five-year annual Excel workbook for a US-listed company: metric-specific SEC accession notes, Source Data, Standardized Data, editable assumptions, average-equity ROE, a historical working-capital view, a Segments tab (revenue and profit by business segment and revenue by region from the 10-K XBRL segment tables, with mix, growth, segment margins and a tie-out to reported revenue; omitted for companies that tag no segments), and Base/Upside/Downside forecasts with year-specific margin, tax, and share-count assumptions. When available, forecast working capital from DSO/DIO/DPO. The workbook includes a DCF with illustrative CAPM/WACC inputs, terminal-value sensitivity, a Dashboard, formula-driven Model Checks, and Audit Flags. Missing data displays as n/a; a generation-time formula scan is included. DCF assumptions are not market-verified. A Target Price tab blends the DCF with Bear/Base/Bull EV/EBIT multiples into a 12-month target, upside and rating; its WACC is a placeholder and its Base multiple a neutral default until the user sets them. Annual periods only (quarterly company facts have a structural Q4 gap). Ask whether the user wants the optional Valuation tab before setting includeValuation — it pulls a Tiingo price snapshot.

One call returns everything needed to write an analyst-style report from SEC filings: the relevant data sections, SEC filing citations for each section, writing rules and a report outline. You (the model) then write the report from the pack only. Report types:

• "earnings_recap" (~12k tokens): latest quarterly XBRL results, 8-K earnings release (Ex-99.1), TTM ratios, segments, guidance language, changed MD&A/Risk Factors passages, insider trades.

• "tenk_red_flags" (~18k tokens): earnings-quality indicators, growth anomalies, five-year ratios, off-balance-sheet items, risk-factor changes, revised XBRL facts, auditor-change/restatement 8-Ks, balance-sheet tie-out.

• "initiation" (~25k tokens): business description, five-year financials and ratios, segments, valuation, peers, capital allocation, guidance track record, risk changes, ownership, insiders. Packs stay under a hard token budget; lower-priority sections are trimmed first and listed in trimmedSections, and failed sections are listed in unavailableSections. If the user's request doesn't clearly map to one report type (e.g. "write me a report on X"), ask which of the three they want, with a one-line description of each, rather than guessing. For "initiation", if the user named no peers, ask for 2–5 comparable companies (suggest a few) before calling; peers are optional if they decline. Text sections cover US 10-K/10-Q filers. Not investment advice.

One call produces both deliverables of a sell-side initiation for a US-listed operating company:

1. The Excel model (same builder as build_financial_model) with a Target Price tab: EV/EBIT valuation with Bear/Base/Bull multiples, a blended DCF + multiple 12-month target, upside and rating, sensitivity, and the return profile. Returned as a download link.

2. A report pack for you to write a 3-page initiation note: key metrics table, valuation outputs read from the evaluated workbook, chart data (share price, stock vs sector ETF, margin trend), SEC filing evidence with citations (business, segments, guidance, risk-factor changes, ownership, insiders), the report outline, writing rules, consistency checks and caveats. Write the note strictly from the pack and give the user both the note and the model link. Quote the model's numbers exactly; address every caveat (the generated DCF uses placeholder WACC inputs, and the Base multiple is a neutral default unless the user gives one). Before calling, if the user hasn't said, ask for 2-5 peers and whether they want a DCF weight other than 30%; proceed with defaults if they decline. Not for banks or insurers (use build_report_pack). Not investment advice.

One-call company overview. Two views:

• view="snapshot" (default): latest TTM SEC financials, ratios, earnings-quality indicators, valuation, recent 10-K/10-Q filings, and insider transactions. Valuation uses a Tiingo IEX or end-of-day price and can be unavailable without quote configuration. Each section reports availability independently.

• view="results_review": a structured, unpublished review packet on the latest 10-Q or 10-K results — SEC XBRL results, comparable history, 1–5 peers you name in peerTickers (period-aligned), and changed MD&A/Risk Factors passages. If the user asks for a results review without naming peers, ask which companies to compare against rather than guessing. Missing or stale values are called out and never treated as zero; source filing identifiers are included. Research summary, not financial advice.

Compute margins, liquidity, leverage, return, and working-capital ratios for a US-listed company. SEC SIC-classified banks also receive income-mix and equity/assets ratios; regulated utilities receive capex/revenue and operating-cash-flow/capex ratios. Specialized panels include their SEC tags, source periods, methodology and coverage limits; missing source values remain null.

Compare what changed between a company's 10-K or 10-Q filings. All views return source-linked added, removed and modified passages with SEC filing dates and accession numbers. Four views:

• view="sentences" (default): full sentence-level diff of ONE Item (itemNumber, e.g. '1A' Risk Factors, '7' MD&A for a 10-K, '2' MD&A for a 10-Q) between two filings — the latest two unless you pass oldAccessionNumber/newAccessionNumber. Covers every sentence. Only pass oldText/newText for text from elsewhere.

• view="brief": a prioritized brief across up to 4 sections (itemNumbers; defaults to 1A and 7 for 10-K, or 1A and 2 for 10-Q) of the latest two filings, ordered by a deterministic keyword and change-type heuristic; maxChanges 1–30, default 12. Reports extraction failures per section.

• view="risk_topics": Item 1A changes grouped by a fixed risk keyword taxonomy (passages can sit in several categories or stay unclassified).

• view="mda_topics": MD&A changes grouped by fixed topics — revenue/demand, margins, liquidity, capital, accounting estimates, trends; unclassified passages stay visible. Ordering and categories are search aids; they do not establish materiality or causality. Not financial or legal advice.

Search SEC filing text across all filers or restrict to one or more CIKs. This uses the SEC's keyword/Boolean search: unquoted words are ANDed; double quotes request an exact phrase (for example, "tariff exposure"). This is keyword search, not natural-language search. Specify dateFrom and dateTo together, and specify forms when you only want certain filing types. Results are deduplicated to one matched document per filing, include a short excerpt from that SEC document when available, enforce the requested CIK/date/exact-form filters, and return SEC's relevance score separately from the excerpt. The total may be approximate above 10,000 document hits. Use offset with nextOffset to continue; SEC pagination ends at 10,000.

Fetch a 10-K or 10-Q and extract one Item section's text (e.g. itemNumber '1A' for Risk Factors, '7' for MD&A in a 10-K, '2' for MD&A in a 10-Q). Use list_recent_filings first to get the accessionNumber and primaryDocument. If what the user asked for doesn't map cleanly to one Item — e.g. "the financial section" could mean Item 7 (Management's Discussion and Analysis of Financial Condition and Results of Operations, i.e. MD&A — management's narrative) or Item 8 (Financial Statements and Supplementary Data, i.e. the actual audited statements) in a 10-K — ask which they mean, naming both Item numbers AND their official headings, instead of picking one silently; pulling the wrong section wastes the call and can read as if it answered the question when it didn't. The extractor anchors on line-level Item headings and returns a qualityWarning for unusually short sections; it is still heuristic, so check the linked SEC filing when the passage matters.

Pull standardized financial line items for a US-listed company from SEC XBRL filings. Available metrics: revenue, grossProfit, operatingIncome, netIncome, epsBasic, epsDiluted, totalAssets, currentAssets, totalLiabilities, currentLiabilities, longTermDebt, totalEquity, cashAndEquivalents, operatingCashFlow, capex, rdExpense, sharesOutstanding, dividendsPerShare, dividendsPaid, stockBasedCompensation, deferredRevenue, goodwill, intangibleAssets, depreciationAmortization, costOfGoodsSold, sellingGeneralAndAdministrative, interestExpense, otherNonoperatingIncomeExpense, pretaxIncome, incomeTaxExpense, liabilitiesAndEquity, assetImpairment, shortTermInvestments, weightedAverageDilutedShares, shareRepurchases, accountsReceivable, inventory, accountsPayable, propertyPlantEquipment, investingCashFlow, financingCashFlow, grossInterestIncome, netInterestIncome, noninterestIncome. Three views:

• view="values" (default): values per period with the XBRL tag used and source filing accession numbers. period="ttm" returns latest FY + current YTD - prior-year comparable YTD for flows (or FY when the latest fact is year-end), and latest instant values for balance-sheet metrics. fiscalYear is derived from the fact's periodEnd; sourceFilingFiscalYear preserves SEC filing metadata. limit 1–40, default 8.

• view="trends": changes, guarded growth rates and filing provenance for up to 8 metrics (default revenue, operatingIncome, netIncome, operatingCashFlow, capex). Quarterly mode compares adjacent reported quarters and matches year-over-year quarters by actual period end; missing periods are not imputed. Annual mode also returns endpoint CAGR. Annual or quarterly only; limit 2–10, default 8. Historical analysis, not a forecast.

• view="revisions": values the company later reported differently for the same XBRL tag and exact period, with both filing dates and accession numbers (up to 6 metrics; defaults to revenue, net income, assets, operating cash flow). Annual or quarterly only; limit 1–50 changed facts per metric, default 20. A difference can reflect an amendment, reclassification, or updated comparative and does not alone establish a formal restatement. Not financial advice.

Recent insider transactions — officers, directors, and >10% owners buying or selling their own company's stock, reported to the SEC within 2 business days of the trade. Covers Forms 3, 4, and 5. Decodes each transaction's SEC code (P=open market purchase, S=open market sale, M=option/RSU exercise, F=tax withholding, A=grant/award, etc.) and includes a buy/sell summary. Scoped to Forms 3/4/5 only — for institutional 13F holdings use institutional_ownership; >5% beneficial ownership (13D/13G) is not covered.

End-of-day stock price history for a US ticker from Tiingo (market data — SEC filings never include prices). Returns the series (open, high, low, close, split- and dividend-adjusted close, volume), dividends and splits in the range, and summary statistics on the adjusted close: total and annualized return, annualized volatility, maximum drawdown with its dates, and the range high and low. frequency: daily, weekly, monthly (default daily). Dates are YYYY-MM-DD; the default range is the last 12 months. Long daily ranges list only the latest 400 points (statistics still cover the full range) — use weekly or monthly for long periods. Not financial advice.

Segment breakdown of a US company's revenue, costs, operating income, assets and other metrics, read from the XBRL of one filing (the latest 10-K by default, or a 10-Q). get_financials only returns company-wide totals; use this tool for figures by business segment, by geography (e.g. United States vs other countries) or by product/service line. Returns, per breakdown: the members (segments, regions or product lines) with the filer's own labels, and per metric the values for each member over the filing's periods (3 fiscal years from a 10-K by default, up to 5 with years=5; quarter and year-to-date in a 10-Q), reconciling items such as corporate and eliminations where tagged, the consolidated total, and a check per period: members_sum_to_total, sums_with_reconciling_items, partial_or_overlapping (members don't add up, e.g. product groupings that overlap) or no_consolidated_figure. Metrics are ordered revenue, costs, operating income, D&A, capex, assets, then others; moreMetrics lists any left out. breakdowns: business, geography, product (default all three). Each value is as reported in that filing (later filings may recast segments). Every result cites the filing and its XBRL instance. Single-segment companies often tag no segments; then read the segment note with get_filing_section (10-K Item 8). Not financial advice.

Combine a live market price (a free, delayed/end-of-day quote — SEC filings never include price) with SEC fundamentals to compute P/E (basic and diluted), P/S, P/B, EV/Revenue, and EV/EBITDA, plus market cap and enterprise value. Flow metrics use TTM when available, otherwise the latest FY; the result states fundamentalsBasis.

Institutional holdings reported on SEC Form 13F, in two directions:

• view="holders" (default): which investment managers hold a stock — reporting-manager count, total reported shares and value, and the top holders with quarter-over-quarter share changes, from SEC's latest quarterly Form 13F data set. Pass ticker (matched to a CUSIP through the issuer name; the match and other share classes are returned for checking) or a 9-character cusip. limit 1–50 holders, default 20.

• view="portfolio": what one manager holds — its latest 13F-HR read live from EDGAR, positions by value with portfolio weights, and new, exited, increased and decreased positions versus its prior quarter. Pass managerCik, or managerName (searched among 13F filers; if several match, the result lists them — ask the user which one before calling again). limit 1–50 positions, default 25. 13F covers long positions in Section 13(f) securities only (no shorts or cash), is filed up to 45 days after quarter end, and can omit confidential positions. Option and bond rows are excluded from share totals. Values are US dollars as filed. If the user asks "who owns X" vs "what does fund Y own", pick the view accordingly; if unclear, ask. Not financial advice.

List the N most recent filings of a given form type (e.g. 10-K, 10-Q, 8-K) for a US-listed company, with accession numbers needed for get_filing_section.

Resolve a US ticker symbol to its SEC CIK number and registered company name. Use this first if you don't already have a CIK.

Two modes on management guidance disclosed in SEC filing MD&A:

• mode="candidates" (default): scans the latest 10-K or 10-Q MD&A (Item 7 or Item 2) for sentences that may contain guidance. Returns verbatim, source-linked candidates labeled by fixed cue words and whether they contain numeric-looking values. Candidates are not confirmed guidance and may include false positives. limit 1–30 excerpts, default 20.

• mode="vs_actuals": finds explicit annual revenue ranges or targets in recent 10-K MD&A and compares them with later SEC-reported annual revenue for the named fiscal year. Only dollar-denominated sentences with an explicit year are used; ambiguous, quarterly and non-revenue guidance is excluded, and an unavailable match is not treated as zero. filingsToInspect 1–10, default 8. Most companies give guidance in earnings releases and calls rather than 10-K/10-Q text, so empty results are common. Not financial advice.

List, add or remove companies on the customer's filing watchlist (up to 10), or check it now. EdgarStack checks every weekday morning and emails a digest when a watched company files a new 10-K, 10-Q or 8-K: a link to each filing, what an 8-K is about, and for 10-K/10-Q which sentences changed in Risk Factors / MD&A versus the previous filing. "check" runs that check immediately and emails the digest if anything is new. Adding a company starts tracking from its current filings, so the first alert comes with its next filing.

Map a US company's off-balance-sheet commitments and exposures from its latest 10-K across 18 categories (purchase obligations, uncommenced leases, supplier finance, receivables sold, VIEs, equity-method investees, guarantees, letters of credit, loss contingencies, contingent consideration, multiemployer plans, unfunded commitments, dilution, credit facilities, environmental/ARO, remaining performance obligations). Returns: the latest 10-K; xbrl facts tagged in THAT filing only (each with magnitude: maximum / recorded / low / reference, plus prior year and change), with tags the issuer stopped using listed under historicalOnly (not current figures); the 10-K's notes and MD&A liquidity section, each scored by trigger phrases; short verbatim excerpts; and a coverage line per category (tagged / text_found / not_found — not_found is not evidence of none). Most items are disclosed only in note text, so after the default call, call again with sectionId for every section marked alwaysRead and for the top-ranked section (coverage[].topSections[0]) of each category the user cares about, and read that text before stating any amount that is not in xbrl. Long sections come in pages: pass offset = nextOffset to continue. 10-K filers only (no 20-F/40-F). No present-value or adjusted-debt calculations.

Compare one to six SEC XBRL metrics for 2–15 US companies. Periods are aligned by actual end date (within 183 days for annual or 45 days for quarterly) to handle different fiscal calendars; the reference date and each row's actual period end are returned. Rankings are descending, skip missing values, and use competition ranks for ties. Available metrics: revenue, grossProfit, operatingIncome, netIncome, epsBasic, epsDiluted, totalAssets, currentAssets, totalLiabilities, currentLiabilities, longTermDebt, totalEquity, cashAndEquivalents, operatingCashFlow, capex, rdExpense, sharesOutstanding, dividendsPerShare, dividendsPaid, stockBasedCompensation, deferredRevenue, goodwill, intangibleAssets, depreciationAmortization, costOfGoodsSold, sellingGeneralAndAdministrative, interestExpense, otherNonoperatingIncomeExpense, pretaxIncome, incomeTaxExpense, liabilitiesAndEquity, assetImpairment, shortTermInvestments, weightedAverageDilutedShares, shareRepurchases, accountsReceivable, inventory, accountsPayable, propertyPlantEquipment, investingCashFlow, financingCashFlow, grossInterestIncome, netInterestIncome, noninterestIncome. There's no default metric — if the user's request doesn't name one (e.g. "compare Apple and Microsoft" with no metric specified), ask which they want before calling rather than guessing.

Find and rank companies across all SEC filers for a calendar-year (optionally quarterly) frame, using SEC's XBRL Frames API. Screen by EITHER:

• metric: one reported value (revenue, grossProfit, operatingIncome, netIncome, epsBasic, epsDiluted, totalAssets, currentAssets, totalLiabilities, currentLiabilities, longTermDebt, totalEquity, cashAndEquivalents, operatingCashFlow, capex, rdExpense); or

• a ratio: a named preset (grossMargin, operatingMargin, netMargin, rdIntensity, capexIntensity, fcfMargin, currentRatio, debtToEquity, returnOnAssets, returnOnEquity, cashToAssets, assetTurnover) or a custom numerator/denominator from the same metric list. Ratio inputs are joined only when all source metrics share the same periodEnd, denominators must be positive, and unusually large ratios carry a dataQualityFlags warning. Revenue uses the preferred tag and two known US-GAAP synonyms; the response lists tags queried and each result reports the tag selected. SEC calendar-year frames can contain an issuer's closest fiscal period rather than one ending December 31, so compare periodEnd (and sourceAccessionNumbers) across results. Ask for a min/max threshold when one is needed rather than guessing.