If much of your wealth is in employee stock options, your other investments add the most diversification when they have low correlation (or low covariance) with your employer's stock. To check, measure the correlation of daily returns between your employer's stock and each holding. In Excel with MarketXLS, =StockReturnCorelationLastOneYear("MSFT","AAPL") returns the one-year correlation of daily returns between two stocks; values near 1 mean the holding moves with your employer's stock and adds little diversification. Lower correlation lowers portfolio risk, but it does not guarantee higher returns. This article is educational and is not investment advice.
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
Understanding Correlation in Portfolio Management
Correlation is a statistical measure of how two stocks have moved together over a specific period, indicating the degree to which they move in the same or opposite direction. Investors use correlation analysis to build a diversified portfolio that balances risk and reward. In addition, a perfect positive correlation has a coefficient of 1, indicating that the two stocks move in the same direction with the same magnitude. On the other hand, a perfect negative correlation has a coefficient of -1, meaning that the two stocks move in opposite directions with the same magnitude, and a coefficient of 0 means that the two stocks are not related. It is also important to consider the covariance among stock investments and employee stock options when developing portfolio diversification strategies.
The Impact of Investing in Stocks Highly Uncorrelated with Employee Stock Options
To build a well-diversified portfolio, investors should consider investing in stocks that are uncorrelated with employee stock options. Compared with highly correlated stocks, uncorrelated stocks can reduce overall portfolio volatility, which can lead to more stable results over time. Additionally, understanding the covariance among stock investments and employee stock options is important in creating a diversified portfolio. By investing in uncorrelated stocks, investors can mitigate the risks associated with concentrated stock positions and reduce the impact of their employer’s stock on their portfolio. Overall, holding stocks with low correlation to your employer's stock reduces concentration risk; it does not by itself raise expected returns.
Calculating Covariance Between Stock Investments and Employee Stock Options with MarketXLS
MarketXLS is an Excel add-in with a function that returns the correlation between two stocks. List your employer's ticker in one cell and each of your holdings in a column, then enter =StockReturnCorelationLastOneYear(employer_cell, holding_cell) beside each holding. Because an option's value moves with its underlying stock, the correlation with the employer's stock is a reasonable proxy for correlation with your options. On Excel for Mac or the web (the Microsoft 365 add-in), add the mxls. prefix.
To help investors make more informed investment decisions and diversify their portfolios effectively, MarketXLS provides a range of functions to make correlation analysis easy and accessible. They are given below:
| Function Title | Function Example | Function Result |
|---|---|---|
| Stock Correlation | =StockReturnCorelationLastOneYear("MSFT","AAPL") | Returns the stock correlation between two stocks in last one year, using daily returns. |
Search all MarketXLS functions in the formula library.
Note: MarketXLS formulas pull the latest data only if you have MarketXLS installed. If you do not have MarketXLS consider subscribing MarketXLS pricing plans
Conclusion
To summarize, correlation analysis plays a crucial role in building a diversified portfolio that balances risk and reward, and MarketXLS provides a variety of functions and tools that simplify this analysis for investors of all levels. With MarketXLS, a correlation check between your employer's stock and each holding is one formula per row.
Moreover, the mentioned blogs are also an excellent source to learn more about related topics.
Evaluating the Relationships of Two Stocks by Covariance
Create Your Own Excel Stock Tracker
How to Calculate Stock Beta in Excel
Craft Your Own Strategy with Active Options Trading
Options Profit Calculator App