|
PureBytes Links
Trading Reference Links
|
Dear Prashanth,
Many thanks, it worked like it should.
Best regards,
Vinay
On Sat, 13 Sep 2008 13:08:11 +0530, Prashanth <prash454.ta@xxxxxxxxx>
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." <vgakkhar@xxxxxxxxxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> 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 <prash454.ta@xxxxxxxxx>
>> 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." <vgakkhar@xxxxxxxxxxx>
>> > To: "Amibroker" <amibroker@xxxxxxxxxxxxxxx>
>> > 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:amibroker-digest@xxxxxxxxxxxxxxx
mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|