FDIC Data for Banks [Call, UBPR & Y-9C Reports]

Intrinio was founded on the principle that making financial data affordable and accessible has the potential to ignite innovation in an archaic industry. First, we built our technology and used it to get full coverage of US equity data. Then we started looking for new data sets that needed to be freed from the shackles of oligopolistic pricing. We stumbled upon FDIC data, and what we built has become truly exciting. 

Because of our technology, we're able to serve this data up at a fraction of the cost of other providers. What was once a premium product reserved only for large organizations (who overpay as well) is now affordable and accessible. Eat your heart out.

FDIC Data - The Regulatory Filings

If you're a bank analyst, an investment banker, or the CFO of a bank, you are most likely intimate with the idea of FDIC data. Feel free to skip to the next section so you can get your hands dirty right away.

But for the rest of us, what exactly is FDIC data?

The FDIC or Federal Deposit Insurance Corporation was created by congress to maintain stability and confidence in banking institutions. This governmental body provides insurance to US citizens and businesses who deposit their money in US banks. If the bank fails you are insured for losses on your deposits in that bank, up to $250,000.

FDIC Data is Collected for Most Banks

Like most heavily regulated industries,  there are several regulatory reports that must be filed by each insured bank. The most important are the Call Reports and UBPR filings for banks, and  Y-9C Reports for bank holding companies.  The Call Reports and UBPR filings are collected by the FDIC for member banks and Y-9C Reports are collected by the Federal Reserve.

Call Reports

The Federal Financial Institutions Examination Council (FFIEC) requires National Banks, State Member Banks, and insured Non-member Banks to file a Call Report. Call report stands for "Consolidated Report of Condition and Income".

Banks with foreign offices file Form 31 and banks without foreign offices file Form 41.

A Call Report includes over 70 pages of information, including fiduciary services, loans to small businesses, charge-offs, changes in bank equity capital, the income statement, and more. The report functions as a summary of a bank's financial condition and result of operations.

  • Filed Quarterly
  • Filed by National Banks, State Member Banks, and Non-Member Banks
  • Required by statute
  • Collected by the FDIC

FDIC Data in the Intrinio Excel add-in

UBPR

The Federal Financial Institutions Examination Council (FFIEC) requires National Banks, State Member Banks, and insured Non-member Banks to file a quarterly UBPR. UBPR stands for "Uniform Bank Performance Report".

A UBPR differs from a Call Report because it's meant for bank supervisory, examination, and management purposes. According to the FFIEC, it shows the impact of management decisions and economic conditions on a bank's performance and balance sheet composition. It also includes items like the income statement, in addition to interest rate risk analysis, off-balance sheet items & derivative analysis, securitization & asset sale activities - and much more.

  • Filed Quarterly
  • Updated Continuously
  • Filed by National Banks, State Member Banks, and Non-Member Banks
  • Required by statute
  • Collected by the FDIC

Y-9C Reports

Y-9C Reports are filed quarterly with the Federal Reserve by bank holding companies. They are required for all domestic bank holding companies with total consolidated assets of $1 billion or more and all multibank holding companies with debt outstanding to the general public or engaged in certain nonbanking activities.

The primary components of the Y-9C Report are the consolidated balance sheet & income statement, and detailed schedules including a schedule for off-balance sheet items and regulatory capital.

  • Filed Quarterly
  • Filed by Bank Holding Companies
  • Required by statute
  • Collected by the Federal Reserve

Why do These Filings Matter?

It's a common belief that banks hold so much control over the economy that they are "too big to fail". These reports are important sources of information for regulators & authorities. Regulators use FDIC data to monitor for credit and systemic risk, misuse, and lack of social responsibility. Large exposures, capital ratios, and reserve requirements are just a few of the things that are regulated.

This data is also used extensively by researchers & academics to conduct studies of bank performance, banking industry trends, economic impacts of banking, and more.

Ratings agencies use FDIC data to research and issue ratings for financial institutions, including banks and bank holding companies.

Investment bankers use FDIC data to study banks that may be interested in merging, or a bank that may be interested in acquiring another bank. This helps them advise the banks from an M&A consulting perspective.

Banks like to analyze their own FDIC data to monitor their performance, stay on top of banking industry trends, and compare their performance to their peers.

Investors and bank analysts use FDIC data to understand a bank's performance, profitability, long term viability, solvency, potential for growth, geographic advantages, and more. This helps them better understand whether they want to invest in a Bank Holding Company.

Coverage

Intrinio provides FDIC data for over 25,000 US banks and 8,000 US bank holding companies.

We've paid special attention to our Security Master - a system for tracking active and delisted companies and linking them across all Intrinio data sets. This means you can use several identifiers to search for banks within this data set.

You can search for a bank's RSSD ID here.

You can search our coverage for banks by ticker or name here.

Accessing FDIC Data via the API

If you haven't already accessed the Intrinio REST Web API, it's very easy to do so. Check out this tutorial, or this blog that shows you how to authenticate with sample API calls and code examples.

Call Syntax

https://api.intrinio.com/data_point?identifier={symbol/rssd}&item={tag}

https://api.intrinio.com/data_point?identifier={symbol1/rssd,symbol2/rssd}&item={tag1,tag2}

Sample Calls

https://api.intrinio.com/data_point?identifier=2362074&item=total_branches

This API Call Returns the Total Bank Branches for C1 Bank, or RSSD ID 852218.

 

https://api.intrinio.com/historical_data?identifier=2362074&item=RIAD4435

This API Call Returns the time series historical data for Interest Income Secured from Single Family Residential Loans for C1 Bank.

 

You can find the full FDIC data documentation for the API here.

Accessing FDIC Data in Excel

If you haven't already accessed the Intrinio Excel add-in, it's very easy to do so. Check out this tutorial. If you run into issues, this blog will help you troubleshoot on a Mac, and this blog will help you troubleshoot on a PC.

Call Syntax

=IntrinioDataPoint(identifier, item)

=IntrinioHistoricalData(identifier, item, sequence, start_date, end_date, frequency, type, show_date)

=IntrinioBankFundamentals(identifier, statement, type, sequence, item)

=IntrinioBankTags(identifier, statement, sequence, item)

=IntrinioBankFinancials(identifier, statement, sequence, type, tag, rounding)

Sample Calls

=IntrinioBankFinancials(2362074,"RI",2015,"FY","RIAD0093")

=IntrinioDataPoint("C","bank_name")

You can find the full FDIC data documentation for the Excel add-in here.

Subscribing & Pricing

On the Intrinio Marketplace, you're automatically subscribed to the Free Plan for three data feeds:

  • US Public Company Financials
  • US & Global Economic
  • Global Public Company Security Master

We don't have a free plan for the FDIC Data - the cost is $500/month for Professionals and includes access via REST Web API and Excel add-in. You can subscribe here.

If you're a developer at a startup or a financial institution interested in leveraging the API to build an application, chat us.

Chat with Us

 

With the high cost of FDIC data, it's no wonder there has been stifled innovation within the banking industry. Arguably, it's one of the last major industries to accept and embrace technological advancement. We're proud to provide affordable FDIC data, and we're looking forward to de-shackling the next data set.