|
PureBytes Links
Trading Reference Links
|
Ken
Doesn't get away from that extra "column click" to sort but what
about something like
SetOption("NoDefaultColumns",True);
Primarysort = Close > Ref(Close,-1); // primary sort
Secondsort = RSI();
myorder = 1000 * primarysort + Secondsort;
Filter = 1;
AddColumn(myorder,"My Order");
AddTextColumn(Name(),"ticker");
AddColumn(C,"C");
AddColumn(RSI(),"RSI");
Just click MyOrder column to sort. Depending on the values of your
primary and secondary sort, you might have to play with the value of
the multiplier.
HTH
Andrew
--- In amibroker@xxxxxxxxxxxxxxx, "Ken Close" <closeks@xxxx> wrote:
> Phsst, DT, Dave:
>
> OTOH.....
>
> I have several applications which rank by a main parameter and then
> select by a second parameter.
>
> I would love to have a way to sort by "primary" column, next by
> "secondary" column, just like the Sort command in Excel. Perhaps a
> right mouse click on the column header, choose primary or
secondary,
> (asc or des is a refinement), then again on another column.
>
> Not so trivial when you have 100 tickers, 40 of which all have the
same
> primary "score" or rating, and you want to choose the best by
sorting
> also the secondary.
>
> Of course!! Export to Excel and sort there, or select the top
primary
> ones and put them in a temporary list, then sort there on
secondary.
>
> I would agree there are more important features to add to
Amibroker.
>
> Ken
>
> -----Original Message-----
> From: Phsst [mailto:phsst@x...]
> Sent: Friday, December 05, 2003 12:59 AM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Re: controlling exploration output
>
> Dimitris,
>
> Glad to see you up bright and early this morning!
>
> I felt the same as you... just how difficult is it, and how long
does
> it take to click on a column heading to accomplish a sort? And is
it
> really important enough to ask Tomasz to make code changes for
> something so trivial? These are important questions, are they not?
>
> Take care.
>
> Phsst
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, "DIMITRIS TSOKAKIS"
<TSOKAKIS@xxxx>
> wrote:
> > Dave,
> > How many clicks ? This is the question.
> > If it is important, please accept one more click, it takes a few
> > seconds.
> > You may add in the body of the exploration an
> >
> > Z=IIf(Name()=="MSFT",1,IIf(Name()=="INTC",2,IIf(Name()
> > =="IBM",3,100)));
> > Filter=1;
> > AddColumn(Z,"My order");
> > AddColumn(C,"");
> > and hit "My order" once.
> > Is it enough, or you want something more automated ?
> > If this click is the problem, please let me know.
> > Dimitris Tsokakis
> > --- In amibroker@xxxxxxxxxxxxxxx, "Dave Merrill" <dmerrill@xxxx>
> > wrote:
> > > Don't think so.
> > >
> > > I'd love it if there was an AFL function SortResults
(ColumnNumber)
> > that was
> > > the equivalent of clicking on a column header in the result
list.
> > Negative
> > > ColumnNumber would sort descending. Ideally, multiple
ColumnNumbers
> > could be
> > > passed to sort on multiple levels.
> > >
> > > Maybe some day...
> > >
> > > Dave
> > >
> > >
> > > > Is there a way to force tickers to appear in an order that I
> > specify?
> > > >
> > > > For example, if ticker 8511 is in the report output (passes
the
> > > > filter), that ticker would be the first symbol on the list,
and if
> > > > ticker 7944 was in the output, it would be second symbol.
> > > >
> > > > I have a preferred ticker order that I would like to see on
some
> > > > outputs, regardless of any other data one might sort by
after the
> > > > output is generated.
> > > >
> > > > Yuki
>
>
>
> Send BUG REPORTS to bugs@xxxx
> Send SUGGESTIONS to suggest@xxxx
> -----------------------------------------
> 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/
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
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/
|