办公必备excel模板-绘制K线图

《办公必备excel模板-绘制K线图》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

日期成交量开盘价最高最低收盘价2005/5/176,868,70517.0717.7816.9217.402005/5/186,415,69317.6118.1517.1718.032005/5/196,144,05318.1718.3517.8218.332005/5/205,302,49318.3118.4018.0018.242005/5/215,569,12218.4118.4617.8518.082005/5/245,750,47718.1818.1917.7217.652005/5/256,487,33017.3817.9717.1217.352005/5/267,489,85016.9817.8316.5117.362005/5/277,679,88217.5217.9017.1817.612005/5/288,564,27817.7818.5017.1718.482005/5/3110,541,23519.1619.5118.3219.242005/6/110,898,99820.0120.1519.7319.522005/6/29,252,13719.3319.6819.1619.122005/6/39,878,16019.2019.6118.8519.252005/6/410,720,73819.8220.2519.2020.142005/6/710,715,36720.4520.9919.9820.695日均线2005/6/89,142,96520.9121.1620.4620.752005/6/98,339,08021.0121.1920.6221.182005/6/108,272,25321.2521.3120.7521.152005/6/118,673,18721.1621.2020.7420.732005/6/149,488,08220.6420.8220.1920.312005/6/159,361,23020.2920.5520.1619.872005/6/1610,444,11320.0220.1119.2919.362005/6/1711,344,33019.5719.8218.8119.692005/6/189,381,71519.8620.1619.6319.812005/6/217,458,39219.7820.1319.4019.462005/6/227,114,25719.5619.9319.2619.612005/6/237,011,68319.7119.8919.4719.512005/6/248,105,39319.5419.6919.0819.082005/6/259,038,95819.0619.1518.7718.66 5日均线 日期成交量开盘价最高最低收盘价2004/3/36,868,70517.0717.7816.9217.402003/3/46,415,69317.6118.1517.1718.032003/3/56,144,05318.1718.3517.8218.332003/3/65,302,49318.3118.4018.0018.242003/3/75,569,12218.4118.4617.8518.082003/3/105,750,47718.1818.1917.7217.652003/3/116,487,33017.3817.9717.1217.352003/3/127,489,85016.9817.8316.5117.362003/3/137,679,88217.5217.9017.1817.612003/3/148,564,27817.7818.5017.1718.482003/3/1810,541,23519.1619.5118.3219.242003/3/1910,898,99820.0120.1519.7319.522003/3/209,252,13719.3319.6819.1619.122003/3/219,878,16019.2019.6118.8519.252003/3/2410,720,73819.8220.2519.2020.142003/3/2510,715,36720.4520.9919.9820.692003/3/269,142,96520.9121.1620.4620.752003/3/278,339,08021.0121.1920.6221.182003/3/288,272,25321.2521.3120.7521.152003/3/318,673,18721.1621.2020.7420.732003/4/19,488,08220.6420.8220.1920.312003/4/29,361,23020.2920.5520.1619.872003/4/310,444,11320.0220.1119.2919.362003/4/411,344,33019.5719.8218.8119.692003/4/79,381,71519.8620.1619.6319.812003/4/87,458,39219.7820.1319.4019.462003/4/97,114,25719.5619.9319.2619.612003/4/107,011,68319.7119.8919.4719.512003/4/118,105,39319.5419.6919.0819.082003/4/159,038,95819.0619.1518.7718.662003/4/1610,291,57018.4718.6018.0318.002003/4/1710,370,36218.1518.2817.4817.802003/4/188,369,23517.9418.2617.7018.002003/4/218,980,63718.2418.7917.5818.412003/4/228,356,96518.7519.3118.2818.752003/4/236,863,10518.7919.0718.5518.592003/4/246,715,30318.5018.6118.1718.472003/4/256,344,50718.3618.5218.1518.312003/4/286,417,13518.2818.6018.1518.272003/4/296,449,59318.3018.5417.9318.092003/4/306,736,65718.2018.4417.8618.302003/5/16,145,28718.5318.7317.9918.622003/5/25,660,59018.8319.0918.3719.022003/5/56,214,79819.1019.6518.8219.452003/5/67,760,96719.5419.8919.4019.632003/5/76,197,68019.6419.8419.3219.60 2003/5/86,826,25519.6319.8919.3519.542003/5/96,857,15319.6419.9319.0419.742003/5/126,179,23719.7420.3619.1720.302003/5/136,685,09020.2720.6119.9420.432003/5/145,945,15320.4020.7320.2520.562003/5/156,983,09820.5821.0320.1820.882003/5/168,370,96821.0721.1920.6320.872003/5/197,203,21720.9921.2120.8920.682003/5/208,448,75220.6821.0320.0020.462003/5/219,396,14520.5821.2819.8121.222003/5/229,972,83321.3121.8820.9521.752003/5/238,535,76321.7922.1521.3421.942003/5/267,118,55822.2122.5821.3422.462003/5/276,023,34722.7922.8622.3922.252003/5/285,124,03722.6322.8621.6422.072003/5/294,298,50422.4723.0621.7722.732003/6/24,247,00922.9923.5422.7122.972003/6/34,196,08323.0923.1622.6522.772003/6/44,314,08822.8823.0522.1622.792003/6/53,940,22122.7523.3922.1022.932003/6/63,977,95522.6323.4322.3122.762003/6/94,853,10222.4022.6922.1922.302003/6/105,420,62322.3822.4221.6621.462003/6/116,130,92021.4622.0120.8621.162003/6/127,321,28921.0321.7520.5121.342003/6/137,066,13321.4121.5420.8620.452003/6/168,673,08720.6420.9919.5219.882003/6/179,316,61619.9620.3419.4320.082003/6/187,543,29020.2320.4419.4320.212003/6/195,672,00520.6420.8820.2520.732003/6/205,710,59320.8621.3220.1621.092003/6/235,571,16821.3321.5821.0720.972003/6/246,076,55321.2121.3320.3820.212003/6/256,137,64820.4220.7319.8519.942003/6/266,459,53920.0420.3819.5319.852003/6/276,531,19919.9720.1919.4019.602003/6/307,041,29119.6819.8219.0819.222003/7/16,827,38319.4119.6718.8819.062003/7/26,567,87119.3719.5218.5619.102003/7/36,204,97919.4919.6318.8219.042003/7/45,018,86419.3619.5318.9419.262003/7/75,027,44219.4919.6019.0019.372003/7/85,559,62619.6119.6719.2019.462003/7/96,539,02019.6519.7519.2519.412003/7/106,599,98719.4819.6719.1618.992003/7/117,517,16219.0119.3818.3418.892003/7/146,188,82019.0319.3918.6719.17 2003/7/155,735,11819.3919.4518.9319.172003/7/164,797,41419.3719.4118.7219.172003/7/174,793,63719.2219.3319.0318.962003/7/185,281,18619.0019.0718.7018.812003/7/214,769,46918.8019.0518.4718.662003/7/225,271,57118.6819.1718.4918.742003/7/235,154,42118.8519.1618.3419.052003/7/245,008,75519.0519.4418.4919.272003/7/254,101,21519.3119.6318.9719.382003/7/293,860,43919.3219.4019.0519.062003/7/303,955,57718.9919.1318.5218.842003/7/313,593,12318.8919.2518.4918.872003/8/13,941,58818.9819.4918.6419.392003/8/43,990,36019.4119.7919.2319.402003/8/54,425,57219.4220.0619.1919.572003/8/64,472,97519.6320.1319.4319.752003/8/73,557,02819.7019.8119.2019.222003/8/83,645,20119.3019.4718.8418.922003/8/113,688,98119.0619.2718.8118.852003/8/124,670,62419.0619.4318.6219.202003/8/135,403,35519.3619.9618.9019.862003/8/145,427,96319.7620.3619.5520.342003/8/156,049,10320.2521.0419.9121.042003/8/184,791,57420.9721.5620.4421.362003/8/193,722,11621.2321.3720.9520.962003/8/203,438,41520.8521.1120.6620.752003/8/213,521,20920.7921.1120.4020.582003/8/223,351,72220.7521.2320.4920.812003/8/254,039,43820.8821.2120.6321.192003/8/264,499,99621.1621.6120.8921.582003/8/275,006,90721.5222.0421.0721.982003/8/284,361,55121.9322.2821.4322.232003/8/293,776,41522.2122.4521.9322.102003/9/24,163,98722.1822.5121.6822.032003/9/33,736,27922.0522.4921.8322.442003/9/43,834,05722.3522.6222.0222.552003/9/53,745,45222.5222.8122.4022.742003/9/84,056,18722.6322.9722.4322.822003/9/94,600,70922.6822.9822.5422.872003/9/105,830,05422.8923.1022.4623.002003/9/117,403,25123.1223.5922.4623.432003/9/129,963,76823.6424.3422.9224.042003/9/157,963,16423.9324.0723.7523.382003/9/167,831,33023.1423.3522.4222.802003/9/176,004,73822.8123.0722.5922.632003/9/186,434,82222.6422.6821.8622.032003/9/196,586,33821.9722.0921.7821.66 2003/9/225,950,48521.5821.8121.2821.402003/9/236,412,64321.6121.8721.3521.692003/9/245,980,33121.6121.8121.4621.552003/9/255,614,19821.4321.5520.9621.002003/9/265,560,20321.0921.3520.7620.742003/9/295,980,04820.8321.0320.4920.592003/9/306,742,95920.7821.0120.4820.602003/10/17,287,56020.7021.0920.5820.712003/10/26,946,76620.8021.0820.5820.762003/10/36,206,97720.8621.0720.6320.542003/10/65,391,07720.5920.8320.3220.272003/10/76,606,74020.3420.7219.8220.272003/10/86,616,42020.3920.5219.9920.202003/10/96,269,35320.2820.5919.8220.152003/10/106,263,31320.3520.8220.1020.532003/10/136,026,70920.7020.8220.0720.502003/10/145,821,09920.6520.8320.1420.582003/10/156,219,95020.5220.8720.4220.522003/10/167,229,87720.4820.7020.1720.312003/10/176,828,72820.4320.7719.5520.552003/10/208,137,66520.7521.7320.1421.572003/10/219,601,21521.8022.9621.1422.702003/10/226,720,86322.9123.3522.6323.082003/10/235,243,16823.1323.2822.7522.842003/10/244,160,21522.8722.9322.4322.552003/10/273,850,46022.4522.6622.2422.432003/10/284,483,31322.3522.6521.8922.462003/10/294,142,78222.3422.6022.2522.382003/10/304,339,51322.4522.8721.9822.702003/10/315,110,11922.8823.4522.3023.122003/11/44,471,16622.9223.2822.7722.692003/11/54,035,39522.6322.9422.3622.582003/11/63,785,51322.7123.0522.2922.942003/11/73,742,77523.0323.1922.8322.962003/11/103,889,62722.8723.1022.6822.922003/11/114,975,83922.9323.2322.7422.842003/11/125,488,77022.9323.0822.4322.612003/11/135,669,85222.7123.0922.0123.042003/11/146,557,81823.0823.5722.6823.532003/11/175,268,72823.3723.7123.0723.402003/11/185,617,19723.2723.5622.7823.122003/11/195,778,89423.2223.4922.6322.842003/11/206,464,37922.8622.9821.9222.122003/11/215,594,16822.0822.3521.5822.132003/11/244,051,67322.2722.5522.0722.282003/11/254,548,30622.1922.4521.6322.112003/11/264,118,53822.0822.3321.6421.84 2003/11/274,464,14121.8822.1621.5721.942003/11/284,117,57321.9322.2121.4522.112003/12/13,728,68822.2022.6221.9222.402003/12/24,246,02422.4822.8121.6122.482003/12/33,759,72122.5622.9322.3622.762003/12/43,865,21522.7323.1022.5122.892003/12/53,210,26122.8223.1022.3722.992003/12/82,842,65822.9223.0022.8622.732003/12/93,941,40122.6322.7922.4322.332003/12/105,109,57822.2322.5321.9322.082003/12/116,040,71821.9322.1621.7821.762003/12/127,766,76021.5021.6321.2021.372003/12/157,663,65021.2821.4120.6621.182003/12/167,111,37021.7621.8620.7021.562003/12/177,004,57122.1422.5121.9222.482003/12/185,265,87922.2922.6921.9822.562003/12/194,458,28322.5722.7722.2822.482003/12/224,608,19322.5822.8922.1322.442003/12/236,132,88722.6322.7722.4122.282003/12/246,454,32822.0722.1821.7821.972003/12/256,945,42122.0022.3821.6922.102003/12/266,597,33822.3922.8522.1622.472003/12/295,230,58322.6022.9122.3722.452003/12/305,191,19622.5422.8522.3322.422003/12/317,703,69922.5122.6322.2222.322004/1/19,774,28122.3722.5421.9322.262004/1/212,111,22721.5922.3421.3022.072004/1/516,645,82521.0821.9520.5721.742004/1/68,905,41921.6321.7520.9921.412004/1/76,586,69921.4121.7820.9921.412004/1/86,183,34621.5821.9221.4321.722004/1/95,413,82321.6521.7121.1421.432004/1/125,696,02021.3021.4221.1121.162004/1/136,328,53721.0621.2420.8620.972004/1/146,976,01620.8421.0220.6420.642004/1/156,952,25820.5820.9220.5220.662004/1/166,917,36621.0421.4020.4921.162004/1/197,515,81221.7522.0521.4821.802004/1/205,985,52521.7122.2821.4621.982004/1/215,037,75321.9622.5221.7422.212004/1/234,368,97622.1022.5522.1022.042004/1/265,642,76121.8522.4421.7422.032004/1/276,098,76921.9322.6621.7522.382004/1/285,488,63322.3222.9422.0722.792004/1/295,848,45322.8823.3222.5623.162004/1/305,821,45523.2123.5923.1023.282004/2/25,067,94823.0823.3723.0122.93 2004/2/34,980,05322.8522.9822.5622.462004/2/44,449,25622.5022.8022.2722.382004/2/55,872,87822.4822.7822.2122.642004/2/67,436,98622.7023.1922.4023.072004/2/910,384,45322.9923.9622.5323.672004/2/1014,452,98123.6025.3223.1524.922004/2/1113,132,43325.0127.0423.9226.832004/2/1210,366,82827.2728.1426.5327.772004/2/137,553,35328.1428.2327.5927.742004/2/164,406,89827.6428.0927.0027.692004/2/174,717,46427.6828.4626.8728.312004/2/183,484,75828.3428.7828.0328.542004/2/192,969,09728.5928.9628.3528.692004/2/232,776,53328.7928.9228.2028.772004/2/242,169,62028.6628.8128.4328.532004/2/252,284,07428.4928.9028.1728.552004/2/262,978,23328.5928.9128.4428.482004/2/273,620,67728.5228.6828.2328.332004/3/15,684,63928.1228.6627.2027.912004/3/25,808,27527.3428.3727.2627.442004/3/35,884,27927.0928.0126.5627.212004/3/45,277,29926.8927.4926.3226.662004/3/55,271,30826.8627.4026.0626.872004/3/85,496,46227.3627.6727.0526.972004/3/96,254,22326.7827.2126.4026.212004/3/107,532,87425.9426.4225.3625.902004/3/118,402,08425.6326.9124.6526.632004/3/127,928,71526.4927.8825.6827.572004/3/168,102,23727.0227.7326.8027.172004/3/178,198,52826.4926.9025.7425.892004/3/186,312,49225.9926.3925.7125.522004/3/196,584,25325.6725.8925.0824.952004/3/226,222,54824.9325.4924.4824.752004/3/235,908,85124.6725.1924.1824.622004/3/245,742,39424.6224.9024.0724.072004/3/256,495,44124.0824.4823.6223.932004/3/266,304,89223.7824.1423.6223.822004/3/296,593,67823.8024.3523.0424.282004/3/306,053,27824.3225.1423.7224.792004/3/315,033,42824.8425.2724.4124.762004/4/15,075,18625.0225.6824.3225.462004/4/25,228,07625.5926.1225.3225.892004/4/54,829,33325.9026.2725.3226.232004/4/66,295,17326.1526.6625.8526.112004/4/76,798,74826.0226.2925.2325.462004/4/87,663,92025.3325.7124.8925.142004/4/99,572,52725.1125.1624.0724.24 2004/4/127,719,18024.4424.5424.0624.092004/4/137,257,98424.1824.3023.4123.842004/4/147,202,22824.0324.2823.6923.912004/4/157,784,63324.0724.2523.5923.742004/4/167,413,61423.8024.0123.0422.962004/4/207,009,73922.9423.4522.5422.832004/4/217,364,33422.7823.2722.3622.942004/4/226,945,87622.9323.1722.3422.672004/4/237,442,49622.5522.7421.9822.202004/4/268,344,75822.0722.3421.4022.022004/4/278,581,25722.0722.5421.5821.852004/4/2810,825,28121.9823.0221.6022.312004/4/2911,073,50122.5923.5122.1322.952004/4/3010,789,28523.1423.8622.8022.792004/5/310,658,96823.3323.6621.8722.232004/5/411,581,50923.1123.5522.3322.822004/5/59,040,66622.9323.7422.1023.652004/5/68,457,04023.5724.5423.0724.392004/5/77,715,16523.9924.6723.7024.232004/5/106,781,88023.8124.2523.6823.512004/5/117,307,52723.5523.8423.1023.132004/5/126,542,77623.1023.4722.7523.162004/5/137,710,90723.2323.7622.6523.562004/5/147,787,91623.4824.1922.9523.932004/5/177,848,93323.7824.5623.4424.192004/5/1810,304,69524.1025.2923.4425.002004/5/1911,667,26225.3726.3824.5625.942004/5/2013,087,28326.5227.6325.8927.152004/5/2110,552,14426.8727.2526.6126.362004/5/249,474,52025.7626.2125.2425.302004/5/257,537,97325.3226.2424.8625.622004/5/266,549,12925.6526.4325.5325.662004/5/277,955,00725.7726.3424.8925.402004/5/288,581,15024.5925.1123.1024.272004/5/319,363,32822.6522.9921.8621.842004/6/113,274,10321.9121.9920.6321.292004/6/27,910,08621.3921.4420.8620.942004/6/37,237,41421.2521.5120.7121.192004/6/48,633,37321.2921.6320.6421.33