[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: Large Correlation Matrix



PureBytes Links

Trading Reference Links

john_dxd_smith,

Did you reach a solution?

Best regards,

--- In amibroker@xxxxxxxxxxxxxxx, "john_dxd_smith" <john_dxd_smith@xxx> wrote:
>
> 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 );
> }
>




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

**** 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/