共13 条记录, 每页显示 10 条, 页签: [1] [2]

[浏览完整版]

标题：vba传递参数时,发现一个很奇怪的事情--参数值在传递中变了!

1楼

dwjgwsm 发表于：2014/11/27 10:52:13

编一个指标:

cc:=round(c);hh:=round(h);ll:=round(l);oo:=round(o);

rh:ref(hh,1),NODRAW;

rl:ref(ll,1),NODRAW;

DEBUGFILE('e:\rd.txt','rh='&NUMTOSTR(RH,0)& ' RL=%.0f',RL);

编一个自定义函数:

Function BOTP(Formula,KY,RH,RL,SS)

BOTP=0

application.msgout TIME & " RH:" & RH & " RL:" & RL

End Function

然后将技术指标加载到C05合约上

vba输出结果如下:

10:39:22 RH:2397 RL:2390

10:39:22 RH:2394 RL:2389

10:39:22 RH:2394 RL:2391

10:39:22 RH:2395 RL:2392

10:39:22 RH:2396 RL:2394

10:39:22 RH:2395 RL:2394

10:39:22 RH:2394 RL:2393

10:39:22 RH:2395 RL:2393

10:39:22 RH:2395 RL:2394

10:39:22 RH:2395 RL:2393

10:39:22 RH:2394 RL:2392

10:39:22 RH:2397 RL:2393

10:39:22 RH:2401 RL:2395

10:39:22 RH:2404 RL:2400

10:39:22 RH:2405 RL:2402

10:39:22 RH:2411 RL:2405

10:39:22 RH:2414 RL:2410

10:39:22 RH:2412 RL:2409

10:39:22 RH:2412 RL:2410

10:39:22 RH:2411 RL:2410

10:39:22 RH:2412 RL:2410

10:39:22 RH:2412 RL:2411

10:39:22 RH:2413 RL:2411

10:39:22 RH:2412 RL:2410

10:39:22 RH:2412 RL:2411

10:39:22 RH:2413 RL:2411

10:39:22 RH:2414 RL:2400

10:39:22 RH:2412 RL:2408

10:39:22 RH:2411 RL:2410

10:39:22 RH:2412 RL:2410

10:39:22 RH:2412 RL:2411

10:39:22 RH:2411 RL:2410

10:39:22 RH:2411 RL:2409

10:39:22 RH:2411 RL:2410

10:39:22 RH:2410 RL:2409

10:39:22 RH:2410 RL:2408

10:39:22 RH:2409 RL:2408

10:39:22 RH:2410 RL:2408

10:39:22 RH:2410 RL:2409

10:39:22 RH:2411 RL:2409

10:39:22 RH:2412 RL:2410

10:39:22 RH:2411 RL:2410

10:39:22 RH:2411 RL:2409

10:39:22 RH:2410 RL:2409

10:39:22 RH:2410 RL:2408

10:39:22 RH:2409 RL:2408

10:39:22 RH:2410 RL:2409

10:39:22 RH:2409 RL:2408

10:39:22 RH:2410 RL:2409

10:39:22 RH:2410 RL:2410

10:39:22 RH:2410 RL:2409

10:39:22 RH:2410 RL:2408

10:39:22 RH:2409 RL:2408

10:39:22 RH:2409 RL:2409

10:39:22 RH:2409 RL:2408

10:39:22 RH:2410 RL:2408

10:39:22 RH:2410 RL:2409

10:39:22 RH:2411 RL:2409

10:39:22 RH:2411 RL:2410

10:39:22 RH:2410 RL:2410

10:39:22 RH:2410 RL:2409

10:39:22 RH:2409 RL:2408

10:39:22 RH:2408 RL:2407

10:39:22 RH:2407 RL:2406

10:39:22 RH:2408 RL:2407

10:39:22 RH:2409 RL:2407

10:39:22 RH:2410 RL:2408

10:39:22 RH:2411 RL:2409

10:39:22 RH:2410 RL:2409

10:39:22 RH:2410 RL:2408

10:39:22 RH:2409 RL:2408

10:39:22 RH:2408 RL:2407

10:39:22 RH:2407 RL:2406

10:39:22 RH:2408 RL:2407

10:39:22 RH:2409 RL:2407

10:39:22 RH:2409 RL:2408

10:39:22 RH:2410 RL:2408

10:39:22 RH:2410 RL:2409

