正文

S&P数据(摘录)

(2019-10-01 20:50:27) 下一个
S&P 500 1%+ Drops to Start October        
Date  % Chg  Rest of Oct (%)  Rest of Year (%)  Next Year (%) Pos in Current Trend Pos in Shiller PE Ratio Critical High Critical Low  L/H (%)  H/L (%)
10/1/1931   (1.85)                       9.44                    (14.80)                (12.00) 5th Bot of 7 Down-Waves before Major Bottom 1929-09: 31.92 1932-07: 4.43      (86.12)  
10/2/1933   (1.03)                     (6.86)                         3.64                (18.50) 2nd Bot of 6 Up-Waves 1st Cor. after Major Bottom 1937-03: 18.68 1942-04: 7.55      (59.58)      321.67
10/1/1934   (2.75)                     (0.23)                         7.59                  57.14 3rd Bot of 6 Up-Waves 1st Cor. after Major Bottom 1946-05: 19.18 1949-06: 13.81      (28.00)      154.04
10/3/1955   (2.70)                     (0.35)                         7.04                  (0.02) Major Cor. at Top of Long Up 1st Cor. after Major Bottom 1956-07: 49.64 1957-12: 39.48      (20.47)      259.45
10/1/1956   (1.43)                       1.97                         4.41                  (6.75) Major Cor. at Top of Long Up before Major Cor. 1961-12: 72.01 1962-06: 52.68      (26.84)        82.40
10/1/1962   (1.39)                       1.86                       13.71                  16.37 1nd Bot of Up-Waves last Cor. before Major Top 1966-02: 93.81 1966-10: 73.20      (21.97)        78.08
10/3/1966   (2.17)                       7.08                         7.25                     6.50 Major Cor. In Mid of Long Up after Major Top 1968-11: 108.37 1970-05: 72.25      (33.33)        48.05
10/1/1975   (1.12)                       7.37                         8.75                     1.16 1st Bot of Long Up last Cor. before Major Bottom 1973-01: 120.71 1974-09: 62.34      (48.36)        67.07
10/1/1976   (1.02)                     (1.22)                         3.16                (12.53) 2nd Bot of Long Up last Cor. before Major Bottom 1980-11: 140.52 1982-08: 103.71      (26.20)      125.41
10/1/1998   (3.01)                     11.38                       24.62                  13.05 Major Cor. before Top of Long Up before Major Top 1987-08: 335.90 1987-11: 223.92      (33.34)      223.88
10/1/2009   (2.56)                       0.62                         8.28                  11.05 1st Bot of Long Up after Major Bottom 2000-03: 1527.46 2002-09: 800.58      (47.59)      582.15
10/3/2011   (2.85)                     14.02                       14.41                  15.20 2nd Bot of Long Up 1st Cor. after Major Bottom 2007-10: 1561.8 2009-03: 683.38      (56.24)        95.08
10/1/2014   (1.32)                       3.69                         5.79                  (6.00) Mid Cor. In Long Up last Cor. before Major Top 2019-07: 3025.86   #VALUE!      342.78
10/1/2019   (1.19)         after Major Top        
[ 打印 ]
阅读 ()评论 (1)
评论
dasan 回复 悄悄话 L/H (%) =100*(RIGHT(I3, LEN(I3)-9)/RIGHT(H3, LEN(H3)-9) - 1)
H/L (%) =100*(RIGHT(H4, LEN(H4)-9)/RIGHT(I3, LEN(I3)-9) - 1)
登录后才可评论.