# How to Check if Your Stocks Are Correlated

> Which of your stocks move together? How to measure correlation, how to group holdings into clusters, and why three stocks can behave like one.

Source: https://www.exent.ai/resources/portfolio-correlation · Reviewed by David, Senior Analyst, Exent · Published Nov 11, 2026 · Updated Nov 11, 2026

## Key takeaways

- Calculate the correlation of monthly returns for each pair of holdings over three to five years. Pairs above about 0.7 move largely as one: Applied Materials and KLA had a 0.93 correlation over five years (Exent’s data).
- Group pairs above 0.7 into clusters and count the clusters: that is how many independent bets you hold.
- Three stocks can behave like one. Applied Materials, KLA and Lam Research had pairwise correlations of 0.86 to 0.93.
- Correlations tend to rise when markets fall, so holdings that look independent in calm times can drop together.

## What does correlation between stocks mean?

Correlation measures how consistently two holdings move in the same direction, on a scale from −1 to +1. At +1 they always move together. At 0 there is no consistent link. At −1 they always move opposite. It says nothing about the size of the moves: a calm utility and a volatile chip stock can be highly correlated if they rise and fall on the same days. The statistics are in [correlation coefficient](https://www.exent.ai/learn/correlation-coefficient).

| Correlation (rule of thumb) | What it means for your portfolio |
| --- | --- |
| Above 0.7 | Moves largely as one: size the pair as a single position |
| 0.3 to 0.7 | Partly related: some diversification |
| Below 0.3 | Mostly independent: real diversification |
| Below 0 | Tends to move opposite: a possible cushion, rare among stocks |

## How do I check if my stocks are correlated?

Use monthly returns over three to five years, the same dates for every holding. In a spreadsheet:

1. Download monthly closing prices, adjusted for dividends and splits, for each holding.
2. Turn prices into monthly returns: this month’s price divided by last month’s, minus one.
3. For each pair, use the CORREL function on the two return columns. In Excel and Google Sheets it is *=CORREL(range1, range2)*.
4. Lay the results out as a matrix, one row and one column per holding, and shade cells above 0.7.

Monthly returns are a good default. Daily returns can show noise, and a single year can be dominated by one event. With 15 holdings you have 105 pairs, which is where the work adds up.

## Which stocks usually move together?

Stocks with the same economic driver: the same industry, the same customers or the same sensitivity to rates or oil. Pairs from Exent’s data, 60 months of monthly returns to Sep 30, 2026:

| Pair | Correlation | Why |
| --- | --- | --- |
| Alphabet class A and class C (GOOGL, GOOG) | 1.00 | Two share classes of one company |
| Applied Materials and KLA | 0.93 | Chip-making equipment |
| JPMorgan Chase and Bank of America | 0.89 | Large US banks |
| Exxon Mobil and Chevron | 0.87 | Oil majors |
| Micron and Lam Research | 0.79 | Memory chips and the equipment to make them |
| Coca-Cola and Procter & Gamble | 0.69 | Consumer staples |
| NVIDIA and the Nasdaq-100 (QQQ) | 0.79 | A top holding of the index |
| Exxon Mobil and the S&P 500 (SPY) | 0.13 | Oil drives it more than the market |
| Amazon and Johnson & Johnson | −0.27 | Growth vs defensive |

## Example: three stocks that behave like one

Applied Materials (AMAT), KLA (KLAC) and Lam Research (LRCX) are different companies with different products. Their prices tell another story.

| 60 months to Sep 30, 2026 | AMAT | KLAC | LRCX |
| --- | --- | --- | --- |
| Correlation with AMAT | 1.00 | 0.93 | 0.88 |
| Correlation with KLAC | 0.93 | 1.00 | 0.86 |
| Fall in the 2022 bear market | −54.5% | −38.2% | −55.6% |
| Fall in the 2025 tariff selloff | −27.9% | −25.9% | −33.6% |
| 5-year volatility | 47.2% | 43.0% | 45.8% |

An investor holding each at 8% might feel they have three moderate positions. In risk terms it is closer to one 24% position in chip equipment. The S&P 500 fell 25.4% in 2022 and 19.0% in the 2025 selloff. All three fell more both times. See the per‑stock data on [Applied Materials](https://www.exent.ai/stocks/amat) and [Lam Research](https://www.exent.ai/stocks/lrcx).

## What are correlation clusters, and how many should I have?

A correlation cluster is a group of holdings that are all highly correlated with each other. Each cluster is one bet. To find them, start from your highest pair, add any holding that is above about 0.7 with the members, and repeat until every holding is in a cluster or stands alone.

Then count. A portfolio of 18 holdings that falls into four clusters has four bets. There is no magic number, but a portfolio whose largest cluster is more than half the money depends on one driver. This is the core of [whether your portfolio is diversified](https://www.exent.ai/resources/is-my-portfolio-diversified), and related to the effective number of bets.

## Do correlations change in a crash?

Yes, they tend to rise. When investors sell broadly, most stocks fall together. The table below compares each asset’s correlation with the S&P 500 in calm months against all months, including the 16 months since mid‑2016 when SPY fell more than 4%:

| Asset | Calm months | All months |
| --- | --- | --- |
| Nasdaq-100 (QQQ) | 0.85 | 0.91 |
| Small caps (IWM) | 0.76 | 0.86 |
| Dividend stocks (SCHD) | 0.71 | 0.82 |
| Gold (GLD) | 0.10 | 0.14 |
| T-bills (BIL) | 0.05 | 0.00 |

Stock funds became more tied to the market once bad months were counted. Gold and T‑bills stayed largely independent. A correlation matrix built only from a calm period can make a portfolio look safer than it is.

## What to do with highly correlated holdings

- Size a cluster as one position and cap its combined weight.
- Within a cluster, ask whether each holding does something the others do not.
- Look for holdings with low or negative correlation to your largest cluster.
- Re-check correlations after big market moves: they are not fixed.

## How to check correlation with Exent

1. Upload a screenshot of your holdings (or a CSV, Excel, PDF or Google Sheet); no brokerage login.
2. Portfolio Analysis builds the correlation matrix for every holding over 1, 3 or 5 years.
3. Crash replays show whether those clusters fell together in 2008, 2020 and 2022.

Exent is our product: [Exent portfolio check](https://www.exent.ai/portfolio)

## Frequently asked questions

### Which of my stocks move together?

Usually the ones with the same economic driver: the same industry, customers, or sensitivity to rates or commodity prices. Measure it with the correlation of monthly returns; pairs above about 0.7 move largely together.

### What is a good correlation between stocks in a portfolio?

For diversification, lower is better. As a rule of thumb, below 0.3 is mostly independent, 0.3 to 0.7 is partly related and above 0.7 behaves like one position.

### How do I calculate correlation in Excel or Google Sheets?

Put each holding’s monthly returns in a column using the same dates, then use =CORREL(range1, range2) for each pair.

### Is negative correlation good?

It can cushion losses, because the holding tends to rise when the other falls. It is rare among stocks and can change over time, so test it across several market periods.

### Does correlation stay the same over time?

No. It shifts with market conditions and tends to rise in sell-offs. Re-check it at least once a year and after large market moves.

---

Educational content, not investment advice. Past performance does not guarantee future results.
