Question
Download the spreadsheets containing the daily stock prices for General Electric , Microsoft , and Wal-Mart and the daily token prices for Bitcoin . Calculate
Download the spreadsheets containing the daily stock prices for General Electric, Microsoft, and Wal-Mart and the daily token prices for Bitcoin. Calculate daily returns over the period MM/DD/2016 to MM/DD/2017, where MM/DD corresponds to the month and day of your birthday. (If your birthday occurs on a weekend, be sure to include at least one daily price before and after your birthday.) Merge the returns for these four assets into a single Excel workbook with the returns for each one in a separate column, properly aligned by date.
*Please note before answering this question, I know this is a lot of work. I am looking for guidance in finishing this homework. If you give me sample of how to finish this I can do the rest. If you would like to finish all of it that is great as well. Thanks!
My birthday is January 15.
- Using the Excel functions for Average and Standard Deviation, calculate the average and standard deviation of returns for each asset.
- Using the Correlation function, construct the correlation matrix for the securities using the daily returns for the entire period.
- Which pair of assets has the highest correlation coefficient? The lowest?
- If you had to choose two assets for your portfolio, which pair would give you the greatest benefit with regard to diversification? Explain.
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