Order from us for quality, customized work in due time of your choice.
For this assignment, you have to download daily prices from 3 stocks, TSLA (tes
For this assignment, you have to download daily prices from 3 stocks, TSLA (tesla) , AMZN (amazon), and NVDA ( nvidia corp.) It has to be on excel.
1) Download daily prices for three stocks: TSLA, AMZN, and NVDA (Jan. 4, 2021 – Dec. 28, 2023) from Yahoo! finance.
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)
Order from us for quality, customized work in due time of your choice.