Select Page

# Plotting average of three correlation coefficients

Optuma Forums Optuma Scripting Plotting average of three correlation coefficients

This topic contains 2 replies, has 2 voices, and was last updated by  Prashant 2 weeks, 5 days ago.

Viewing 3 posts - 1 through 3 (of 3 total)
• Author
Posts
• #47771

Prashant
• Topics: 2
• Replies: 1
• Posts: 3

I have 4 indices – Nifty50, Nifty Midcap 100, Nifty smallcap 100, Nifty 500
​Correl1 = Correl(Nifty50, Nifty 500)
​Correl2 = Correl(Nifty Midcap 100, Nifty 500)
​Correl3 = Correl(Nifty smallcap 100, Nifty 500)
​Avg Correl = (Correl1 + Correl2 + Correl3)/3
​I want to plot the Avg Correl.

#47779

Darren
• Topics: 25
• Replies: 110
• Posts: 135

Hi Prashant,

Your best option is to open a Script Chart for NIFTY500 and then use this formula to plot the average 100 day correlation:

The current value is 0.39, which is the average of the tools when plotted on the chart:

#47787

Prashant
• Topics: 2
• Replies: 1
• Posts: 3

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.