[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: formatting exploration output



PureBytes Links

Trading Reference Links

--- In amibroker@xxxxxxxxxxxxxxx, Sidney Kaiser <s9kaiser@xxxx> wrote:
> 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);

This is a conditional addition of a column.
It is not possible, as you may read at #32196 and its interesting 
replies.
As for the text of an existing column, it is restricted to the last 
string value and it is not variable.
As an alternative, you may define two separate columns as
Filter=1;
addcolumn(stochD()>70,"stochD()>70",1.0);
addcolumn(stochD()<=70,"stochD()<=70",1.0);
and see 1 and 0 respectively, after exploring for the n=1 last bar.
Then hit on each caption to gather > or <= securities.
DT


> 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
> 
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.449 / Virus Database: 251 - Release Date: 01/27/2003


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/