pp-sec-edgar

What this skill does

<!-- GENERATED FILE — DO NOT EDIT.
     This file is a verbatim mirror of library/developer-tools/sec-edgar/SKILL.md,
     regenerated post-merge by tools/generate-skills/. Hand-edits here are
     silently overwritten on the next regen. Edit the library/ source instead.
     See the repository agent guide, section "Generated artifacts: registry.json, cli-skills/". -->

# SEC EDGAR — Printing Press CLI

## Prerequisites: Install the CLI

This skill drives the `sec-edgar-pp-cli` binary. **You must verify the CLI is installed before invoking any command from this skill.** If it is missing, install it first:

1. Install via the Printing Press installer. It defaults binaries to `$HOME/.local/bin` on macOS/Linux and `%LOCALAPPDATA%\Programs\PrintingPress\bin` on Windows:
   ```bash
   npx -y @mvanhorn/printing-press-library install sec-edgar --cli-only
   ```
2. Verify: `sec-edgar-pp-cli --version`
3. Ensure the reported install directory is on `$PATH` for the agent/runtime that will invoke this skill.

If the `npx` install fails (no Node, offline, etc.), fall back to a direct Go install (requires Go 1.26.3 or newer):

```bash
go install github.com/mvanhorn/printing-press-library/library/developer-tools/sec-edgar/cmd/sec-edgar-pp-cli@latest
```

If `--version` reports "command not found" after install, the runtime cannot see the binary directory on `$PATH`. Do not proceed with skill commands until verification succeeds.

## When to Use This CLI

Pick this CLI when an agent needs to query SEC filings, XBRL financial facts, insider trading (Form 4), or institutional holdings (13F) across many companies or many periods — anything that benefits from a local SQLite store rather than a per-call API roundtrip. For one-off single-filing reads, the typed endpoint mirrors (filings get, facts get) work without sync. For cross-company pivots, insider clustering, peer-group benchmarks, or live filing watches, the transcendence commands turn what would be ten API calls + a Python loop into one CLI invocation.

## When Not to Use This CLI

Do not activate this CLI for requests that require creating, updating, deleting, publishing, commenting, upvoting, inviting, ordering, sending messages, booking, purchasing, or changing remote state. This printed CLI exposes read-only commands for inspection, export, sync, and analysis.

## Unique Capabilities

These capabilities aren't available in any other tool for this API.

### Local state that compounds
- **`watchlist items`** — Across a saved watchlist of CIKs, surface 8-Ks filed in the window grouped by Item code (2.05 restructuring, 5.02 exec change, 4.02 non-reliance).

  _Equity analysts triage filings by Item code, not by company. Pick this when an agent needs cross-company 8-K filtering by Item._

  ```bash
  sec-edgar-pp-cli watchlist items --since 30d --item 2.05,5.02,4.02 --cik 0000320193,0000789019,0001652044 --json
  ```
- **`insider-cluster`** — Flag issuers where 3+ distinct insiders filed Form 4 with the same transaction code (open-market buy or sale) within a rolling N-day window.

  _Clustered insider selling is a textbook forensic signal. Pick this when an agent needs derived signals over raw Form 4 data._

  ```bash
  sec-edgar-pp-cli insider-cluster --within 5d --min-insiders 3 --code S --since 90d --json
  ```
- **`industry-bench`** — Take an XBRL concept for one reporting period, group by SIC code, and emit percentile statistics (p10/p50/p90) across every public-company filer in that SIC.

  _Quant researchers and equity analysts need peer-group benchmarks. Pick this when an agent should answer 'how does X compare to its industry peers'._

  ```bash
  sec-edgar-pp-cli industry-bench --tag us-gaap:Revenues --period CY2024Q4 --sic 7372 --stat p50,p90 --json
  ```
- **`cross-section`** — Pivot a single XBRL concept across an explicit company list and the last N reporting periods. Output as a wide pivot table (one row per company, one column per period).

  _Comp-set analysis is one of the highest-frequency analyst rituals. Pick this when an agent compares fundamentals across an explicit ticker list._

  ```bash
  sec-edgar-pp-cli cross-section --tag us-gaap:Revenues --ticker AAPL,MSFT,GOOGL --periods last8 --json
  ```
- **`holdings delta`** — Diff an institutional investor's 13F holdings across two consecutive quarters. Categorize each issuer as ADD / EXIT / INCREASE / DECREASE with share-count delta.

  _Tracking institutional money flow is a classic factor signal. Pick this when an agent compares a fund's positioning across quarters._

  ```bash
  sec-edgar-pp-cli holdings delta --filer-cik 0001067983 --period 2024Q4 --vs 2024Q3 --json
  ```

### Agent-native plumbing
- **`watch`** — Stream the SEC Atom getcurrent feed with multi-dimensional filtering: form type, 8-K item, CIK watchlist, and keyword regex. Emits one NDJSON line per match.

  _Agents that monitor for specific filing events should subscribe to this stream rather than polling submissions per CIK._

  ```bash
  sec-edgar-pp-cli watch --form 8-K --item 2.05 --cik 0000320193,0000789019 --keyword 'going concern' --one-shot --json
  ```

### SEC-specific signals
- **`restatements`** — Surface 8-K Item 4.02 (non-reliance on prior financials) plus all 10-K/A and 10-Q/A amendments filed in the window — the textbook accounting-irregularity signal.

  _Forensic accounting agents look for restatements as a leading indicator of trouble. Pick this when an agent needs accounting-quality signals._

  ```bash
  sec-edgar-pp-cli restatements --since 90d --json
  ```
- **`late-filers`** — Find issuers that filed an NT 10-K, NT 10-Q, or NT 20-F in the window — the SEC's 'I'm going to miss my reporting deadline' notification.

  _Late filings are leading indicators of operational or accounting trouble. Pick this when an agent needs to flag at-risk companies._

  ```bash
  sec-edgar-pp-cli late-filers --since 90d --form 10-K --json
  ```

## Command Reference

**companies** — Company directory (ticker → CIK → name)

- `sec-edgar-pp-cli companies tickers` — Full ticker-to-CIK map for every public-equity issuer with a listed ticker (~10k entries)
- `sec-edgar-pp-cli companies tickers_exchange` — Ticker-to-CIK map keyed by exchange (Nasdaq, NYSE, etc.)
- `sec-edgar-pp-cli companies tickers_mf` — Mutual fund ticker-to-CIK map (one row per share class)

**facts** — XBRL financial facts (data.sec.gov)

- `sec-edgar-pp-cli facts company` — Get all XBRL facts for a company across every reporting period
- `sec-edgar-pp-cli facts frame` — Get one XBRL concept value reported by every public filer for one period (cross-company slice)
- `sec-edgar-pp-cli facts get` — Get a single XBRL concept time series for one company (one tag across all of its filings)

**submissions** — Filer (company) filing history

- `sec-edgar-pp-cli submissions <cik>` — Get full submissions history for a filer by 10-digit zero-padded CIK


### Finding the right command

When you know what you want to do but not which command does it, ask the CLI directly:

```bash
sec-edgar-pp-cli which "<capability in your own words>"
```

`which` resolves a natural-language capability query to the best matching command from this CLI's curated feature index. Exit code `0` means at least one match; exit code `2` means no confident match — fall back to `--help` or use a narrower query.

## Recipes


### Apple income-statement trend, agent-friendly

```bash
sec-edgar-pp-cli facts statement --cik 0000320193 --kind income --periods last8 --agent --select 'facts.us-gaap.Revenues,facts.us-gaap.OperatingIncomeLoss,facts.us-gaap.NetIncomeLoss'
```

XBRL responses are deeply nested; --select with dotted paths picks only the three concepts the agent needs across the last 8 periods.

### Cluster-buying watchlist scan

```bash
sec-edgar-pp-cli insider-cluster --within 14d --min-insiders 3 --code P --since 90d --json
```

Open-market insider buying (Form 4 code P) clustered across 3+ insiders in 14 days, last 90 days. The store-