10:39:22 RH:2409 RL:2409

10:39:22 RH:2410 RL:2409

10:39:23 RH:2410 RL:2409

10:39:29 RH:2410 RL:2409

10:39:30 RH:2410 RL:2409

10:39:33 RH:2410 RL:2409

10:39:39 RH:2410 RL:2409

10:39:40 RH:2410 RL:2409

10:39:46 RH:2410 RL:2409

10:39:47 RH:2410 RL:2409

10:40:03 RH:2410 RL:2409

10:40:08 RH:2410 RL:2409

10:40:09 RH:2410 RL:2409

10:40:18 RH:2410 RL:2409

10:40:19 RH:2410 RL:2409

10:40:23 RH:2410 RL:2409

10:40:26 RH:2410 RL:2409

10:40:28 RH:2410 RL:2409

10:40:37 RH:2410 RL:2409

10:40:38 RH:2410 RL:2409

10:40:41 RH:2410 RL:2409

10:40:43 RH:2410 RL:2409

10:40:49 RH:2410 RL:2409

10:40:51 RH:2410 RL:2409

10:40:52 RH:2410 RL:2409

10:40:56 RH:2410 RL:2409

10:40:58 RH:2410 RL:2409

10:41:05 RH:2410 RL:2409

10:41:19 RH:2410 RL:2409

10:41:29 RH:2410 RL:2409

10:41:35 RH:2410 RL:2409

10:41:36 RH:2410 RL:2409

10:41:37 RH:2410 RL:2409

10:41:38 RH:2410 RL:2409

10:41:40 RH:2410 RL:2409

10:41:49 RH:2410 RL:2409

rd.txt中显示结果如下:

2014-11-27 10:38:57.344 rh=2410 RL=2409

2014-11-27 10:39:04.442 rh=2410 RL=2409

2014-11-27 10:39:22.872 rh=2410 RL=2409

2014-11-27 10:39:23.708 rh=2410 RL=2409

2014-11-27 10:39:29.793 rh=2410 RL=2409

2014-11-27 10:39:30.807 rh=2410 RL=2409

2014-11-27 10:39:33.849 rh=2410 RL=2409

2014-11-27 10:39:39.932 rh=2410 RL=2409

2014-11-27 10:39:40.946 rh=2410 RL=2409

2014-11-27 10:39:46.017 rh=2410 RL=2409

2014-11-27 10:39:47.031 rh=2410 RL=2409

2014-11-27 10:40:03.255 rh=2410 RL=2409

2014-11-27 10:40:08.325 rh=2410 RL=2409

2014-11-27 10:40:09.350 rh=2410 RL=2409

2014-11-27 10:40:18.464 rh=2410 RL=2409

2014-11-27 10:40:19.479 rh=2410 RL=2409

2014-11-27 10:40:23.535 rh=2410 RL=2409

2014-11-27 10:40:26.577 rh=2410 RL=2409

2014-11-27 10:40:28.605 rh=2410 RL=2409

2014-11-27 10:40:37.733 rh=2410 RL=2409

2014-11-27 10:40:38.747 rh=2410 RL=2409

2014-11-27 10:40:41.788 rh=2410 RL=2409

2014-11-27 10:40:43.815 rh=2410 RL=2409

2014-11-27 10:40:49.900 rh=2410 RL=2409

2014-11-27 10:40:51.927 rh=2410 RL=2409

2014-11-27 10:40:52.941 rh=2410 RL=2409

2014-11-27 10:40:56.998 rh=2410 RL=2409

2014-11-27 10:40:58.012 rh=2410 RL=2409

2014-11-27 10:41:05.109 rh=2410 RL=2409

2014-11-27 10:41:19.306 rh=2410 RL=2409

2014-11-27 10:41:29.447 rh=2410 RL=2409

2014-11-27 10:41:35.529 rh=2410 RL=2409

2014-11-27 10:41:36.543 rh=2410 RL=2409

2014-11-27 10:41:37.558 rh=2410 RL=2409

2014-11-27 10:41:38.573 rh=2410 RL=2409

2014-11-27 10:41:40.599 rh=2410 RL=2409

2014-11-27 10:41:49.726 rh=2410 RL=2409

2014-11-27 10:42:05.950 rh=2410 RL=2409

2014-11-27 10:42:06.965 rh=2410 RL=2409

