stkindi請教　[金字塔]

各位好， 我在一個窗體里面設了一個timer， 然后timer激發的時候我想去讀一個公式的返回值， 但是總返回0， 不知道是什么問題，請各位前輩幫我看一下， stkindi用的是說明里的例子

這是我的code

Sub APPLICATION_Timer(ID)

  If ID=10 then
        Application.msgout Cdate(time) & ",10o???ê±?÷′￥·￠á?"
   

  Set Formula = marketdata.STKINDI(QT_MARKET,QT_MARKETID,"ma(5,10,20,60)",0,0)
  ma1 = Formula.GetBufData("ma1",Formula.DataSize-1)
  
  application.MsgOut  Formula.DataSize
  application.MsgOut  "inside timer ma1 = " & ma1 '??ê?μú2?ùk??é?μ?MA3??±ê??êy?μ
 end if
End Sub

22:08:15,10號計時器觸發了
0
inside timer ma1 = 0

為什么返回不了ma1的值呢？我的圖上需要打開這個公式vba才能返回嗎？ 謝謝

Sub APPLICATION_Timer(ID)

  If ID=10 then
 Application.msgout Cdate(time) & "你好"
 Set Formula = marketdata.STKINDI("if08","zj","ma(5,10,20,60)",0,0) '調用中金所IF08合約的1分鐘的MA移動平均線指標,參數依次是5,10,20,60

 ma1 = Formula.GetBufData("ma1",Formula.DataSize-1)
 application.MsgOut  Formula.DataSize
 application.MsgOut  "inside timer ma1 = " & ma1
  end if
End Sub

樓主是否還應在另外一個函數中去調用Application.SetTimer()

Sub APPLICATION_Timer(ID)

  If ID=10 then
 Application.msgout Cdate(time) & "你好"
 Set Formula = marketdata.STKINDI("if08","zj","ma(5,10,20,60)",0,0) '調用中金所IF08合約的1分鐘的MA移動平均線指標,參數依次是5,10,20,60

 ma1 = Formula.GetBufData("ma1",Formula.DataSize-1)
 application.MsgOut  Formula.DataSize
 application.MsgOut  "inside timer ma1 = " & ma1
  end if
End Sub

樓主是否還應在另外一個函數中去調用Application.SetTimer()

沒錯， 我已經在另外的地方調用setTimer, 原貼后半部分就是輸出

謝謝樓上的回復，我把你的code直接復制過去， 下面是輸出結果， 還是0

