Excel Question
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →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
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds