PureBytes Links
Trading Reference Links
|
I'm trying to find top 100 positive/negative correlation pairs out of
3000 x 3000 correlation matrix.
How do I change the script to produce 9 million rows of ( ticker1,
ticker2, correlation ) so that I can just click to sort in AA result
window ?
WatchlistNum = 32;
SetOption( "NoDefaultColumns", True );
Filter = Status( "LastBarInTest" );
list = GetCategorySymbols( categoryWatchlist, WatchlistNum );
AddTextColumn( Name(), "Correlation", 1.0 );
Ticker1= Name();
for( Col=0; ( Ticker2 = StrExtract( List, Col ) ) != ""; Col++ )
{
Var2 = Foreign( Ticker2, "Close" );
Corr = Correlation( Close, Var2, 20 );
AddColumn( Corr, Ticker2, 1.6 );
}
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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
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: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/
|