Stock Portfolio Organizer

The ultimate porfolio management solution.

Shares, Margin, CFD's, Futures and Forex
EOD and Realtime
Dividends and Trust Distributions
And Much More ....
For Portfolio Manager Click Here

WiseTrader Toolbox

#1 Selling Amibroker Plugin featuring:

Advanced Adaptive Indicators
Advanced Pattern Exploration
Neural Networks
And Much More ....
Find Out More Here

Correlation Table for Amibroker (AFL)

4 / 5 (Votes 7)
amibroker, exploration

Using the analysis feature in Amibroker, one can compare degree of correlations between and across securities found in a filtered watch list. This Amibroker code was prepared by the Quanting Dutchman last year.

Just edit the CorrPd line in the formula and specify the period of correlation you’re trying to analyse.


Similar Indicators / Formulas

General Market Exploration by XeL
Submitted by xel over 7 years ago
miftha indicator
Submitted by coolpace over 9 years ago
Deel - Average Dollar Price Volatility
Submitted by kaiji almost 10 years ago
Submitted by morgen over 9 years ago
Volume Spike Exploration
Submitted by ngocleasing over 9 years ago

Indicator / Formula

Copy & Paste Friendly
WLNum = Param("WatchlistNr",0,0,255,1);
CorrPd = 21;
list = GetCategorySymbols( categoryWatchlist, WLNum);

Filter = DateNum()==Status("rangetodate");
//SetSortColumns( 2 );
Ticker1= Name();

for( Col=0; (Ticker2=StrExtract( List, Col))!= ""; Col++)
 Var2 = Foreign(Ticker2,"C");
 Corr = Correlation( C/Ref(C,-1), Var2/Ref(Var2,-1), CorrPd);
 Color = IIf(Corr>0.5, colorLime, IIf(Corr>0,colorBrightGreen,IIf(Corr<-0.5, colorRed,IIf(Corr<0,colorOrange,colorWhite))));
 Color = IIf(Ticker1==Ticker2, 1, color);
 AddColumn( Corr, Ticker2, 1.3, 1, Color,width=60);


1. arm


2. 13oct08

What type of co-relations we are talking about, metal stocks to companies using those metals? and automobile companies? Something like that?

Leave Comment

Please login here to leave a comment.