VBA能否編寫自動補充指定品種數據 [金字塔]
- 咨詢內容:
我想偷懶,哈哈。有沒有可以用VBA編寫自動補充指定品種的歷史行情數據的,給個思路就行;
下面是論壇精華里的自動補分筆數據,是不是按照這個類似的,代碼不是看得太懂;
Sub SJBC()
'16~17點開始補分筆數據
if application.ReceiveDataStatus=0 then application.ReceiveData(1)
Application.PeekAndPump
application.SendMessage(33882)
call application.Settimer(1,600000)
call application.Settimer(2,9000000)
Set Wrap = CreateObject("DynamicWrapper")
Wrap.Register "user32.dll","FindWindowA","i=ss","f=s", "r=l"
Wrap.Register "user32.dll","FindWindowExA","i=llss","f=s", "r=l"
Wrap.Register "user32.dll","SendMessageA","i=lull","f=s", "r=l"
h = Wrap.FindWindowA("#32770","數據接收")
tab=Wrap.FindWindowExA(h,0,"SysTabControl32","")
TCM_SETCURFOCUS=4912
WM_SETFOCUS=7
WM_KEYDOWN=256
WM_KEYUP=257
BM_CLICK=245
Wrap.SendMessageA tab,TCM_SETCURFOCUS,2,0
h1=Wrap.FindWindowExA(h,0,"#32770","自定義補數據")
cb=Wrap.FindWindowExA(h1,0,"ComboBox","")
Wrap.SendMessageA cb,WM_SETFOCUS,0,0
Wrap.SendMessageA cb,WM_KEYDOWN,VK_DOWN,0
Wrap.SendMessageA cb,WM_KEYUP,VK_DOWN,0
bt=0
bt=Wrap.FindWindowExA(h1,0,"Button","開始補充")
Wrap.SendMessageA bt,BM_CLICK,0,0
if bt<>0 then todayhas=1
End Sub - 金字塔客服:
VBA不提供直接的方法操作補數據,你帖子提到的代碼是通過WINDOWS的API通過模擬鼠標操作來實現自動數據補充的
- 用戶回復: 謝謝回復,我知道了!那我還是自己點點好了;謝謝!
有思路,想編寫各種指標公式,程序化交易模型,選股公式,預警公式的朋友
可聯系技術人員 QQ: 1145508240 (不貴!點擊查看價格!)
相關文章
-
沒有相關內容