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 ....
WiseTrader Toolbox
#1 Selling Amibroker Plugin featuring:
Advanced Adaptive Indicators
Advanced Pattern Exploration
Neural Networks
And Much More ....
Correlation Table for Amibroker (AFL)
Rating:
4 / 5 (Votes 7)
Tags:
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.
Screenshots
Similar Indicators / Formulas
GapUp and Bearish Close (Reversal) _Daily
Submitted
by indraji2001 over 10 years ago
General Market Exploration by XeL
Submitted
by xel over 12 years ago
miftha indicator
Submitted
by coolpace over 14 years ago
Deel - Average Dollar Price Volatility
Submitted
by kaiji almost 15 years ago
DIX50,20,10
Submitted
by morgen over 14 years ago
Volume Spike Exploration
Submitted
by ngocleasing over 14 years ago
Indicator / Formula
Copy & Paste Friendly
// eCorrelationTable.afl
WLNum = Param("WatchlistNr",0,0,255,1);
CorrPd = 21;
list = GetCategorySymbols( categoryWatchlist, WLNum);
SetOption("NoDefaultColumns",True);
Filter = DateNum()==Status("rangetodate");
//SetSortColumns( 2 );
AddTextColumn(Name(),"Corr("+NumToStr(Corrpd,1.0)+")",1.0,width=70);
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);
}2 comments
Leave Comment
Please login here to leave a comment.
Back
DID NOT WORK
What type of co-relations we are talking about, metal stocks to companies using those metals? and automobile companies? Something like that?