Please, follow the instruction for essay. 1. Go to finance.yahoo.com to download
ID: 2634733 • Letter: P
Question
Please, follow the instruction for essay.
1. Go to finance.yahoo.com to download the daily historical prices for S&P 500 index, from January 1st 2003 to December 31st 2013.
2. Calculate the daily returns before and after the Thanksgivings holidays for all the years, using the closing prices.
3.Based on the sample results, provide a short anecdotal conclusion regarding the effect of the Thanksgiving holiday on the index return
*Before Thanksg Daily Return = (Wednesday Close Price - Tuesday Close Price)/Tuesday Close Price
After Thanksg Daily Return = (Friday Close Price - Wednesday Close Price)/Wednesday Close Price
*Compare these two daily returns each year, and write down any patterns you observed over 10 years, such as one was (always or most of the time) higher than the other and etc. If you like (not required), throw in a few lines guessing what may have caused these patterns?
Explanation / Answer
The above table shows calculations for after thanksgiving.
A time when people are more emotional than rational. People become more optimistic.
-0.01498
This table shows daily returns before thanksgiving.
2003 0.000236194 0.023619 2004 -0.00075311 -0.07531 2005 -0.00208595 -0.2086 2006 0.003655527 0.365553 2007 -0.01689053 -1.68905 2008 -0.00964311 -0.96431 2009 0.017233462 1.723346 2010 0.007468603 0.74686 2011 0.002685511 0.268551 2012 -0.01302632 -1.30263 2013 0.000796791 0.079679