Homework answers / question archive / 1) The file monthly

1) The file monthly

Finance

Share With

1. 1) The file monthly.csv contains monthly data of portfolio returns from the combined NYSE/AMEX/Nasdaq over the period 1926/1–2020/12. The first column is the date for the end of the month (in yyyymmdd format). The second column is the valueweighted market return, the third column is the equal-weighted market return. The 4th to 13th column are monthly returns from 10 size decile portfolios (sorted by market capitalization, from lowest to highest).
   1. Compute the average, standard deviation, 25th, 50th, and 75th percentiles basedon the monthly returns of the 12 portfolios.
   2. Compute the coefficients of skewness and (excess) kurtosis based on the monthlyreturns of the 12 portfolios. For each coefficient, perform a test of normality.
   3. Repeat the exercises in parts (a) and (b) but based on the returns for the monthof January as well as for the rest of year.
2. The file daily.csv contains daily data from the combined NYSE/AMEX/Nasdaq over the period 1926/1/2–2020/12/31. The first column is the date (in yyyymmdd format). The second column is the value-weighted market return, the third column is the equalweighted market return.
   1. Construct weekly return series using the daily data. The weekly return is computedas the return from Wednesday’s closing price to the following Wednesday’s close, with the following exceptions:
      • If the following Wednesday’s price is missing, the Thursday’s price (or Tuesday’s if Thursday’s is missing) is used.
      • If both Tuesday’s and Thursday’s prices are missing, the return for that week is reported as missing, and the return for the following week is a 2-week return.
   2. Compute the average, standard deviation, 25th, 50th, and 75th percentiles basedon the weekly returns of the two portfolios.
   3. Compute the coefficients of skewness and (excess) kurtosis based on the weeklyreturns of the two portfolios. For each coefficient, perform a test of normality.