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.

Use values between -1 and 1. Try 0.8 for similar stock regions, 0.2–0.4 for stocks vs bonds, and near 0 for cash.
Enter only unique pairs; the matrix will mirror them automatically.
Tip: Start with rough estimates, then refine correlations as you gather more data. Watch how diversification changes.
Important: This tool does not validate whether your correlations form a mathematically consistent covariance matrix. Use it as an educational visualization and sanity check, not as a full risk engine.

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