Gakkhar -- Change = C - Ref(C, -1); AddColumn(100*Change/Ref(C, -1), "% Change", 1.2); // I like two digits after the .
// Below assumes using daily data and viewing daily // If you want to view other than daily then it gets trickier AddColumn(HHV(H, 252), "52 week high", 1.2); // assume 252 trading days/year AddColumn(LLV(L, 252), "52 week low", 1.2); // assume you wanted MA=simple moving average. MACD requires 2 parameters AddColumn(MA(C, 50), "50day moving ave.", 1.2); AddColumn(MA(C, 200), "200day moving ave.", 1.2); AddColumn(MA(V, 252), "Volume(1 year moving ave", 1.0); BTW, check operator precedence and use () if in doubt. Good luck. -- Keith Vinay Gakkhar. wrote: > In Formulas/ Systems, I have set the following: > > Filter = V > 1500000 AND H < 200 AND H > 20 AND -1 > (C-O)/C*100 AND 9 < > (H-L)/H*100 AND 0.2 > (H-O)/O*100; > AddColumn ( Open, "Open" , 1.1 ); > AddColumn ( High, "High" , 1.1 ); > AddColumn ( Low, "Low" , 1.1 ); > AddColumn ( Close, "Close" , 1.1, IIf( ROC(C, 1 ) > 0, colorGreen, colorRed ) > ) ; > AddColumn ( Volume, "Volume" , 1.0 ); > AddColumn( OBV(), "OBV", 1.0 ); > > I also want to add columns showing the followings:- > > Previous day's close > % Change > Change > 52-Weeks' High > 52-Weeks' Low > 50-Days MACD > 200-Days MACD > Average Volume > > Can you please guide me what to write for getting these columns? > > gakkhar > > > > ___________________________________________________________ > Inbox full of spam? Get leading spam protection and 1GB storage with All New > Yahoo! Mail. http://uk.docs.yahoo.com/nowyoucan.html > > > > Please note that this group is for discussion between users only. > > To get support from AmiBroker please send an e-mail directly to > SUPPORT {at} amibroker.com > > For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: > http://www.amibroker.com/devlog/ > > For other support material please check also: > http://www.amibroker.com/support.html > > Yahoo! Groups Links > > > > >
