Exploring Negative Correlation in Stock Market Investing
Negative correlation means two securities tend to move in opposite directions: when one rises, the other tends to fall. It is measured by the correlation coefficient, which runs from -1 (always opposite) to +1 (always together), and you can calculate it in Excel with =CORREL() on two series of daily returns. Holding negatively correlated assets reduces portfolio volatility, because losses in one holding are partly offset by gains in the other, although it can also reduce returns when both sides are in the portfolio.
Try it in your own spreadsheet
Get the free MarketXLS sample workbook (.xlsx).
No account needed. MarketXLS live data requires a paid plan. Preview workbook
Explore more videos
Factors That Influence Stock Market Correlation
Negative correlation usually comes from securities responding in opposite ways to the same driver. Common sources include:
- Economic conditions: Defensive assets (such as long-term Treasuries) often rise when growth slows, while cyclical stocks fall.
- Commodity prices: Higher oil prices help producers but raise costs for airlines and other heavy fuel users.
- Flight to safety: In market stress, investors often sell stocks and buy safe-haven assets, pushing their prices in opposite directions.
- Hedging instruments: Inverse ETFs and put options are designed to move against their underlying.
Correlations are not fixed. They change over time and can move toward +1 during market crises, just when diversification is most needed.
Strategies to Leverage Negative Correlation
Investors use negative correlation in four main ways:
- Short Selling: Short selling is a strategy where an investor borrows a stock from a broker and sells it at the current market price. When the stock price drops, the investor buys the stock back and returns it to the broker. Pairing a short position with a long position in a related stock is one way to trade the relationship between the two.
- Day Trading: Day trading involves trading stocks on the same day. Some day traders watch short-term relationships between securities, but correlations over short periods are unstable.
- Investment Portfolio: Setting up an investment portfolio to take advantage of a negative correlation can help an investor to spread risk and reduce volatility.
- Hedging: Options, futures, and inverse ETFs can be used to add a negatively correlated position to an existing portfolio.
Using MarketXLS for Correlation Analysis
MarketXLS measures correlation in Excel by pulling historical prices for each holding with =QM_GetHistory("AAPL"), converting them to daily returns, and applying Excel's =CORREL() to each pair. A correlation matrix built this way shows which holdings actually offset each other. MarketXLS quotes are 15-minute delayed on the Standard plan and real-time on the Advanced and Business plans; this article is educational and not investment advice.
Search for all templates on the MarketXLS templates page.
Relevant blogs that you can read to learn more about the topic
Correlation Matrix (Measuring Portfolio Diversification)
How to hedge a drop in S&P 500 Using MarketXLS
“The Ultimate Guide to ETF Screeners”
Fear and Greed Index (Understanding Investor Sentiments)
Stock Drawdown