Dear Prashanth, Many thanks for your, as always, volunteering to help.
Please check the following: TargetA = (Ref(C,-1))*1.05; TargetB = C*1.02; Result = ( C-(Ref(C,-1))*100/(Ref(C,-1)) ); AddColumn ( TargetA , "TargetA", 1.0); AddColumn ( TargetB , "TargetB", 1.0); AddColumn ( Result , "Result", 1.0); AddColumn ( TargetA-Result , "Column4", 1.0);; // if Result is a positive figure AddColumn ( TargetB+Result , "Column4", 1.0);; // if Result is a negative figure Filter = Result > -3 AND Result < 3 ; Here, instead of the two "Column4", I want to have only one which shows the resultant of "TargetA-Result" if the Result is a positive figure, but shows the resultant of "TargeB+Result" if the Result is a negative figure. Thanks again, Vinay On Sat, 13 Sep 2008 08:32:48 +0530, Prashanth <[EMAIL PROTECTED]> wrote: > You can use IIf condition. To get a AFL itself, it would be helpfull if > you > can provide your AFL so that required modifications can be done on the > same. > > Cheers > > Prashanth > ----- Original Message ----- > From: "Vinay Gakkhar." <[EMAIL PROTECTED]> > To: "Amibroker" <[email protected]> > Sent: Saturday, September 13, 2008 08:18 > Subject: [amibroker] I need little help > > >> In Automatic Analysis, I have "TargetA" in one column, "TargetB" in the >> second column, and the 'Result' of a formula in the third column. Based >> on >> several factors, the Result will be either a plus figure or a minus > figure. >> >> I want that if result is a plus figure, then I should get in fourth >> column >> the resultant of TargetA minus Result, and if result is a minus figure, >> I >> should get in fourth column the resultant of TargetB plus Result. >> >> Can anyone please guide me what to write in my exploration? >> >> vgakkhar >> >> >> >> >> >> >> ------------------------------------ >> >> 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 >> >> >> > > > ------------------------------------ > > 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 > > > ------------------------------------ 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/amibroker/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/amibroker/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
