Correlation to 10YY

Optuma Forums Optuma Scripting Correlation to 10YY

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #66177
    • Topics: 17
    • Replies: 7
    • Posts: 24

    I have been trying to make a script to determine correlation of  S&P 500 sectors to the yield on 10 YR Treasury.  I would like to be able to change the look back period.

    Here is what I have…Can anyone tell me if this is accurate, or help me fix it?

    C1 = CLOSE();
    CRL(C1, S1, BARS=252, CALCSTYLE=% Change)

    • Topics: 76
    • Replies: 1,038
    • Posts: 1,114

    Hi Matthew,

    If you are using this in a watchlist or column chart then you will need to increase the amount of data that is loaded (for speed, we limit the data loaded to 1 year). Change the Date Range property to Last 10 Years, and change to a Weekly timeframe. Then change the formula to 52 weeks x 5 years = 260:

    CRL(C1, S1, BARS=260, CALCSTYLE=% Change)


Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest