A simple python code to digest bulk ffiec data into a single sheet in xls. Allowing for creation of charts and pivot tables that would otherwise be difficult to process. THis can also pre
To use this script, you must have python installed on your system.
Place the python script into a folder where your single period bulk call report data ZIP downloaded from https://cdr.ffiec.gov/public/PWS/DownloadBulkData.aspx is.
Run script (can take as long as several minutes to process)
Open master.xlsx
You can create charts and pivot tables in anticipation of the data. Name it something.