Volatility Chart in Excel – Lessons in Chart Design From NY Times

Here's a slightly dated chart from NY Times showing volatility on the Wall St across the century. The chart does commendable work in conveying information about a longish time series pretty effectively. I found some great chart design principles at work here that I could utilize for day to day charting needs. (Click on image to open larger version. Click here for the original version) Here's a look ...

Continue Reading

Volatility Chart in Excel - Lessons in Chart Design From NY Times

Bulls, Bears, Donkeys and Elephants

Posted on 16 October 2008

Bulls, Bears, Donkeys and Elephants
Who would want to use something like this..... (See Bulls, Bears, Donkeys and Elephants ) ......when they could've used this instead.....
Continue Reading

Comments     

How the mighty have fallen

Posted on 05 October 2008

How the mighty have fallen
Below is a list of how much the global markets have fallen in the past year. The highs and the lows may not coincide with the beginning and end of the one year period. Data for week ending 5-Oct-08. S&P 500 52 week low: 1,098 52 week high: 1,576 Correction: 30%...
Continue Reading

Comments     

How much is $700 billion?

Posted on 03 October 2008

How much is $700 billion?
USA Today came out with this graphic recently which compares the size of the recent bailout package with the other historical packages in the past. I tried my own version of this and came pretty close to achieving the same results in excel. "Close" because there would be errors since the size of the boxes may not accurately represent the number corresponding to it. As Paulson said, "If you have ...
Continue Reading

Comments     

Subscribe

Keep up with the latest stories - Delivered right to your inbox
feedburner

Translate

English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel


ARCHIVES