Spearman Correlation is an alternative to the Pearsons Correlation and correlates based on the ranking of the series values .

 

This WikipediA link provides a good explanation of how this statical function analyzes information.

 

Use this function when an IPV Auto Indexed Series, or Price Series, and the dates in each series can be synchronized before computing series Correlation.  

 

This version computes the Log returns before computing the Correlation.

 

Syntax:

SpearmanLogCorrelationSync( series1, series2, bars )

 

Parameter:

Description:

series1

Name of first data series

series2

Name of second data series

bars

Number of bars over which to find the correlation.

 

Returns:

The correlation over the specified number of bars.

 

Example:

 

 

Links:

 

 

See Also:

 

 


Edit Time: 3/21/2022 11:45:27 AM


Topic ID#: 577

 

Created with Help & Manual 7 and styled with Premium Pack Version 2.80 © by EC Software