Thursday, August 9, 2012

48 Industries (Dendrogram Ordered) Over 50 Years

Thanks to reader AHWest for the comment on post 48 Industries Since 1963.

“I think it would be interesting to see the industries ordered by some sort of similarity of returns.”

I think this is a great suggestion, and I would like to see it also.  I tried the dendrogram plot technique from Inspirational Stack Overflow Dendrogram Applied to Currencies, but then I spotted the dendrogramGrob in the latticeExtra documentation.  This was much easier, and in a couple of lines, we are able to order and connect the 48 industries.

From TimelyPortfolio
R code from GIST (do raw for copy/paste):

2 comments:

  1. This one throws an error

    french_industry_xts <- as.xts(french_industry[,1:NCOL(french_industry)],
    order.by=as.Date(datestoformat))

    Error in as.POSIXlt.character(x, tz, ...) :
    character string is not in a standard unambiguous format

    Any idea why is that?

    ReplyDelete
    Replies
    1. in a prior post, reader suggested the following

      I changed it to

      french_industry_xts <- as.xts(french_industry[,1:NCOL(french_industry)],
      as.POSIXct(datestoformat,format="%Y-%m-%d"))

      and it's all OK.

      Delete