VBA能否編寫(xiě)自動(dòng)補(bǔ)充指定品種數(shù)據(jù) [金字塔]
- 咨詢(xún)內(nèi)容:
我想偷懶,哈哈。有沒(méi)有可以用VBA編寫(xiě)自動(dòng)補(bǔ)充指定品種的歷史行情數(shù)據(jù)的,給個(gè)思路就行;
下面是論壇精華里的自動(dòng)補(bǔ)分筆數(shù)據(jù),是不是按照這個(gè)類(lèi)似的,代碼不是看得太懂;
Sub SJBC()
'16~17點(diǎn)開(kāi)始補(bǔ)分筆數(shù)據(jù)
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","數(shù)據(jù)接收")
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","自定義補(bǔ)數(shù)據(jù)")
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","開(kāi)始補(bǔ)充")
Wrap.SendMessageA bt,BM_CLICK,0,0
if bt<>0 then todayhas=1
End Sub - 金字塔客服:
VBA不提供直接的方法操作補(bǔ)數(shù)據(jù),你帖子提到的代碼是通過(guò)WINDOWS的API通過(guò)模擬鼠標(biāo)操作來(lái)實(shí)現(xiàn)自動(dòng)數(shù)據(jù)補(bǔ)充的
- 用戶(hù)回復(fù): 謝謝回復(fù),我知道了!那我還是自己點(diǎn)點(diǎn)好了;謝謝!
有思路,想編寫(xiě)各種指標(biāo)公式,程序化交易模型,選股公式,預(yù)警公式的朋友
可聯(lián)系技術(shù)人員 QQ: 1145508240 進(jìn)行 有償 編寫(xiě)!(不貴!點(diǎn)擊查看價(jià)格!)
相關(guān)文章
-
沒(méi)有相關(guān)內(nèi)容