Adviser RAUM Decliners (forced-seller / Redemption Watchlist — discretionary-RAUM drops + basis-change guard)
adv_raum_declinersForced-seller / Redemption Watchlist tool. Returns advisers whose discretionary RAUM fell between their two most recent ADV filings, ranked by percent decline. Pair with thirteenf_portfolio_full(cik=...) to surface specific equities under redemption-driven selling pressure ('which stocks face forced selling this quarter').
Backed by a pre-computed table (proc2.adv.firm_raum_decliners, 3,423 rows / 816 with cik). Daily blue/green refresh. Sub-2ms warm.
Two correctness-critical design choices baked in upstream by adv — surface these in any prompt that consumes the output:
Decline is computed on DISCRETIONARY RAUM, not total. The Sageview case is the canonical false-positive class: −84% on total RAUM ($238.6B → $37.5B) but +0.5% on discretionary — the entire $201B drop was a nondiscretionary reclassification, NOT a redemption. Sageview never enters the table because the filter is discretionary-only. Don't second-guess the table by re-computing off total.
basis_change_suspect=trueflags the residual cases where discretionary DID fall but the discretionary/total mix also shifted >20pts. These are likely reporting-basis reclassifications, NOT redemptions (K1 Investment Mgmt, GraniteShares ETF reclass are typical examples). The tool default excludes these (include_basis_changes=false). Setinclude_basis_changes=trueonly if you're auditing the data; never include them in 'who's facing forced selling' answers.
Killer acceptance case (per spec): Politan Capital Management (crd 316047, cik 1885245) → drop_pct=46.04, basis_change_suspect=false. The Masimo (MASI) campaign — clean redemption signal. Chain into thirteenf_portfolio_full(cik=1885245) for the at-risk equity book.
No as_of param — by design (adv team's position 2026-06-12, futures agreed): the table always compares each adviser's two MOST RECENT filings to detect discretionary-RAUM declines. Adding as_of would conflict with that purpose. For replay backtests at a past date, reconstruct equivalent decline signals from adv_manager_raum_trend(crd, limit=8) — the trend tool's rows carry their own as_of (Pattern B PIT, ~300K rows across all filings), so a client-side cutoff to as_of + take the two most recent ≤ as_of + compute (1 - latest_disc/prior_disc) reproduces the decliner detection PIT-correctly.
Filters (all index/scan-fast):
min_drop_pct(default 30) — minimum % discretionary declinemin_prior_raum_disc(default 1e9) — prior-filing discretionary RAUM in USD; use to anchor on size (1e9 = $1B+ advisers, which is the futures team's default for the Redemption Watchlist)min_latest_asof— only include advisers whose latest filing is on/after this date (YYYY-MM-DD); use to scope to a recent vintagewith_cik_only(default true) — restrict to advisers with a resolved SEC CIK (the 13F-joinable subset; the whole point is chaining intothirteenf_*). Coverage gap: only a minority of >$1B-prior-disc decliners resolve to a cik today — adv's CRD↔CIK bridge backfill is in flight; universe widens over time.include_basis_changes(default false) — set true to opt back in (audit only)sort∈ {drop_pct_desc(default),prior_raum_disc_desc,latest_asof_desc}limit(default 50, max 200)
Spec-validated counts (for sanity): no filters → 3,423; with_cik_only=true → 816; min_drop_pct=30 + min_prior_raum_disc=1e9 + with_cik_only=true + NOT basis_change_suspect (the worked default) → 60 advisers.
Each row carries prior_source_filing_id / latest_source_filing_id (the two Form ADV filings the prior / latest RAUM come from).
Every adviser crd in the output has the adviser's SEC cik beside it (#2287; x_crd -> x_cik, a CRD list -> ..._crd_ciks): the CIK of the 13F filer that reports under that CRD, else the CIK on its own Form ADV; ciks lists both when they differ; null when neither exists. A row that already had its own cik keeps it.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "adv_raum_decliners"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | Sort order. drop_pct_desc (default) = biggest decline first. | drop_pct_desc |
| limit | No | Max rows (default 50, max 200). | |
| min_drop_pct | No | Minimum discretionary-RAUM % decline (0-100). Default 30 (the futures team's Redemption Watchlist baseline). | |
| with_cik_only | No | If true (default), restrict to advisers with resolved SEC CIK (the 13F-joinable subset). Set false only when you want the full discretionary-decliner universe regardless of 13F-chainability. | |
| min_latest_asof | No | Only include advisers with `latest_asof >= this YYYY-MM-DD`. Use to scope to recent vintages. | |
| min_prior_raum_disc | No | Minimum PRIOR-filing discretionary RAUM in USD. Default 1e9 ($1B+) — typical forced-seller universe. | |
| include_basis_changes | No | Default false — exclude rows where `basis_change_suspect=true` OR NULL (basis-change-unknown). Set true ONLY when auditing data quality; NEVER include these in 'who's facing forced selling' answers — they're reporting-basis reclassifications, not redemptions. |