Can someone help on the proper use of 'addtextcolumn' function ???

Can someone help me out?

During AFL coding, i wanted results to show in cells of the column that meet the criteria while the other cells in the column remain blank/null.

My afl coding solution was as follows:
QUOTE:
Filter = 1;
AddColumn(MA(EstSec_3,260),"Volatility",1.6,IIf(MA(EstSec_3,260)>0,colorGreen,colorRed));
AddColumn(EstSec_5,"Relative Price Strength",1.6,IIf(EstSec_5>1,colorGreen,colorRed));
AddColumn(EstSec_7,"Cash Momentum Rate",1.6,IIf(EstSec_7>0,colorGreen,colorRed));
SetSortColumns(-3);
AddRankColumn();
SetSortColumns(-5);
AddRankColumn();
SetSortColumns(-4);
AddRankColumn();
AddTextColumn(IIf(((MA(EstSec_3,260)>0)AND(EstSec_5>1)AND(EstSec_7>0)),printf(FullName()),null),"Stock Purchase",colorBlue);
UNQUOTE:

Unfortunately, my use of the function "addtextcolumn" is not proper as the error sign gave 'wrong arguements'. Can someone help on the proper use of "addtextcolumn" function ???

I remain.

Mike-Ekwueme (respartner)

N.B: i am an AFL coding beginner....

Mike

I cannot make head or tail of the logic you are trying to implement. .

However, I can say following w.r.t. AddText function.

Values passed to AddText column need to be scalar or array-invariant textual information. If you pass an Array in place of text function, only the last value of array will get printed as text.

Also, you cannot use IIf function with textual data. You need to use WriteIf(...) function

HTH

============================================

Dear MM,

I have tried 'writeif" function but it seems not appropriate as it demands a "text" result. I made progress using function - fullname() which is an array (if i am not mistaken). The following command line worked without any criteria:

AddTextColumn(Fullname(),"Stock Purchase",77, colorBlue);

-----------------------------------------------------------------

Would the following command line be appropriate when there is a criteria with a 'last spring/value of an array' result ?

AddTextColumn(printf(IIf((MA(EstSec_3,260)>0)AND(EstSec_5>1)AND(EstSec_7>0),FullName(),null)),"Stock Purchase",77, colorBlue);

or

AddColumn(IIf((MA(EstSec_3,260)>0)AND(EstSec_5>1)AND(EstSec_7>0),FullName(),Null),"Stock Purchase",77,colorBlue);

Command Explanation: I want the last string/value in the array {(fullname()} to show in a cell of a column if the criteria is met unless the cell remains blank...

I hope this time my explanation was clearer.
Your kind advice and solution proposal will be gladly appreciated.
I remain.

Mike....

Hi Mike

What MM had said is right,
use only text functions like AddTextColumn with WriteIf
don't mix them up

for e.g.

In the above just change the condition i.e. in place of MA(C,7) > MA(C,13), use your own criteria


Happy

Dear MM007,

The 'addrankcolumn' function creates ranking columns which are one-based.

Can the numbers (ranks) within the rank column be used for other logic purpose ?
If yes, can the name of the rank column be the name of the array within a logic statement ?

For example:
rank(relative price strength)<21
//accept all tickers with rank number or position less than No. 21//

If this is wrong, is there an alternative function for such rank logic ?
Please yr kind advice will be most highly appreciated.
I remain.

Mike-Ekwueme....

Yes, Mike it is possible but getting it right is bit difficult and will take serious debugging efforts.

Yes, Mike it is possible but getting it right is bit difficult and will take serious debugging efforts.

Dear MM007,

I have rcv-ed a lot of thanks for this question.
It seems that this simple 'ranking number' logic function in Excel is not adequately provided in Amibroker.
Can you help us all by providing a rough copy of the code for everyone to work on?
Maybe with more minds working on it - we can create the code.
I remain.

Mike-Ekwueme...