剔出CPI的黄金价格(1971-2012).xls

DateCPI US CPI Annuel Percent Change Gold Price Gold Price CPI RoR Gold RoR Gold CPI 197140 51 000000 41 17 41 17 197241 81 0320993 2 59 00 57 1743 31 38 85 197344 41 0962966 2 97 84 89 2565 83 56 12 197449 31 21728411 0 158 96 130 5962 47 46 32 197553 81 3283959 1 160 91 121 131 23 7 24 197656 91 4049385 8 124 71 88 77 22 50 26 72 197760 61 4962966 5 147 78 98 7618 50 11 26 197865 21 6098777 6 193 39 120 1330 86 21 63 197972 61 79259311 3 304 83 170 0557 62 41 56 198082 42 03456813 5 614 61 302 08101 62 77 64 198190 92 24444410 3 459 26 204 62 25 28 32 26 198296 52 3827166 2 375 28 157 50 18 29 23 03 198399 62 4592593 2 423 61 172 2512 88 9 37 1984103 92 5654324 3 360 50 140 52 14 90 18 42 1985107 62 6567903 6 317 18 119 38 12 02 15 04 1986109 62 7061731 9 367 72 135 8815 93 13 82 1987113 62 8049383 6 446 28 159 1121 36 17 09 1988118 32 9209884 1 436 79 149 54 2 13 6 01 1989124 03 0617284 8 380 74 124 35 12 83 16 84 1990130 73 2271605 4 383 32 118 780 68 4 48 1991136 23 3629634 2 362 10 107 67 5 54 9 35 1992140 33 4641983 0 343 86 99 26 5 04 7 81 1993144 53 5679013 0 360 00 100 904 69 1 65 1994148 23 6592592 6 384 12 104 976 70 4 04 1995152 43 7629632 8 384 05 102 06 0 02 2 77 1996156 93 8740743 0 387 82 100 110 98 1 91 1997160 53 9629632 3 330 98 83 52 14 66 16 57 1998163 04 0246911 6 294 12 73 08 11 14 12 50 1999166 64 1135802 2 278 55 67 71 5 29 7 34 2000172 24 2518523 4 279 10 65 640 20 3 06 2001177 14 3728402 8 272 67 62 36 2 30 5 01 2002179 94 4419751 6 309 66 69 7113 57 11 80 2003184 04 5432102 3 362 91 79 8817 20 14 58 2004188 94 6641982 7 409 17 87 7312 75 9 82 2005195 34 8222223 4 444 47 92 178 63 5 07 2006201 64 9777783 2 603 95 121 3335 88 31 63 2007207 35 1195562 8 695 39 135 8315 14 11 95 2008215 35 3161233 8 871 65 163 9625 35 20 71 2009214 55 297210 0 4 972 90 183 6611 62 12 01 2010218 15 3840991 6 1 224 52 227 4325 86 23 83 2011224 95 5540493 2 1 565 81 281 9227 87 23 96 2012229 65 6689882 1 1 674 32 295 356 93 4 76 G Go ol ld d P Pr ri ic ce e 1971 1973 1975 1977 1979 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 2011 0 00 200 00 400 00 600 00 800 00 1 000 00 1 200 00 1 400 00 1 600 00 1 800 00 Gold Price C CP PI I P Pe er rc ce en nt ta ag ge e 1972 1974 1976 1978 1980 1982 1984 1986 1988 1990 1992 1994 1996 1998 2000 2002 2004 2006 2008 2010 2012 2 0 0 0 2 0 4 0 6 0 8 0 10 0 12 0 14 0 16 0 Date CPI CPI Percentage G Go ol ld d P Pr ri ic ce e C CP PI I 1971 1973 1975 1977 1979 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 2011 0 00 50 00 100 00 150 00 200 00 250 00 300 00 350 00 Gold Price CPI R Ro oR R G Go ol ld d 1971 1973 1975 1977 1979 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 2011 40 00 20 00 0 00 20 00 40 00 60 00 80 00 100 00 120 00 RoR Gold G Go ol ld d P Pr ri ic ce e 1971 1973 1975 1977 1979 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 2011 0 00 200 00 400 00 600 00 800 00 1 000 00 1 200 00 1 400 00 1 600 00 1 800 00 Gold Price 1 设定美国1982 1984年3年CPI的均值为100 2 设定1971年美国CPI指数为报告中所用CPI数据的基期 3 黄金价格为年度平均价格 计量办法不同 数据间可能存在一定误差 4 黄金自1971年至2012年 算术平均回报率为11 9693 5 黄金自1971年至2012年 剔除CPI之后的算术平均回报率为7 1490 6 以1971年为基期 2012年末的黄金价格为295 35美元 王东阳 wangdongyang BGCN Gold Research R Ro oR R G Go ol ld d C CP PI I 1971 1973 1975 1977 1979 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 2011 40 00 20 00 0 00 20 00 40 00 60 00 80 00 100 00 RoR Gold CPI 1971 1973 1975 1977 1979 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 2011 0 00 200 00 400 00 600 00 800 00 1 000 00 1 200 00 1 400 00 1 600 00 1 800 00 Gold PriceGold Price CPI R Ro oR R G Go ol ld d 1971 1973 1975 1977 1979 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 2011 40 00 20 00 0 00 20 00 40 00 60 00 80 00 100 00 120 00 RoR Gold G Go ol ld d P Pr ri ic ce e 1971 1973 1975 1977 1979 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 2011 0 00 200 00 400 00 600 00 800 00 1 000 00 1 200 00 1 400 00 1 600 00 1 800 00 Gold Price G Go ol ld d P Pr ri ic ce e 1971 1973 1975 1977 1979 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 2011 0 00 200 00 400 00 600 00 800 00 1 000 00 1 200 00 1 400 00 1 600 00 1 800 00 Gold Price C CP PI I P Pe er rc ce en nt ta ag ge e 1972 1974 1976 1978 1980 1982 1984 1986 1988 1990 1992 1994 1996 1998 2000 2002 2004 2006 2008 2010 2012 2 0 0 0 2 0 4 0 6 0 8 0 10 0 12 0 14 0 16 0 Date CPI CPI Percentage G Go ol ld d P Pr ri ic ce e C CP PI I 1971 1973 1975 1977 1979 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 2011 0 00 50 00 100 00 150 00 200 00 250 00 300 00 350 00 Gold Price CPI R Ro oR R G Go ol ld d 1971 1973 1975 1977 1979 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 2011 40 00 20 00 0 00 20 00 40 00 60 00 80 00 100 00 120 00 RoR Gold R Ro oR R G Go ol ld d 1971 1973 1975 1977 1979 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 2011 40 00 20 00 0 00 20 00 40 00 60 00 80 00 100 00 120 00 RoR Gold R Ro oR R G Go ol ld d C CP PI I 1971 1973 1975 1977 1979 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 20