Dear Prashanth, Many thanks, it worked like it should.
Best regards, Vinay On Sat, 13 Sep 2008 13:08:11 +0530, Prashanth <[EMAIL PROTECTED]> wrote: > AddColumn(IIf(Result >0 ,AA, AB),"Column4"); > > Add the above syntax and you should get the required. > > Cheers > > Prashanth > > ----- Original Message ----- > From: "Vinay Gakkhar." <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Saturday, September 13, 2008 12:20 > Subject: Re: [amibroker] I need little help > > >> 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 >> >> >> ------------------------------------ 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/
