Home /
Expert Answers /
Finance /
2-calendar-anomalies-3-points-total-a-download-the-adjusted-closing-prices-for-s-p-500-month-pa539
(Solved): 2. Calendar Anomalies ( 3 points total) a) Download the adjusted closing prices for S\&P 500 month ...
2. Calendar Anomalies ( 3 points total) a) Download the adjusted closing prices for S\&P 500 monthly from 12/1927 to most recent. Compute monthly returns based on the adjusted closing prices. (If you use Yahoo for return data, see my note on the solution template regarding Yahoo's labeling of dates) b) Construct a table of monthly average returns (use arithmetic average) for each month of the year, similar to the example on the slide deck. Repeat this for the S\&P for 1) 1927-1997 and 2) 1998-most recent time periods. Also repeat this for Russell 2000 for the most recent time period from 1998 onwards. c) Is there a January effect? What might explain the difference in the month effect between the first part of the sample and the second part of the sample? d) Compute average returns for each weekday for SPY and Russell 2000 e) Is there a weekday effect in either index? What might explain the weekday effect?