Re: [amibroker] Excluding symbols

["IVA GmbH" <funnybiz@xxxxxx>]

Hello William,
 
this is a precious little goodie I´ll definitely 
put to use!
 
Mans thanks for sharing, I´m an awful 
programmer>sob<.
 
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:12 
  AM
  Subject: 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. 







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.