차트에 상하한가 표시하기

- 상한가 수식 -

A1 = if(date<20150615, ( PreDayClose() * 15 ) / 100,( PreDayClose() * 30 ) / 100);
A2 = A1 + PredayClose();

A = if(A2 < 1000, A2,

if(A2 < 5000, if(A2%10 > 5, A2 - (A2%10-5),if(A2%10 < 5, A2 - (A2%10), A2),0),

if(A2 < 10000,A2 - (A2%10),

if(A2 < 50000, if(A2%100 > 50,A2 -(A2%100-50),if(A2%100 < 50, A2-(A2%100),A2),0),

if(A2 <100000, A2 - (A2%100),

if(A2 <500000, A2 - (A2%1000),A2 - (A2%1000)))))));

floor(A) <= C

- 하한가 수식 -

A1 = if(date<20150615, ( PreDayClose() * 15 ) / 100,( PreDayClose() * 30 ) / 100);
A2 = Ceil(PredayClose() - A1);

A3 = if(PreDayClose() < 1000, A2,

if(PreDayClose() < 5000, if(A2%10 > 5, 10-(A2%10)+A2, if(A2%10 >= 1 && A2%10 < 5, 5-(A2%10)+A2, A2),0),

if(PreDayClose() < 10000, if(A2%10 >0, A2 + (10 - (A2%10)),A2),

if(PreDayClose() < 50000, if(A2%100 >50, 100-(A2%100)+A2, if(A2%100 >= 1 && A2%100 < 50, 50-(A2%100)+A2, A2),0),

if(PreDayClose() <100000, if(A2%100 > 0, A2 + (100-(A2%100)),A2),

if(PreDayClose() <500000, if(A2%1000 > 500, 1000-(A2%1000)+A2, if(A2%1000 >= 1 && A2%1000 < 500, 500-(A2%1000)+A2,A2),0),

if(A2%1000 > 1, 1000-(A2%1000)+A2,A2)

))))));

A3 >= C