I understand the process on excel: calculate betas, calculate covariance with $Cov(R_{i,t},R_{j,t}) = \beta_{i,m} \cdot \beta_{j,m} \cdot \sigma^2_m$
where m is the market return and i and j are assets.
I'm confused as to what the assumptions are in order to be able to do this?
Can I do this since I have market data 4 US stocks and the S&P500 meaning that I'm only considering systematic risk?
Please could someone give me the assumptions in order to use the CAPM relation to find a variance covariance matrix?