EOD daily change exploration

[amitrandive]

Dear All

I am trying to get a daily exploration for the change in prices for scrips in a watch-list or single stock.

Am trying to modify the attached AFL.

Basically I need the percent change for "n" number of previous days to show in the exploration.The number of days should be changeable.

Using the below code for this

pchng=ROC(C,1);
pchng1=ROC(C,2);
Filter = pchng OR pchng1;
AddColumn(Close, "Close Price",1.2 );
AddColumn(pchng, "Percent Change",1.2 ,textcolor=IIf( Ref(C,- 1)>C,colorRed,colorGreen)); 
AddColumn(pchng1, "Percent Change1",1.2 ,textcolor=IIf( Ref(C,- 1)>C,colorRed,colorGreen));

Need Exploration results in the below format