• Votes for this article no votes for this yet
  • Dashboard Insight Newsletter Sign Up

I Need a Bailout
Tracking Losses with Graphics

by Steve Miller, President, OpenBIFriday, June 26, 2009

Sometimes you just know your dashboards are going to provide intelligence you'd rather not see. Such is the case with my “how much have I lost?” visuals now used for daily recessionary torture.

The data representing the Dow Jones Wilshire 5000 and MSCI  Small + Mid Cap 2200 indexes are downloaded from the Yahoo! Finance and MSCI Barra web sites, respectively. The analytics are the product of the open source R Project for Statistical Computing.

Stock Market Dashboard by OpenBi
Click on image for larger version

The two graphs in column one detail the sad recent history of the DJ Wilshire 5000, first from its peak in 2007,  then year to date for 2009. The ragged blue top left curve depicts the daily close of the 5000 from its high on 10/11/2007 to the present. The six dates on the horizontal axis represent five roughly equal ranges, including start and end dates. The left vertical axis details five equal ranges of native index values, while the right standardizes at 100 as a starting point. The better-behaved brown plot is actually a smoothing spline fit to the data that distinguishes the forest from the day-to-day trees. The green horizontal line shows the index high water mark for the period; the red line the low water mark. The soft gray lines indicate index values at the beginning and end of the measurement periods. For the top graphs on both the left and right, the peak and start are one and the same.

From its high of 15819, the Wilshire 5000 declined to 6858, a loss of 57%, before starting a comeback. It's now off more than 40% from peak.  Initially down 25% in 2009, the Wilshire  has since “recovered” to near its starting point. The MSCI Barra Small + Mid Cap 2200 shows a similar pattern, albeit with a bit more extreme lows and highs, befitting its higher risk.

The R lattice graphics used to produce these plots combine a flexible out-of-the-box multidimensional metaphor with a powerful graphics programming language for visual customization. In tandem, they make R an ideal platform for complex statistical dashboards. Now if we could just get some better news to visualize.....

About OpenBI

OpenBI, LLC, is a business intelligence consultancy that develops affordable BI solutions for clients using open source software and cloud computing.  Our  partners include Pentaho, Jaspersoft, MySQL, Vertica, Infobright and the R Platform for Statistical Computing.

Participate with OpenBI, Pentaho and Vertica as we showcase these state-of-the-art technologies along with R in a webinar and demo on July 9 (http://www.pentaho.com/events/).

Tweet article    Stumble article    Digg article    Buzz article    Delicious bookmark      Dashboard Insight RSS Feed
Other articles by this author


No comments have been posted yet.

Site Map | Contribute | Privacy Policy | Contact Us | Dashboard Insight © 2018