1990-2010上证指数市盈率市净率等.xls

市盈率(整体法)财务数据匹配规则 当年中报2 剔除规则 不调整市净率(整体法)财务数据匹配规则 当年中报 剔除规则 不调整市销率(整体法)财务数据匹配规则 当年中报2 剔除规则 不调整市现率(整体法)财务数据匹配规则 当年中报2 剔除规则 不调整总市值(合计)单位 亿元总股本(合计)单位 亿股收盘价(总股本加权平均)单位 元时间上证综合指数成份上证综合指数成份上证综合指数成份上证综合指数成份上证综合指数成份上证综合指数成份上证综合指数成份1990-12-1918.1911.819.1316.670.09179.11990-12-2019.0912.0919.1617.080.09183.461990-12-2120.0512.6319.2117.850.09191.731990-12-2421.0613.2119.2718.660.09200.441990-12-2522.1113.7919.3219.480.09209.281990-12-2623.2114.1619.3620.010.09214.911990-12-2723.2114.1619.3620.010.09214.931990-12-2823.4514.2919.3720.190.09216.891990-12-3123.6814.4219.3920.380.09218.891991-01-0236.565.3710.4820.560.09220.91991-01-0336.95.4210.4820.750.09222.951991-01-0437.245.4710.4920.940.092251991-01-0737.415.4910.4921.040.09226.051991-01-0837.65.5210.4921.150.09227.181991-01-0937.775.5510.4921.240.09228.221991-01-1037.945.5710.521.340.09229.261991-01-1138.135.610.521.440.09230.381991-01-1438.225.6110.521.50.09230.941991-01-1538.315.6310.521.550.09231.491991-01-1638.235.6110.521.510.09231.031991-01-1738.155.610.521.460.09230.551991-01-1838.065.5910.521.410.092301991-01-21385.5810.521.380.09229.651991-01-2237.855.5610.521.290.09228.731991-01-2337.75.5410.4921.20.09227.781991-01-2437.545.5110.4921.110.09226.831991-01-2537.385.4910.4921.030.09225.881991-01-2837.235.4710.4920.940.09224.961991-01-2937.225.4710.4920.940.09224.911991-01-3037.215.4710.4920.930.09224.861991-01-3137.215.4610.4920.930.09224.841991-02-0137.215.4610.4920.930.09224.841991-02-0437.215.4610.4920.930.09224.831991-02-0537.25.4610.4920.930.09224.81991-02-0637.395.4910.4921.030.09225.911991-02-0737.575.5210.4921.130.09227.031991-02-0837.765.5410.4921.240.09228.141991-02-1137.945.5710.521.340.09229.251991-02-1238.095.5910.521.420.09230.161991-02-1338.275.6210.521.530.09231.261991-02-1438.465.6510.521.630.09232.411991-02-1938.645.6710.521.730.09233.461991-02-2038.765.6910.5121.80.09234.211991-02-2138.955.7210.5121.910.09235.371991-02-2239.145.7510.5122.010.09236.51991-02-2539.145.7510.5122.020.09236.511991-02-2636.115.310.4720.310.09218.221991-02-2736.15.310.4720.310.09218.161991-02-2836.15.310.4720.30.09218.111991-03-0136.095.310.4720.30.09218.071991-03-0435.925.2710.4720.20.09217.031991-03-0535.755.2510.4720.110.092161991-03-0635.585.2210.4720.010.09214.981991-03-0735.415.210.4619.920.09213.951991-03-0835.245.1810.4619.820.09212.931991-03-1135.075.1510.4619.720.1195.121991-03-1234.95.1310.4619.630.1194.191991-03-1334.375.0510.4519.330.1191.251991-03-1434.215.0210.4519.240.1190.331991-03-1534.195.0210.4519.230.1190.261991-03-1834.185.0210.4519.220.1190.181991-03-1934.165.0210.4519.210.1190.061991-03-2033.984.9910.4519.110.1189.081991-03-2133.814.9710.4419.020.1188.161991-03-2233.654.9410.4418.930.1187.251991-03-2533.494.9210.4418.840.1186.341991-03-2633.334.8910.4418.750.1185.441991-03-2733.164.8710.4418.650.1184.541991-03-28334.8510.4318.560.1183.631991-03-2932.854.8210.4318.480.1182.781991-04-0133.014.8510.4318.560.1183.651991-04-0233.014.8510.4418.570.1183.691991-04-0333.024.8510.4418.570.1183.751991-04-0432.954.8410.4318.530.1183.361991-04-0532.514.7710.4318.280.1180.871991-04-0832.354.7510.4318.20.1180.031991-04-0932.24.7310.4218.110.1179.171991-04-1032.034.710.4218.020.1178.251991-04-1131.884.6810.4217.930.1177.391991-04-1231.734.6610.4217.850.1176.551991-04-1531.584.6410.4217.760.1175.711991-04-1631.434.6210.4217.680.1174.881991-04-1731.284.5910.4117.590.1174.051991-04-1831.134.5710.4117.510.1173.211991-04-1931.064.5610.4117.470.1172.81991-04-2230.894.5410.4117.370.1171.881991-04-2330.744.5110.4117.290.1171.051991-04-2430.64.4910.4117.210.1170.251991-04-2530.454.4710.417.130.1169.451991-04-2630.354.4610.417.070.1168.891991-04-2930.074.4210.416.910.1167.331991-04-3029.794.3810.416.760.1165.781991-05-0229.524.3410.3916.60.1164.251991-05-0329.374.3110.3916.520.1163.421991-05-0629.094.2710.3916.360.1161.881991-05-0728.824.2310.3816.210.1160.341991-05-0828.544.1910.3816.050.1158.831991-05-0928.284.1510.3815.910.1157.361991-05-1028.014.1110.3715.760.1155.871991-05-1327.784.0810.3715.630.1154.581991-05-1427.644.0610.3715.550.1153.831991-05-1527.524.0410.3715.480.1153.111991-05-1627.133.9810.3615.260.1150.981991-05-1727.44.0210.3715.410.1152.461991-05-2027.644.0610.3715.550.1153.821991-05-2127.94.110.3715.70.1155.271991-05-2227.894.110.3715.690.1155.21991-05-2327.94.110.3715.690.1155.231991-05-2428.164.1410.3715.840.1156.71991-05-2728.354.1610.3815.950.1157.751991-05-2828.624.210.3816.10.1159.231991-05-2928.94.2410.3816.260.1160.841991-05-3029.194.2910.3916.420.1162.441991-05-3129.354.3110.3916.510.1163.331991-06-0329.654.3510.3916.670.1164.961991-06-0429.944.410.416.840.1166.61991-06-0530.244.4410.417.010.1168.261991-06-0630.534.4810.417.170.1169.911991-06-0730.714.5110.4117.270.1170.861991-06-1031.014.5510.4117.440.1172.551991-06-1131.324.610.4117.620.1174.291991-06-1231.644.6510.4217.790.1176.041991-06-1331.954.6910.4217.970.1177.791991-06-1431.654.6510.4217.80.1176.091991-06-1731.964.6910.4217.980.1177.851991-06-1832.284.7410.4318.160.1179.631991-06-1932.64.7910.4318.340.1181.421991-06-2032.934.8410.4318.520.1183.241991-06-2133.264.8810.4418.710.1185.051991-06-2433.584.9310.4418.890.1186.881991-06-2533.924.9810.4519.080.1188.761991-06-2634.265.0310.4519.270.1190.661991-06-2734.615.0810.4519.470.1192.571991-06-2834.965.1310.4619.660.1194.511991-07-0134.935.1310.4619.650.1194.391991-07-0234.65.0810.4519.460.1192.521991-07-0334.585.0810.4519.450.1192.441991-07-0434.935.1310.4619.650.1194.351991-07-0534.925.1310.4619.640.1194.291991-07-0834.95.1310.4619.630.1194.211991-07-0934.95.1310.4619.630.1194.181991-07-1034.895.1210.4619.630.1194.151991-07-1134.895.1210.4619.630.1194.161991-07-1234.95.1310.4619.630.1194.21991-07-1535.075.1510.4619.730.1195.171991-07-1635.425.210.4619.930.1197.121991-07-1735.785.2510.4720.120.1199.081991-07-1836.145.3110.4720.330.1201.071991-07-1936.175.3110.4720.340.1201.271991-07-2236.535.3710.4820.550.1203.291991-07-2336.95.4210.4820.760.1205.331991-07-2437.255.4710.4920.950.1207.291991-07-2537.285.4810.4920.970.1207.451991-07-2637.495.5110.4921.090.1208.61991-07-2937.775.5510.4921.240.1210.151991-07-3038.055.5910.521.40.1211.721991-07-3138.435.6410.521.610.1213.821991-08-0138.815.710.5121.830.1215.971991-08-0239.25.7610.5122.050.1218.121991-08-0539.595.8110.5222.270.1220.31991-08-0639.995.8710.5222.490.1222.51991-08-0740.395.9310.5322.720.1224.731991-08-0840.795.9910.5322.940.1226.951991-08-0941.196.0510.5423.170.1229.191991-08-1241.66.1110.5423.40.1231.461991-08-1342.016.1710.5523.630.1233.761991-08-1442.436.2310.5523.860.1236.071991-08-1542.856.2910.5624.10.1238.431991-08-1643.276.3610.5624.340.1240.791991-08-1943.716.4210.5724.580.1243.21991-08-2044.146.4810.5724.830.1245.631991-08-2144.586.5510.5825.080.1248.081991-08-2245.036.6110.5825.330.1250.571991-08-2346.596.8410.626.210.1256.41991-08-2648.637.1410.6327.350.11252.41991-08-2749.097.2110.6327.610.11254.761991-08-2849.557.2810.6427.870.11257.181991-08-2950.027.3510.6528.140.11259.631991-08-3050.57.4210.6528.410.11262.111991-09-0248.947.1910.6327.520.11253.981991-09-0349.427.2610.6427.80.11256.481991-09-0449.917.3310.6428.070.11259.041991-09-0550.417.410.6528.350.11261.611991-09-0650.917.4810.6628.640.11264.231991-09-0951.427.5510.6628.920.11266.881991-09-1050.987.4910.6628.670.11264.581991-09-1150.57.4210.6528.40.11262.081991-09-1250.047.3510.6528.150.11259.71991-09-1350.057.3510.6528.150.11259.741991-09-1650.547.4210.6528.430.11262.311991-09-1750.087.3610.6528.170.11259.931991-09-1849.647.2910.6427.920.11257.621991-09-1949.237.2310.6427.690.11255.491991-09-2048.787.1610.6327.440.11253.171991-09-2348.347.110.6327.190.11250.91991-09-2447.917.0410.6226.950.11248.641991-09-2547.486.9710.6126.710.11246.431991-09-2647.066.9110.6126.470.11244.231991-09-2746.76.8610.626.270.11242.371991-09-3046.276.810.626.020.11240.141991-10-0346.286.810.626.030.11240.21991-10-0446.746.8610.6126.290.11242.581991-10-0747.26.9310.6126.550.11244.991991-10-0847.216.9310.6126.550.11245.011991-10-0947.236.9410.6126.570.11245.131991-10-1047.77.0110.6226.830.11247.581991-10-1148.157.0710.6227.090.11249.921991-10-1448.577.1310.6327.320.11252.061991-10-1549.057.210.6327.590.11254.571991-10-1649.547.2810.6427.860.11257.11991-10-1750.027.3510.6528.140.11259.631991-10-1850.527.4210.6528.420.11262.231991-10-2151.027.4910.6628.70.11264.821991-10-2251.527.5710.6628.980.11267.411991-10-2352.037.6410.6729.270.11270.041991-10-2452.067.6510.6729.280.11270.221991-10-2552.377.6910.6829.460.11271.811991-10-2852.97.7710.6829.750.11274.531991-10-2953.427.8510.6930.050.11277.241991-10-3053.717.8910.6930.210.11278.751991-10-3154.257.9710.730.510.11281.551991-11-0154.788.0410.7130.810.11284.31991-11-0455.328.1310.7131.120.11287.141991-11-0555.878.2110.7231.430.11289.981991-11-0656.428.2910.7331.740.11292.841991-11-0756.988.3710.7332.050.11295.711991-11-0857.558.4510.7432.370.11298.681991-11-1158.128.5410.7532.690.11301.671991-11-1258.698.6210.7533.010.11304.61991-11-1359.018.6710.7633.190.11306.261991-11-1459.328.7110.7633.360.11307.851991-11-1559.628.7610.7733.540.11309.441991-11-1860.218.8410.7733.870.11312.511991-11-1960.518.8910.7834.030.11314.041991-11-2061.118.9710.7834.370.11317.161991-11-2161.419.0210.7934.540.11318.711991-11-2261.729.0610.7934.720.11320.341991-11-2562.349.1610.835.060.11323.551991-11-2662.969.2510.8135.410.11326.741991-11-2763.589.3410.8135.760.11329.961991-11-2864.199.4310.8236.10.11333.141991-11-2964.379.4510.8236.210.11334.091991-12-0265.019.5510.8336.570.11337.421991-12-0365.669.6410.8436.930.11340.791991-12-0466.029.710.8437.130.11342.631991-12-0566.369.7510.8537.330.11344.421991-12-0667.039.8410.8637.70.11347.891991-12-0967.389.910.8637.90.11349.731991-12-1068.049.9910.8738.270.11353.131991-12-1168.3710.0410.8738.460.11354.851991-12-1268.410.0410.8738.470.11354.981991-12-1369.0510.1410.8838.840.11358.361991-12-1669.110.1510.8838.870.11358.631991-12-1769.4410.210.8939.060.11360.381991-12-1869.7810.2510.8939.250.11362.161991-12-1969.7910.2510.8939.260.11362.221991-12-2070.4610.3510.939.630.11365.691991-12-2371.1610.4510.9140.030.11369.341991-12-2471.1910.4610.9140.040.11369.491991-12-2571.5410.5110.9140.240.11371.311991-12-2671.9110.5610.9240.450.11373.231991-12-2772.6210.6610.9340.840.11376.881991-12-3072.6610.6710.9340.870.11377.121991-12-3173.0510.7310.9341.090.11379.141992-01-0249.314.4813.2341.30.11381.041992-01-0349.794.5313.2341.70.11384.771992-01-0650.074.5513.2441.940.11386.951992-01-0750.354.5813.2442.170.11389.071992-01-0850.624.613.2442.40.11391.21992-01-0950.884.6313.2442.610.11393.21992-01-1051.184.6513.2442.860.11395.471992-01-1348.184.4913.1644.830.13349.171992-01-1448.414.5113.1645.030.13350.81992-01-1548.674.5313.1645.280.13352.681992-01-1648.684.5313.1645.280.13352.751992-01-1748.694.5413.1645.290.13352.821992-01-2048.694.5413.1745.30.13352.851992-01-2148.934.5613.1745.520.13354.611992-01-2248.944.5613.1745.530.13354.681992-01-2348.964.5613.1745.550.13354.791992-01-2449.24.5813.1745.770.13356.571992-01-2749.664.6313.1746.20.13359.861992-01-2849.694.6313.1746.220.13360.071992-01-2949.924.6513.1746.440.13361.741992-01-3050.174.6713.1846.670.13363.571992-01-3150.424.713.1846.910.13365.41992-02-0350.454.713.1846.930.13365.581992-02-0750.454.713.1846.940.13365.621992-02-1050.724.7313.1847.190.13367.561992-02-1150.744.7313.1847.20.13367.691992-02-1250.744.7313.1847.210.13367.731992-02-1350.724.7313.1847.190.13367.591992-02-1450.714.7213.1847.180.13367.511992-02-1750.724.7313.1847.190.13367.591992-02-1862.985.8713.2658.590.13456.411992-02-1967.076.2513.2962.40.13486.081992-02-2070.476.5713.3165.560.13510.71992-02-2163.355.7413.1876.630.15534.381992-02-2463.485.7513.1876.840.15535.761992-02-25635.7113.1777.240.15537.561992-02-2662.575.6713.1777.60.15539.191992-02-2763.115.7213.1777.940.15541.851992-02-2863.335.7413.1878.280.15544.141992-03-0263.225.7313.1778.630.15546.081992-03-0363.375.7413.1878.980.15548.41992-03-0463.515.7613.1879.20.15549.871992-03-0563.625.7713.1879.450.15551.511992-03-0663.95.7913.1879.690.15553.271992-03-0963.885.7913.1879.660.15553.071992-03-1064.145.8113.1979.930.15555.011992-03-1164.215.8213.1980.170.15556.51992-03-1264.225.8213.1980.320.15557.431992-03-1364.295.8313.1980.430.15558.171992-03-1664.425.8413.1980.630.15559.481992-03-1764.525.8513.1980.920.15561.341992-03-1864.495.8413.1981.130.15562.581992-03-1964.635.8613.1981.60.15565.521992-03-2064.945.8813.1982.080.15568.781992-03-2365.295.9213.282.690.15572.81992-03-2465.595.9413.283.370.15577.221992-03-2565.395.9313.283.050.15575.11992-03-2665.735.9613.283.710.15579.441992-03-2743.024.1212.4698.420.78129.41992-03-3042.994.1212.4698.610.78129.591992-03-3142.914.1112.4698.640.78129.61992-04-0142.864.1112.4698.760.78129.711992-04-0242.854.112.4698.860.78129.821992-04-0342.884.1112.4699.070.78130.071992-04-0642.864.1112.4699.140.78130.141992-04-0742.954.1112.4699.260.78130.321992-04-0843.014.1212.4699.440.78130.551992-04-0943.034.1212.4799.610.78130.751992-04-1043.114.1312.4799.690.78130.871992-04-1344.324.2512.491030.78135.161992-04-1446.444.4512.53108.90.78142.641992-04-1547.354.5412.55111.30.78145.841992-04-1647.364.5412.55111.40.78145.861992-04-1747.014.512.55110.40.78144.631992-04-2045.64.3712.52106.50.78139.651992-04-2145.454.3512.51106.10.78139.121992-04-2244.74.2812.5104.10.78136.481992-04-2345.444.3512.51105.90.78138.821992-04-2446.384.4412.53107.40.78140.951992-04-2747.014.512.55109.40.78143.481992-04-2847.714.5712.561110.78145.631992-04-2948.434.6412.57112.20.78147.291992-04-3048.024.612.57111.10.78145.861992-05-0448.594.6512.58112.70.78147.871992-05-0547.584.5612.56109.90.78144.31992-05-0647.014.512.55108.60.78142.581992-05-0746.884.4912.54108.50.78142.421992-05-0847.844.5812.56111.30.78145.941992-05-1151.034.8912.63120.40.78157.641992-05-1251.84.9612.64122.80.78160.631992-05-1352.19512.651240.78162.221992-05-1452.685.0512.66125.60.78164.171992-05-1554.585.2312.7130.60.78170.691992-05-1857.525.5112.76137.70.78179.91992-05-1960.255.7712.81145.30.78189.661992-05-2061.815.9212.84149.10.78194.581992-05-2196.789.2713.55244.60.78317.361992-05-22103.59.9113.68259.80.78337.471992-05-25111.910.7213.85282.20.78366.251992-05-2693.268.9313.48230.30.78299.71992-05-2795.79.1713.53237.30.78308.731992-05-2892.378.8513.46231.40.78300.661992-05-2997.739.3613.57245.10.78318.351992-06-0193.97913.492340.78304.251992-06-0291.658.7813.45228.20.78296.651992-06-0385.68.213.32211.60.78275.331992-06-0469.616.6713167.80.79216.231992-06-0569.646.6713168.20.79216.771992-06-0869.16.6212.991670.79215.151992-06-0970.96.7913.03171.50.79220.991992-06-1074.467.1313.1181.30.79231.921992-06-1174.127.113.09180.40.79230.731992-06-1273.837.0713.09179.80.79230.031992-06-1573.687.0613.08179.40.79229.491992-06-1673.767.0713.09179.60.79229.771992-06-1773.297.0213.08178.60.79228.451992-06-18736.9913.07178.60.79228.311992-06-1973.157.0113.07179.20.79229.11992-06-2272.916.9813.07179.10.79228.811992-06-2372.216.9213.05177.40.79226.651992-06-2471.866.8813.051760.79224.921992-06-2572.456.9413.06177.30.79226.691992-06-2672.596.9513.06177.80.79227.2919