補充資料：
如何獲取所有股票歷史數據：
如果要對股市進行分析，首先就要獲取所有股票的歷史數據，只有通過股票的歷史數據，我們才能分析出股市的規律。
（以Think pad X13 銳龍版筆記本電腦，Windows 10 操作為例）
壹、工具/原料
1、EXCEL2007或者以上版本，不能使用WPS
2、電腦1g內存1核處理器及以上配置
3、擁有較強邏輯分析能力以及少量智慧及以上的大腦壹顆
方法/步驟：
第壹步，獲取股票代碼，復制其中壹部分到第壹個工作表A4到A127，然後通過程序把每壹個代碼寫入到不同的工作表A2位置，並對該工作表以該股票代碼命名。程序如下：
Sub 工作表命名()
For i = 4 To 127
Sheets(i).Range("a2") = "'" & Sheets(1).Range("a" & i)
Next i
For i = 4 To Sheets.Count
Sheets(i).Name = Sheets(i).Range("a2").Value
Next
End Sub
第二步，獲取股票歷史數據。代碼如下：
Private Function GetSource(sURL As String) As String
Dim oXHTTP As Object
Set oXHTTP = CreateObject("MSXML2.XMLHTTP")
oXHTTP.Open "GET"， sURL， False
oXHTTP.Send
GetSource = oXHTTP.responsetext
Set oXHTTP = Nothing
End Function
Sub 歷史數據()
Dim objXML As Object
Dim txtContent As String
Dim i As Integer
Dim strCode As String
Dim gp As String
Dim kaishihang
Dim arr， arr1， arr2， arr3， arr4， arr5， arr6， arr7， arr8， arr9， arr10， arr11
On Error Resume Next
EndRow = Range("a65536").End(xlUp).Row
startRow = 4
If startRow Range(Cells(startRow， 1)， Cells(EndRow， 11)).Value = ""
Else
Exit Sub
End If
Set objXML = CreateObject("Microsoft.XMLHTTP")
gp = [A2]
For h = 1 To 4
For m = 1 To 4
kaishihang = [A65535].End(xlUp).Row
nian = Replace(Str(Year(Now) + 1 - h)， " "， "")
jidu = Replace(Str(4 + 1 - m)， " "， "")
With objXML
.Open "GET"， "ame:"股票"}],isAuth:"0",authTitle:"",isUserAdmin:"0",userAdminLevel:"",userAdminTitle:"",userAdminType:"",isFamous:"0",isMaster:"0",goodRate:"47"},isAnonymous:"0",isCurrentUser:"0",mapUrl:"",refer:"",replyAskNum:"1",threadId:"3833623469",hasComment:"1",qid:"388993703",raid:"43229295",recommendCanceled:"0"}; F.context('answers')['958405867']['c_timestamp'] = '1330863451'; F.context('answers')['958405867'].encodeUid = '87334069236f25705e794209'; F.context('answers')['958405867'].ext_pack = {"anony_bad_value":"4","anony_good_value":"2","authentic_refuse":"1","authentic_time":"1436595632","authentic_uid":"617178426","dynamic_optime":"1658779812","dynamic_score_detail":"{\"qua_score\":2862,\"time_score\":null,\"ide_score\":null,\"pre_score\":1001623}","high_light":"\u540c\u82b1\u987a||\u5f00\u76d8\u4ef7","recTime":"0","relate_word":["\u540c\u82b1\u987a"]}; F.context('answers')['958405867'].bit_pack = {"is_recommend":"1","wap_flag":"0","is_pic_contained":"0","media_flag":"0","help_flag":"0","anonymous":"0","is_really_anonymous":"0","level_new":"1","comment_flag":"1","in_mis":"0","auto_recommend":"1","content_rich_flag":"0","prior_flag":"1","hidden_flag":"0","rec_canceled_flag":"0","mis_flag":"0","file_flag":"0","read_flag":"0","is_challenge":"0","ikaudio_flag":"0","mavin_flag":"0","is_delete_lock":"0","authentic_state":"1","is_compulsory_best":"0","dynamic_stick_flag":"0","video_flag":"0","vote_affirmative":"0","vote_negative":"0","is_video":"0","is_baiduyun":"0","is_yike_card":"0","is_baidumap":"0","is_note":"0"}; 徐元極gP
2012-03-04·TA獲得超過1974個贊知道小有建樹答主回答量：1049采納率：0%幫助的人：509萬我也去答題訪問個人頁關註展開全部以同花順股票軟件為例：首先切換到要下載數據的股票K線形態，按“F1”進入“日線某某股票歷史成交”，點擊鼠標右鍵->數據導出->導出所有數據->在“請選擇導出的類型”中選擇excel或txt,,只有這二種格式可以選擇；選取好後點擊下壹步，在“導入導出對話框模板”中選擇妳要的項目（如最高價、最低價，開盤價等，默認是全選），點下壹步，完成。默認保存路徑在桌面上。追問有沒有可以批量下載所有股票的歷史數據，這樣壹個壹個地下載太費時費力了，謝謝！追答沒有批量下載，只能壹個壹個來。本回答被網友采納已贊過已踩過妳對這個回答的評價是？評論收起 F.context('answers')['958821204'] = {uid:"0",imId:"0",isAnonymous:"1",isCurrentUser:"0",mapUrl:"",refer:"",replyAskNum:"1",threadId:"3835284817",hasComment:"0",qid:"388993703",raid:"43193036",recommendCanceled:"0"}; F.context('answers')['958821204']['c_timestamp'] = '1330916221'; F.context('answers')['958821204'].encodeUid = '0'; F.context('answers')['958821204'].ext_pack = {"dynamic_optime":"1658779812","dynamic_score_detail":"{\"qua_score\":2054,\"time_score\":null,\"ide_score\":null,\"pre_score\":1002100}"}; F.context('answers')['958821204'].bit_pack = {"is_recommend":"0","wap_flag":"0","is_pic_contained":"0","media_flag":"0","help_flag":"0","anonymous":"1","is_really_anonymous":"0","level_new":"1","comment_flag":"0","in_mis":"0","auto_recommend":"0","content_rich_flag":"0","prior_flag":"1","hidden_flag":"0","rec_canceled_flag":"0","mis_flag":"0","file_flag":"0","read_flag":"0","is_challenge":"0","ikaudio_flag":"0","mavin_flag":"0","is_delete_lock":"0","authentic_state":"0","is_compulsory_best":"0","dynamic_stick_flag":"0","video_flag":"0","vote_affirmative":"0","vote_negative":"0","is_video":"0","is_baiduyun":"0","is_yike_card":"0","is_baidumap":"0","is_note":"0"}; 匿名用戶
2012-03-05展開全部以華中智能股票軟件為例：首先切換到要下載數據的股票K線形態，按“F1”進入“日線某某股票歷史成交”，點擊鼠標右鍵->數據導出->導出所有數據->在“請選擇導出的類型”中選擇excel或txt,,追問有沒有可以批量下載所有股票的歷史數據，這樣壹個壹個地下載太費時費力了，謝謝！已贊過已踩過妳對這個回答的評價是？評論收起 F.context('answers')['961436030'] = {uid:"580533802",imId:"public.1.28bad583.MLc6syCaYviPxpVVEpIYTQ",id:"961436030",userName:"Trader309",userNameEnc:"Trader309",user:{sex:"1",iconType:"6",gradeIndex:"2",grAnswerNum:"0",isAuth:"0",authTitle:"",isUserAdmin:"0",userAdminLevel:"",userAdminTitle:"",userAdminType:"",isFamous:"0",isMaster:"0"},isAnonymous:"0",isCurrentUser:"0",mapUrl:"",refer:"",replyAskNum:"",threadId:"3845744121",hasComment:"1",qid:"388993703",raid:"",recommendCanceled:"0"}; F.context('answers')['961436030']['c_timestamp'] = '1331118361'; F.context('answers')['961436030'].encodeUid = '2a3e4069236f25705e799a22'; F.context('answers')['961436030'].ext_pack = {"anony_bad_value":"2","dynamic_optime":"1658779812","dynamic_score_detail":"{\"qua_score\":1867,\"time_score\":null,\"ide_score\":null,\"pre_score\":1002658}","recTime":"1612006033"}; F.context('answers')['961436030'].bit_pack = {"is_recommend":"0","wap_flag":"0","is_pic_contained":"0","media_flag":"0","help_flag":"0","anonymous":"0","is_really_anonymous":"0","level_new":"1","comment_flag":"1","in_mis":"0","auto_recommend":"0","content_rich_flag":"0","prior_flag":"0","hidden_flag":"0","rec_canceled_flag":"0","mis_flag":"0","file_flag":"0","read_flag":"0","is_challenge":"0","ikaudio_flag":"0","mavin_flag":"0","is_delete_lock":"0","authentic_state":"0","is_compulsory_best":"0","dynamic_stick_flag":"0","video_flag":"0","vote_affirmative":"0","vote_negative":"0","is_video":"0","is_baiduyun":"0","is_yike_card":"0","is_baidumap":"0","is_note":"0"}; Trader309
推薦於2021-01-30知道答主回答量：7采納率：0%幫助的人：1.1萬我也去答題訪問個人頁關註展開全部百度搜：大富翁數據中心，他們有提供這個，價格也不貴，花點小錢辦大事，歷史壹分鐘，五分鐘，任意分鐘都有，還有分筆，逐筆等，股票期貨外匯全有。 還有每天盤後提供下載已贊過已踩過妳對這個回答的評價是？評論收起 F.context('answers')['2927321071'] = {uid:"607150799",imId:"public.1.6e728c48.l8I9_Tr3Mfx2Oc4otHllJg",passPhoto:"1",id:"2927321071",userName:"找到那壹撇",userNameEnc:"%E6%89%BE%E5%88%B0%E9%82%A3%E4%B8%80%E6%92%87",user:{sex:"1",iconType:"6",gradeIndex:"9",grAnswerNum:"251",carefield: [{cid:"74",cname:"電腦/網絡"},{cid:"154",cname:"家居裝修"}],isAuth:"0",authTitle:"",isUserAdmin:"0",userAdminLevel:"",userAdminTitle:"",userAdminType:"",isFamous:"0",isMaster:"0",goodRate:"58",mavinUtype:"0",mavinIsNew:"1",mavinName:"找到那壹撇",mavinTitle:"知道合夥人互聯網行家",mavinAnswerNum:"849",mavinAdoptNum:"251",mavinLevel:"1",mavinLevelTitle:"",mavinMajor:"1",mavinHelpNum:"176萬",mavinPraise:"2757",mavinLevelDesc:"",mavinFields: ["互聯網"],mavinAvatar:"82p8{vertical-align:top}.jzjg54b{background-image:url(82p8:after,.y4mca6a:after{-webkit-font-smoothing:antialiased;color:#999;display:inline-block;font-family:ecomicons;font-size:16px;font-style:normal;font-variant:normal;font-weight:400;line-height:1;text-transform:none}.wcn82p8:after{content:""}.kbsse7b:after{content:""}.hmz7uhn:after{content:""}._5eaqmrb:after{content:""}.hdq8k3m:after{content:""}.h1cy1u2:after{content:""}.y4mca6a:after{content:"06"}.mgukwmc{background-image:url(//nv00.cdn.bcebos.com/nv01/static/ecom/iphone_icons/consult-4b14dbfbfb.svg);background-size:16px 16px;height:16px;margin-top:-2px;width:16px}.mgukwmc,.uv6nn3t{display:inline-block;vertical-align:middle}.uv6nn3t{background-image:url(.cdn.bcebos.com/icon_ask.svg);background-size:14px 14px;height:14px;margin-top:-4px;width:14px}.rpyu4qw,.rpyu4qw:after{color:#92b9f8}.dcwrt3z{background-image:url(/nv01/static/ecom/iphone_icons/open-icon-79fc6653f2.svg);background-size:12px 12px;height:12px;margin-top:-1px;vertical-align:middle;width:12px}.dcwrt3z,.ub4bu1k{display:inline-block}.ub4bu1k{align-items:center;border-radius:50%;display:flex;height:16px;justify-content:center;width:16px}.ub4bu1k:after{border-right:1px solid #858585;border-top:1px solid #858585;content:"";transform:translateX(-1px) rotate(45deg);width:5px}.rhb42mg,.ub4bu1k:after{display:inline-block;height:5px}.rhb42mg{background:url(.cdn.bcebos.com/icon-down-arrow.png) no-repeat;background-size:contain;margin-left:3px;width:13.3px}.g7urw9u{background:url(/nv01/static/ecom/iphone_icons/speaker-icon-3aa8f67fc1.svg) 50% no-repeat;background-size:14px 14px;display:inline-block;height:14px;position:relative;width:14px}.t6j42ms{background-image:url(.cdn.bcebos.com/icon-shoppingcar-red.svg);background-size:16px 16px;margin-top:-2px}.ec_font_consult_pc,.t6j42ms{display:inline-block;height:16px;vertical-align:middle;width:16px}.ec_font_consult_pc{background-image:url(//nv00.cdn.bcebos.com/nv01/static/ecom/iphone_icons/pc-consult-icon-c84e9d2571.svg);position:relative;top:-1px}.ec-icon-qrcode{background-image:url(//nv00.cdn.bcebos.com/nv01/static/ecom/iphone_icons/ec-qr-3c7d2b63fb.svg);display:inline-block;height:18px;position:relative;right:2px;top:-2px;vertical-align:middle;width:18px}.em8wr4b{background-color:#f5f5f5}@charset "UTF-8";body ._886bxmw{font-size:12px;line-height:22px;padding-top:0;transform:translateY(.4166666667em)}body ._886bxmw:before{content:"";display:block;height:0;margin-top:-10px}body ._886bxmw a,body ._886bxmw div{color:#333}body ._886bxmw .d81nas8{color:#999;font-size:15px;line-height:25px}body ._886bxmw ._9mnfgfc{margin-right:5px}._886bxmw font{color:#34b458}.ec-2246 ._886bxmw font{color:#c60a00}.ec-2246 ._886bxmw{font-size:16px}.ec-2246 ._8gpc1uj{position:relative}.ec-2246 ._8gpc1uj:after{background-color:#fff;bottom:0;color:#34b458;content:"點擊查看詳情";display:inline-block;padding-left:10px;padding-right:0;position:absolute;right:0}.ec-2246 ._8gpc1uj:before{background-image:linear-gradient(270deg,#fff,hsla(0,0%,100%,0));bottom:0;content:"";height:29px;position:absolute;right:90px;width:47px}.gkz1g7v{color:#000;display:block;font-size:14px;line-height:22px;padding-top:0;transform:translateY(.2857142857em)}.gkz1g7v:before{content:"";display:block;height:0;margin-top:-8px}.hk5ej48{color:#f60;font-size:14px;line-height:22px;padding-top:0;transform:translateY(.2857142857em);vertical-align:middle}.hk5ej48:before{content:"";display:block;height:0;margin-top:-8px}div.rdfj8qz{padding-left:2px;padding-right:2px}._7fkq62g{margin-left:-2px;margin-right:-2px;padding-right:40px}._7fkq62g .rdfj8qz{background-color:#ebf0f1;margin-left:0;margin-right:8px;padding:0}.qdhzv3w{-webkit-box-flex:4;align-items:center;background:#ebf0f1;display:flex;-webkit-flex:4 4 auto;font-size:12px;justify-content:center;text-align:center;width:33.33333333%}.qdhzv3w a{cursor:pointer;font-size:12px;line-height:12px}.qdhzv3w a,.qdhzv3w a:active,.qdhzv3w a:hover,.qdhzv3w a:visited{color:#7a8f9a}.akchcut{-webkit-box-align:stretch;-webkit-box-lines:single;-webkit-box-orient:horizontal;-webkit-box-pack:justify;-webkit-align-content:flex-start;-webkit-align-items:stretch;display:flex;display:-ms-flexbox;-webkit-flex-wrap:nowrap;-webkit-justify-content:space-between;margin-left:-1%;margin-right:-1%;width:auto}._4d1k38u,._4xe2q8a,._7khr1fb,._8p6hqr6,.cchkup1,.fyvpkbs,.hc2xyr5,.k5am1ka,.q36b955,.t8yrmj3,.us9bvq9,.zp9f283{min-height:1px;padding-left:1%;padding-right:1%;position:relative}.k5am1ka{-moz-box-flex:1;-webkit-box-flex:1;flex:1;-ms-flex:1;-webkit-flex:1 1 auto;width:8.33333333%}._4d1k38u{-moz-box-flex:2;-webkit-box-flex:2;flex:2;-ms-flex:2;-webkit-flex:2 2 auto;width:16.6666666%}.q36b955{-moz-box-flex:3;-webkit-box-flex:3;flex:3;-ms-flex:3;-webkit-flex:3 3 auto;width:25%}.cchkup1{-moz-box-flex:4;-webkit-box-flex:4;flex:4;-ms-flex:4;-webkit-flex:4 4 auto;width:33.33333333%}.zp9f283{-moz-box-flex:5;-webkit-box-flex:5;flex:5;-ms-flex:5;-webkit-flex:5 5 auto;width:41.66666667%}._7khr1fb{-moz-box-flex:6;-webkit-box-flex:6;flex:6;-ms-flex:6;-webkit-flex:6 6 auto;width:50%}._4xe2q8a{-moz-box-flex:7;-webkit-box-flex:7;flex:7;-ms-flex:7;-webkit-flex:7 7 auto;width:58.3333333%}.fyvpkbs{-moz-box-flex:8;-webkit-box-flex:8;flex:8;-ms-flex:8;-webkit-flex:8 8 auto;width:66.66666667%}.hc2xyr5{-moz-box-flex:9;-webkit-box-flex:9;flex:9;-ms-flex:9;-webkit-flex:9 9 auto;width:75%}.t8yrmj3{-moz-box-flex:10;-webkit-box-flex:10;flex:10;-ms-flex:10;-webkit-flex:10 10 auto;width:83.3333333%}.us9bvq9{-moz-box-flex:11;-webkit-box-flex:11;flex:11;-ms-flex:11;-webkit-flex:11 11 auto;width:91.66666667%}._8p6hqr6{-moz-box-flex:12;-webkit-box-flex:12;flex:12;-ms-flex:12;-webkit-flex:12 12 auto;width:100%}.akchcut *{box-sizing:border-box}._3yw1ejd{justify-content:center}._3yw1ejd,._6gpgxmk{display:flex;flex-direction:column}._4dn6d3c{flex:1;-webkit-flex:1}.q6tmvmu{align-items:center;display:flex;justify-content:center}.nuj2ghy{line-height:0}._82rg9c1{margin-right:6px;padding-right:0}._3f746qg{margin-right:8px;padding-right:0}._2kafetg{padding-left:0}.h54pdk9{margin-right:9px;padding-right:0}.nxxbs5j{margin-top:auto}.sde9q3d .akchcut:last-child>div>div:last-child{margin-bottom:0}.qeb9494{padding-bottom:100%}.cbnvsmc{padding-bottom:133.33333333%}.bd8dsh2{padding-bottom:33.3333333333%}.s8vwdyg{padding-bottom:56.25%}._7647yj6{padding-bottom:50%}._3hu75mr{padding-bottom:75%}.kdcm6p9{padding-bottom:66.66666667%}.xgdthff{padding-bottom:40%}.wagcupv{background-position:50%;background-repeat:no-repeat;background-size:cover}._3hu75mr,._7647yj6,.bd8dsh2,.cbnvsmc,.kdcm6p9,.qeb9494,.s8vwdyg,.xgdthff{height:0;overflow:hidden}._3hu75mr img,._7647yj6 img,.bd8dsh2 img,.cbnvsmc img,.kdcm6p9 img,.qeb9494 img,.s8vwdyg img,.xgdthff img{width:100%}.dycvwv4{border-radius:9px}._1kcc4s3{border-top-left-radius:0}.f9mstuk{border-top-right-radius:0}._24395ct{border-bottom-right-radius:0}.r1yfcd1{border-bottom-left-radius:0}.qd9k1mu{color:#333;font-size:14px;line-height:24px;margin-top:2px}.qhn3ktc{color:#f60;font-size:14px;line-height:22px;margin:5px 0;vertical-align:middle}._6ad8bqy{position:relative}.a85j8fv{background:radial-gradient(transparent 50%,rgba(0,0,0,.05) 100%);height:100%;left:0;position:absolute;top:0;transform:translateZ(0);width:100%}.dycvwv4 .a85j8fv{border-radius:9px}._1kcc4s3 .a85j8fv{border-top-left-radius:0}.f9mstuk .a85j8fv{border-top-right-radius:0}._24395ct .a85j8fv{border-bottom-right-radius:0}.r1yfcd1 .a85j8fv{border-bottom-left-radius:0}._6ad8bqy.qeb9494{height:92px;padding-bottom:0}.ec-2246 ._6ad8bqy.kdcm6p9{height:160px;margin:auto;padding:0;width:240px} 廣告您可能關註的內容股票哪比較好-點擊進入網站m.lj168.com查看更多 !function(t){"use strict";function e(t,e){if(t){var n=new Date().getTime(),i=new Image;t+="&rand="+(n+Math.random()),window.ecomLogImage||(window.ecomLogImage={}),window.ecomLogImage["--IMAGE"+n]=i,e=e||{};var r=!1;i.onload=i.onerror=i.onabort=function(o){if(!e.charge){if(o&&"load"!==o.type){if(r)"error"in e&&e.error();else{i.src=t,r=!0;return}}else"load"in e&&e.load()}i.onload=i.onerror=i.onabort=null,window.ecomLogImage["--IMAGE"+n]=null,i=null},i.src=t}}var n,i=function(){var t,e,n,i=0,r=0,o=0,s=0,a=0,c=0,u=0,l=0,h=/link\?url\=([^\&]+)/,f=/\?url\=([^\.]+)\./,d="data-cklink",p=/[?&]tn=([^&]*)/;function v(t){if(!t)return!1;var e=h.exec(t)||f.exec(t);return!!e&&(h.exec(t)?e[1].length