Compare Bank Snapshot Trends
fdic_compare_bank_snapshotsCompare FDIC reporting snapshots across banks to rank growth, profitability, or efficiency changes. Batch roster lookup, financial snapshots, and demographics for analytical comparisons.
Instructions
Compare FDIC reporting snapshots across a set of institutions and rank the results by growth, profitability, or efficiency changes.
This tool is designed for heavier analytical prompts that would otherwise require many separate MCP calls. It batches institution roster lookup, financial snapshots, optional office-count snapshots, and can also fetch a quarterly time series inside the server.
Good uses:
Identify North Carolina banks with the strongest asset growth from 2021 to 2025
Compare whether deposit growth came with branch expansion or profitability improvement
Rank a specific cert list by ROA, ROE, asset-per-office, or deposit-to-asset changes
Pull a quarterly trend series and highlight inflection points, streaks, and structural shifts
Inputs:
state or certs: choose a geographic roster or provide a direct comparison set
start_repdte, end_repdte: Report Dates (REPDTE) in YYYYMMDD format — must be quarter-end dates (0331, 0630, 0930, 1231)
analysis_mode: snapshot or timeseries
institution_filters: optional extra institution filter when building the roster
active_only: default true
include_demographics: default true, adds office-count comparisons when available
sort_by: ranking field (default: asset_growth). All options: asset_growth, asset_growth_pct, dep_growth, dep_growth_pct, netinc_change, netinc_change_pct, roa_change, roe_change, offices_change, assets_per_office_change, deposits_per_office_change, deposits_to_assets_change
sort_order: ASC or DESC
limit: maximum ranked results to return
Returns concise comparison text plus structured deltas, derived metrics, and insight tags for each institution.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| state | No | State name for the institution roster filter. Example: "North Carolina" | |
| certs | No | Optional list of FDIC certificate numbers to compare directly. Max 100. | |
| institution_filters | No | Additional institution-level filter used when building the comparison set. Example: BKCLASS:N or CITY:"Charlotte" | |
| active_only | No | Limit the comparison set to currently active institutions. | |
| start_repdte | No | Starting Report Date (REPDTE) in YYYYMMDD format. Must be a quarter-end date: March 31 (0331), June 30 (0630), September 30 (0930), or December 31 (1231). Example: 20210331 for Q1 2021. If omitted, defaults to the same quarter one year before end_repdte. | |
| end_repdte | No | Ending Report Date (REPDTE) in YYYYMMDD format. Must be a quarter-end date: March 31 (0331), June 30 (0630), September 30 (0930), or December 31 (1231). Must be later than start_repdte. Example: 20251231 for Q4 2025. If omitted, defaults to the most recent quarter-end date with published data (~90-day lag). | |
| analysis_mode | No | Use snapshot for two-point comparison or timeseries for quarterly trend analysis across the date range. | snapshot |
| include_demographics | No | Include office-count changes from the demographics dataset when available. | |
| limit | No | Maximum number of ranked comparisons to return. | |
| sort_by | No | Comparison field used to rank institutions. Valid options: asset_growth, asset_growth_pct, dep_growth, dep_growth_pct, netinc_change, netinc_change_pct, roa_change, roe_change, offices_change, assets_per_office_change, deposits_per_office_change, deposits_to_assets_change. | asset_growth |
| sort_order | No | Sort direction for the ranked comparisons. | DESC |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||