|
PureBytes Links
Trading Reference Links
|
No, I
missed something, Michael.
<FONT
color=#0000ff>I'd<SPAN
class=913293322-25062003>, however avoid
Excel.
<SPAN
class=913293322-25062003>Sort on the desired column, export it to a csv file,
open it with TextPad and cut it at line 100 before applying a list to
comma-separated symbol macro.
<SPAN
class=913293322-25062003>
<SPAN
class=913293322-25062003>Bob
<FONT face=Tahoma
size=2>-----Original Message-----From: Michael.S.G.
[mailto:OzFalcon@xxxxxxxx]Sent: Wednesday, June 25, 2003 3:29
PMTo: amibroker@xxxxxxxxxxxxxxxSubject: RE: [amibroker]
Sorting Top 20% stocksBob,Am I
missing something here? How do you know you have selected 100 stocks and not
more or less? is there a Selection Count hidden somewhere
?KR Michael.
<FONT face=arial color=#0000ff
size=2>Did you try <shift><left-click>?<FONT
face=arial color=#0000ff size=2><<<FONT
face="Times New Roman, Times">(Via excel - Because selecting 100 lines in
the results window is painfull).<FONT face=arial color=#0000ff
size=2>>>
-----Original Message-----
From: Michael.S.G. [<A href=""
eudora="autourl">mailto:OzFalcon@xxxxxxxx]
Sent: Wednesday, June 25, 2003 5:45 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Sorting Top 20% stocks
At the moment, I just use this:
Filter = <FONT
face="Courier New, Courier" color=#ff00ff>1;
TurnOver = <FONT face="Courier New, Courier"
color=#0000ff>MA(Close * Volume,<FONT
face="Courier New, Courier" color=#ff00ff>32);
<FONT face="Courier New, Courier"
color=#0000ff>AddColumn(TurnOver, <FONT face="Courier New, Courier"
color=#ff00ff>"TurnOver", <FONT face="Courier New, Courier"
color=#ff00ff>1.2);
Then Manualy sort the column and then add the top 100 to a
watchlist.
(Via excel - Because selecting 100 lines in the results window is
painfull).
I would prefer to just be able to run one explore & import to a
watchlist or parse with more filters.
I will look at other ways of achiveing this - Possibly via
JScript......
KR
Michael.
At 09:06 AM 25/06/2003 +0200, you wrote:
Hi, just a tip: I think you should reformulate what you are
trying to achieve or solve. IMHO AddToComposite is
not necessary for this.
UM
----- Original Message -----
From: "Michael.S.G." <OzFalcon@xxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Wednesday, June 25, 2003 3:35 AM
Subject: [amibroker] Sorting Top 20% stocks
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I would like to be able to make a selection of stocks - Based
on Top
> 20% Turnover.
>
> After Looking at the UserGuide and Downloadable AB Archives I
have
> created the following AFL..
> Using the AddToComposite function and running a Scan then
Explore,
> I can't seem to be able to get the AddToComposite part to
work.
>
> Perhaps I am tring to make a Square Wheel Roll, If there is an
easier
> way of Ranking/Selection - Please do tell!
>
> Also, I have AA set to "Last 1 Quotation".
>
> /* Aimed Percentage to select (APS %) */
> APS = 20;
> AP = ((100 - aps)/100);
>
> Filter = 1;
>
> TurnOver = MA(Close * Volume,32);
> AddColumn(TurnOver, "TurnOver", 1.2);
> AddColumn(AP, "AP", 1.2);
>
> /* AddToComposite statements are for Automatic Analysis ->
Scan */
> /* add Close price to our index OHLC fields */
>
> /* Make ATC a Highest Value - Doesn't Work... */
> FC = Foreign( "~MyIndex", "V");
> aTO = IIf (TurnOver > FC,(Turnover - fc), 0);
> // Can't figure out why this doesnt
> // increase V. Perhaps Circular?
> AddToComposite(aTO, "~MyIndex", "V" );
>
> /* add one to open intest field (we use this field as a
counter) */
> AddToComposite( 1, "~MyIndex", "I" );
>
> Buy = 0; // required by scan mode
>
> /* this part is for Indicator Builder */
> // Graph0 = Foreign( "~MyIndex", "C" )/Foreign( "~MyIndex", "I"
);
>
> FT = Foreign( "~MyIndex", "V");
> IT = Foreign( "~MyIndex", "I" );
> AddColumn(FT,"FT-ForeignTally",1.2);
> AddColumn(IT,"CounterTally",1.2);
> AddColumn(aTO,"To Add",1.2);
>
> //Filter = Turnover > (Foreign( "~MyIndex", "V" ) * ap);
>
>
> Any Help Appreciated.
> KR
> Michael.
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Yahoo! Groups
Sponsor <A
href=""><IMG
height=250 alt=c94524d.jpg src="jpg00208.jpg"
width=300> <IMG height=1 alt=c9452e3.jpg
src="jpg00209.jpg" width=1>Send BUG REPORTS to
bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page:
<A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Send
BUG REPORTS to bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Yahoo! Groups Sponsor
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 the Yahoo! Terms of Service.
Attachment:
Description: ""
Attachment:
Description: ""
|