September 1st, 2012, 2:00 pm
Yes, exactly. I have been looking for a good board question to illustrate the new built-in FinancialData in Mathematica.This is a good one. Some code that sorts returns by day of the week:Results: decade of the '90's:-------------------------------------------------------WeekdayStats["SP500",{1990,1,1},{1999,12,31}]Monday: mean(%) = 0.118567 std dev = 0.971239Tuesday: mean(%) = 0.0624191 std dev = 0.913289Wednesday: mean(%) = 0.0877446 std dev = 0.759541Thursday: mean(%) = -0.0294375 std dev = 0.896667Friday: mean(%) = 0.061481 std dev = 0.886581ndays=2527 daycounts={482,518,516,508,503}Overall mean=0.0596475 overall mean check=0.0596475Results: turn of the century to date:--------------------------------------------------------------WeekdayStats["SP500",{2000,1,1},{2012,8,30}]Monday: mean(%) = -0.00623899 std dev = 1.50773Tuesday: mean(%) = 0.052273 std dev = 1.41775Wednesday: mean(%) = -0.00468118 std dev = 1.32218Thursday: mean(%) = 0.043123 std dev = 1.36286Friday: mean(%) = -0.0461352 std dev = 1.18871ndays=3186 daycounts={597,653,655,643,638}Overall mean=0.00804684 overall mean check=0.00804684