Correlation
Overview
The Correlation tool requires two overlayed securities and when applied will show how closely the two securities are correlated.
The Correlation tool includes two plot selections. This makes it possible to alter which security is used for Plot 1 and Plot 2.
In the below example, QAN has been used for Plot 1 and VAH for Plot 2.
To change Plot 1 to VAH and Plot 2 to QAN, right click on the tool and make the changes from the Properties menu. It is also possible to offset Plot 2, if you want Plot 2 to be offset by 2 days then you will adjust this value to 2.
To apply the tool, first overlay two codes on a chart. Next, select the tool from the Statistical tool group, and left-click on the chart to add the tool. Optuma will then draw the tool in a window below the chart using the default settings.
Scripting Function: CRL()
Actions & Properties
Actions
Copy Data to Clipboard: Will copy the tool’s values to the clipboard which can then be inserted into a spreadsheet, for example, allowing for further analysis.
Add to Toolbar: Adds the selected tool to your custom toolbar.
Apply Settings to All: When multiple Correlation tools have been applied to a chart, page or workbook, this action can be used to apply the settings of the one selected to other instances of the tool. This is a great time saver if an adjustment is made to the tool - such as line colour - as this allows all the other Correlation tools in the chart, page or entire workbook to be updated instantly.
Copy Tool: Allows you to copy the selected tool, which can then be pasted onto a different chart window.
Move to Back: If the tool is displaying in front of other tools or indicators clicking this action will move the tool view to the background.
Move to Front: If the tool is displaying behind other tools or indicators on the chart, clicking this action will bring the tool to the forefront.
Restore Default Settings: Click this action if you have adjusted the default settings of the tool, and wish to return to the standard properties originally installed with Optuma.
Save Settings as Default: If you have adjusted any of the tool’s properties (colour, for example) you can save the adjustments as your new default setting. Each time you apply a new Correlation to a chart, the tool will display using the new settings.
Delete: Deletes the tool from the chart.
Properties
Tool Name: Allows you to adjust the name of the tool, as it’s displayed in the Structure Panel.
Plot 1: Sets which security will be used for the first plot.
Plot 2: Sets which security will be used for the second plot.
Plot 2 Offset: Moves the 2nd plot forward or backwards in time. The offset is measured in bars, so a value of 2 will push the tool forward 2 bars and -2 will move the tool back 2 bars.
Bars: Sets the number of bars to be used in the Correlation calculation.
Calculate On: The calculation can be based on Price, or % Change.
Plot Style:** This property expands to provide the following:
- Plot Style - Allows you to change how the Correlation is displayed on your chart. There are 6 options available: Line, Dot, Histogram, Step, Shaded, Shaded Step.
- Line Style - The Line Style property allows you to adjust the type of the line displayed. There are 8 options available: Solid, Dots, Dash, Dash Dots, Long Dash, Long Dash Dot, Long Dash Dot Dot, Stippled.
- Line Width - Allows you to adjust the width of the line. Moving the slider bar to the right increases the thickness of the line.
- Line Colour - Allows you to select the colour of the line. Clicking on the drop down arrow will display a colour swatch. Locate the desired colour and left-click it once to select it.
- Fill Up / Down Barrier - When the Plot Style is set to Shaded you are able to adjust the barrier value, i.e. the margin between the two correlation plots. The default value is 0.00.
- Fill Up Colour - When the Plot Style is set to Shaded you are then able to alter the Fill Colour for the tool.
- Fill Down Colour - When the Plot Style is set to Shaded you are then able to alter the Fill Colour for the tool.
Centre Line Style: This property expands to provide the following:
- Line Style - The Line Style property allows you to adjust the type of the line displayed. There are 8 options available: Solid, Dots, Dash, Dash Dots, Long Dash, Long Dash Dot, Long Dash Dot Dot, Stippled.
- Line Width - Allows you to adjust the width of the line. Moving the slider bar to the right increases the thickness of the line.
- Line Colour - Allows you to select the colour of the line. Clicking on the drop down arrow will display a colour swatch. Locate the desired colour and left-click it once to select it.
- Transparency - Use this slider bar to adjust the transparency of the Centre Line. Moving the slider to the left will increase the transparency of the tool.
- Fill Transparency - When the Plot Style is set to Shaded you are then able to adjust the shading transparency. Moving the slider to the left will increase the transparency of the tool.
Offset: Moves the tool forward or backwards in time. The offset is measured in bars, so a value of 2 will push the tool forward 2 bars and -2 will move the tool back 2 bars.
Tool Transparency: Use this slider bar to adjust the transparency of the tool. Moving the slider to the left will increase the transparency of the tool.
Visible: Un-tick this checkbox to hide the tool from the chart.
Show In Price Scale: When selected the current Correlation value will be displayed in the Price Scale.