Thanks Kelvin, you are always so supportive. I got it. Previous day, so the "-". But is there any other way to write this code more efficiently? I am learning it from all of you.
Sudip
Sudip
Filter only when Close Break [Above/Below] Previous Close by 5% AND Volume must be >=AvgVol by 1.5 times
Code:
C1 = Ref(C,-1);
AV = V/MA(V,10);
Filter=(C>=C1*1.05 OR C<=C1*0.95) AND AV>=1.5;
AddTextColumn(Name(), "SYMBOL");
AddColumn(DateTime(), "DATE", formatDateTime,colorBlue);
AddColumn(C, "Close", 1.2);
AddTextColumn(WriteIf(C>C1,"Above", "Below"), "Break", 1, colorBlack,IIf(C>C1,colorBrightGreen,colorRed),50);
AddColumn( C1, "Previous Close", 1.2, colorDefault, colorDefault, 50);
AddColumn( 100.0*abs(C-C1)/C1, "%Change", 1.2);
AddColumn(V/1000, "Volume(K)", 1);
AddColumn(AV, "Average Volume", 1.1);
Last edited: