In an Excel workbook I reported 10 time series of 10 titles that should cover the past 15 years. After i calculated the returns and the statistics (mean, std. dev, var, etc.) I'd like to calculate the medium correlation coefficient of the portfolio. I don't mean the correlation matrix, but a single number for the entire portfolio.
Is that possible?