上证指数预测模型摘要股票市场是我国资本市场的重要组成部分,在推动我国经济发展进程中起到了非常重要的作用。
为了更好地理解股票市场以及获得更高的收益,股市的预测成了重多投资者和学术研究者研究和分析的热点问题。
而上证指数是研究和判断股票价格变化趋势必不可少的重要依据,在一定程度上反映了我国的经济实力,是宏观经济的晴雨表,也是分析微观经济的重要指标,所以研究上证指数的预测模型具有非常重要的现实意义和使用价值。
本文在充分分析影响股市价格众多因素的基础上,选择多组变量,基于多元回归线性分析建立上证指数的预测模型。
首先需要尽可能多的选择原始数据,在这里为了方便计算选择了3月到5月上证指数及各变量的数据(除去休盘日)共64组,22个变量。
使用SPSS 软件进行线性分析后,剔除某些无关,甚至关联很小的变量后,得出了回归方程的系数,从而得出了上证指数的预测模型2210-212010-191810-1716151413121110954321x 101.800+0.834x +x 102.887+0.017x -x 103.391-0.003x -10x -4.824e -0.030x -0.258x -0.387x +0.019x -21.964x -18.203x +11.195x -0.032x -0.180x +0.230x -0.703x -0.677x +-774.860=y ⨯⨯⨯然后利用图表分析了此模型的好坏程度。
关键词:1上证指数;2多元回归分析法;3 SPSS 分析;一、问题的背景与提出上证指数,是上海证券综合指数的简称。
是最早发布的指数,以上海证券交易所挂牌上市的全部股票为计算范围,以发行量为权数的加权综合股价指数。
它是研究和判断股票价格变化趋势必不可少的重要依据,在一定程度上反映了我国的经济实力,是宏观经济的晴雨表,也是分析微观经济的重要指标,所以研究上证指数的预测模型具有非常重要的现实意义和使用价值。
本文将在此背景下,充分分析上证指数的组成,使用多元线性回归的方法对其进行合理的预测,建立模型,具有实际意义,以预测未来上证指数的变化趋势。
二、基本假设1.忽略除文中提到的影响因素之外的因素对上证指数的影响。
2.假设经济形势稳定,不会出现较为明显的通货膨胀或通货紧缩。
三、主要变量符号说明为了便于描述问题,我们用一些符号来代替问题中涉及的一些基本变量,如表1所示。
表1 主要变量符号说明一览表【注】其余没有列出的符号,我们将在文章第一次出现时给出具体说明四、问题的分析对上证指数进行预测,需要对影响上证指数的主要因素进行分析进行分析[1]:对整体股票市场而言,其状态最基本的表现方式是股票价格指数和成交量,而这两项指标又受社会、政治、经济、政策、心理等多种因素的影响。
首先选择表中可以查到的数据作为变量:MACD:DIFF, DEA;RSI;KDJ:D 指标,J 指标;WR;PSY;OBV 其次选择以下变量:财政收入增长率、财政支出增长率、货币供应量1M 、货币流通量0M 、居民消费价格指数、固定资产投资情况。
由于股民心理受收盘价和成交量的影响,故对上证指数的影响可用以下变量表示:今日收盘价;今日成交量;昨日收盘价;昨日成交量;近5日平均收盘价;近5日平均成交量;近20日平均收盘价;近20日平均成交量.以上均采用最近三个月的数据(包括上证指数)五、问题模型的建立和求解5.1问题的求解5.1.1多元线性回归分析的数学模型[2]设明日收盘价为y,影响因素为22个,分别为1x ,2x ,3x ,4x ,5x ,6x ,7x ,8x ,9x ,10x ,11x ,12x ,13x ,14x ,15x ,16x ,17x ,18x ,19x ,20x ,21x ,22x ,它们之间有以下线性关系ε+++++++++=22226655443322110...y x b x b x b x b x b x b x b b5.1.2模型求解使用SPSS[3]进行回归分析得模型汇总a. 预测变量: (常量), x22, x17, x15, x18, x10,x5, x16, x14, x19, x20, x13, x4, x12, x3, x9,x21, x2, x1, x11。
模型平方和df 均方 F Sig.1 回归332809.2261917516.275360.552 .000b 残差2137.602 44 48.582总计334946.82863a. 因变量: yb. 预测变量: (常量), x22, x17, x15, x18, x10, x5, x16, x14, x19, x20, x13, x4, x12, x3, x9, x21, x2, x1, x11。
系数a模型非标准化系数标准系数t Sig.B 标准误差试用版1 (常量)-774.86011619.193-.067 .947 x1 .677 .495 .291 1.368 .178 x2 -.703 .423 -.310 -1.662 .104 x3 -.230 .323 -.035 -.712 .480 x4 .180 .239 .048 .754 .455 x5 -.032 .126 -.014 -.256 .799 x9 -11.195 19.037 -.130 -.588 .559 x10 18.203 121.877 .031 .149 .882 x11 -21.964 46.006 -.144 -.477 .635 x12 -.019 .120 -.007 -.157 .876 x13 .387 .238 .081 1.629 .111 x14 -.258 .687 -.020 -.376 .709 x15 -.030 .012 -.058 -2.582 .013x16 -4.824E-010.000 -.040 -1.759 .086x17 -.003 .009 -.006 -.322 .749x18 -3.391E-010.000 -.028 -1.372.177x19 -.017 .030 -.022 -.561 .578x202.887E-01.000 .019 .543 .590x21 .834 .053 .846 15.595 .000x221.800E-01.000 .010 .114 .909a. 因变量: y5.1.3 模型结果2210-212010-191810-1716151413121110954321x101.800+0.834x+x102.887+0.017x-x103.391-0.003x-10x-4.824e-0.030x-0.258x-0.387x+0.019x-21.964x-18.203x+11.195x-0.032x-0.180x+0.230x-0.703x-0.677x+-774.860=y⨯⨯⨯六、结果分析与进一步推广6.1多元线性回归分析结果图表从上图可以看出标准化残差的分布情况总体总体呈正态,集中在0的附近,这可以说明该回归方程的准确性是比较高的。
由由由由由由由由由由由由由由由由由由6.2预测模型准确情况分析在matlab中做出实际值与预测值的比较图如下七、模型的评价优点:1. 可推广性。
该多元线性回归法可以应用到多变量线性关系问题评估中。
2. 严谨性。
SPSS与MATLAB相结合进行建模与模型评估,大大提高了模型的严谨性,较大程度的减少了人为计算可能会出现的误差。
4. 全面性。
变量的选择几乎涵盖了所有可能的影响因素,因此此建模过程是较为全面的。
5. 实用性。
本文所建模型与实际紧密联系,结合实际情况对数据进行合理的处理,使模型更加贴近实际,通用性强,具有现实意义。
缺点:1.由于时间的限制,对数据的统计和整理还不完善,其中读取数据量很大,有待进一步修改。
2.由于选取变量的时间范围较窄,因此模型的准确性还有待在数据更多的条件下进一步的验证。
八、参考文献:[1] 邹艳芬.上证指数的主要影响因素分析.江苏连云港:连云港化工高等专科学校学报,2002.[2] 李金海.多元回归分析在预测中的应用.河北;河北工业大学学报,1996年第三期[3] 包凤达等.多元回归分析的软件求解与案例解读.数理统计与管理,2000年第五期附录一:变量数据表x1 x2 x3 x4 x5 x6 x7 x8 x9 x10 x11 x12 x13 x14 x15 x16 x17 x18 x19 x20 x21 x22 y-69.58 -78.3540.452.868.45 6.5 15.4 22.1 4.4 99.6 10.768.0750 5082733.170187207443002687.98207410709002842.82255121888202898.68635224115526852914.92-60.31 -78.3550.0151.6344.286.5 15.4 22.1 4.4 99.6 10.728.5758.33520.782849.68270961783002733.170187207443002876.47264376931802908.01945223903421952922.65-51.55 -78.3550.7553.6765.846.5 15.4 22.1 4.4 99.6 10.725.1558.33513.652859.76287478210002849.68270961783002879.04237980467402915.56765220873905352930.00-42.95 -78.3551.8857.5981.146.5 15.4 22.1 4.4 99.6 10.720.2858.33516.782874.17312495169002859.76287478210002868.04219448031402922.7755217520667102937.30-33.87 -78.3553.7362.894.096.5 15.4 22.1 4.4 99.6 10.711.1866.67518.952897.34217466836002874.17312495169002855.26182398508402929.5433212223201952944.97-26.06 -78.3554.0768.44102.236.5 15.4 22.1 4.4 99.6 10.7 9.79 75521.282901.39233482661002897.34217466836002847.70177868347202937.3298214186377352953.52-22.73 -78.3550.2472.4496.466.5 15.4 22.1 4.4 99.6 10.721.0766.67519.452862.56138979461002901.39233482661002840.29163849148402944.78995214125346852962.15-24.48 -78.3545.0572.9375.8 6.5 15.4 22.1 4.4 99.6 10.739.2566.67518.062804.73194816030002862.56138979461002841.87173351763202952.08315218222349102971.31-25.12 -78.3545.6471.562.996.5 15.4 22.1 4.4 99.6 10.737.2166.67519.332810.31127247554002804.73194816030002861.89174446599802961.09485217876779252981.13-21.42 -78.3550.7470.7966.556.5 15.4 22.1 4.4 99.6 10.721.5375521.282859.50194816030002810.31127247552890.86211663632972.277222515312990.88400 600 5 775-17.88 -78.3551.2369.9464.8 6.5 15.4 22.1 4.4 99.6 10.726.4875522.922864.37163386667002859.50194816030002922.72243180517602980.48505221910449652999.18-14.43 -78.3551.8869.5967.536.5 15.4 22.1 4.4 99.6 10.729.7383.33524.782870.43186492535002864.37163386667002949.72264578648602990.59865229241278603006.09-8.8 1 -78.3555.5871.5182.7 6.5 15.4 22.1 4.4 99.6 10.710.8983.33526.782904.83200290213002870.43186492535002977.62270675634003001.19515230328543353010.70-0.2 9 -78.3560.4274.7493.556.5 15.4 22.1 4.4 99.6 10.7 8.2483.33529.922955.15313332735002904.83200290213002988.85278018872003009.85955229794685253012.6111.4 6 -78.3565.678.53101.246.5 15.4 22.1 4.4 99.6 10.7 3.7283.33533.443018.80352400438002955.15313332735002993.71250367193803013.78605223293274103012.7818.9 8 -78.3562.8681.3498.2 6.5 15.4 22.1 4.4 99.6 10.711.3275530.742999.36270377322003018.80352400438002981.51220291354403014.98695213499912203011.8425.5 2 -78.3563.7683.8699.016.5 15.4 22.1 4.4 99.6 10.77.18 75532.913009.96216977462002999.36270377322002965.60202808959003013.6478214138257053010.7326.4 2 -78.3556.8183.1979.156.5 15.4 22.1 4.4 99.6 10.726.3366.67530.542960.97237006403003009.96216977462002963.74201487756803010.7943212759726403010.2228.3 1 -78.3558.6782.1575.936.5 15.4 22.1 4.4 99.6 10.723.4475532.292979.43175074344002960.97237006403002972.33198169165203010.7078207769989653009.7327.7 4 -78.3555.6279.1861.326.5 15.4 22.1 4.4 99.6 10.733.8175530.272957.82202021241002979.43175074344002978.35204463469603009.0696205309084603008.6023.9 5 -78.3550.5973.1236.8 6.5 15.4 22.1 4.4 99.6 10.7 62.366.67528.442919.83182965345002957.82202021241002997.40215405290203009.4136201093602753006.9327.1 6 -78.3559.1670.9257.7 6.5 15.4 22.1 4.4 99.6 10.516.1766.67530.543000.65210371451002919.83182965345003023.55225264631403011.1055198488717503004.5829.6 2 -78.3559.4770.9771.268.6 12.4 22.9 6 99.8 10.519.8366.67532.753003.92220413445003000.65210371451003025.11227374242403008.35275194903308653001.3631.6 6 -78.3560.0472.9184.568.6 12.4 22.9 6 99.8 10.515.2766.67534.813009.53206545866003003.92220413445003021.31220872480003005.073189348167802988.7436.3 7 -78.3564.2976.4797.848.6 12.4 22.9 6 99.8 10.5 2.866.67537.383053.07256730344003009.53206545866003026.20223566971603000.7285187456056652975.2439.4 4 -78.3563.8780.01101.228.6 12.4 22.9 6 99.8 10.5 5.9558.33535.063050.59232262051003053.07256730344003020.32208764636402997.6385182889894752960.6038.0 4 -78.3556.9479.9979.858.6 12.4 22.9 6 99.8 10.534.3350532.853008.42220919506003050.59232262051003023.53224312875402995.001178518361352944.7234.6 4 -78.3553.4376.7357.178.6 12.4 22.9 6 99.8 10.549.2750530.972984.96187904633003008.42220919506003038.31221776540202945.2425177812210952927.0535.4 8 -78.3559.1775.8570.638.6 12.4 22.9 6 99.8 10.572.9450533.173033.96220018324002984.96187904633003056.95222118223802937.6177435895802916.7834.9 2 -78.3557.5464.6967.078.6 12.4 22.9 6 99.8 10.524.6450531.343023.65182718668003033.96220018324003056.89214775461402927.5315172476445102905.7737.5 1 -78.3562.2774.4673.6 8.6 12.4 22.9 6 99.8 10.519.5850534.443066.64310003246003023.65182718668003060.72209538367802918.201170130285002894.8740.3 7 -78.3563.8776.0685.718.6 12.4 22.9 6 99.8 10.5 10.558.33536.523082.36208237830003066.64310003246003041.91204166562402906.662161447005452883.4841.8 1 -78.3563.0877.8988.518.6 12.4 22.9 6 99.8 10.513.5258.33534.633078.12189613051003082.36208237830003016.02200400366202893.8995156751099452872.7538.9 1 -78.3555.277664.648.6 12.4 22.9 6 99.8 10.546.4550532.793033.68183304512003078.12189613051002992.24189920089602882.5365153003126502863.2936.9 3 -78.3556.4873.4157.868.6 12.4 22.9 6 99.8 10.539.7550534.763042.82156533200003033.68183304512002974.84178430435802873.0365150006354102854.9529.3 6 -78.3546.056835.598.6 12.4 22.9 6 99.8 10.564.8541.67531.532972.58283144219003042.82156533200002959.22170666116602861.271149204085402847.2621.5 1 -78.3543.5960.8117.678.6 12.4 22.9 6 99.8 10.5 75.133.33529.032952.89189406849002972.58283144219002955.43140210800802852.9875140626628002840.4315.6 3 -78.3544.635413.088.6 12.4 22.9 6 99.8 10.571.7941.67531.012959.24137211668002952.89189406849002953.97130062085802846.617136591330502833.949.84 -78.42.947.37.64 8.6 12.4 22.9 6 99.8 10.5 78.341.6529.2946125856295913722949124428401357282735 2 4 4 7 75 .67 24300 .24 1166800.79 8187780 .83755426985.486.63 -78.35 46.15 42.75 15.028.6 12.4 22.9 699.8 10.5 68.95 50 530.92 2964.70 11771160400 2946.67 12585624300 2944.98 133******** 2834.5875 13503407995 2821.023.16 -78.35 44.47 38.87 15.578.6 12.4 22.9 699.8 10.5 73.7 41.67 529.62 2953.67 130******** 2964.70 11771160400 2950.30 14259045820 2827.107 13432486300 2815.74-0.24 -78.35 43.2235.7617.118.6 12.4 22.9 699.8 10.5 78.07 41.67 528.23 2945.59 138******** 2953.67 130******** 2959.13 14538320680 2820.5455 13295784425 2810.04-3.48 -78.35 42.0532.8615.468.6 12.4 22.9 699.8 10.5 78.31 33.33 527.15 2938.32 10931062800 2945.59 138******** 2772.66 159******** 2814.3185 131516971702803.44-1.64 -78.35 52.5 34.38 43.51 8.3 13.6 23.7 6.3 99.5 9.6 41.85 41.27 528.82 2922.64 16870364300 2938.32 10931062800 2751.42 173******** 2808.525 131367419752807.19-0.3 -78.35 52.24 40.69 78.54 8.3 13.6 23.7 6.3 99.5 9.6 42.76 33.33 527.17 2991.27 16540710600 2922.64 16870364300 2733.41 16364852540 2808.224 13369525465 2812.111.29 -78.35 53.44 49.25 100.64 8.3 13.6 23.7 6.3 99.5 9.6 7.47 41.67 528.62 2997.84 14483138300 2991.27 16540710600 2702.57 157******** 2798.59 13202620984 2817.09-4.24 -78.35 39.4847.6137.778.3 13.6 23.7 6.3 99.5 9.699.7733.33526.55 2013.25 20679649800 2997.84 14483138300 2670.17 156******** 2787.520556 13131481133 2823.95-14.99 -78.35 31.0142.229.86 8.3 13.6 23.7 6.3 99.5 9.694.3733.33524.75 2832.11 180******** 2013.25 20679649800 2832.94 137******** 2833.065882 126874712122832.98-23.2 -78.35 31.1 35.88 -2.15 8.3 13.6 23.7 6.3 99.5 9.6 93.26 41.67 525.95 2832.59 12082931000 2832.11 180******** 2836.69 12438714660 2833.125625 123530736002832.99-29.02 -78.35 32.0530.17-4.078.3 13.6 23.7 6.3 99.5 9.690.1341.67527.31 2837.04 135******** 2832.59 12082931000 2838.91 12489509740 2833.161333 12371083107 2832.66-33.34 -78.35 31.9227 7.99 8.3 13.6 23.7 6.3 99.5 9.675.5241.67525.95 2835.86 136******** 2837.04 13579546600 2833.00 12583356940 2832.884286 122847642862832.09-37.04 -78.35 30.9324.8812.138.3 13.6 23.7 6.3 99.5 9.679.4533.33524.82827.11 11431971000 2835.86 13633765500 2827.21 12088505260 2832.655385 121809949622832.08-37.03 -78.35 36.76 24.6423.188.3 13.6 23.7 6.3 99.5 9.6 68.841.67 525.95 2850.86 11465359200 2827.11 114319712826.89 119761292833.117122434132832.76000040 5 625-38.23 -78.35 15.7724.9126.568.3 13.6 23.7 6.3 99.5 9.672.0241.47524.72 2843.68 12336906400 2850.86 11465359200 2825.45 12092466300 2831.504545 12314145845 2833.65-41.15 -78.35 31.1323.5815.588.3 13.6 23.7 6.3 99.5 9.688.1841.67523.31 2807.51 14048782600 2843.68 12336906400 2821.04 11854133920 2830.287 123118697902834.66-43.02 -78.35 31.0622.8518.748.3 13.6 23.7 6.3 99.5 9.688.4633.33522.22806.91 11159507100 2807.51 14048782600 2822.56 11114922700 2832.817778 121188794782836.50-42.51 -78.35 36.1126.2 46.32 8.3 13.6 23.7 6.3 99.5 9.6 61.5 41.67 523.28 2825.48 10870089900 2806.91 11159507100 2825.67 10953566580 2836.05625 122388010252839.07-40.18 -78.35 40.7433.5577.638.3 13.6 23.7 6.3 99.5 9.621.0941.67524.49 2843.65 12047045500 2825.48 10870089900 2824.78 10976465060 2837.567143 12434331186 2842.53-39.65 -78.35 37.1838.7770.078.3 13.6 23.7 6.3 99.5 9.648.8841.67523.37 2821.67 11145244500 2843.65 12047045500 2820.54 10693447740 2836.553333 124988788002848.93-39.3 -78.35 36.1541.5258.048.3 13.6 23.7 6.3 99.5 9.6 57.2 41.67 522.34 2815.09 10352726500 2821.67 11145244500 2839.53 12769605660 2839.53 127696056602864.94-38 -78.35 38.24 43.95 58.54 8.3 13.6 23.7 6.3 99.5 9.6 47.61 41.67 523.49 2822.44 10352726500 2815.09 10352726500 2845.64 133******** 2845.64 13373825450 2871.29-36.66 -78.35 37.9845.7756.718.3 13.6 23.7 6.3 99.5 9.649.3733.23522.39 2821.05 10984582300 2822.44 10352726500 2853.37 14380858433 2853.373333 143808584332879.84-30.07 -78.35 38.4448.3864.028.3 13.6 23.7 6.3 99.5 9.6 47.6 41.67 523.45 2822.45 10631958900 2821.05 10984582300 2869.54 16078996500 2869.535 160789965002893.08-25.92 -78.35 59.9255.2396.348.3 13.6 23.7 6.3 99.5 9.6 0.38 50525.62916.62 21526034100 2822.45 10631958900 2916.62 21526034100 2916.62 215260341002913.51附录二:MATLAB 程序%% 导入电子表格中的数据% 用于从以下电子表格导入数据的脚本:% % % %% 工作簿: C:\Users\www.0001.Ga\Documents\数学建模\第二次小模拟\工作簿2.xlsx 工作表:Sheet1%% 要扩展代码以供其他选定数据或其他电子表格使用,请生成函数来代替脚本。