|
PureBytes Links
Trading Reference Links
|
Nice, William.
With all those functions in AFL, itīs sometimes
hard to keep perspective - for me.
Itīs right in front of my eyes and I donīt see the
solution - at times.
Appreciate it!
Markus
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
<A title=williampeters1@xxxxxxxxxxxx
href="">William Peters
To: <A title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Thursday, February 27, 2003 5:24
AM
Subject: RE: [amibroker] Excluding
symbols
Here are
a few more variations...
<FONT face="Comic Sans MS"
size=2>
If you
want 'Equal to' then use the following:
<FONT
face="Times New Roman">F1 = <FONT
face="Times New Roman">Name() == <FONT
color=#ff00ff>"ABC"<FONT
face="Courier New">;
Filter =
F1;AddColumn( C, <FONT
color=#ff00ff>"Close" );
<FONT face="Courier New"
size=2>
For all
symbols beginning with the letter 'A'
F1 = <FONT
color=#0000ff>Name() >= <FONT
color=#ff00ff>"A<FONT
color=#ff00ff>" AND Name() < <FONT
color=#ff00ff>"B<FONT
color=#ff00ff>" ;Filter = F1;<FONT
color=#0000ff>AddColumn( C, "Close"
);<SPAN
class=328291804-27022003>
<FONT
size=2><FONT
face="Comic Sans MS">
<FONT
size=2>
<FONT
size=2>William
<FONT
size=2>
<FONT
size=2> -----Original
Message-----From: William Peters
[mailto:williampeters1@xxxxxxxxxxxx]Sent: Wednesday 26 February,
2003 8:12 PMTo: amibroker@xxxxxxxxxxxxxxxSubject: RE:
[amibroker] Excluding symbols
Hi
Markus,
<FONT face="Comic Sans MS"
size=2>
Here is
one way to approach it:
F1 = <FONT
color=#0000ff>Name() > "A" <FONT
face="Courier New">AND <FONT face="Courier New"
color=#0000ff>Name() < <FONT
face="Courier New" color=#ff00ff>"M"<FONT
face="Courier New"> ;F2 = (<FONT
face="Courier New" color=#0000ff>StrMid<FONT
face="Courier New">(<FONT face="Courier New"
color=#0000ff>Name(),<FONT
color=#ff00ff>0,<FONT
face="Courier New" color=#ff00ff>1)
!= <FONT face="Courier New"
color=#ff00ff>"!<FONT
face="Courier New" color=#ff00ff>"<FONT
face="Courier New">AND <FONT face="Courier New"
color=#0000ff>StrMid(<FONT
face="Courier New" color=#0000ff>Name<FONT
face="Courier New">(),1<FONT
face="Courier New">,<FONT face="Courier New"
color=#ff00ff>1) != <FONT
size=2>"!"<FONT
face="Courier New">AND <FONT face="Courier New"
color=#0000ff>StrMid(<FONT
face="Courier New" color=#0000ff>Name<FONT
face="Courier New">(),2<FONT
face="Courier New">,<FONT face="Courier New"
color=#ff00ff>1) != <FONT
size=2>"!"<FONT
face="Courier New">AND <FONT face="Courier New"
color=#0000ff>StrMid(<FONT
face="Courier New" color=#0000ff>Name<FONT
face="Courier New">(),3<FONT
face="Courier New">,<FONT face="Courier New"
color=#ff00ff>1) != <FONT
face="Courier New" color=#ff00ff>"!"<FONT
face="Courier New">);Filter = F1 AND F2;<FONT
face="Courier New" color=#0000ff>AddColumn(
C, "Close"<FONT
face="Courier New" size=1> );
<FONT
size=2><FONT
face="Comic Sans MS">
<FONT
face="Comic Sans MS" size=2>The above selects
all tickers between A and M (Not including A and M) without the '!' symbol
within the first 4 characters of the ticker name. You can modify as
required.
<FONT
face="Comic Sans MS" size=2><SPAN
class=656220804-27022003>
<FONT
face="Comic Sans MS" size=2><SPAN
class=656220804-27022003>Regards,
<FONT
face="Comic Sans MS" size=2><SPAN
class=656220804-27022003>William
<FONT
size=2>
<FONT
face="Comic Sans MS" size=2><SPAN
class=656220804-27022003>
<FONT
face="Comic Sans MS" size=2><SPAN
class=656220804-27022003>
<FONT
size=2> -----Original
Message-----From: funnybiz@xxxxxx
[mailto:funnybiz@xxxxxx]Sent: Wednesday 26 February, 2003 4:00
PMTo: amibroker@xxxxxxxxxxxxxxxSubject: [amibroker]
Excluding symbols
Hello,
Iīve difficulties to formulate a filter that lets
me exclude symbols from a scan according to their ticker names.
For instance: exclude all symbols containing "!"
(indices from the QP2 database) or starting with the letter "a"
etc.
How can this be done, please?
filter=name
MarkusSend 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.
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
ADVERTISEMENT
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.
|