You can color cells individually, here is an example. Run on small
WatchList, say 10 tickers, or it will execute slowly.
herman
SetOption("NoDefaultColumns",True);
Filter = Status("LastBarInTest");
WLN = Param("WatchListNumber",0,0,64,1);
list = GetCategorySymbols( categoryWatchlist, WLN);
AddTextColumn(Name(),"Correlation",1.0);
Ticker1= Name();
for( Col=0;
(Ticker2=StrExtract( List, Col))!= ""; Col++)
{
Var2 = Foreign(Ticker2,"C");
Corr = Correlation( C,
Var2, 8);
Color = IIf(Corr>0, colorBrightGreen, IIf(Corr<0, colorRed,colorWhite));
Color = IIf(Ticker1==Ticker2, 1,
Color);
AddColumn( Corr,
Ticker2, 1.3, 1,
Color);
}
Thursday, March 15, 2007, 11:16:00 AM, you wrote:
> |
Not possible afaik. You "could" put in "^" and "v"
. I think I remember that you can color a column - not sure about
a cell unless you can change the column color by row.
Outside AB you could use excel to do something like
that.
d
From: amibroker@xxxxxxxxxxxxxxx
[mailto:amibroker@xxxxxxxxxxxxxxx] On
Behalf Of Ken Close
Sent: Thursday,
March 15, 2007 11:09 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker]
Symbol within AA Results Cells
Is it possible to insert a symbol (like
shapeuparrow) within a cell in a results table? I have written a
AddTextColumn and used a WriteIf statement to put in words describing a
trend, such as "Up Trend" if a parameter is above a certain value and
"Down Trend" if the value is below a certain value.
I would like to have a green up arrow or red down
arrow instead of the text described above.
Is this possible?
If not, how might you achieve an automation of
some sort (say with the exported table rather than within AB itself) so
you could put said symbol in the cells instead of words?
Any suggestions will be appreciated.
Ken
|