Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate and report the total return, standard deviation, and Sharpe ratio of your portfolio on a weekly basis. The total fund is 1millions dollars USD
Calculate and report the total return, standard deviation, and Sharpe ratio of your portfolio on a weekly basis. The total fund is 1millions dollars USD
Stock ticker | Date | Quantity | Price |
NVDA | 29/04/2024 | 300 | 876.5 |
MSFT | 29/04/2024 | 350 | 405.95 |
AMZN | 29/04/2024 | 850 | 179.46 |
MA | 29/04/2024 | 269 | 462 |
NVDA | 30/04/2024 | 300 | 872.4 |
MSFT | 30/04/2024 | 350 | 401.49 |
AMZN | 30/04/2024 | 850 | 181.09 |
MA | 30/04/2024 | 269 | 456.26 |
APPL | 30/04/2024 | 500 | 173.33 |
TSLA | 30/04/2024 | 800 | 187.11 |
NVDA | 1/05/2024 | 300 | 864.2 |
MSFT | 1/05/2024 | 350 | 389.33 |
AMZN | 1/05/2024 | 850 | 175 |
MA | 1/05/2024 | 269 | 451.2 |
APPL | 1/05/2024 | 500 | 170.33 |
TSLA | 1/05/2024 | 800 | 183.28 |
NVDA | 2/05/2024 | 300 | 844.49 |
MSFT | 2/05/2024 | 350 | 397.66 |
AMZN | 2/05/2024 | 850 | 180.85 |
MA | 2/05/2024 | 269 | 443 |
APPL | 2/05/2024 | 500 | 172.51 |
TSLA | 2/05/2024 | 800 | 182.86 |
NVDA | 3/05/2024 | 300 | 887.89 |
MSFT | 3/05/2024 | 350 | 406.66 |
AMZN | 3/05/2024 | 850 | 186.21 |
MA | 3/05/2024 | 269 | 443.58 |
APPL | 3/05/2024 | 500 | 183.38 |
TSLA | 3/05/2024 | 800 | 181.19 |
Week 2 | |||
NVDA | 6/05/2024 | 300 | 921.4 |
MSFT | 6/05/2024 | 350 | 413.54 |
AMZN | 6/05/2024 | 850 | 188.7 |
MA | 6/05/2024 | 269 | 449.37 |
APPL | 6/05/2024 | 500 | 181.71 |
TSLA | 6/05/2024 | 800 | 184.76 |
NVDA | 7/05/2024 | 300 | 905.4 |
MSFT | 7/05/2024 | 350 | 409.34 |
AMZN | 7/05/2024 | 850 | 188.76 |
MA | 7/05/2024 | 269 | 453.06 |
APPL | 7/05/2024 | 500 | 182.4 |
TSLA | 7/05/2024 | 800 | 177.81 |
NVDA | 8/05/2024 | 300 | 905.29 |
MSFT | 8/05/2024 | 350 | 410.57 |
AMZN | 8/05/2024 | 850 | 188.88 |
MA | 8/05/2024 | 269 | 453.55 |
APPL | 8/05/2024 | 500 | 182.56 |
TSLA | 8/05/2024 | 800 | 175.01 |
NVDA | 9/05/2024 | 300 | 887.47 |
MSFT | 9/05/2024 | 350 | 412.32 |
AMZN | 9/05/2024 | 850 | 179.46 |
MA | 9/05/2024 | 269 | 445.49 |
APPL | 9/05/2024 | 500 | 184.57 |
TSLA | 9/05/2024 | 800 | 171.97 |
NVDA | 10/05/2024 | 300 | 902.99 |
MSFT | 10/05/2024 | 350 | 413.01 |
AMZN | 10/05/2024 | 850 | 189.45 |
MA | 10/05/2024 | 269 | 456.5 |
APPL | 10/05/2024 | 500 | 184.89 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started