Calculating stock correlations

Discussion in 'Stocks' started by tradelite, Nov 24, 2008.

  1. tradelite


    I want to be able to calculate correlations between different stocks, etfs, etc. I want to do this for 20 day, 6mo, 1yr, and 2yr data, but, I don't want to shell out the cash for a bloomberg terminal.

    Any ideas on cheaper alternatives or formulas I can use with Excel?

    Any help is much appreciated,