[amibroker] Re: finding pairs

["kenbethau" <kenbeth@xxxxxxxxxxxx>]

to convert the following matrix to a list so as to update pair ratio data for graphing would be good any ideas?
i have altered hermans correlation matrix to produce the ticker and ratio of the pairs ,cutting and pasting is a bit slow, any other ideas of automatically updating a large number of pairs would be appreciated
here is the code i am playing with at moment..

////////////************************///////////////////////
list = GetCategorySymbols( categoryWatchlist,6
);// enter same watchlist number as in filter///

SetOption("NoDefaultColumns",True);
////////////////////
Filter = C>0;//Status("LastBarInTest") ;
SetSortColumns( 1 );
AddTextColumn(Name(),"Close",1.0);
AddColumn( DateTime(), "Date / Time", formatDateTime ); 

Ticker1= Name();
for( Col=0; (Ticker2=StrExtract( List, Col))!= ""; Col++)
//Ticker2=StrExtract( List,1); 


{
Var2 = Foreign(Ticker2,"C");
Corr =  C/Var2;
AddColumn( Corr,Ticker2, 1.3, 1, 5);
AddTextColumn(Name()+ticker2,"Pair",1.0);

}
////////////////////////////************//////////////////////

ken



------------------------------------

**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to 
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

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:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/