2014-11-27 10:42:08.994 rh=2410 RL=2409

2楼

dwjgwsm 发表于：2014/11/27 10:54:45

C05合约的3分钟周期,盘中延时刷新设置1000毫秒

3楼

dwjgwsm 发表于：2014/11/27 11:01:19

技术指标上还有一句:

BOTP(kccont,RH,RL,SS);

kccont和SS参数与本问题无关

还有个问题,为什么vba中输出的数据次数大于指标中输出的次数?

4楼

yukizzc 发表于：2014/11/27 11:20:14

公式是逐k模式运行的，在每根k上多会运行模型。所以也就造成你msgout好多个

你勾上仅刷最后一根k再去运行看就对了

5楼

dwjgwsm 发表于：2014/11/27 11:57:08

勾选了的!

6楼

yukizzc 发表于：2014/11/27 13:18:45

你确定指标勾了仅刷最后一根？？这是我的vba输出，前面一段是历史k线的输出，后面的话全部是最后一根k在进行输出了。你可以在图表上限定下k线数量，不要去刷新那么多

13:16:30 RH:2761 RL:2754
13:16:30 RH:2762 RL:2759
13:16:30 RH:2762 RL:2760
13:16:30 RH:2763 RL:2758
13:16:30 RH:2764 RL:2760
13:16:30 RH:2761 RL:2755
13:16:30 RH:2761 RL:2754
13:16:30 RH:2762 RL:2758
13:16:30 RH:2760 RL:2753
13:16:30 RH:2757 RL:2753
13:16:30 RH:2754 RL:2750
13:16:30 RH:2754 RL:2750
13:16:30 RH:2757 RL:2751
13:16:30 RH:2756 RL:2752
13:16:30 RH:2755 RL:2750
13:16:30 RH:2757 RL:2752
13:16:30 RH:2755 RL:2750
13:16:30 RH:2753 RL:2750
13:16:30 RH:2752 RL:2751
13:16:30 RH:2751 RL:2747
13:16:30 RH:2752 RL:2749
13:16:30 RH:2753 RL:2749
13:16:30 RH:2752 RL:2748
13:16:30 RH:2751 RL:2748
13:16:30 RH:2748 RL:2746
13:16:30 RH:2751 RL:2747
13:16:31 RH:2751 RL:2749
13:16:31 RH:2753 RL:2751
13:16:31 RH:2754 RL:2750
13:16:31 RH:2754 RL:2751
13:16:31 RH:2753 RL:2751
13:16:31 RH:2755 RL:2752
13:16:31 RH:2756 RL:2753
13:16:31 RH:2756 RL:2753
13:16:31 RH:2756 RL:2752
13:16:31 RH:2753 RL:2752
13:16:31 RH:2754 RL:2752
13:16:31 RH:2757 RL:2753
13:16:31 RH:2758 RL:2751
13:16:31 RH:2754 RL:2751
13:16:31 RH:2754 RL:2744
13:16:31 RH:2746 RL:2743
13:16:31 RH:2745 RL:2742
13:16:31 RH:2746 RL:2742
13:16:31 RH:2750 RL:2745
13:16:31 RH:2750 RL:2748
13:16:31 RH:2751 RL:2749
13:16:31 RH:2751 RL:2749
13:16:31 RH:2754 RL:2750
13:16:31 RH:2754 RL:2752
13:16:31 RH:2754 RL:2752
13:16:32 RH:2754 RL:2752
13:16:33 RH:2754 RL:2752
13:16:33 RH:2754 RL:2752
13:16:34 RH:2754 RL:2752
13:16:34 RH:2754 RL:2752
13:16:36 RH:2754 RL:2752
13:16:42 RH:2754 RL:2752
13:16:42 RH:2754 RL:2752
13:16:43 RH:2754 RL:2752
13:16:45 RH:2754 RL:2752
13:16:45 RH:2754 RL:2752
13:16:46 RH:2754 RL:2752
13:16:47 RH:2754 RL:2752
13:16:47 RH:2754 RL:2752
13:16:48 RH:2754 RL:2752
13:16:48 RH:2754 RL:2752
13:16:49 RH:2754 RL:2752
13:16:57 RH:2754 RL:2752
13:16:58 RH:2754 RL:2752
13:16:58 RH:2754 RL:2752
13:16:59 RH:2754 RL:2752
13:17:00 RH:2754 RL:2752
13:17:01 RH:2754 RL:2752
13:17:03 RH:2754 RL:2752
13:17:05 RH:2754 RL:2752
13:17:05 RH:2754 RL:2752
13:17:06 RH:2754 RL:2752
13:17:07 RH:2754 RL:2752
13:17:08 RH:2754 RL:2752
13:17:09 RH:2754 RL:2752
13:17:10 RH:2754 RL:2752
13:17:14 RH:2754 RL:2752
13:17:14 RH:2754 RL:2752
13:17:15 RH:2754 RL:2752
13:17:16 RH:2754 RL:2752
13:17:19 RH:2754 RL:2752
13:17:20 RH:2754 RL:2752
13:17:22 RH:2754 RL:2752
13:17:22 RH:2754 RL:2752
13:17:23 RH:2754 RL:2752
13:17:23 RH:2754 RL:2752
13:17:24 RH:2754 RL:2752
13:17:25 RH:2754 RL:2752
13:17:25 RH:2754 RL:2752
13:17:26 RH:2754 RL:2752
13:17:26 RH:2754 RL:2752
13:17:27 RH:2754 RL:2752
13:17:28 RH:2754 RL:2752
13:17:30 RH:2754 RL:2752
13:17:30 RH:2754 RL:2752
13:17:31 RH:2754 RL:2752
13:17:31 RH:2754 RL:2752
13:17:32 RH:2754 RL:2752
13:17:32 RH:2754 RL:2752
13:17:33 RH:2754 RL:2752
13:17:35 RH:2754 RL:2752
13:17:37 RH:2754 RL:2752
13:17:38 RH:2754 RL:2752
13:17:38 RH:2754 RL:2752
13:17:39 RH:2754 RL:2752

