無法抓取櫃轉市或興櫃轉上市櫃的3個月/12個月平均營收及比較期資訊

您好，

我想要每個月匯出所有上市櫃公司的3個月及12個月平均營收以及其年增率，不過每次跑出來的結果都會漏掉櫃轉市或興櫃轉上市櫃的公司，請問可以怎麼修改解決這個問題呢?

程式碼如下:

-----------------------------

setbarfreq("M");

value1 = average(GetField("月營收","M"),3); //3個月平均營收

value2 = average(GetField("月營收","M"),12); //12個月平均營收

value3 = average(GetField("月營收","M"),15);

value4 = average(GetField("月營收","M"),24);

value5 = (value3*15 - value2*12) / 3; //3個月平均營收比較期

value6 = (value4*24 - value2*12) / 12; //12個月平均營收比較期

value7 = (value1 - value5) / value5 * 100;//3個月營收年增率

value8 = (value2 - value6) / value6 * 100;//12個月營收年增率

value9=GetField("月營收","M");

value10=GetField("月營收年增率","M");

condition1 = datevalue(currentdate,"M") - datevalue(getFieldDate("月營收", "M"),"M") = 1;

condition2 = datevalue(currentdate,"M") - datevalue(getFieldDate("月營收", "M"),"M") = -11;

condition3= value6>-9999999; 

if condition1 or condition2 = true then begin;

if condition3

then ret=1;

end;