portfolios.tools

Asset Correlation Matrix

Visualize how ETFs and asset classes move together.

Inputs

Select ETFs

Results

Correlation Matrix

SymbolSPYBNDGLD
SPY1.000.170.26
BND0.171.000.02
GLD0.260.021.00

Diversification Score

0.9

Like this tool? Help keep portfolios.tools free forever.

$5
$1$50

How It Works

Select ETF tickers from the bundled catalog spanning US broad market, sector, international, bond, gold, and REIT proxies. The tool computes pairwise Pearson correlation coefficients across ten years of synthetic monthly return data stored locally in your browser. Start with your current core holdings plus one candidate fund to see whether diversification score improves before adding position size. A classic three fund portfolio might include US total market, international equities, and aggregate bonds before adding satellite sleeves like listed real estate or commodities. Start with core holdings plus one candidate ETF before sizing new sleeve: diversification score should rise before adding dollars. Add international sleeve VGK or VWO to US core and watch diversification score versus all US basket. Start with core holdings plus one candidate ETF before sizing new sleeve: diversification score should rise before adding dollars. Add international sleeve VGK or VWO to US core and watch diversification score versus all US basket.

Review the full symmetric correlation matrix, the three highest and three lowest correlated pairs, and the overall diversification score. A high score suggests better shock absorption when equities sell off, though correlations often spike toward one during global crises. Re run the selection after swapping candidate tickers to confirm the new sleeve lowers average pairwise correlation rather than adding redundant exposure to the same market factor. Flag any pair above 0.85 as a sign you may own two funds tracking nearly identical risk. Export ranked pairs into your investment policy statement when documenting diversification rationale for advisory clients. Flag pairs above 0.85 correlation as redundant exposure to same factor even when ticker names differ. Remove redundant SPY and VOO pair when both track US large cap: keeps matrix readable. Ten year synthetic monthly data approximates relationships: confirm with live quotes before trades. Flag pairs above 0.85 correlation as redundant exposure to same factor even when ticker names differ. Remove redundant SPY and VOO pair when both track US large cap: keeps matrix readable. Ten year synthetic monthly data approximates relationships: confirm with live quotes before trades.

rationale for advisory clients. Flag pairs above 0.85 correlation as redundant exposure to same factor even when ticker names differ. Remove redundant SPY and VOO pair when both track US large cap: keeps matrix readable. Ten year synthetic monthly data approximates relationships: confirm with live quotes before trades. Flag pairs above 0.85 correlation as redundant exposure to same factor even when ticker names differ. Remove redundant SPY and VOO pair when both track US large cap: keeps matrix readable. Ten year synthetic monthly data approximates relationships: confirm with live quotes before trades.

Use Asset Correlation Matrix whenever inputs change: after market moves, new contributions, or revised personal assumptions. Bookmark the page for quick reruns without installing software.

Step by step

  1. Select ETF symbols from the catalog
  2. Review the correlation matrix and ranked pairs
  3. Adjust selection to improve diversification score

Worked example

Select ETF tickers from the bundled catalog spanning US broad market, sector, international, bond, gold, and REIT proxies. Enter the sample inputs described in How it works to reproduce the scenario step by step.

Adjust one input at a time to see sensitivity. Asset Correlation Matrix updates instantly so you can stress test optimistic and conservative assumptions before acting.

When to use this calculator

Reach for Asset Correlation Matrix when visualize how etfs and asset classes move together.. It suits quick what if analysis before trades, allocation changes, or plan updates.

Pair with related tools when the decision spans taxes, liquidity, or multi year projections beyond what one formula captures.

Common mistakes

Copying outputs without checking input units or stale market prices is a frequent error with Asset Correlation Matrix. Confirm tickers, percentages, and dates before acting.

Running a single baseline scenario ignores tail risks. Stress test with conservative inputs and compare against related tools listed below when the decision is material.

The Formula

Pearson ρ = Σ(x_i - x̄)(y_i - ȳ) / √(Σ(x_i - x̄)² × Σ(y_i - ȳ)²). Mean and std dev computed on 120 monthly return rows per ETF. Matrix is n×n symmetric with diagonal = 1.

Twenty ETF catalog with synthetic monthly returns over 120 months. Diversification score equals one minus average absolute correlation. Synthetic returns approximate historical relationships but differ from live market data. Refresh selections when your strategic allocation policy changes materially each year before rebalancing holdings. Rolling three year live correlations often exceed long run averages during prolonged bull markets when diversification benefits feel stronger than crisis data suggests. Synthetic monthly returns approximate history: confirm with live data before trading on correlation insights alone. Pearson correlation on monthly returns misses tail dependence visible only in daily crisis data. Bond equity correlation was positive in twenty twenty two stress: historical synthetic data may understate tail co movement. Crisis months push correlations toward one: synthetic data may understate tail dependence. Refresh ETF selections when strategic allocation policy changes each year. Use live market data confirmation before trades. Synthetic monthly returns approximate history: confirm with live data before trading on correlation insights alone. Pearson correlation on monthly returns misses tail dependence visible only in daily crisis data. Bond equity correlation was positive in twenty twenty two stress: historical synthetic data may understate tail co movement. Crisis months push correlations toward one: synthetic data may understate tail dependence.

Limitations and assumptions

Twenty ETF catalog with synthetic monthly returns over 120 months. Diversification score equals one minus average absolute correlation. Synthetic returns approximate historical relationships but differ from live market data. Refresh selections when your strategic allocation policy changes materially each year before rebalancing holdings. Rolling three year live correlations often exceed long run averages during prolonged bull markets when diversification benefits feel stronger than crisis data suggests. Synthetic monthly returns approximate history: confirm with live data before trading on correlation insights alone. Pearson correlation on monthly returns misses tail dependence visible only in daily crisis data. Bond equity correlation was positive in twenty twenty two stress: historical synthetic data may understate tail co movement. Crisis months push correlations toward one: synthetic data may understate tail dependence. Refresh ETF selections when strategic allocation policy changes each year. Use live market data confirmation before trades. Synthetic monthly returns approximate history: confirm with live data before trading on correlation insights alone. Pearson correlation on monthly returns misses tail dependence visible only in daily crisis data. Bond equity correlation was positive in twenty twenty two stress: historical synthetic data may understate tail co movement. Crisis months push correlations toward one: synthetic data may understate tail dependence. Asset Correlation Matrix does not replace personalized advice. Fees, slippage, account specific rules, and behavioral constraints may change real world outcomes.

Key terms

How is correlation calculated
Pearson correlation coefficient rho equals covariance divided by the product of standard deviations.
What data does the correlation matrix use
The tool bundles twenty ETF proxies including SPY, VTI, QQQ, IWM, VGK, VWO, BND, TLT, GLD, and VNQ with ten years of seeded synthetic monthly returns across categories.
Model assumption
Diversification Score equals one minus the average absolute correlation across selected pairs.

Compare alternatives

Size allocation weights with Risk Parity Allocator, measure overall portfolio heat with Portfolio Temperature, and backtest multi asset blends with Lost Decade Backtester on portfolios. Use those calculators when asset correlation matrix alone does not capture the full decision.

Internal links on portfolios.tools help you chain calculators: run Asset Correlation Matrix first, then validate edge cases with a specialized tool from the related section below.

FAQ

How is correlation calculated?

Pearson correlation coefficient rho equals covariance divided by the product of standard deviations. Values range from negative one for perfect inverse movement to positive one for lockstep behavior. Zero indicates no linear relationship over the sample period. Pearson rho on monthly returns captures co movement but not causation: two equity funds may correlate because both respond to the same interest rate and growth shocks rather than because one drives the other. Pearson correlation on monthly returns over ten year synthetic window estimates co movement not causation. Diversification score equals one minus average absolute pairwise correlation across selected tickers. Pearson correlation on monthly returns over ten year synthetic window estimates co movement not causation. Diversification score equals one minus average absolute pairwise correlation across selected tickers.

What data does the correlation matrix use?

The tool bundles twenty ETF proxies including SPY, VTI, QQQ, IWM, VGK, VWO, BND, TLT, GLD, and VNQ with ten years of seeded synthetic monthly returns across categories. Data is educational: confirm relationships with live data before trading decisions. Synthetic series smooth extremes that appear in live crisis months when correlations often converge toward one regardless of prior diversification benefits. Twenty ETF catalog spans bonds gold REITs and sectors for educational correlation exploration. Twenty ETF catalog spans bonds gold REITs and sectors for educational correlation exploration.

What is the diversification score?

Diversification Score equals one minus the average absolute correlation across selected pairs. Higher scores mean portfolio components move more independently. Near zero means assets largely move together. Mixing stocks, bonds, and gold typically raises diversification score versus an all equity basket. Scores above 0.4 on this scale often indicate meaningful sleeve differentiation worth maintaining through periodic rebalances. Crisis months push correlations toward one: synthetic ten year data smooths extremes that live portfolios suffer. Crisis months push correlations toward one: synthetic ten year data smooths extremes that live portfolios suffer.

Which pairings tend to have high vs low correlation?

SPY and VTI typically show correlation above 0.9 because both track US large cap equity. SPY and aggregate bonds often show low or negative correlation useful for classic stock bond balance. Sector ETFs like XLE and XLK may correlate less with broad market during regime shifts. International equity sleeves sometimes add less diversification than expected when global markets sync during risk off episodes.

How many assets can I compare?

Select two to twenty ETF tickers from the catalog. Results show the full symmetrical matrix, three highest pairs, three lowest pairs, and diversification score. Use lowest correlation pairs to prioritize new sleeves that reduce portfolio level co movement. Remove redundant tickers that duplicate existing correlation exposure before adding new fund lines. Compare diversification score before and after each candidate addition to quantify marginal benefit. Institutional allocators often cap any single pairwise correlation above 0.75 when approving new fund mandates. Remove lowest correlation pair candidates first when building satellite sleeve around US total market core. Diversification score above zero point four suggests meaningful sleeve independence worth maintaining in rebalance policy. Revisit correlation selections after major Fed policy shifts because bond equity relationships regime shift over decades. Remove lowest correlation pair candidates first when building satellite sleeve around US total market core. Diversification score above zero point four suggests meaningful sleeve independence worth maintaining in rebalance policy.

Can I use Asset Correlation Matrix on a phone or tablet?

Yes. Asset Correlation Matrix runs entirely in your mobile browser with the same formulas as desktop. Optional localStorage may remember inputs on your device when enabled in browser settings.

Where is my data stored when I use Asset Correlation Matrix?

Nowhere on our servers. Calculations execute locally in your browser. Optional localStorage saves form fields on your device only and never transmits portfolio numbers over the network.

Should I rely on Asset Correlation Matrix for tax or legal decisions?

No. Asset Correlation Matrix provides educational math only. Tax law, account rules, and personal circumstances vary. Consult a qualified tax or legal professional before transactions with material consequences.

Related Tools

Size allocation weights with Risk Parity Allocator, measure overall portfolio heat with Portfolio Temperature, and backtest multi asset blends with Lost Decade Backtester on portfolios.tools when building diversified ETF portfolios from correlation insights. Risk Parity Allocator sizes weights after correlation matrix confirms sleeves diversify rather than duplicate. Risk Parity Allocator sizes weights after correlation matrix confirms sleeves diversify rather than duplicate.