|
PureBytes Links
Trading Reference Links
|
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
|
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
![]()
SPONSORED LINKS
__,_._,___
|