I clipped this from one of my routines and I think this will work if the individual watchlists 1...10 contain the tickers from which the indexes are composed. 

1) Select a current symbol with a suitable number bars

2)  Select n last quotations = 1

3)  Run as a SCAN

Ths should produce 10 tickers ~WLAvg1 to ~WLAvg10 with the average volume in the Volume field.

You choose how you want to average the price arrays.

Hope this helps

Joe

 

VolTotal = Count = CountVol = 0;

for (j =1 ; j<=10; j++)

{

//_TRACE("WL # " + j);

watchlistsymbols = GetCategorySymbols(categoryWatchlist, j);

for (mem = 0; (member = StrExtract(watchlistsymbols, mem)) != ""; mem++)

{

ticker = Foreign(member, "Close");

//_TRACE("Ticker "+ ticker+" no of member "+ mem);

tickvol = Nz( Foreign(member, "Volume") );

VolTotal = Voltotal + tickvol;

countvol = countvol + IIf(IsEmpty(ticker), 0, 1);

}

IndexVolavg = voltotal / countvol;

// Here generate a symbol name for example "~WLAvg01 to "~WLAvg10"

Listnum = j; // for readability

if (Listnum < 10)

Listnumstr = StrFormat("%1.0f", Listnum);

else

Listnumstr = StrFormat("%2.0f", Listnum);

AddToComposite(indexvolavg, "~WLAvg" + Listnumstr, "V", atcFlagDefaults + atcFlagEnableInExplore);

}

Buy = Sell = 0;

----- Original Message -----
From: Terry
Sent: Wednesday, October 04, 2006 2:10 PM
Subject: RE: [amibroker] Composite Calculations - help

You might try using a different variable for list since you have it both as a numeric, then you assign a string to it. This may or may not be causing problems, but I'm guessing it is.

 

list==10;

Comp ="SP-500";

 

   list = CategoryGetSymbols( categoryWatchlist, list );   

--

Terry

 

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bill
Sent: Wednesday, October 04, 2006 12:28
To: [email protected]
Subject: [amibroker] Composite Calculations - help

 

Hello,

I like to keep composite data on a dozen or so indices.  If I have a

seperate .afl for each index and run it against a watch list

containing the components of that index, everything appears to work

fine.  However, I've recently been trying to have one .afl access

the different watch lists as such:

 

if (InWatchList(10)){

list==10;

Comp ="SP-500";

 

   list = CategoryGetSymbols( categoryWatchlist, list );   

   for( i = 0; ( sym = StrExtract( list, i ) ) != ""; i++ );

}

else

NEXT WATCH List and so on.

I run this against all the stock components contained in all the

indices. database (TC2007).  I know there is duplication with one

stock being in more than one index. Again it appears to work just

fine however, I receive different answers than

when I run it the first way.  Anyone know why this might be?? And

what I can do?

 

Thanks in Advance for any assistance,

 

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

 

<*> To visit your group on the web, go to:

    http://groups.yahoo.com/group/amibroker/

 

<*> Your email settings:

    Individual Email | Traditional

 

<*> To change settings online go to:

    http://groups.yahoo.com/group/amibroker/join

    (Yahoo! ID required)

 

<*> To change settings via email:

    mailto:[EMAIL PROTECTED]

    mailto:[EMAIL PROTECTED]

 

<*> To unsubscribe from this group, send an email to:

    [EMAIL PROTECTED]

 

<*> Your use of Yahoo! Groups is subject to:

    http://docs.yahoo.com/info/terms/

 

 

__._,_.___

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






SPONSORED LINKS
Software support Small business finance Business finance online
Business finance training Business finance course

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___

Reply via email to