Skip to main content
Glama
Panda Public Funding Tools

Panda Public Funding Tools

SEC Financials to Excel: EDGAR XBRL Comps & Model Data

sec_financials_excel
Read-only

Retrieve standardized annual financials for US-listed companies from SEC EDGAR 10-K XBRL data, including income statement, balance sheet, cash flow, and derived metrics for comps, multi-year models.

Instructions

Return standardized annual financials for US-listed companies from SEC EDGAR XBRL 10-K data: income statement, balance sheet and cash-flow lines plus EBITDA, free cash flow, net debt, margins and growth, one row per company-year, each number tagged to its source filing. Unlike pdf_table_extractor (any PDF table, best-effort), this reads structured filings and is exact; unlike federal_contract_finder it covers public-company fundamentals, not government spend. Use when you need comps, model inputs or multi-year history for tickers or CIKs. Do not use for private companies, foreign filers without 10-Ks, quarterly data or share prices (not included). Parameters: contactEmail is required by SEC's fair-access rule and is sent only to SEC. Billing is per company-year, so worst case = companies x years; run_max_items does not set years, so cap cost with years and run_max_charge_usd. Unknown tickers are returned free with a status. Returns per item: agentSummary, company, ticker, cik, fiscalYear, periodEnd, form, filed, revenue, grossProfit, operatingIncome, netIncome, epsDiluted, operatingCashFlow, capex, freeCashFlow, ebitda, cash, totalDebt, netDebt, stockholdersEquity, margins, revenueGrowth, epsGrowth, sourceTags. The comps workbook stays in the run's Apify key-value store.

Behavior: read-only; runs the Apify Actor pandadad0214/sec-financials-excel (https://apify.com/pandadad0214/sec-financials-excel) on your own Apify account. Price: $0.002 per company-year of financials. Runs that find nothing are not charged per result, and spending is capped per call by run_max_charge_usd (default $0.50). run_max_items (default 50) limits items returned but does not limit what the Actor bills; use the tool's own limits and run_max_charge_usd. Most calls finish in 5-15 s for a few inputs; large inputs or crawls can take minutes, so raise run_timeout_secs (max 300) or shrink the input after a timeout error. Returns JSON {actor, count, items}; long text output is trimmed to whole items, with all items in structuredContent.

Input Schema

NameRequiredDescriptionDefault
yearsNoFiscal years per company. Most recent annual (10-K) periods to return. You pay per company-year row, so this also caps the cost.
companiesYesCompanies (tickers or CIKs). US-listed companies that file 10-Ks with the SEC, e.g. AAPL, MSFT, BRK-B or a CIK like 320193. Up to 200 per run.
contactEmailYesYour contact email (required by SEC). SEC requires every automated request to declare a contact in its User-Agent header. It is sent to SEC only and is never stored in the output.
run_max_itemsNoOptional. Most results to return from this call (default from PANDA_MAX_ITEMS, 50). Also limits how many results the Actor produces and charges for, unless you set its own max field.
run_timeout_secsNoOptional. Seconds to wait for results (default from PANDA_TIMEOUT_SECS, 120; max 300).
run_max_charge_usdNoOptional. Hard spending cap for this call in USD (default from PANDA_MAX_CHARGE_USD, 0.50).

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.0

TDQS

A4.8/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnlyHint=true, openWorldHint=true and destructiveHint=false, and the description stays consistent while adding substantial context the annotations cannot carry: SEC fair-access contact requirement, $0.002 per company-year billing, that run_max_items does not limit the Actor's billing while run_max_charge_usd does, default $0.50 cap, 5-15 s typical latency with run_timeout_secs up to 300, and that unknown tickers come back free with a status. Non-idempotency is implicitly covered by per-call billing and the explicit warning about repeated cost exposure.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Front-loaded with purpose, then routing, then parameter cost guidance, then runtime behavior — a sensible order. It is long and dense, and the exhaustive return-field list in the middle sentence competes with the usage guidance for attention, but since no output schema exists the field inventory earns its place.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Covers everything an agent needs for a 6-parameter, billed, long-running remote Actor call: cost model and caps, timeout guidance and remediation, required SEC contact email, per-item return fields in the absence of an output schema, and where the workbook artifact lands. Nothing material is left to inference.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so baseline is 3, but the description adds real interpretation: it explains the years/company-year cost coupling and warns that run_max_items does not set years, so cost must be capped with years plus run_max_charge_usd — a cross-parameter interaction the schema only hints at. It slightly restates schema content (contactEmail's SEC purpose), which keeps this from a 5.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb and resource — 'Return standardized annual financials for US-listed companies from SEC EDGAR XBRL 10-K data' — and enumerates the content (income statement, balance sheet, cash-flow lines plus EBITDA, FCF, net debt, margins, growth) at one row per company-year. It explicitly contrasts itself with pdf_table_extractor (best-effort PDF tables vs. exact structured filings) and federal_contract_finder (fundamentals vs. government spend), so an agent can separate it from siblings without opening a schema.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Gives an affirmative trigger ('Use when you need comps, model inputs or multi-year history for tickers or CIKs') and explicit exclusions ('Do not use for private companies, foreign filers without 10-Ks, quarterly data or share prices'). It also names the two alternatives it supersedes, which is the full when/when-not/alternative triad.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.