7楼

dwjgwsm 发表于：2014/11/27 13:38:04

图片点击可在新窗口打开查看此主题相关图片如下：11.jpg

此主题相关图片如下：222.jpg

刚才又试过了,

vba输出结果.另外,DEBUGFILE没用错把?

13:33:16 RH:2397 RL:2390
13:33:16 RH:2394 RL:2389
13:33:16 RH:2394 RL:2391
13:33:16 RH:2395 RL:2392
13:33:16 RH:2396 RL:2394
13:33:16 RH:2395 RL:2394
13:33:16 RH:2395 RL:2394
13:33:16 RH:2394 RL:2393
13:33:16 RH:2395 RL:2393
13:33:16 RH:2395 RL:2394
13:33:16 RH:2395 RL:2394
13:33:16 RH:2395 RL:2394
13:33:16 RH:2395 RL:2393
13:33:16 RH:2394 RL:2392
13:33:16 RH:2397 RL:2393
13:33:16 RH:2401 RL:2395
13:33:16 RH:2404 RL:2400
13:33:16 RH:2405 RL:2402
13:33:16 RH:2411 RL:2405
13:33:16 RH:2414 RL:2410
13:33:16 RH:2412 RL:2409
13:33:16 RH:2412 RL:2410
13:33:16 RH:2411 RL:2410
13:33:16 RH:2412 RL:2410
13:33:16 RH:2412 RL:2410
13:33:16 RH:2412 RL:2411
13:33:16 RH:2413 RL:2411
13:33:16 RH:2412 RL:2410
13:33:16 RH:2412 RL:2411
13:33:16 RH:2413 RL:2411
13:33:16 RH:2414 RL:2400
13:33:16 RH:2412 RL:2408
13:33:16 RH:2411 RL:2410
13:33:16 RH:2411 RL:2410
13:33:16 RH:2412 RL:2410
13:33:16 RH:2412 RL:2411
13:33:16 RH:2412 RL:2411
13:33:16 RH:2412 RL:2411
13:33:16 RH:2412 RL:2411
13:33:16 RH:2411 RL:2410
13:33:16 RH:2411 RL:2409
13:33:16 RH:2411 RL:2410
13:33:16 RH:2411 RL:2410
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2408
13:33:16 RH:2410 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2410 RL:2408
13:33:16 RH:2410 RL:2409
13:33:16 RH:2411 RL:2409
13:33:16 RH:2412 RL:2410
13:33:16 RH:2411 RL:2410
13:33:16 RH:2411 RL:2410
13:33:16 RH:2411 RL:2410
13:33:16 RH:2411 RL:2410
13:33:16 RH:2411 RL:2410
13:33:16 RH:2411 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2410 RL:2409
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2410
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2409
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2410 RL:2408
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2411 RL:2409
13:33:16 RH:2411 RL:2410
13:33:16 RH:2411 RL:2410
13:33:16 RH:2411 RL:2410
13:33:16 RH:2411 RL:2410
13:33:16 RH:2411 RL:2410
13:33:16 RH:2411 RL:2410
13:33:16 RH:2410 RL:2410
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2409 RL:2408
13:33:16 RH:2408 RL:2407
13:33:16 RH:2407 RL:2406
13:33:16 RH:2408 RL:2407
13:33:16 RH:2409 RL:2407
13:33:16 RH:2410 RL:2408
13:33:16 RH:2410 RL:2408
13:33:16 RH:2411 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2408 RL:2407
13:33:16 RH:2407 RL:2406
13:33:16 RH:2408 RL:2407
13:33:16 RH:2408 RL:2407
13:33:16 RH:2408 RL:2407
13:33:16 RH:2409 RL:2407
13:33:16 RH:2409 RL:2407
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2410 RL:2408
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2409 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2410 RL:2409
13:33:16 RH:2409 RL:2409
13:33:16 RH:2409 RL:2408
13:33:16 RH:2408 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2407
13:33:16 RH:2408 RL:2407
13:33:16 RH:2409 RL:2408
13:33:16 RH:2409 RL:2408
13:33:16 RH:2410 RL:2408
13:33:17 RH:2410 RL:2408
13:33:18 RH:2410 RL:2408
13:33:20 RH:2410 RL:2408
13:33:21 RH:2410 RL:2408
13:33:23 RH:2410 RL:2408
13:33:24 RH:2410 RL:2408
13:33:26 RH:2410 RL:2408
13:33:27 RH:2410 RL:2408
13:33:33 RH:2410 RL:2408
13:33:34 RH:2410 RL:2408
13:33:36 RH:2410 RL:2408
13:33:37 RH:2410 RL:2408
13:33:38 RH:2410 RL:2408
13:33:39 RH:2410 RL:2408
13:33:40 RH:2410 RL:2408
13:33:41 RH:2410 RL:2408
13:33:44 RH:2410 RL:2408
13:33:45 RH:2410 RL:2408
13:33:48 RH:2410 RL:2408
13:33:52 RH:2410 RL:2408
13:33:53 RH:2410 RL:2408
13:33:54 RH:2410 RL:2408
13:33:55 RH:2410 RL:2408
13:33:56 RH:2410 RL:2408
13:33:57 RH:2410 RL:2408
13:33:58 RH:2410 RL:2408
13:34:00 RH:2410 RL:2408

