When I generate spreadsheets, all the calculations are built in. Then I got a neat spreadsheet from David where the calculations are made by the user.
There's an Explain sheet which looks like this:
>And I can enter my own calculations?
>zzz ... huh ... how about the the whole list?
Suppose we do the DOW and sort on the volatility. We'd get an ordering that looks like this:
See who's at the bottom of the volatility list? It's our friend the DOW.
That's because it's the volatility of the collection of all 30 stocks. Diversification, don't you see?
Of course, we're doin' the past year, from March, 2006 to March 2007. For the calendar year 1987, the year of the crash, the volatility was 34.5%.
Nevertheless, the DOW was near the bottom.
>And how about the S&P500?
I should point out that the spreadsheet may change dramatically ... without notice.
P.S. The S&P 500 is here