Dear Prashanth, Yes, it worked. It worked very well.
You are very kind, very considerate. Best regards, Vinay On Sat, 13 Sep 2008 20:48:21 +0530, Prashanth <[EMAIL PROTECTED]> wrote: > Did it work ? I forgot to include this , > > AA = TargetA - Result; > > AB = TargetB + Result; > > Am attaching the AFL just in case. > > Cheers > > Prashanth > > ----- Original Message ----- > From: "Vinay Gakkhar." <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Saturday, September 13, 2008 19:29 > Subject: [amibroker] I need little help > > >> 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 >> >> >> ------------------------------------ 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/
