我設定的公式為本益成長比=本益比"D"/近4季的稅後淨利成長率的平均值
可是篩選後出現欄位資料不存在、計算出現runtime錯誤等錯誤,能否幫幫我,感謝!
var:truevalue(0);
input: PEG(0.5,"預估本益成長比上限");
value1 = getfield("本益比","D") / average(GetField("稅後淨利成長率","Q"),4);
if value1 <= PEG then ret = 1;
outputfield(1, getfielddate("本益比","D"), 2, "本益比資料日期");
outputfield(2, getfield("本益比","D"), 2, "當期本益比");
outputfield(3, getfielddate("稅後淨利成長率","Q"), 2, "稅後淨利成長率資料日期");
outputfield(4, average(GetField("稅後淨利成長率","Q"),4), 2, "前4平均稅後淨利成長率");
outputfield(5, value1, 2, "本益成長比");



1 評論