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,colorBlue); 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 [email protected], "rashmo_70" <[EMAIL PROTECTED]> 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 >
