Skip to content

Correlation Function - CRL()

By Optuma Team · Updated 2020-07-16

To calculate correlations between a stocks, asset classes or sectors use the CRL() function.

For example, to show the 22 day correlation between the S&P500 index and various asset classes use the following in a watchlist with the GETDATA() function to use the SPX data:

S1 = GETDATA(CODE=SPX:WI);
C1 = CLOSE();
CRL(C1, S1, BARS=22)

By default it will calculate based on % change, but it can also be calculated on price change.

Capture

Choose which categories of cookies you allow. Strictly-necessary cookies are always on. You can change this any time via the "Cookie Settings" link in the footer.

  • Functional

    Remember preferences like dismissed banners and your dark-mode choice.

  • Analytics

    Help us understand how the site is used so we can improve it.

  • Marketing

    Measure our advertising and help us reach people who may be interested in Optuma.