Equity Vs Etf Correlation

Discussion in 'ETFs' started by newycity, Jun 1, 2006.

  1. newycity


    Is there anyone who can help me out with finding the correlation of a number of stocks vs. various etfs or index. I know i can write some sort of macro into excel and probably come up with what i need, but i am hoping there is a simpler way.
  2. lrm



    Excel already has a correlation function. Input the time series you are interested in and use CORREL() to find the correlation coefficient. See http://www.ce.memphis.edu/1112/excel/correl.htm for an example.

    Best regards,