Let’s assume the stock is Tesla (TSLA ... At its most basic, Microsoft Excel is a place to list your stocks and other investments and track their price movements from day to day.

This will be one value for your two-stock portfolio, and we can call it C12. Use the CORREL function in Excel to calculate this value, applied to the two series of daily values for the two stocks.