Correlation Grid Chart

Author: Optuma Team Last updated: Nov 29, 2018 01:39

Overview

For clients subscribed to Enterprise Services, the Correlation Grid Chart is a multi-code chart that allows you to quickly measure the correlation values between a list of symbols or a portfolio. Areas of high correlation values are highlighted in green, and low correlation values in red.

CorChar1

The correlation values can be built from any available time frame (Daily, Weekly, Monthly, etc), and the correlation look back period can also be adjusted.

You can also open a full chart by clicking on the correlation value and selecting the preview window.

CorChar2

The chart that displays will contain a window for each code, and the correlation indicator allowing for more in-depth analysis.

CorChar3

To open a Correlation Grid Chart, left-click on the New menu, then go to Multi-Code Chart, and select Correlation Grid Chart, or you can open a list of symbols under Open As > Open Correlation Grid.

Actions & Properties

Actions

CorChar4
Clone Chart: When selected the existing chart will be duplicated. It will be placed above the existing chart, from here it can either be moved to a new page or tiled alongside your existing chart(s).

Print Chart: Opens the page in a PDF document, which can then be printed.

Restore Default Settings: Click this action if you have adjusted the default settings of the Correlation Chart, and wish to return to the standard properties originally installed with Optuma.

Save Settings as Default: If you have adjusted any of the Correlation Chart properties you can save the adjustments as your new default setting. Each time you open a new Correlation Chart it will display using the new settings.

Send To: This option allows the current chart to be saved as either an image file, saved to the clipboard or added to a Manual List. If you have Professional Services then the additional options of sending the chart via Chat Message, to Word and Outlook are also available.

Copy CSV values to Clipboard: Copy the values of the Correlation chart to clipboard which can be pasted into other programs such as notepad or Excel.

Open List As: Allows you to open the codes in the Correlation Chart into a different multi-code chart (RRG for example).

Properties

CrlGridUpdate
Title: Allows you to change the name of the chart in the title bar. By default it will read Correlation Chart but this can be changed to any text and will also be reflected when the page is published.

CorChar6

Bars: Sets the number of bars to be used in the Correlation calculation.

Calculate On: Display correlations based on Price, or % Change.
Price Display Format: Allows you to adjust the number of decimal places are displayed on the charts correlation values.

Date Range: By default the chart will load the last years data for each code. This is done to save system resources, however if you adjust the charts time frame to higher values (yearly for example) you will need to adjust the Date Range to load more data to allow the correlation values to calculate.

Automatically Set Font Size: When ticked the font size of the correlation values will increase / decrease based on the space available. Increasing / decreasing the size of the chart will cause the labels to change size as well. With the checkbox unticked the labels will remain static.

Font Size: This slider bar allows you to increase / decrease the font size of the correlation values.

Linked to List: Allows you to link the correlation chart to a list of codes, automatically updating if any changes are made to the lists constituent codes. The chart can be linked to scans, manual lists, and symbol lists.