Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Download the daily prices for the period January 1, 2000, to December 31, 2018, for the following stocks (these are the company names, and the
- Download the daily prices for the period January 1, 2000, to December 31, 2018, for the following stocks (these are the company names, and the stock identifiers, known as tickers, are in parenthesis, which is what you will need to use to download the data): Apple (AAPL), IBM (IBM), Microsoft (MSFT), Intel (INTC), Amazon (AMZN), and JPMorgan Chase & Co. (JPM).
- For each stock, calculate the daily simple return.
- For each stock, calculate the daily log return.
- For each stock, calculate the annual return (hint: this can be done in several ways, and you can check what happens when you download the data on a year-by-year basis).
2. Prepare a summary table, that for each stock will have the following information: mean, standard deviation, skewness and kurtosis – for the simple return, and for the log return. Thus, since there are 5 stocks, prepare a table that has a total of 8 rows, and 5 columns.
3. What is the daily return of the portfolio made up of these five stocks? What is the average, standard deviation, skewness and kurtosis of the portfolio return?
Step by Step Solution
★★★★★
3.43 Rating (153 Votes )
There are 3 Steps involved in it
Step: 1
1 Download the daily prices for the period January 1 2000 to December 31 2016 for the following stoc...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