您好,
請參見我的程式碼, run的結果不能滿足設定條件, 例如當季的應收帳款周轉率,存貨周轉率, 營業現金流量/營業利益,需大於上季,請問問題出在哪裡? 謝謝!
本要用上傳檔案,但因為 .xsb .docs .txt 皆不能接受,請問到底附檔名要用什麼格式,才能上傳 ? 原始碼如下;
SetTotalBar(13);
setbarfreq("Q");
If GetField("應收帳款週轉率(次)","Q")>GetField("應收帳款週轉率(次)","Q")[4] and //每季應收帳款週轉率都進步,且今年比去年好
GetField("應收帳款週轉率(次)","Q")[1]>GetField("應收帳款週轉率(次)","Q")[5] and
GetField("應收帳款週轉率(次)","Q")[2]>GetField("應收帳款週轉率(次)","Q")[6] and
GetField("應收帳款週轉率(次)","Q")[3]>GetField("應收帳款週轉率(次)","Q")[7] and
GetField("應收帳款週轉率(次)","Q")>GetField("應收帳款週轉率(次)","Q")[1] and
GetField("應收帳款週轉率(次)","Q")[1]>GetField("應收帳款週轉率(次)","Q")[2] and
GetField("應收帳款週轉率(次)","Q")[2]>GetField("應收帳款週轉率(次)","Q")[3]
then
condition1 = true;
If GetField("存貨週轉率(次)","Q")>GetField("存貨週轉率(次)","Q")[4] and //每季存貨週轉率都進步,且今年比去年好
GetField("存貨週轉率(次)","Q")[1]>GetField("存貨週轉率(次)","Q")[5] and
GetField("存貨週轉率(次)","Q")[2]>GetField("存貨週轉率(次)","Q")[6] and
GetField("存貨週轉率(次)","Q")[3]>GetField("存貨週轉率(次)","Q")[7] and
GetField("存貨週轉率(次)","Q")>GetField("存貨週轉率(次)","Q")[1] and
GetField("存貨週轉率(次)","Q")[1]>GetField("存貨週轉率(次)","Q")[2] and
GetField("存貨週轉率(次)","Q")[2]>GetField("存貨週轉率(次)","Q")[3]
then
condition2 = true;
//最近5季正現金流量
if GetField("營業現金流量/營業利益")[5] >0 and GetField("營業現金流量/營業利益")[4] >0 and
GetField("營業現金流量/營業利益")[3] >0 and GetField("營業現金流量/營業利益")[2] >0 and
GetField("營業現金流量/營業利益")[1] >0 and GetField("營業現金流量/營業利益")[0] >0
then condition3 = true ;
If condition1 and condition2 and condition3
then ret=1;
outputfield1(GetField("應收帳款週轉率(次)","Q")[7],"7應收周轉");
outputfield2(GetField("應收帳款週轉率(次)","Q")[6],"6應收周轉");
outputfield3(GetField("應收帳款週轉率(次)","Q")[5],"5應收周轉");
outputfield4(GetField("應收帳款週轉率(次)","Q")[4],"4應收周轉");
outputfield5(GetField("應收帳款週轉率(次)","Q")[3],"3應收周轉");
outputfield6(GetField("應收帳款週轉率(次)","Q")[2],"2應收周轉");
outputfield7(GetField("應收帳款週轉率(次)","Q")[1],"1應收周轉");
outputfield8(GetField("應收帳款週轉率(次)","Q")[0],"0應收周轉");
outputfield31(GetField("存貨週轉率(次)","Q")[7],"7存貨周轉");
outputfield32(GetField("存貨週轉率(次)","Q")[6],"6存貨周轉");
outputfield33(GetField("存貨週轉率(次)","Q")[5],"5存貨周轉");
outputfield34(GetField("存貨週轉率(次)","Q")[4],"4存貨周轉");
outputfield35(GetField("存貨週轉率(次)","Q")[3],"3存貨周轉");
outputfield36(GetField("存貨週轉率(次)","Q")[2],"2存貨周轉");
outputfield37(GetField("存貨週轉率(次)","Q")[1],"1存貨周轉");
outputfield38(GetField("存貨週轉率(次)","Q")[0],"0存貨周轉");
outputfield51(GetField("營業現金流量/營業利益")[5],"5現金流量");
outputfield52(GetField("營業現金流量/營業利益")[4],"4現金流量");
outputfield53(GetField("營業現金流量/營業利益")[3],"3現金流量");
outputfield54(GetField("營業現金流量/營業利益")[2],"2現金流量");
outputfield55(GetField("營業現金流量/營業利益")[1],"1現金流量");
outputfield56(GetField("營業現金流量/營業利益")[0],"0現金流量");

5 評論