Trendalyzer view of the banking crisis

The team at “And Still I Persist” has created their own version of Hans Rosling’s “Trendalyzer” (see: Radar post) to visualize the current US banking crisis.

First lets look at the top 8 banks and their mortgages that are 90+ days late. Below is a flash charting system, feel free to use the controls and experiment. We chart the total assets of the bank along the horizontal axis, the value of loans that go 90+ days late on the vertical, and the size of the circles represent the total loan portfolio for that bank. You can set the charts in motion by hitting the “Play” button and stop them at any time. Hovering over a circle will show you the value for that data point.

Our charts step forward in time for Q1-2002 one quarter at a time, reading directly from the bank’s own FDIC reports.

Bank Portfolios – 90+ Days Late

See the original article for more about this visualization and the team that created it.

Update: Bruce Henderson invites anybody interested in working with a larger data set to take a look at the OSG Boomerang tool.

tags: , , , , , ,
  • http://and-still-I-persist.com/ Bruce Henderson

    Thanks for the link, we are hoping to have the data from Q1 2008 from the FDIC in the next month or so (once they publish it). Given the turmoil in the banking world it should show some very significant changes in banking health stats.

    If anyone wants to work with a larger data set (and able to show more banking health factors), feel free to take a look at:

    http://xserve.osgcorp.com/flex/fdic/

    Bruce & the OSG Boomerang Team

  • http://www.dog-obedience.net Ajeet Khurana

    Wow! I played with that little application as if it was a strategy based video game.

    But whatever way I try to generate the outcomes, one thing that is clear to me (not from the graph) is that the severe media speculation itself is enough to spur sentiment to cause another Bear Sterns (or two). Good luck to all of us.

  • http://radar.oreilly.com/jesse/ Jesse Robbins

    @Bruce – This really is a great use of the visualization. Great work! Thank you for making the tool available.