Correlation calculations

Optuma Forums Optuma Scripting Correlation calculations


Viewing 1 post (of 1 total)
  • Author
  • #47523
    • Topics: 62
    • Replies: 502
    • Posts: 564

    The Correlation Grid is available for Enterprise Services clients which allows you to calculate the correlations between each component of a list, but what if you just wanted to show the correlation of a list of symbols against an index or another security? This can be done using the Correlation function CRL().

    Here’s an example of the US Sector ETFs against the US Dollar Index $DXY over the last 20 trading days, using this script in a Watchlist column:

    Utilities ($XLU) is currently most positively correlated to the $DXY, with Materials ($XLB) the most negatively correlated. Real Estate ($XLRE) is the leasr correlated:


    1 user thanked author for this post.
Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.