Correlation calculations

Optuma Forums Optuma Scripting Correlation calculations


Viewing 1 post (of 1 total)
  • Author
  • #47523
    • Topics: 66
    • Replies: 589
    • Posts: 655

    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