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
