cmbs.news: CMBS loan data

Returns the coverage and currency of the data: trust and loan counts, as-of and filing dates, the headline index, plan limits, licence and links to the docs, OpenAPI and changelog. Use it to answer how current or complete the data is, or what limits apply.

Returns single-property CMBS loans as operating comparables: revenue, operating expenses, NOI (each per square foot), expense ratio, occupancy, DSCR and valuations, filtered by property type, metro, state, size and year built, with medians over every match. Use it for market operating benchmarks; use search_loans for loan status and terms.

Returns the cmbs.news distress index: delinquency, special-servicing and matured-unpaid rates (balance-weighted, every public trust), this month's transfers in and out of special servicing, and rates by property type. Set view for one part, or for more: vintage, state, series (every month since December 2016) or seasoning. Open data under CC BY 4.0. Use it for market-wide rates and trends; use wire for the individual loans that changed this month.

Returns one certificate class by its 9-character CUSIP: its trust, coupon, original and current balance, principal paid, realized losses and credit support from the latest trustee report. Use it when the user gives a CUSIP; use get_trust to see all of a trust's classes. An unknown CUSIP returns an error.

Returns one loan's record by its slug: terms, status, coverage, occupancy, the three largest tenants, watch flags, every trust holding a piece, and the special servicer's comment facts, appraisal reduction and advances. The special servicer is named only when one trust holds the whole loan and its report names one. Get the slug from search_loans; use get_trust for the deal. Fields not included in the current plan are named in proFields.

Returns one loan's monthly reports back to its first filing (late 2016 at the earliest): balance, payment status, special servicing, workout strategy, modification, coverage and occupancy. Use it to see how a loan reached its current state. Without a paid cmbs.news plan it returns a plan notice; the loan page on cmbs.news shows the last six months.

Returns the guarantors, named parties and contacts that SEC filings give for one loan (prospectus Annex A-1 and the trust's 10-D), each with a link to its filing. Use it after get_loan when asked who stands behind a loan. Without a paid cmbs.news plan it returns only how many are on file.

Returns what each trust's monthly trustee report (Form 10-D) said about one loan, month by month, for about the last year: the special servicer's comment facts with a short excerpt, resolution strategy, transfer and return dates, foreclosure, bankruptcy and REO dates, appraisal values and reductions, advances and modifications, and what changed from the previous report. Use it after get_loan to see what happened to a loan and what changed this month. Without a paid cmbs.news plan it returns a plan notice.

Returns one CMBS trust (deal) by slug or name fragment: balance and distress, parties (master and special servicer, directing certificateholder, operating advisor, trustee), every certificate class with CUSIP, coupon, balance, losses and credit support, and liquidated loans with loss severity. Use list_trusts to find a trust by name; use search_loans with trust set to a slug for the trust's loans.

Lists public CMBS trusts, most distressed first (share of balance delinquent or with the special servicer), optionally filtered by a name fragment such as Benchmark or 2021. Use it to find a trust's slug or to see which deals are most distressed; use get_trust for one deal. No match returns an empty list.

Returns loans in public CMBS trusts that match your filters, largest balance first unless sorted, with the total match count and total balance. Use it to find a loan or property by name, address, city or ZIP, or to screen by status, type, state, metro, tenant, maturity, balance, coverage, occupancy, rate, vintage, servicer, originator or trust. All filters are optional and combine; no match returns an empty list and a total of 0. Use get_loan for one loan's full record and tenant_exposure to rank tenants.

Lists the loans where a named tenant is among the three largest at the property, with balance, status, coverage and, where it is the largest tenant, the lease end. With no tenant it lists the tenants with the most CMBS exposure. Use it to measure exposure to one tenant; use search_loans with tenant set to filter a wider search. No match returns an empty list.

Returns the latest monthly Wire: loans transferred to or returned from special servicing, newly delinquent, moved deeper into delinquency, new appraisal reductions, liquidations with losses and special servicer updates, largest first. Use section to fetch one list. Use it for what changed this month; use distress_index for rates and trends and search_loans for a loan's current state. Comment excerpts are included only with a paid cmbs.news plan.