8楼

yukizzc 发表于：2014/11/27 13:44:58

逐k模式，第一次加载会从k线第一根开始计算，你vba输出前面的都是历史k上的数据。后面2410才是最新一根k，并且没有再去刷历史的了。

这个和dubugout本来就不一样的，你看下debugfile函数说明，它是只在最后一个周期进行输出。

你如果vba也想这么输出自己代码里价格条件if barpos=datacount then botup；

9楼

dwjgwsm 发表于：2014/11/27 13:57:09

明白了!谢谢!

刚才又发现一个问题:

2014-11-27 13:51:21.772 rh=2410 RL=2408

2014-11-27 13:51:22.787 rh=2410 RL=2408

2014-11-27 13:51:23.803 rh=2410 RL=2409

2014-11-27 13:51:24.814 rh=2410 RL=2409

2014-11-27 13:51:29.884 rh=2410 RL=2409

2014-11-27 13:51:41.039 rh=2410 RL=2409

2014-11-27 13:51:43.067 rh=2410 RL=2409

2014-11-27 13:51:44.081 rh=2410 RL=2409

2014-11-27 13:52:02.332 rh=2410 RL=2409

2014-11-27 13:52:09.430 rh=2410 RL=2409

2014-11-27 13:52:11.458 rh=2410 RL=2409

2014-11-27 13:52:53.033 rh=2410 RL=2409

为啥RL变了??这个时候不应该变啊

[此贴子已经被作者于2014/11/27 13:57:46编辑过]

10楼

yukizzc 发表于：2014/11/27 14:04:16

你看下debug的记录，要么当时这个值变动了？？

共13 条记录, 每页显示 10 条, 页签: [1] [2]