ABCDEFGHIJKLMNOPQRSTU
1
Shiller Data
Yahoo Finance Data
2
YearMonthFull DateS&P Composite Price (Monthly Avg)Annualized DividendImplied Monthly DividendCPIS&P 500 Month Closing Price
3
18711Jan-31-18714.44 0.26 0.02 12.46 Sources:
4
18712Feb-28-18714.50 0.26 0.02 12.84 Shiller
http://www.econ.yale.edu/~shiller/data.htm
5
18713Mar-31-18714.61 0.26 0.02 13.03 Yahoo finance
https://ca.finance.yahoo.com/quote/%5EGSPC/history?period1=-630961200&period2=1519880400&interval=1d&filter=history&frequency=1d
6
18714Apr-30-18714.74 0.26 0.02 12.56
7
18715May-31-18714.86 0.26 0.02 12.27 Notes:
8
18716Jun-30-18714.82 0.26 0.02 12.08
Shiller prices are monthly averages
9
18717Jul-31-18714.73 0.26 0.02 12.08
Shiller prices are S&P 500 from 1957 to present, and a composite of indices before 1957
10
18718Aug-31-18714.79 0.26 0.02 11.89
Closing price is as per Yahoo Finance from March-1-1950 and onwards
11
18719Sep-30-18714.84 0.26 0.02 12.18
12
187110Oct-31-18714.59 0.26 0.02 12.37
13
187111Nov-30-18714.64 0.26 0.02 12.37
14
187112Dec-31-18714.74 0.26 0.02 12.65
15
18721Jan-31-18724.86 0.26 0.02 12.65
16
18722Feb-28-18724.88 0.27 0.02 12.65
17
18723Mar-31-18725.04 0.27 0.02 12.84
18
18724Apr-30-18725.18 0.27 0.02 13.13
19
18725May-31-18725.18 0.28 0.02 13.13
20
18726Jun-30-18725.13 0.28 0.02 13.03
21
18727Jul-31-18725.10 0.28 0.02 12.84
22
18728Aug-31-18725.04 0.29 0.02 12.94
23
18729Sep-30-18724.95 0.29 0.02 13.03
24
187210Oct-31-18724.97 0.29 0.02 12.75
25
187211Nov-30-18724.95 0.30 0.02 13.13
26
187212Dec-31-18725.07 0.30 0.03 12.94
27
18731Jan-31-18735.11 0.30 0.03 12.94
28
18732Feb-28-18735.15 0.31 0.03 13.23
29
18733Mar-31-18735.11 0.31 0.03 13.23
30
18734Apr-30-18735.04 0.31 0.03 13.23
31
18735May-31-18735.05 0.31 0.03 12.94
32
18736Jun-30-18734.98 0.32 0.03 12.56
33
18737Jul-31-18734.97 0.32 0.03 12.56
34
18738Aug-31-18734.97 0.32 0.03 12.56
35
18739Sep-30-18734.59 0.32 0.03 12.56
36
187310Oct-31-18734.19 0.33 0.03 12.27
37
187311Nov-30-18734.04 0.33 0.03 11.89
38
187312Dec-31-18734.42 0.33 0.03 12.18
39
18741Jan-31-18744.66 0.33 0.03 12.37
40
18742Feb-28-18744.80 0.33 0.03 12.37
41
18743Mar-31-18744.73 0.33 0.03 12.37
42
18744Apr-30-18744.60 0.33 0.03 12.18
43
18745May-31-18744.48 0.33 0.03 12.08
44
18746Jun-30-18744.46 0.33 0.03 11.80
45
18747Jul-31-18744.46 0.33 0.03 11.89
46
18748Aug-31-18744.47 0.33 0.03 11.80
47
18749Sep-30-18744.54 0.33 0.03 11.80
48
187410Oct-31-18744.53 0.33 0.03 11.61
49
187411Nov-30-18744.57 0.33 0.03 11.51
50
187412Dec-31-18744.54 0.33 0.03 11.51
51
18751Jan-31-18754.54 0.33 0.03 11.51
52
18752Feb-28-18754.53 0.33 0.03 11.51
53
18753Mar-31-18754.59 0.32 0.03 11.51
54
18754Apr-30-18754.65 0.32 0.03 11.61
55
18755May-31-18754.47 0.32 0.03 11.32
56
18756Jun-30-18754.38 0.32 0.03 11.13
57
18757Jul-31-18754.39 0.31 0.03 11.13
58
18758Aug-31-18754.41 0.31 0.03 11.23
59
18759Sep-30-18754.37 0.31 0.03 11.13
60
187510Oct-31-18754.30 0.31 0.03 11.13
61
187511Nov-30-18754.37 0.30 0.03 11.04
62
187512Dec-31-18754.37 0.30 0.03 10.94
63
18761Jan-31-18764.46 0.30 0.03 10.85
64
18762Feb-28-18764.52 0.30 0.03 10.85
65
18763Mar-31-18764.51 0.30 0.03 10.85
66
18764Apr-30-18764.34 0.30 0.03 10.75
67
18765May-31-18764.18 0.30 0.03 10.37
68
18766Jun-30-18764.15 0.30 0.03 10.09
69
18767Jul-31-18764.10 0.30 0.03 10.09
70
18768Aug-31-18763.93 0.30 0.03 10.18
71
18769Sep-30-18763.69 0.30 0.03 10.28
72
187610Oct-31-18763.67 0.30 0.03 10.47
73
187611Nov-30-18763.60 0.30 0.03 10.56
74
187612Dec-31-18763.58 0.30 0.03 10.75
75
18771Jan-31-18773.55 0.29 0.02 10.94
76
18772Feb-28-18773.34 0.28 0.02 10.66
77
18773Mar-31-18773.17 0.27 0.02 10.18
78
18774Apr-30-18772.94 0.26 0.02 10.47
79
18775May-31-18772.94 0.25 0.02 10.66
80
18776Jun-30-18772.73 0.25 0.02 10.09
81
18777Jul-31-18772.85 0.24 0.02 10.18
82
18778Aug-31-18773.05 0.23 0.02 9.80
83
18779Sep-30-18773.24 0.22 0.02 9.70
84
187710Oct-31-18773.31 0.21 0.02 9.70
85
187711Nov-30-18773.26 0.20 0.02 9.51
86
187712Dec-31-18773.25 0.19 0.02 9.51
87
18781Jan-31-18783.25 0.19 0.02 9.23
88
18782Feb-28-18783.18 0.19 0.02 9.13
89
18783Mar-31-18783.24 0.19 0.02 8.94
90
18784Apr-30-18783.33 0.19 0.02 8.85
91
18785May-31-18783.34 0.19 0.02 8.56
92
18786Jun-30-18783.41 0.19 0.02 8.37
93
18787Jul-31-18783.48 0.18 0.02 8.47
94
18788Aug-31-18783.45 0.18 0.02 8.56
95
18789Sep-30-18783.52 0.18 0.02 8.56
96
187810Oct-31-18783.48 0.18 0.02 8.47
97
187811Nov-30-18783.47 0.18 0.02 8.37
98
187812Dec-31-18783.45 0.18 0.02 8.18
99
18791Jan-31-18793.58 0.18 0.02 8.28
100
18792Feb-28-18793.71 0.18 0.02 8.37