Correl([Column],[Column],[Period])

The Correl Indicator measures the relationship between the two columns. The correlation coefficient ranges between +1.0 and -1.0. The calculation of Correl is the same as the spreadsheet function CORREL (PEARSON).

In this version of Seer, the two passed in columns must both be the same size or an error will be reported.

Examples:

#Return the Correl column, using the close and the close of 5 bars ago.
#Note: We use NVL round the Ref(Close,-5) as we need to convert NAN 
#(Not A Number) to zero produced by REF otherwise all the values in the 
#returned column will be NAN
Correl(Close,NVL(Ref(Close,-5),0),14);

#Return the value for today of the Correlation of the 14 bar close of the 
#current instrument against the 14 bar of the close of CSCO
Today(Correl(Close,CSCO->Close,14));

Related functions:

ATR , ADX , BB , CCI , MFI , OBV , RSI , SS , ROC , RS , Range , Envelope , DEMA , MACD , TypicalPrice , MedianPrice , WeightedClose , Momentum , WilliamsR , Performance , Percent , TrueRange , Volatility , PivotPoint , MoneyFlow , StaDev , AveDev , Variance , Skewness , Kurtosis , LongWhite , LongBlack , PiercingLine , BullishEngulfing , BearishEngulfing , HammerHanging , ThreeWhiteSoldiers , ThreeBlackCrows , DarkCloudCover , Doji , LinearReg , LinearRegAngle , LinearRegIntercept , LinearRegSlope , TSF