RE: [amibroker] formatting exploration output

["William Peters" <williampeters1@xxxxxxxxxxxx>]

Sid,

This will leave you with some white space but it seems from your post that you dont mind that.
You might get some ideas from it anyway.

test1 = WriteIf( Cross(70,RSI(12)), "RSI < 70 Sell", "");
test2 = WriteIf( Cross( Signal(), MACD() ), "MACD Signal", "");

Filter = Cross(70,RSI(12)) OR Cross( Signal(), MACD() );

AddTextColumn(test1,"RSI < 70 Sell");
AddTextColumn(test2,"MACD Signal");

Regards,
William


-----Original Message-----
From: Sidney Kaiser [mailto:s9kaiser@xxxxxxxxxxx]
Sent: February 7, 2003 10:04 PM
To: AmiBroker@xxxxxxxxxxxxxxx
Subject: [amibroker] formatting exploration output


First a few words of explanation of what I want to do.  I have 4-5 
indicators that I want to test against the close or against various fixed 
levels.  If the test is true I want to output a short piece of text only, 
like " <70 sell?".  Visualize a spreadsheet like grid of stock symbols down 
the left, column headings of the 5 tests across the top, and a few sparse 
entries indicating only the sell logic hits for easy readability.

This could possibly be done in a commentary, and that might be of some use 
when browsing random stocks, but I want to apply it to my list of current 
holdings each night for possible sell signals.  An exploration seems like 
the better choice for that.

So, the questions.  How do I test for a condition and output the short text 
string under the appropriate heading in an exploration?

I tried this:
IIf( StochRSI < 70, AddTextColumn("< 70 Sell ?","StochRSI"),Null);

But it is not appropriate for repetitive symbols as the whole column is 
full of "< 70 Sell ?" strings.

Can I do something like:
IIf( StochRSI < 70, Column0 = "< 70 Sell ?",Null);

Or am I hopelessly confused and need some other approach?

Ideas?

TIA
Sid

Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)

Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 



Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)

Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/