S&P 500 Yearly returns in %
|
The Year Return Indicator calculates the yearly performance in percent of any price or data series.
The results are saved in ASCII format to an user specified file for further processing.
Below is an example of the S&P 500. The calculations requires correct formatted date fields, YYYYMMDD (ex. 20071231).
|
|
Ticker |
Year |
First Close |
Last Close |
Year return |
|
^GSPC |
1950 |
0 |
20.43 |
0 |
|
^GSPC |
1951 |
20.77 |
23.77 |
14.44 |
|
^GSPC |
1952 |
23.8 |
26.57 |
11.64 |
|
^GSPC |
1953 |
26.54 |
24.81 |
-6.52 |
|
^GSPC |
1954 |
24.95 |
35.98 |
44.21 |
|
^GSPC |
1955 |
36.75 |
45.48 |
23.76 |
|
^GSPC |
1956 |
45.16 |
46.67 |
3.34 |
|
^GSPC |
1957 |
46.2 |
39.99 |
-13.44 |
|
^GSPC |
1958 |
40.33 |
55.21 |
36.9 |
|
^GSPC |
1959 |
55.44 |
59.89 |
8.03 |
|
^GSPC |
1960 |
59.91 |
58.11 |
-3 |
|
^GSPC |
1961 |
57.57 |
71.55 |
24.28 |
|
^GSPC |
1962 |
70.96 |
63.1 |
-11.08 |
|
^GSPC |
1963 |
62.69 |
75.02 |
19.67 |
|
^GSPC |
1964 |
75.43 |
84.75 |
12.36 |
|
^GSPC |
1965 |
84.23 |
92.43 |
9.74 |
|
^GSPC |
1966 |
92.18 |
80.33 |
-12.86 |
|
^GSPC |
1967 |
80.38 |
96.47 |
20.02 |
|
^GSPC |
1968 |
96.11 |
103.86 |
8.06 |
|
^GSPC |
1969 |
103.93 |
92.06 |
-11.42 |
|
^GSPC |
1970 |
93 |
92.15 |
-0.91 |
|
^GSPC |
1971 |
91.15 |
102.09 |
12 |
|
^GSPC |
1972 |
101.67 |
118.05 |
16.11 |
|
^GSPC |
1973 |
119.1 |
97.55 |
-18.09 |
|
^GSPC |
1974 |
97.68 |
68.56 |
-29.81 |
|
^GSPC |
1975 |
70.23 |
90.19 |
28.42 |
|
^GSPC |
1976 |
90.9 |
107.46 |
18.22 |
|
^GSPC |
1977 |
107 |
95.1 |
-11.12 |
|
^GSPC |
1978 |
93.82 |
96.11 |
2.44 |
|
^GSPC |
1979 |
96.73 |
107.94 |
11.59 |
|
^GSPC |
1980 |
105.76 |
135.76 |
28.37 |
|
^GSPC |
1981 |
136.34 |
122.55 |
-10.11 |
|
^GSPC |
1982 |
122.74 |
140.64 |
14.58 |
|
^GSPC |
1983 |
138.34 |
164.93 |
19.22 |
|
^GSPC |
1984 |
164.04 |
167.24 |
1.95 |
|
^GSPC |
1985 |
165.37 |
211.28 |
27.76 |
|
^GSPC |
1986 |
209.59 |
242.17 |
15.54 |
|
^GSPC |
1987 |
246.45 |
247.08 |
0.26 |
|
^GSPC |
1988 |
255.94 |
277.72 |
8.51 |
|
^GSPC |
1989 |
275.31 |
353.4 |
28.36 |
|
^GSPC |
1990 |
359.69 |
330.22 |
-8.19 |
|
^GSPC |
1991 |
326.45 |
417.09 |
27.77 |
|
^GSPC |
1992 |
417.26 |
435.71 |
4.42 |
|
^GSPC |
1993 |
435.38 |
466.45 |
7.14 |
|
^GSPC |
1994 |
465.44 |
459.27 |
-1.33 |
|
^GSPC |
1995 |
459.11 |
615.93 |
34.16 |
|
^GSPC |
1996 |
620.73 |
740.74 |
19.33 |
|
^GSPC |
1997 |
737.01 |
970.43 |
31.67 |
|
^GSPC |
1998 |
975.04 |
1229.23 |
26.07 |
|
^GSPC |
1999 |
1228.1 |
1469.25 |
19.64 |
|
^GSPC |
2000 |
1455.22 |
1320.28 |
-9.27 |
|
^GSPC |
2001 |
1283.27 |
1148.08 |
-10.53 |
|
^GSPC |
2002 |
1154.67 |
879.82 |
-23.8 |
|
^GSPC |
2003 |
909.03 |
1111.92 |
22.32 |
|
^GSPC |
2004 |
1108.48 |
1211.92 |
9.33 |
|
^GSPC |
2005 |
1202.08 |
1248.29 |
3.84 |
|
^GSPC |
2006 |
1268.8 |
1418.3 |
11.78 |
|
^GSPC |
|
1416.6 |
1467.95 |
3.62 |