Re: [amibroker] InWatchList and ATC question/problem

["Tomasz Janeczko" <groups@xxxxxxxxxxxxx>]

Bill,

Your formula will work good if and only if watchlists are mutually exclusive
(have no common members). Otherwise you would need to 
put as many addtocomposites as there are watch lists, or build a loop:

symbols = "DJ-15,DJ-20,DJ-30,SP-500,MID--X,SML--X,RUI-X,RUT-X,NDX-X";

for( i = 0; ( sym = StrExtract( symbols, i ) ) != ""; i++ )
{
   if( InWatchList( i + 7 ) )
   {
     AddToComposite( Advanced, "~Adv "+sym,"X" );
     AddToComposite( Declined, "~Dec "+sym,"X");
   }
}



Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message ----- 
From: "Bill" <zim630@xxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Tuesday, October 17, 2006 10:11 PM
Subject: [amibroker] InWatchList and ATC question/problem


> Hi All,
> I've posted something similar to this before and received some 
> ideas, thanks for those responses.  I am by no stretch of the 
> imagination a programmer, but I am trying to learn.
> 
> I calculate several formula for ATC against indices maintained in 
> Watch Lists.  As an Example: if I use this formula (separate formula 
> for each index):
> YestClose = Ref( Close, -1 );
> Advanced = Close > YestClose;
> Declined = Close < YestClose;
> 
> AddToComposite( Advanced, "~Adv "+"MID--X" ,"X" );
> AddToComposite( Declined, "~Dec "+ "MID--X" ,"X");
> 
> and run it against a watch list containing S&P midcap components 
> watch list number 11 - Today's result is 109.
> 
> If however I run this against all stocks in the system:
> if (InWatchList(07)) sym="DJ-15"; 
> if (InWatchList(08)) sym="DJ-20"; 
> if (InWatchList(09)) sym="DJ-30"; 
> if (InWatchList(10)) sym="SP-500"; 
> if (InWatchList(11)) sym="MID--X"; 
> if (InWatchList(12)) sym="SML--X"; 
> if (InWatchList(13)) sym="RUI-X"; 
> if (InWatchList(14)) sym="RUT-X"; 
> if (InWatchList(15)) sym="NDX--X"; 
> 
> AddToComposite( Advanced, "~Adv "+sym,"X" );
> AddToComposite( Declined, "~Dec "+sym,"X");
> The result value for today on watchlist 11 MID--X is 1661.
> 
> watch list 11 & 12 give differing results.  Watch list 07 thru 09 
> return no results at all. The remaining results are identical. What 
> is going on? What am I missing?
> 
> Any help will be greatly appreciated. 
> And a Big Thanks in advance.
> 
> Bill
> 
> 
> 
> 
> 
> Please note that this group is for discussion between users only.
> 
> To get support from AmiBroker please send an e-mail directly to 
> SUPPORT {at} amibroker.com
> 
> For other support material please check also:
> http://www.amibroker.com/support.html
> 
> 
> Yahoo! Groups Links
> 
> 
> 
> 
> 
>

Content-Description: "AVG certification"
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.13.27/517 - Release Date: 11/3/2006