Skip to main content
BankRegReports for Excel Beta

Live regulatory data,
in your own model.

Nine functions over the same 202 fields the API serves. Change the bank in one cell and the whole sheet refills. Works in Excel for Windows, Mac and the web, and the free tier is enough to use it.

Install it

Three steps: get a key, add the add-in to Excel, connect. Excel on the web is the quickest route and takes about two minutes.

Step 1: Get a free API key

The add-in signs in with a BankRegReports API key, the same brr_ key the REST API uses. Create an account, open Account settings, API tab, and generate one. Copy it when it appears: we store only a hash and cannot show it again.

Step 2: Add it to Excel

The add-in installs from one small file, the manifest. It tells Excel where the add-in lives and holds no data and no credentials. Pick the route that matches how you use Excel.

Excel on the web

Just you, about two minutes, no administrator

  1. Download the manifest with the button above.
  2. Open any workbook in Excel on the web.
  3. Select Home, then Add-ins, then More Settings.
  4. Select Upload My Add-in, browse to the manifest and select Upload.

Excel keeps an uploaded add-in in that browser. Upload it again if you clear the browser's data or switch browsers.

Your whole team

A Microsoft 365 administrator, once, for everyone

  1. In the Microsoft 365 admin center, open Settings, then Integrated apps.
  2. Select Upload custom apps and set the app type to Office Add-in.
  3. Choose the option to provide a link to the manifest and paste this address: https://www.bankregreports.com/addin/manifest.xml
  4. Choose who gets it and select Deploy.

The BankRegReports tab then appears in Excel for Windows, Mac and the web for those people. Microsoft says it can take up to 72 hours to show on the ribbon.

Excel for Windows

Desktop, without an administrator

  1. Put the manifest in a folder and share that folder.
  2. In Excel, open File, Options, Trust Center, Trust Center Settings, Trusted Add-in Catalogs.
  3. Add the folder's network path, tick Show in Menu, and restart Excel.
  4. Select Home, Add-ins, Advanced, then Shared Folder, and add BankRegReports.

Excel for Mac

Desktop, without an administrator

  1. In Finder, press Cmd+Shift+G and go to ~/Library/Containers/com.microsoft.Excel/Data/Documents/wef Create the wef folder if it is missing.
  2. Copy the manifest into that folder.
  3. Restart Excel, select Home, then Add-ins, and choose BankRegReports.

Step 3: Connect and pull a number

Open the BankRegReports tab on the ribbon and select Open pane. On the Connect tab, paste your API key and select Connect. The pane shows your plan and its daily limits. Then type this in any cell:

=BRR.P(852218, "cet1_ratio")

That is the CET1 ratio for JPMorgan Chase Bank, N.A. as of its latest filed quarter. To start from a finished sheet instead, open the pane's Templates tab and insert one, or download a workbook below.

The formulas

Three shapes, because data for a spreadsheet comes in exactly three: a value as of a period, a history, and a field whose value is a table.

BRR.P

A value as of a period. A range on either argument spills a block.

BRR.P(entity, field, [period], [options])
=BRR.P(852218, "cet1_ratio")

BRR.H

History: dates beside values, over a window you pin. A range of up to 25 institutions spills one long table.

BRR.H(entity, field, [start], [end], [options])
=BRR.H(852218, "roa", "2022Q1", "2025Q4", "Per=A")

BRR.S

A set: a field whose value is a table, such as branches or peers.

BRR.S(entity, dataset, [rows], [options])
=BRR.S(852218, "branches")

BRR.ID

The institution id for a name or FDIC certificate number.

BRR.ID(query)
=BRR.ID("JPMorgan")

BRR.META

A field's label, unit, precision or description.

BRR.META(field, [attribute])
=BRR.META("roa", "unit")

BRR.SCREEN

The banks that pass a set of filters, one bank per row.

BRR.SCREEN(filters, [sort], [limit], [options])
=BRR.SCREEN("state=GA; tier=4; min_cet1=10", "roa")

BRR.PEERS

A bank's peer group as a column of ids, ready to feed BRR.P.

BRR.PEERS(entity, [count], [options])
=BRR.P(BRR.PEERS(852218), {"roa","cet1_ratio"})

BRR.RANK

Where a bank sits among its peers on one field, as a percentile.

BRR.RANK(entity, field, [measure])
=BRR.RANK(852218, "cet1_ratio")

BRR.BENCH

An industry benchmark for a size tier; omit the tier for all six.

BRR.BENCH(field, [tier], [stat], [period])
=BRR.BENCH("roa", 4)

Templates

18 ready-made workbooks in the house format, every cell a live formula. Open one with the add-in connected, change the institution in one cell and the sheet refills. Leave the as-of date blank and it follows the latest filed quarter. Until the add-in is installed, the cells show #NAME?.

Sign in to download the workbooks

The templates come with a free account, the same one that issues your API key. Sign in and the Excel add-in page in your dashboard lists every workbook with its download.

How it behaves

One request, not one per cell

Excel calls a custom function once per cell. Every call here joins a queue that de-duplicates and batches, so a 500-cell model is a couple of requests per recalculation rather than 500.

Units travel with the number

Each field carries its unit and precision, so a ratio is never multiplied twice and a figure reported in thousands is never shown as dollars.

A missing value is never a zero

A bank that did not report a line renders as a dash, not as 0. A zero is a measurement; an absence is not, and a model cannot tell them apart after the fact.

Pin the window

BRR.H takes an explicit start and end. A sheet built on "the last 20 quarters" quietly moves every time a quarter lands, so the figure you signed off in March is not the one the cell shows in April.

Questions

Do I need a paid plan?

No. The free tier includes 200 requests a day, and with batching that is a genuine working allowance rather than a demo. You do need an account, since the add-in authenticates with an API key.

Why do the cells show #NAME?

Excel does not know the BRR functions until the add-in is installed in that copy of Excel. Install it with one of the routes above, open the pane and connect, and the cells fill on the next recalculation.

Is it in the Microsoft store?

Not yet. Until it is, install it from the manifest as described above. The manifest route installs the same add-in a store listing would.

Is it the same data as the API?

The same, through the same endpoints. A cell, a Python call and a download all resolve the same field to the same number.

Can a refresh change a historical number?

Yes, and it should. Values are the latest restated figure, so when a bank amends a filing the corrected number appears. This is stated rather than silent, and every response carries its vintage.

Where does my API key live?

In Excel on your machine, in the add-in's own storage. It is sent only to BankRegReports, and disconnecting removes it.

Powered by BankRegReports API