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