RE: [amibroker] Excluding symbols

["William Peters" <williampeters1@xxxxxxxxxxxx>]

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"> "<FONT 
color=#ff00ff>!<FONT face="Courier New" 
color=#ff00ff>"AND 
<FONT face="Courier New" 
color=#0000ff>StrMid(<FONT 
face="Courier New" color=#0000ff>Name<FONT 
face="Courier New">(),1<FONT 
face="Courier New">,1<FONT 
face="Courier New">) != <FONT face="Courier New" 
color=#ff00ff>"!"AND 
<FONT face="Courier New" 
color=#0000ff>StrMid(<FONT 
face="Courier New" color=#0000ff>Name<FONT 
face="Courier New">(),2<FONT 
face="Courier New">,1<FONT 
face="Courier New">) != <FONT face="Courier New" 
color=#ff00ff>"!"AND 
<FONT face="Courier New" 
color=#0000ff>StrMid(<FONT 
face="Courier New" color=#0000ff>Name<FONT 
face="Courier New">(),3<FONT 
face="Courier New">,1<FONT 
face="Courier New">) != <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. 







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.