financial markets | Excel & VBA

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 ...

Bulls, Bears, Donkeys and Elephants

Posted on 16 October 2008

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

Comments

How the mighty have fallen

Posted on 05 October 2008

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%...

Comments

How much is $700 billion?

Posted on 03 October 2008

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 ...

Comments