[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: SP P/E data series



PureBytes Links

Trading Reference Links

Chris wrote:
> Here is one web site that has the yearly data. It is offered for free,

Thanks Chris.

> although you can't download it. I printed out the page and then inputed the
> data by hand into a spreadsheet a while ago.

Geez, that's the hard way. In Netscape, just save the page as plain
text. Open it in notepad and strip away all the extra descriptions, etc.
Then you can open it directly with excel as a space separated text file.
I've included space separated and comma separated formats below.

Space separated...

 Year   High    Low    Close
 1871                 11.61
 1872                 11.60
 1873                 10.50
 1874                 9.98
 1875                 12.27
 1876                 14.47
 1877                 10.47
 1878                 10.85
 1879                 10.95
 1880                 10.62
 1881                 14.06
 1882                 13.79
 1883                 14.20
 1884                 15.43
 1885                 17.04
 1886                 16.29
 1887                 15.29
 1888                 19.96
 1889                 17.92
 1890                 18.45
 1891                 14.97
 1892                 15.17
 1893                 18.08
 1894                 27.03
 1895                 18.48
 1896                 20.08
 1897                 14.53
 1898                 14.49
 1899                 13.05
 1900                 12.92
 1901                 15.75
 1902                 13.37
 1903                 13.48
 1904                 14.47
 1905                 13.39
 1906                 12.64
 1907                 11.82
 1908                 13.46
 1909                 12.71
 1910                 12.85
 1911                 15.63
 1912                 13.57
 1913                 13.44
 1914                 15.60
 1915                 9.46
 1916                 6.18
 1917                 6.62
 1918                 7.60
 1919                 9.41
 1920                 9.92
 1921                 23.70
 1922                 12.12
 1923                 8.79
 1924                 9.74
 1925                 8.94
 1926                 9.95
 1927                 13.21
 1928                 13.70
 1929                 16.05
 1930                 21.10
 1931                 33.67
 1932                 138.89
 1933                 29.59
 1934                 25.71
 1935 17.218  10.469  17.22
 1936 19.305  16.502  16.69
 1937 17.241  9.259   9.34
 1938 21.882  9.488   20.66
 1939 19.881  13.87   13.87
 1940 13.908  9.05    10.21
 1941 10.331  7.283   7.80
 1942 9.901   7.424   9.55
 1943 12.422  9.56    12.42
 1944 14.451  12.376  14.29
 1945 18.182  14.184  18.08
 1946 22.321  14.164  14.16
 1947 13.966  9.132   9.47
 1948 9.363   6.636   6.64
 1949 7.225   5.754   7.23
 1950 7.704   6.566   7.19
 1951 9.709   7.353   9.71
 1952 11.062  9.653   11.06
 1953 10.941  9.001   9.88
 1954 12.987  9.93    12.99
 1955 13.333  11.876  12.56
 1956 13.986  11.876  13.66
 1957 14.306  11.682  12.20
 1958 19.194  12.121  19.19
 1959 19.157  16.34   17.67
 1960 17.762  16      17.76
 1961 22.883  17.953  22.42
 1962 21.786  15.221  17.15
 1963 18.727  17.331  18.73
 1964 19.92   17.762  17.99
 1965 19.841  16.722  17.58
 1966 17.825  12.706  14.60
 1967 18.975  14.948  17.76
 1968 18.622  16.026  17.83
 1969 17.889  15.106  15.36
 1970 17.271  13.021  17.27
 1971 20.284  17.212  18.83
 1972 19.96   18.083  19.23
 1973 19.531  12.151  12.71
 1974 12.72   7.15    7.53
 1975 11.87   7.69    11.87
 1976 13.32   10.79   11.21
 1977 11.05   8.66    8.85
 1978 9.64    8.13    8.30
 1979 8.63    7.14    7.43
 1980 9.38    6.69    9.19
 1981 9.28    7.68    8.00
 1982 10.36   6.92    10.32
 1983 13.71   10.35   12.47
 1984 12.65   9.77    10.05
 1985 13.78   9.97    13.78
 1986 17.47   13.27   16.34
 1987 23.19   14.73   15.64
 1988 16.34   11.6    12.19
 1989 14.87   12.03   14.71
 1990 16.84   13.89   15.21
 1991 23.3    14.33   23.30
 1992 26.1    22.91   24.31
 1993 24.79   22.32   23.05
 1994 23.6    16.48   16.86
 1995 17.75   15.71   17.47
 1996 20.92   17.01   20.58
 1997 24.02   19.40   23.99

Comma separated...

Year,High,Low,Close
1871,,,11.61
1872,,,11.6
1873,,,10.5
1874,,,9.98
1875,,,12.27
1876,,,14.47
1877,,,10.47
1878,,,10.85
1879,,,10.95
1880,,,10.62
1881,,,14.06
1882,,,13.79
1883,,,14.2
1884,,,15.43
1885,,,17.04
1886,,,16.29
1887,,,15.29
1888,,,19.96
1889,,,17.92
1890,,,18.45
1891,,,14.97
1892,,,15.17
1893,,,18.08
1894,,,27.03
1895,,,18.48
1896,,,20.08
1897,,,14.53
1898,,,14.49
1899,,,13.05
1900,,,12.92
1901,,,15.75
1902,,,13.37
1903,,,13.48
1904,,,14.47
1905,,,13.39
1906,,,12.64
1907,,,11.82
1908,,,13.46
1909,,,12.71
1910,,,12.85
1911,,,15.63
1912,,,13.57
1913,,,13.44
1914,,,15.6
1915,,,9.46
1916,,,6.18
1917,,,6.62
1918,,,7.6
1919,,,9.41
1920,,,9.92
1921,,,23.7
1922,,,12.12
1923,,,8.79
1924,,,9.74
1925,,,8.94
1926,,,9.95
1927,,,13.21
1928,,,13.7
1929,,,16.05
1930,,,21.1
1931,,,33.67
1932,,,138.89
1933,,,29.59
1934,,,25.71
1935,17.218,10.469,17.22
1936,19.305,16.502,16.69
1937,17.241,9.259,9.34
1938,21.882,9.488,20.66
1939,19.881,13.87,13.87
1940,13.908,9.05,10.21
1941,10.331,7.283,7.8
1942,9.901,7.424,9.55
1943,12.422,9.56,12.42
1944,14.451,12.376,14.29
1945,18.182,14.184,18.08
1946,22.321,14.164,14.16
1947,13.966,9.132,9.47
1948,9.363,6.636,6.64
1949,7.225,5.754,7.23
1950,7.704,6.566,7.19
1951,9.709,7.353,9.71
1952,11.062,9.653,11.06
1953,10.941,9.001,9.88
1954,12.987,9.93,12.99
1955,13.333,11.876,12.56
1956,13.986,11.876,13.66
1957,14.306,11.682,12.2
1958,19.194,12.121,19.19
1959,19.157,16.34,17.67
1960,17.762,16,17.76
1961,22.883,17.953,22.42
1962,21.786,15.221,17.15
1963,18.727,17.331,18.73
1964,19.92,17.762,17.99
1965,19.841,16.722,17.58
1966,17.825,12.706,14.6
1967,18.975,14.948,17.76
1968,18.622,16.026,17.83
1969,17.889,15.106,15.36
1970,17.271,13.021,17.27
1971,20.284,17.212,18.83
1972,19.96,18.083,19.23
1973,19.531,12.151,12.71
1974,12.72,7.15,7.53
1975,11.87,7.69,11.87
1976,13.32,10.79,11.21
1977,11.05,8.66,8.85
1978,9.64,8.13,8.3
1979,8.63,7.14,7.43
1980,9.38,6.69,9.19
1981,9.28,7.68,8
1982,10.36,6.92,10.32
1983,13.71,10.35,12.47
1984,12.65,9.77,10.05
1985,13.78,9.97,13.78
1986,17.47,13.27,16.34
1987,23.19,14.73,15.64
1988,16.34,11.6,12.19
1989,14.87,12.03,14.71
1990,16.84,13.89,15.21
1991,23.3,14.33,23.3
1992,26.1,22.91,24.31
1993,24.79,22.32,23.05
1994,23.6,16.48,16.86
1995,17.75,15.71,17.47
1996,20.92,17.01,20.58
1997,24.02,19.4,23.99

-- 
   Dennis