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.

When you record a macro, you instruct Excel to remember a series of actions you perform. After being recorded, these actions ...