Try this "Performance Exploration" over your database of stocks. Sort
buy column 250 for top gainers or losers. Big gainers were "FSLR,SWIM,
ASTI etc.
Dick H.
basis = C;
perf1 = basis / Ref(basis, -1) * 100 - 100;
perf5 = basis / Ref(basis, -5) * 100 - 100;
perf30 = basis / Ref(basis, -30) * 100 - 100;
perf250 = basis / Ref(basis, -250) * 100 - 100;
//AddTextColumn( FullName(), "FullName" );
//AddTextColumn( IndustryID( 1) ," Industry Sector ", 25.0,
colorWhite, colorBlue);
//AddColumn( counter, "counter",1. 2,colorBrown) ;
//AddTextColumn( MarketID( 2) ," Market ", 25.0, colorWhite,
colorBlue);
//return = ROC(C,250);
AddColumn (Close, "Close",1.2) ;
AddColumn (Ref(Close,- 1), "Close-1",1. 2);
//AddColumn( RS, "RS", 1.3 ,IIf( RS >= 1, colorDarkGreen, colorRed ));
AddColumn(perf1, "perf1%", 1.2);
AddColumn(perf5, "perf5%", 1.2);
AddColumn(perf30, "perf30%", 1.2);
AddColumn(perf250, "perf250%", 1.2);
//AddColumn( return, "250 Bar Return", 1.2);
AddColumn(Volume, "Volume", 1.0);
AddColumn(MA( V,10),"MA( V10",1.0) ;
//AddColumn( (adr/C)*100, "ADR % of C", 2.2, colorDarkGreen, colorGold);
//AddColumn( ADR, "Avg Daily Range (10)", 2.2, colorWhite,colorBlu e);
Filter = 1; // dummy
//Filter = (1 != (IndustryID( 0)==x OR IndustryID(0) ==y OR
IndustryID(0) ==z));
//This will skip all stocks in Industry X,Y,Z (Assignments at
yourdiscretion) .
--- In amibroker@xxxxxxxxx ps.com, "rashmo_70" <rashmo_70@x ..> wrote:
>
> Hi guys is there a code to check yearly performance of Stocks in
database.
> Its similar to (quick market review) but i need to export as csv file
> thanks
>