Federal Reserve Summary Update

Trevor O'Hearn
2 min readAug 9, 2020

The Federal Reserve comes out with a weekly summary of everything they are doing. It comes in the most basic html template possible with only a few options on how to view the file at the top. For the average person, all the tables and things that are on the next couple of pages seem like several lists of confusing values and dates. Obviously not a lot of thought goes into whether or not most people can understand what they are sending out every week. So I am building a simpler way to understand, all of that information.

This is a process and there will be a lot more to come but for now I have added several scripts on my GitHub (link below) to extract the overview table or even every table that is laid out on the webpage. The ‘quickscrape.py’ will write the 2020 and 2019 summary tables to a ‘.csv’ file that can be uploaded to Excel and is all nice and clean.

If you are aware of Jupyter Notebook and a little more tech savvy you can grab the dictionary of all the tables containing lists of all the zipped data from every table off of the file ‘AllTableScrape.ipynb’. This large dictionary of dictionaries will be available in json and xml formats as separate files on my Github so that anybody can use this information even if you know another programming language (like javascript or php); not just Python.

There is a link to the project on my Github below, as well as a link to the scraped table (viewable through github). Feel free to check out the Federal Reserve Summary link and see for yourself just how confusing it is!

--

--