Spreadsheet: 83578d1283535451-highlighting-in-excel-chart-excel_pe
Sheet: Sheet1

Date | [NAME] (L1) | '--- Cur P/E (R1) | Recession
2010-09-03 00:00:00 | 1101.55 | 14.6284 | 1
2010-08-31 00:00:00 | 1049.33 | 14.6284 | 1
2010-07-31 00:00:00 | 1101.6 | 14.6284 | 1
2010-06-30 00:00:00 | 1030.71 | 14.6284 | 1
2010-05-31 00:00:00 | 1089.41 | 14.6284 | 1
2010-04-30 00:00:00 | 1186.6899 | 14.6284 | 1
2010-03-31 00:00:00 | 1169.4301 | 14.6284 | 1
2010-02-28 00:00:00 | 1104.49 | 14.6284 | 1
2010-01-31 00:00:00 | 1073.87 | 14.6284 | 1
2009-12-31 00:00:00 | 1115.1 | 14.6284 | 1
2009-11-30 00:00:00 | 1095.63 | 14.6284 | 1
2009-10-31 00:00:00 | 1036.1899 | 14.6284 | 1
2009-09-30 00:00:00 | 1057.08 | 14.6284 | 1
2009-08-31 00:00:00 | 1020.62 | 14.6284 | 1
2009-07-31 00:00:00 | 987.48 | 14.6284 | 1
2009-06-30 00:00:00 | 919.32 | 14.6284 | 1
2009-05-31 00:00:00 | 919.14 | 14.6284 | 1
2009-04-30 00:00:00 | 872.81 | 14.6284 | 1
2009-03-31 00:00:00 | 797.87 | 14.6284 | 1
2009-02-28 00:00:00 | 735.09 | 14.6284 | 1
2009-01-31 00:00:00 | 825.88 | 14.6284 | 1
2008-12-31 00:00:00 | 903.25 | 14.6284 | 1
2008-11-30 00:00:00 | 896.24 | 14.6284 | 1
2008-10-31 00:00:00 | 968.75 | 14.6284 | 1
2008-09-30 00:00:00 | 1166.36 | 14.6284 | 1
2008-08-31 00:00:00 | 1282.83 | 14.6284 | 1
2008-07-31 00:00:00 | 1267.38 | 14.6284 | 1
2008-06-30 00:00:00 | 1280 | 14.6284 | 1
2008-05-31 00:00:00 | 1400.38 | 14.6284 | 1
2008-04-30 00:00:00 | 1385.59 | 14.6284 | 1
2008-03-31 00:00:00 | 1322.7 | 14.6284 | 1
2008-02-29 00:00:00 | 1330.63 | 14.6284 | 1
2008-01-31 00:00:00 | 1378.55 | 14.6284 | 1
2007-12-31 00:00:00 | 1468.36 | 14.6284 | 1
2007-11-30 00:00:00 | 1481.14 | 14.6284
2007-10-31 00:00:00 | 1549.38 | 14.6284
2007-09-30 00:00:00 | 1526.75 | 14.6284
2007-08-31 00:00:00 | 1473.99 | 14.6284
2007-07-31 00:00:00 | 1455.27 | 14.6284
2007-06-30 00:00:00 | 1503.35 | 14.6284
2007-05-31 00:00:00 | 1530.62 | 14.6284
2007-04-30 00:00:00 | 1482.37 | 14.6284
2007-03-31 00:00:00 | 1420.86 | 14.6284
2007-02-28 00:00:00 | 1406.8199 | 14.6284
2007-01-31 00:00:00 | 1438.24 | 14.6284
2006-12-31 00:00:00 | 1418.3 | 14.6284
2006-11-30 00:00:00 | 1400.63 | 14.6284
2006-10-31 00:00:00 | 1377.9399 | 14.6284
2006-09-30 00:00:00 | 1335.85 | 14.6284
2006-08-31 00:00:00 | 1303.8199 | 14.6284
2006-07-31 00:00:00 | 1276.66 | 14.6284
2006-06-30 00:00:00 | 1270.2 | 14.6284
2006-05-31 00:00:00 | 1270.09 | 14.6284
2006-04-30 00:00:00 | 1310.61 | 14.6284
2006-03-31 00:00:00 | 1294.83 | 14.6284
2006-02-28 00:00:00 | 1280.66 | 14.6284
2006-01-31 00:00:00 | 1280.08 | 14.6284
2005-12-31 00:00:00 | 1248.29 | 14.6284
2005-11-30 00:00:00 | 1249.48 | 14.6284
2005-10-31 00:00:00 | 1207.01 | 14.6284
2005-09-30 00:00:00 | 1228.8101 | 14.6284
2005-08-31 00:00:00 | 1220.33 | 14.6284
2005-07-31 00:00:00 | 1234.1801 | 14.6284
2005-06-30 00:00:00 | 1191.33 | 14.6284
2005-05-31 00:00:00 | 1191.5 | 14.6284
2005-04-30 00:00:00 | 1156.85 | 14.6284
2005-03-31 00:00:00 | 1180.59 | 14.6284
2005-02-28 00:00:00 | 1203.6 | 14.6284
2005-01-31 00:00:00 | 1181.27 | 14.6284
2004-12-31 00:00:00 | 1211.92 | 14.6284
2004-11-30 00:00:00 | 1173.8199 | 14.6284
2004-10-31 00:00:00 | 1130.2 | 14.6284
2004-09-30 00:00:00 | 1114.58 | 14.6284
2004-08-31 00:00:00 | 1104.24 | 14.6284
2004-07-31 00:00:00 | 1101.72 | 14.6284
2004-06-30 00:00:00 | 1140.84 | 14.6284
2004-05-31 00:00:00 | 1120.6801 | 14.6284
2004-04-30 00:00:00 | 1107.3 | 14.6284
2004-03-31 00:00:00 | 1126.21 | 14.6284
2004-02-29 00:00:00 | 1144.9399 | 14.6284
2004-01-31 00:00:00 | 1131.13 | 14.6284
2003-12-31 00:00:00 | 1111.92 | 14.6284
2003-11-30 00:00:00 | 1058.2 | 14.6284
2003-10-31 00:00:00 | 1050.71 | 14.6284
2003-09-30 00:00:00 | 995.97 | 14.6284
2003-08-31 00:00:00 | 1008.01 | 14.6284
2003-07-31 00:00:00 | 990.31 | 14.6284
2003-06-30 00:00:00 | 974.5 | 14.6284
2003-05-31 00:00:00 | 963.59 | 14.6284
2003-04-30 00:00:00 | 916.92 | 14.6284
2003-03-31 00:00:00 | 848.18 | 14.6284
2003-02-28 00:00:00 | 841.15 | 14.6284
2003-01-31 00:00:00 | 855.7 | 14.6284
2002-12-31 00:00:00 | 879.82 | 14.6284
2002-11-30 00:00:00 | 936.31 | 14.6284
2002-10-31 00:00:00 | 885.76 | 14.6284
2002-09-30 00:00:00 | 815.28 | 14.6284
2002-08-31 00:00:00 | 916.07 | 14.6284
2002-07-31 00:00:00 | 911.62 | 14.6284
2002-06-30 00:00:00 | 989.82 | 14.6284
2002-05-31 00:00:00 | 1067.14 | 14.6284
2002-04-30 00:00:00 | 1076.92 | 14.6284
2002-03-31 00:00:00 | 1147.39 | 14.6284
2002-02-28 00:00:00 | 1106.73 | 14.6284
2002-01-31 00:00:00 | 1130.2 | 14.6284
2001-12-31 00:00:00 | 1148.08 | 14.6284
2001-11-30 00:00:00 | 1139.45 | 14.6284 | 1
2001-10-31 00:00:00 | 1059.78 | 14.6284 | 1
2001-09-30 00:00:00 | 1040.9399 | 14.6284 | 1
2001-08-31 00:00:00 | 1133.58 | 14.6284 | 1
2001-07-31 00:00:00 | 1211.23 | 14.6284 | 1
2001-06-30 00:00:00 | 1224.42 | 14.6284 | 1
2001-05-31 00:00:00 | 1255.8199 | 14.6284 | 1
2001-04-30 00:00:00 | 1249.46 | 14.6284 | 1
2001-03-31 00:00:00 | 1160.33 | 14.6284 | 1
2001-02-28 00:00:00 | 1239.9399 | 14.6284
2001-01-31 00:00:00 | 1366.01 | 14.6284
2000-12-31 00:00:00 | 1320.28 | 14.6284
2000-11-30 00:00:00 | 1314.95 | 14.6284
2000-10-31 00:00:00 | 1429.4 | 14.6284
2000-09-30 00:00:00 | 1436.51 | 14.6284
2000-08-31 00:00:00 | 1517.6801 | 14.6284
2000-07-31 00:00:00 | 1430.83 | 14.6284
2000-06-30 00:00:00 | 1454.6 | 14.6284
2000-05-31 00:00:00 | 1420.6 | 14.6284
2000-04-30 00:00:00 | 1452.4301 | 14.6284
2000-03-31 00:00:00 | 1498.58 | 14.6284
2000-02-29 00:00:00 | 1366.42 | 14.6284
2000-01-31 00:00:00 | 1394.46 | 14.6284
1999-12-31 00:00:00 | 1469.25 | 14.6284
1999-11-30 00:00:00 | 1388.91 | 14.6284
1999-10-31 00:00:00 | 1362.9301 | 14.6284
1999-09-30 00:00:00 | 1282.71 | 14.6284
1999-08-31 00:00:00 | 1320.41 | 14.6284
1999-07-31 00:00:00 | 1328.72 | 14.6284
1999-06-30 00:00:00 | 1372.71 | 14.6284
1999-05-31 00:00:00 | 1301.84 | 14.6284
1999-04-30 00:00:00 | 1335.1801 | 14.6284
1999-03-31 00:00:00 | 1286.37 | 14.6284
1999-02-28 00:00:00 | 1238.33 | 14.6284
1999-01-31 00:00:00 | 1279.64 | 14.6284
1998-12-31 00:00:00 | 1229.23 | 14.6284
1998-11-30 00:00:00 | 1163.63 | 14.6284
1998-10-31 00:00:00 | 1098.67 | 14.6284
1998-09-30 00:00:00 | 1017.01 | 14.6284
1998-08-31 00:00:00 | 957.28 | 14.6284
1998-07-31 00:00:00 | 1120.67 | 14.6284
1998-06-30 00:00:00 | 1133.84 | 14.6284
1998-05-31 00:00:00 | 1090.8199 | 14.6284
1998-04-30 00:00:00 | 1111.75 | 14.6284
1998-03-31 00:00:00 | 1101.75 | 14.6284
1998-02-28 00:00:00 | 1049.34 | 14.6284
1998-01-31 00:00:00 | 980.28 | 14.6284
1997-12-31 00:00:00 | 970.43 | 14.6284
1997-11-30 00:00:00 | 955.4 | 14.6284
1997-10-31 00:00:00 | 914.62 | 14.6284
1997-09-30 00:00:00 | 947.28 | 14.6284
1997-08-31 00:00:00 | 899.47 | 14.6284
1997-07-31 00:00:00 | 954.29 | 14.6284
1997-06-30 00:00:00 | 885.14 | 14.6284
1997-05-31 00:00:00 | 848.28 | 14.6284
1997-04-30 00:00:00 | 801.34 | 14.6284
1997-03-31 00:00:00 | 757.12 | 14.6284
1997-02-28 00:00:00 | 790.82 | 14.6284
1997-01-31 00:00:00 | 786.16 | 14.6284
1996-12-31 00:00:00 | 740.74 | 14.6284
1996-11-30 00:00:00 | 757.02 | 14.6284
1996-10-31 00:00:00 | 705.27 | 14.6284
1996-09-30 00:00:00 | 687.31 | 14.6284
1996-08-31 00:00:00 | 651.99 | 14.6284
1996-07-31 00:00:00 | 639.95 | 14.6284
1996-06-30 00:00:00 | 670.63 | 14.6284
1996-05-31 00:00:00 | 669.12 | 14.6284
1996-04-30 00:00:00 | 654.17 | 14.6284
1996-03-31 00:00:00 | 645.5 | 14.6284
1996-02-29 00:00:00 | 640.43 | 14.6284
1996-01-31 00:00:00 | 636.02 | 14.6284
1995-12-31 00:00:00 | 615.93 | 14.6284
1995-11-30 00:00:00 | 605.37 | 14.6284
1995-10-31 00:00:00 | 581.5 | 14.6284
1995-09-30 00:00:00 | 584.41 | 14.6284
1995-08-31 00:00:00 | 561.88 | 14.6284
1995-07-31 00:00:00 | 562.06 | 14.6284
1995-06-30 00:00:00 | 544.75 | 14.6284
1995-05-31 00:00:00 | 533.4 | 14.6284
1995-04-30 00:00:00 | 514.71 | 14.6284
1995-03-31 00:00:00 | 500.71 | 14.6284
1995-02-28 00:00:00 | 487.39 | 14.6284
1995-01-31 00:00:00 | 470.42 | 14.6284
1994-12-31 00:00:00 | 459.27 | 14.6284
1994-11-30 00:00:00 | 453.69 | 14.6284
1994-10-31 00:00:00 | 472.35 | 14.6284
1994-09-30 00:00:00 | 462.71 | 14.6284
1994-08-31 00:00:00 | 475.5 | 14.6284
1994-07-31 00:00:00 | 458.26 | 14.6284
1994-06-30 00:00:00 | 444.27 | 14.6284
1994-05-31 00:00:00 | 456.51 | 14.6284
1994-04-30 00:00:00 | 450.91 | 14.6284
1994-03-31 00:00:00 | 445.77 | 14.6284
1994-02-28 00:00:00 | 467.1399 | 14.6284
1994-01-31 00:00:00 | 481.6099 | 14.6284
1993-12-31 00:00:00 | 466.45 | 14.6284
1993-11-30 00:00:00 | 461.7898 | 14.6284
1993-10-31 00:00:00 | 467.8298 | 14.6284
1993-09-30 00:00:00 | 458.9299 | 14.6284
1993-08-31 00:00:00 | 463.5598 | 14.6284
1993-07-31 00:00:00 | 448.1299 | 14.6284
1993-06-30 00:00:00 | 450.5298 | 14.6284
1993-05-31 00:00:00 | 450.1899 | 14.6284
1993-04-30 00:00:00 | 440.1899 | 14.6284
1993-03-31 00:00:00 | 451.6699 | 14.6284
1993-02-28 00:00:00 | 443.3799 | 14.6284
1993-01-31 00:00:00 | 438.7798 | 14.6284
1992-12-31 00:00:00 | 435.71 | 14.6284
1992-11-30 00:00:00 | 431.3499 | 14.6284
1992-10-31 00:00:00 | 418.6799 | 14.6284
1992-09-30 00:00:00 | 417.7998 | 14.6284
1992-08-31 00:00:00 | 414.0298 | 14.6284
1992-07-31 00:00:00 | 424.22 | 14.6284
1992-06-30 00:00:00 | 408.1399 | 14.6284
1992-05-31 00:00:00 | 415.3499 | 14.6284
1992-04-30 00:00:00 | 414.95 | 14.6284
1992-03-31 00:00:00 | 403.6899 | 14.6284
1992-02-29 00:00:00 | 412.7 | 14.6284
1992-01-31 00:00:00 | 408.79 | 14.6284
1991-12-31 00:00:00 | 417.0901 | 14.6284
1991-11-30 00:00:00 | 375.22 | 14.6284
1991-10-31 00:00:00 | 392.45 | 14.6284
1991-09-30 00:00:00 | 387.8601 | 14.6284
1991-08-31 00:00:00 | 395.4299 | 14.6284
1991-07-31 00:00:00 | 387.8101 | 14.6284
1991-06-30 00:00:00 | 371.1599 | 14.6284
1991-05-31 00:00:00 | 389.8301 | 14.6284
1991-04-30 00:00:00 | 375.3398 | 14.6284
1991-03-31 00:00:00 | 375.22 | 14.6284 | 1
1991-02-28 00:00:00 | 367.0701 | 14.6284 | 1
1991-01-31 00:00:00 | 343.9299 | 14.6284 | 1
1990-12-31 00:00:00 | 330.22 | 14.6284 | 1
1990-11-30 00:00:00 | 322.22 | 14.6284 | 1
1990-10-31 00:00:00 | 304 | 14.6284 | 1
1990-09-30 00:00:00 | 306.0498 | 14.6284 | 1
1990-08-31 00:00:00 | 322.5601 | 14.6284 | 1
1990-07-31 00:00:00 | 356.1499 | 14.6284 | 1
1990-06-30 00:00:00 | 358.02 | 14.6284
1990-05-31 00:00:00 | 361.23 | 14.6284
1990-04-30 00:00:00 | 330.8 | 14.6284
1990-03-31 00:00:00 | 339.9399 | 14.6284
1990-02-28 00:00:00 | 331.8899 | 14.6284
1990-01-31 00:00:00 | 329.0801 | 14.6284