Corp Refi Screen (issuers ranked by debt maturing in year)
tranche_refi_screenCross-sectional refi-pressure screener: corporate issuers ranked by fund-held debt value maturing in a target year, as-of a date. Returns issuer ticker/cik + fund_held_value + weighted_coupon + bond_count, descending. The 'who has the biggest 2027 wall' question. Source: N-PORT-P fund holdings panel.
IMPORTANT: This is the FUND slice of total maturing debt — N-PORT-P covers ~$3T of ~$11T US corp bonds. Honest as a RANK (within-panel ordering is load-bearing); do NOT present absolute $ as 'total debt maturing.' Corporate-only (issuer_cat='CORP'). Historical depth: 2019-09-30 to current — pin as_of to any quarter-end for backtests.
Console Credit Monitor rules: defaults to the newest SETTLED month (the newest month is still filling in); weighted_coupon above 20% is blanked (structured notes). Each issuer carries listed_parent {ticker, cik, name, via} — the listed company behind a financing sub, resolved via bond CIK, MARS company CIK, Ex-21 parent, then normalised name.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"maturity_year": "<maturity_year>"
},
"name": "tranche_refi_screen"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| as_of | No | Report date YYYY-MM-DD (default: the newest settled month). | |
| top_n | No | Max issuers to return (default 25, max 200). | |
| maturity_year | Yes | Year bonds mature in (e.g. 2027). |