Pairs Grid Chart
- Default Ratio Script: Data 1 / Data
- Number of Days the relative strength has been higher: V1 = data1/data2; DU(V1)
- Compare Difference in Daily % Change: ROC(Data1, Bars=1) - ROC(Data2, Bars=1
- Convergence / Divergence Indicator: DIVERGENCE(Data1, Data2)
OverviewThe Pairs Grid Chart is a multi-code chart that allows you to quickly measure various metrics such as Ratio or Relative Comparison values between pairs of codes within a list / portfolio.
The calculations are based on the vertical column compared to the horizontal, with cells with a high ratio value (by default) highlighted in green, and low ratio values in red. In the example above, BA on the vertical has a share price 11 times that of GE on the horizontal, with the inverse being 0.09.
In previous versions of Optuma you would have needed to setup each column individually in a watchlist, with a different division spread ratio script for each code. Depending on how many codes you were comparing this could take hours, with this new chart type it can be setup in seconds.
The ratio values can be built from any available time frame (Daily, Weekly, Monthly, etc).
You can also open a full chart by clicking on the ratio value and selecting the preview window.
The chart that displays will contain a window for each code, and a division spread of the two codes at the bottom.
Actions & Properties
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 Pairs Chart, and wish to return to the standard properties originally installed with Optuma.
Save Settings as Default: If you have adjusted any of the Pairs Chart properties you can save the adjustments as your new default setting. Each time you open a new Pairs 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 Pairs 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 Pairs Chart into a different multi-code chart (RRG for example).
Title: Allows you to change the name of the chart in the title bar. By default it will read Pairs Grid but this can be changed to any text and will also be reflected when the page is published.
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 ratio values to calculate.
Automatically Set Font Size: When ticked the font size of the ratio 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 ratio values.
Script: Opens the Script Editor window allowing you to adjust the script producing values on the Pairs chart. By default the Ratio script will be used, which is a division spread of the two codes.
These two data references can be used with other scripts. For example:
- This will produce a series of positive values representing how long the Data1 symbol has been relatively stronger than the Data2 symbol, calculated using the DaysUp DU() function. In this example NAB has been stronger than AMP and ANZ for 6 straight days:
Using the standard Divergence function (10 bar default) this script will produce a set of results which are 1 (convergence) 0 (null) or -1 (divergence).
Linked to List: Allows you to link the Pairs 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.