1) Download daily prices for?three stocks:?TSLA,?AMZN,?NVDA?(Jan?1,?2021?- Jun 30,?2021) from ?????Blo

04 Aug 1) Download daily prices for?three stocks:?TSLA,?AMZN,?NVDA?(Jan?1,?2021?- Jun 30,?2021) from ?????Blo

Posted at 02:49h in Business & Finance / Financial markets by

1) Download daily prices for three stocks: TSLA, AMZN, NVDA (Jan 1, 2021 - Jun 30, 2021) from Bloomberg.

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 returns using Data Analysis Toolpak

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