補充資料：
如何獲取所有股票歷史數據：
如果要對股市進行分析，首先就要獲取所有股票的歷史數據，只有通過股票的歷史數據，我們才能分析出股市的規律。
（以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:"/zhidao/wh%3D450%2C600/sign=e47f0ea0ee50352ab1342d0c6673d7c4/267f9e2f07082838c1bcdd03bf99a9014c08f170.jpg",mavinDesc:"接觸和從事互聯網行業，已有5、6年的時間了。現主要工作是SEO（搜索引擎優化）。"},isAnonymous:"0",isCurrentUser:"0",mapUrl:"",refer:"",replyAskNum:"",threadId:"11709284285",hasComment:"1",qid:"388993703",raid:"",recommendCanceled:"0"}; F.context('answers')['2927321071']['c_timestamp'] = '1530839576'; F.context('answers')['2927321071'].encodeUid = 'cf624069236f25705e793024'; F.context('answers')['2927321071'].ext_pack = {"anony_good_value":"6","from_feedback":"1","mode_begintime":"0","mode_qtype":"0","op_uid":"0","partner":[],"reason_1_2":"2","reply_entry":"qb_none_none"}; F.context('answers')['2927321071'].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"}; 人名重後賢4
2018-07-06·知道合夥人互聯網行家人名重後賢4
知道合夥人互聯網行家采納數：251獲贊數：2739接觸和從事互聯網行業，已有5、6年的時間了。現主要工作是SEO（搜索引擎優化）。
向TA提問私信TA關註展開全部以前的大多都不能下載了，要麽都要求好高，反正都限制了。
反倒是壹些個人愛好者還在做，我經常在“數據即服務”這個微信公眾號上下載，沒啥限制，數據十幾年的都有，就是從上市到現在的，Excel格式的。
其實現在壹些網站和軟件都變了，不再像以前那麽好心提供了，妳也可以在微信公眾號看看其他的，個人的還好些。已贊過已踩過妳對這個回答的評價是？評論收起12下壹頁>收起5條折疊回答收起更多回答（7）推薦律師服務：若未解決您的問題，請您詳細描述您的問題，通過百度律臨進行免費專業咨詢其他類似問題2016-12-28如何導出股票的全部行情數據4更多類似問題?>為妳推薦：特別推薦 F.context('cmsRight', [ { 'url':'/d01373f082025aaf511aa256e9edab64034f1a07?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_450%2Ch_600%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto', 'contractId':'A24KA00562', } ]); 癌癥的治療費用為何越來越高？“網絡廁所”會造成什麽影響？電動車多次降價，品質是否有保障？華強北的二手手機是否靠譜？為妳推薦 F.context('recBrand',[{"img":"\/86d6277f9e2f07083523f69dfb24b899a901f20d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_450%2Ch_600%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto","url":"/hm.js?6859ce5aaf00fb00387e6434e4fcc925"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(hm, s); })(); window.tt = 1721471437;