countif 不合預期

順便附上整個腳本

//突破前高

input:N(2); 

condition5 = GetField("收盤價") >= Highest(GetField("最高價")[1],N);

 

condition6 = close>close[1]*1.024; //

//=================================================================

 

//價量

input:VolumeLimit(10000);

input:VolumeCloseLimit(800000); //參考 價100, 8000張 //當沖可能要設更高 150*8000 = 1200000 ?

 

Value1 = GetField("成交量");

 

If close < 50 Then

condition11 = Volume > 3000;

If close > 50 and close < 200 Then 

condition11 = Volume > 2000;

If close >= 200 and close <= 500 Then 

condition11 = Volume > 1000;

If close > 500 Then 

condition11 = Volume > 100;

 

// Volume*close > VolumeCloseLimit-1 Then

condition7 = Volume > Average(Volume[1], 5) * 2;

condition12 = Volume > Volume[1] * 2;

//Else

//condition7 = Volume > Average(Volume[1], 5) * 2.5;

 

condition8 = Value1 > VolumeLimit-1;

 

condition9 = Volume*close > VolumeCloseLimit-1;

//if   condition7 and (condition8 or condition9) then ret =1;

//=================================================================

 

//====後續篩選，均線糾結程度===============================================================

Value1 = average(close, 5);

Value2 = average(close, 10);

Value3 = average(close, 20);

 

 

value5 = MaxList(Value1, Value2, Value3); //均線取最大

value6 = MaxList2(Value1, Value2, Value3); //均線第二大

value7 = MinList(Value1, Value2, Value3);

value8 = MinList2(Value1, Value2, Value3);

 

input:DistMaxMin(1.0371); 

input:DistMaxMid(1.026);

input:DistMidMin(1.026); 

 

condition1 = close > value7; //收盤價大於最低的均線

 

value9 = value5/value7;

condition2 = value9 < DistMaxMin; //差距最大的兩條均線，差距需小於0.35

 

value10 = value5/value6;

condition3 = value10 < DistMaxMid; //最大均線跟第二大均線，差距小於0.26

value11 = value6/value7;

condition4 = value11 < DistMidMin; //第二大均線跟最小均線，差距小於0.26

 

input:DistCloseMax(1.04); 

condition10 = close/value5 < DistCloseMax;

//condition11 = close

//=============================================================

//過去三個月是否有紅k棒 超過3%? 過濾平穩股票  //但會錯過鴻海 2317 03/04

input:j(100); 

value12 = close/close[1];

value13 = countif(value12 > 1.03, j);

condition11 = value13 > 1;

//=============================================================

input:k(5);

condition999 =  (condition5 and condition6)  and ((condition7 or condition12) and (condition8 or condition9));

condition111 = TrueAny(condition999, k);

 

 

if   condition11 and condition1 and condition2 and (condition3 or condition4) and condition10 and condition111 then ret =1;