[amibroker] Ranking Many Columns

[vishveshchauhan]

Hello group,

I have piece of code which throws output as ROC of last 50 days. Now I want to 
have output as sorted on every column based on rank. For an Ex. if ROC is 
highest it should be rank 1 and if last then 50. Each column should display 
rank instead of ROC.

Any help highly appreciated
 
Filter=1;
AddTextColumn(FullName(),"Name");

for(i=1;i<=50;i++)
{

        AddColumn(ROC(Ref(C,-i),1),"");

}

Regards
Vishvesh