ED vs MSFT: Correlation
Measured on weekly returns over the past three years, Consolidated Edison (ED) and Microsoft (MSFT) carry a correlation of -0.27, a negative link.
Data as of 2026-08-27 · refreshed every trading day · weekly returns · methodology
How correlated are ED and MSFT?
On 3 years of weekly data the ED/MSFT correlation comes out at -0.27, negative, meaning they tend to move in opposite directions. The relationship has been stable: the 1-year correlation (-0.31) sits close to the 3-year figure. The 5-year figure is -0.04, and annualized covariance runs at -123.9 %².
By 3-year correlation, MSFT places #86 of the 105 assets tracked against ED. The trailing year gives ED the advantage: +10.2% versus +0.5%, a 9.7-point spread. Do not treat this figure as fixed: across three years the rolling one-year correlation ranged all the way from -0.39 to 0.20. Note the risk asymmetry: MSFT runs 1.7 times the annualized volatility of the other leg, so equal-weighting the two is not an equal-risk position.
How is this computed?
Pearson correlation on weekly returns: ρ(A,B) = cov(rA, rB) / (σA · σB), over windows of 52, 156 and 260 weeks. Covariance is annualized (×52) and expressed in %². Full definitions on the methodology page.
ED vs MSFT: side by side
| ED (Consolidated Edison) | MSFT (Microsoft) | |
|---|---|---|
| 1-year return | +10.2% | +0.5% |
| 5-year return | +67.5% | +73.3% |
| Volatility (ann.) | 16.5% | 27.5% |
| Beta vs S&P 500 | -0.21 | 1.12 |
| Max drawdown (3Y) | -17.4% | -34.5% |
| Market cap | $39.5B | $3,750.3B |
| P/E (trailing) | 17.5 | 28.1 |
| Dividend yield | 3.22% | 0.73% |
| Sector / category | Utilities | Information Technology |
Year-by-year returns
| Year | ED | MSFT |
|---|---|---|
| 2022 | +15.7% | -28.0% |
| 2023 | -1.1% | +58.2% |
| 2024 | +1.5% | +12.9% |
| 2025 | +15.1% | +15.6% |
| 2026 | +10.1% | +5.1% |
Calendar-year price returns; the current year is year-to-date as of the data date above.
Are ED and MSFT good diversifiers for each other?
By historical standards, yes. A correlation of -0.27 means the two rarely move for the same reasons.
FAQ
What is the correlation between ED and MSFT?
The ED/MSFT correlation stands at -0.27 on a 3-year window (1 year: -0.31, 5 years: -0.04), computed from weekly returns as of 2026-08-27.
Is MSFT a good diversifier for ED?
By historical standards, yes. A correlation of -0.27 means the two rarely move for the same reasons.
What does a correlation of -0.27 mean?
On the −1 to +1 scale, -0.27 describes how much the two returns move together: +1 is lockstep, 0 is independence, negative values mean opposite directions. It says nothing about which performed better.
Use this data
$ curl https://www.pairbook.io/api/v1/pairs/ed-vs-msft.json
Drop this badge in a README or notebook; it updates with the data:
[](https://www.pairbook.io/pair/ed-vs-msft/)
The core API is free. Terms and every endpoint in the API documentation.
Related comparisons
Hubs: ED correlations · MSFT correlations
