Finance Problem
• Download daily prices for three stocks: TSLA, AMZN, NVDA (Jan 1, 2021 - Jun 30, 2021) from Bloomberg.
• Compute daily stock returns for three stocks.
• Calculate the respective averages standard deviations for daily stock returns.
• Generate a covariance matrix with three daily stock returns using Data Analysis Toolpak
• Compute an equal-weighted (33.3%: TSLA, 33.3%: AMZN, 33.3%: NVDA) portfolio return and risk (Hint: Use MMULT function in Excel)
The response should include a reference list. Using one-inch margins, Times New Roman 12 pnt font, double-space and APA style of writing and citations.