excel

1) Download daily prices forthree stocks:TSLA,AMZN,NVDA(Jan1,2020- July,2020)

2)Compute daily stock returns for three stocks.

3) Calculate the respective averages standard deviations for daily stock returns.

4) Generate a covariance matrix with three daily stock returnsusingData AnalysisToolpak

5) Computeanequal weighted (33.3%: TSLA, 33.3%: AMZN, 33.3%: NVDA) portfolio return and risk (Hint: Use MMULT function in Excel)