22:39:56,0號計時器觸發了
inside timer ma1 = 0
22:40:01,0號計時器觸發了
inside timer ma1 = 0
22:40:06,0號計時器觸發了
inside timer ma1 = 0
22:40:11,0號計時器觸發了
inside timer ma1 = 0
22:40:16,0號計時器觸發了
inside timer ma1 = 0
22:40:21,0號計時器觸發了
inside timer ma1 = 0
22:40:26,0號計時器觸發了
inside timer ma1 = 0
22:40:31,0號計時器觸發了
inside timer ma1 = 0
22:40:36,0號計時器觸發了
inside timer ma1 = 0
22:40:41,0號計時器觸發了
inside timer ma1 = 0
22:40:46,0號計時器觸發了
inside timer ma1 = 0
22:40:51,0號計時器觸發了
inside timer ma1 = 0
22:40:56,0號計時器觸發了
inside timer ma1 = 0
22:41:01,0號計時器觸發了
inside timer ma1 = 0
22:41:06,0號計時器觸發了
inside timer ma1 = 0
22:41:11,0號計時器觸發了
inside timer ma1 = 0
22:41:16,0號計時器觸發了
inside timer ma1 = 0
22:41:21,0號計時器觸發了
inside timer ma1 = 0
22:41:26,0號計時器觸發了
inside timer ma1 = 0
22:41:31,0號計時器觸發了
inside timer ma1 = 0
22:41:36,0號計時器觸發了
inside timer ma1 = 0
22:41:41,0號計時器觸發了
inside timer ma1 = 0
22:41:46,0號計時器觸發了
inside timer ma1 = 0
22:41:51,0號計時器觸發了
inside timer ma1 = 0
22:41:56,0號計時器觸發了
inside timer ma1 = 0
22:42:01,0號計時器觸發了
inside timer ma1 = 0
22:42:07,0號計時器觸發了
inside timer ma1 = 0
22:42:12,0號計時器觸發了
inside timer ma1 = 0
22:42:17,0號計時器觸發了
inside timer ma1 = 0
22:42:22,0號計時器觸發了
inside timer ma1 = 0
22:42:27,0號計時器觸發了
inside timer ma1 = 0
22:42:32,0號計時器觸發了
inside timer ma1 = 0
22:42:37,0號計時器觸發了
inside timer ma1 = 0
22:42:42,0號計時器觸發了
inside timer ma1 = 0
22:42:47,0號計時器觸發了
inside timer ma1 = 0
22:42:52,0號計時器觸發了
inside timer ma1 = 0
22:42:57,0號計時器觸發了
inside timer ma1 = 0
22:43:02,0號計時器觸發了
inside timer ma1 = 0
22:43:07,0號計時器觸發了
inside timer ma1 = 0
22:43:12,0號計時器觸發了
inside timer ma1 = 0
22:43:17,0號計時器觸發了
inside timer ma1 = 0
22:43:22,0號計時器觸發了
inside timer ma1 = 0
22:43:27,0號計時器觸發了
inside timer ma1 = 0
22:43:32,0號計時器觸發了
inside timer ma1 = 0
22:43:37,0號計時器觸發了
inside timer ma1 = 0
21:49:09,0號計時器觸發了
inside timer ma1 = 0
21:49:17,0號計時器觸發了
inside timer ma1 = 0
QT_MARKETID = DAX
QT_MARKET = MO
ma1 = 0
QT_MARKETID = DAX
QT_MARKET = MO
ma1 = 0
21:49:22,0號計時器觸發了
inside timer ma1 = 0
21:49:27,0號計時器觸發了
inside timer ma1 = 0
21:49:32,0號計時器觸發了
inside timer ma1 = 0
22:02:08,0號計時器觸發了
inside timer ma1 = 0
22:02:13,0號計時器觸發了
inside timer ma1 = 0
22:02:18,0號計時器觸發了
inside timer ma1 = 0
22:02:27,0號計時器觸發了
inside timer ma1 = 0
QT_MARKETID = DAX
QT_MARKET = MO
ma1 = 0
QT_MARKETID = DAX
QT_MARKET = MO
ma1 = 0
22:02:32,0號計時器觸發了
inside timer ma1 = 0
22:02:37,0號計時器觸發了
inside timer ma1 = 0
22:02:42,0號計時器觸發了
inside timer ma1 = 0
22:02:47,0號計時器觸發了
inside timer ma1 = 0
22:02:52,0號計時器觸發了
inside timer ma1 = 0
22:02:57,0號計時器觸發了
inside timer ma1 = 0
22:03:02,0號計時器觸發了
inside timer ma1 = 0
22:03:07,0號計時器觸發了
inside timer ma1 = 0
22:03:12,0號計時器觸發了
inside timer ma1 = 0
22:03:17,0號計時器觸發了
inside timer ma1 = 0
22:04:22,0號計時器觸發了
0
inside timer ma1 = 0
QT_MARKETID = DAX
QT_MARKET = MO
ma1 = 0
QT_MARKETID = DAX
QT_MARKET = MO
ma1 = 0
22:04:31,0號計時器觸發了
0
inside timer ma1 = 0
22:04:36,0號計時器觸發了
0
inside timer ma1 = 0
22:04:41,0號計時器觸發了
0
inside timer ma1 = 0
22:04:46,0號計時器觸發了
0
inside timer ma1 = 0
22:04:51,0號計時器觸發了
0
inside timer ma1 = 0
22:04:56,0號計時器觸發了
0
inside timer ma1 = 0
22:05:01,0號計時器觸發了
0
inside timer ma1 = 0
22:05:06,0號計時器觸發了
0
inside timer ma1 = 0
22:05:11,0號計時器觸發了
0
inside timer ma1 = 0
22:05:16,0號計時器觸發了
0
inside timer ma1 = 0
22:05:21,0號計時器觸發了
0
inside timer ma1 = 0
22:05:26,0號計時器觸發了
0
inside timer ma1 = 0
22:05:31,0號計時器觸發了
0
inside timer ma1 = 0
22:05:36,0號計時器觸發了
0
inside timer ma1 = 0
22:05:41,0號計時器觸發了
0
inside timer ma1 = 0
22:05:46,0號計時器觸發了
0
inside timer ma1 = 0
22:05:51,0號計時器觸發了
0
inside timer ma1 = 0
22:05:56,0號計時器觸發了
0
inside timer ma1 = 0
22:06:01,0號計時器觸發了
0
inside timer ma1 = 0
22:06:06,0號計時器觸發了
0
inside timer ma1 = 0
22:06:11,0號計時器觸發了
0
inside timer ma1 = 0
22:06:16,0號計時器觸發了
0
inside timer ma1 = 0
22:06:21,0號計時器觸發了
0
inside timer ma1 = 0
22:06:26,0號計時器觸發了
0
inside timer ma1 = 0
22:06:31,0號計時器觸發了
0
inside timer ma1 = 0
22:06:36,0號計時器觸發了
0
inside timer ma1 = 0
22:06:41,0號計時器觸發了
0
inside timer ma1 = 0
22:06:46,0號計時器觸發了
0
inside timer ma1 = 0
22:06:51,0號計時器觸發了
0
inside timer ma1 = 0
22:06:56,0號計時器觸發了
0
inside timer ma1 = 0
22:07:01,0號計時器觸發了
0
inside timer ma1 = 0
22:07:06,0號計時器觸發了
0
inside timer ma1 = 0
22:07:11,0號計時器觸發了
0
inside timer ma1 = 0
22:07:16,0號計時器觸發了
0
inside timer ma1 = 0
22:07:21,0號計時器觸發了
0
inside timer ma1 = 0
22:07:26,0號計時器觸發了
0
inside timer ma1 = 0
22:07:31,0號計時器觸發了
0
inside timer ma1 = 0
22:07:36,0號計時器觸發了
0
inside timer ma1 = 0
22:07:41,0號計時器觸發了
0
inside timer ma1 = 0
22:08:01,0號計時器觸發了
0
inside timer ma1 = 0
QT_MARKETID = DAX
QT_MARKET = MO
ma1 = 0
QT_MARKETID = DAX
QT_MARKET = MO
ma1 = 0
22:08:10,0號計時器觸發了
0
inside timer ma1 = 0
22:08:15,0號計時器觸發了
0
inside timer ma1 = 0
20:48:34你好
0
inside timer ma1 = 0
20:48:39你好
0
inside timer ma1 = 0
20:48:44你好
0
inside timer ma1 = 0
20:48:49你好
0
inside timer ma1 = 0
20:48:54你好
0
inside timer ma1 = 0
20:48:59你好
0
inside timer ma1 = 0
20:49:04你好
0
inside timer ma1 = 0
20:49:09你好
0
inside timer ma1 = 0
20:49:14你好
0
inside timer ma1 = 0
20:49:19你好
0
inside timer ma1 = 0
20:49:24你好
0
inside timer ma1 = 0
20:49:29你好
0
inside timer ma1 = 0
20:49:34你好
0
inside timer ma1 = 0
20:49:39你好
0
inside timer ma1 = 0
20:49:44你好
0
inside timer ma1 = 0
20:49:49你好
0
inside timer ma1 = 0