檢視分母0問題2

diloga 發文於 2025/07/08

value1 = 100 * (Highest(High, 9) - Close) / (Highest(High, 9) - Lowest(Low, 9)) - 70;

value2 = Average(value1, 9);

if highest(high,9)-lowest(low,9) <> 0 then

value3 = (Close - Lowest(Low, 9)) / (Highest(High, 9) - Lowest(Low, 9)) * 100;

value4 = Average(value3, 3);

value5 = Average(value4, 3);

value6 = value5 - value2;

value7 = Maxlist(value6, 0);

if value7 Cross Under 20 then plot11(25, "");

已經留意到分母0問題，但執行仍出現檢視分母是否為0的困擾

2 評論

排序方式: 標準 | 最新

虎科大許教授發文於 2025/07/08

只要執行的商品某天的9期最高價等於9期最低價，就會出現分母為0的錯誤。

建議改寫成：

value1 = IFF(Highest(High, 9)-Lowest(Low, 9)<>0,100 * (Highest(High, 9)-Close)/(Highest(High, 9)-Lowest(Low, 9))-70,0);

value3 = IFF(Highest(High, 9)-Lowest(Low, 9)<>0,(Close-Lowest(Low, 9))/(Highest(High, 9)-Lowest(Low, 9))*100,0);

diloga 發文於 2025/07/08

3Q解惑

發表回覆

分類