Work with me: Private Investment Coaching
See my notes below regarding the file.
Building My Own Custom Bank Screener
My original intent for this week’s post was to run a screen for banks based on this post from Tim Melvin, and report on the top results. Then I got distracted….
Working with my buddy Claude, I built a custom screener that pulls from the free FDIC BankFind Suite API. I don’t know why I didn’t build something like this sooner. Right, I didn’t have Claude. Anyway…
The screener does two main things:
It lets you search the FDIC’s database of 4000+ banks based on criteria you define from the available data points.
Allows you to dig into a specific bank starting at any point in time. It’ll populate charts/graphs and give you five years + two quarters of financial history in the UBPR format.
A couple of notes:
This tool searches the FDIC database, which is a repository of bank financials. Many banks are owned by holding companies, so be careful about differences between the two (holding company debt funding a clean-looking bank, for example).
You’ll need to run the file on a desktop.
You might need to allow permissions to access the FDIC API.
Feedback Welcome
Let me know what you think. How can I make this a better tool?
I’m already thinking of adding 10 years of financials with common sizing, and creating more of the UBPR sections. But I’d like to try it out for a while before going too deep into redesigning it.
More thoughts? Let me know in a private message or leave a comment.
Stay Rational!
Adam
Order the 2nd Edition Now!
Praise for the 2nd Edition
I’m incredibly grateful for the people who took the time to review early drafts of the new material and provided feedback, as well as praise for both editions:
“If you want to understand how Warren Buffett built Berkshire Hathaway into one of the most valuable businesses in the world, you have to read this book. This is your opportunity to stand beside Picasso as he paints each brush stroke. A must read for all Buffett and Berkshire groupies.”
- Bill Ackman, Founder and CEO of Pershing Square
“I and my teammates at the Gabelli Organization have been tracking Warren’s success for some 50 years. Adam’s book captures the work and highlights the history of Berkshire and the hard and diligent work of Buffett and Munger, Jain and Abel, and Combs and Weschler.”
- Mario Gabelli, Chairman and CEO, Gabelli Funds
“Adam Mead’s discussion of the values and virtues which have shaped Berkshire Hathaway over 50 years is a must read for those investors in search of the forces that have delivered such investment value over time.” – Thomas A. Russo, Gardner Russo & Quinn LLC
“Few activities can be more rewarding for any value investor than studying the history and evolution of Warren Buffett and Berkshire Hathaway. Adam has done us a huge favor with his yeoman efforts in producing this treatise. Since it is chronologically ordered, it is an invaluable reference guide for all things Berkshire.” — Mohnish Pabrai
“Adam continues to deliver a resource very valuable to both Berkshire fans and the investor community as a whole, his depth of knowledge is clearly demonstrated here again. I thoroughly enjoyed this latest addition.” - Dan Calkins, Chairman & CEO, Benjamin Moore
“The question must be asked, ‘Why another Berkshire book?’ When you read this monumental effort by Adam Mead, the answer will be obvious. Read cover to cover, both the uninitiated to Berkshire and its most ardent followers will derive enormous utility and satisfaction from it. I learned so many new and important things about Berkshire and its history. It is my pleasure to encourage you to enjoy this gem.”
- Christopher P. Bloomstran
“Whatever Adam writes is always first-class - guaranteed.
-Andy Kilpatrick, Author, Of Permanent Value: The Story of Warren Buffett
Nice build. One idea would be adding the CRE concentration ratios from the 2006 guidance, construction over 100% of capital and total CRE over 300%. It's a screen a lot of people are running right now.