Portfolio Correlation Matrix
Build a simple correlation matrix for up to five assets. See how strongly your holdings move together and how much diversification you really have.
Correlation basics and diversification
Correlation is a simple but powerful way to understand diversification. When assets are highly correlated, they tend to move together, and diversification benefits are limited. When correlations are low or negative, combining assets can significantly reduce overall portfolio volatility.
1. Correlation definition
Correlation between assets i and j:
ρ(i,j) = Cov(R_i, R_j) / (σ_i σ_j)
Where:
R_i, R_j = returns of assets i and j
Cov = covariance
σ_i, σ_j = standard deviations of returns
Correlation is bounded between -1 and 1. It is dimensionless and focuses on co-movement, not magnitude of returns.
2. Correlation matrix structure
For N assets, the correlation matrix is an N × N table:
Diagonal:
ρ(i,i) = 1 for all i
Off-diagonal:
ρ(i,j) = ρ(j,i) for all i ≠ j
The diagonal is always 1 because each asset is perfectly correlated with itself. The matrix is symmetric because correlation is the same regardless of order.
3. Diversification intuition
Lower correlations → lower covariance terms in portfolio variance:
Var_p = Σ w_i² σ_i² + Σ Σ w_i w_j σ_i σ_j ρ(i,j)
Holding volatilities and weights fixed, reducing ρ(i,j) reduces Var_p.
This is why mixing assets with low or negative correlations can reduce overall risk even if individual assets are volatile.
How to read your correlation matrix
Once you build the matrix, scan the colors and values. High correlations (near 1, often red) mean those assets tend to move together. Low correlations (near 0, often green) suggest diversification. Negative correlations are rare but powerful—they indicate assets that tend to move in opposite directions.
Worked example
Imagine a five-asset portfolio:
- US stocks
- International stocks
- Bonds
- Real estate
- Cash
You might enter correlations like 0.85 between US and international stocks, 0.3 between stocks and bonds, 0.6 between stocks and real estate, and near 0 between cash and everything else. The matrix will highlight that stocks are tightly linked, bonds provide partial diversification, and cash is largely uncorrelated.
Using the results
If your average correlation is high and most cells are red, your portfolio may be more concentrated than you think. You can experiment with adding assets that historically have lower correlations to your core holdings. If you see a few green or blue cells, those assets are doing most of the diversification work.
Remember that correlations change over time, especially during market stress. Use this tool as a snapshot and a teaching aid, not a guarantee of future behavior.
Frequently Asked Questions
Can I leave some asset names blank?
Yes. Blank asset names are ignored, and the matrix will shrink to include only named assets.
What happens if I skip some correlations?
Missing correlations are treated as 0 (no linear relationship). You can fill them in later as you refine your assumptions.
Does this check mathematical consistency?
No. The tool does not verify positive semi-definiteness or other matrix properties. It focuses on visualization and intuition.
Can I export the matrix?
Yes. Use the Export CSV button to download the matrix and use it in your own models or spreadsheets.
Related tools
Information on this site is for educational purposes only and is not financial, tax, or legal advice. Calculations are estimates and may not reflect actual results. See our Privacy Policy and Disclaimer.