omplete excel assignments by 7/6/2022, 11:59 pm. 1) Download daily prices for three stocks: TSLA, AMZN, NVDA (Jan 1, 202
Posted: Wed Jul 06, 2022 6:27 pm
omplete excel assignments by 7/6/2022, 11:59pm.
1) Download daily prices for threestocks: TSLA, AMZN, NVDA (Jan 1, 2021 - May 31, 2022) fromyahoo!finance.
2) Compute daily stockreturns for three stocks.
3) Calculate the respective averages &standard deviations for daily stock returns.
4) Generate a covariance matrix with threedaily stock returns using DataAnalysis 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)
1) Download daily prices for threestocks: TSLA, AMZN, NVDA (Jan 1, 2021 - May 31, 2022) fromyahoo!finance.
2) Compute daily stockreturns for three stocks.
3) Calculate the respective averages &standard deviations for daily stock returns.
4) Generate a covariance matrix with threedaily stock returns using DataAnalysis 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)