Watchlists in Optuma provide you with the raw and important information for a number of securities on one screen. Any fundamental or technical value or condition can be added to a custom column using the Optuma Scripting Language, such as 52 Week High, sector, market cap, moving average slope direction, weekly RSI value, % above 50MA, Relative Rotation Graph® values - basically anything you can think of. When real-time data is enabled, the information displayed on the Watchlist will dynamically update with each tick.
As you click on a ticker in the list any chart of the same tab will update accordingly.
Professional and Enterprise Services clients can automatically group the list (eg by Sector, or by decile) and summarise each one:
Intro to Watchlists
This video is pulled from the Optuma 101 course that you can access here. This course takes you through the basics of Optuma and helps you get up and running and using Optuma to its full potential. This video will cover how to create and open a watchlist.
This video is also pulled from the Optuma 101 course and will take you deeper into the flexibility of watchlists and show you how you can use watchlists to help further your analysis and make the most out of Optuma.
Opening a Watchlist
There are four ways to create a Watchlist:
Method 1 - Individually Add Codes
Click the New menu located on the top-left corner of the program window. In the menu that displays left-click the Watchlist option.
A blank Watchlist will open.
You can populate the Watchlist by typing in the codes you want displayed.
Optuma TipThis method of opening a Watchlist in Optuma has a keyboard shortcut of Ctrl + Alt + W
Method 2 - Import a CSV file
Instead of typing the individual codes as described above, if you have a list of codes in a text (.csv) file that you wish to create a Watchlist from, select the Import From CSV option under the Actions menu, and navigate to the required file to be imported.
Method 3 - By Exchange Folder or Symbol List
Press F3 on your keyboard to open the Data File Selector.
Expand the exchanges down and locate a folder you wish to display on a Watchlist.
Right-click on the selected folder and click the Open in Watchlist option. If you want to use a Symbol List, click on the Symbol Lists tab and select the Symbol List you want to use for the Watchlist. Note that the Watchlist will stay "Linked" to the Symbol List and as changes are made to the underlying list, the Watchlist will be updated.
The codes contained within the selected folder will be opened in a Watchlist.
Method 4 - From Scanning Manager Results
Scan results can be exported to a create a new Watchlist, which can be linked to the scan. As the data is updated then the codes in the Watchlist will be refreshed. For more information on the Scanning Manager, click here.
The following columns are available in a Watchlist:
- Change (%) - The Net Change of the security displayed as a percentage rather than a dollar value.
- Chart Preview - Hover your mouse cursor over the Chart Preview column and a small preview of the securities chart will display. Left clicking on the chart preview will open a chart for the selected code.
- Code - The code of the security.
- Currency - This is the currency of the security.
- Direction - The direction of the security is calculated by comparing the latest price to the previous days Close.
- Exchange - Which exchange the security trades on.
- High - The High price for the selected security.
- Last - Displays the Last price the security traded at.
- Last Date - Displays the last date data was added to the security.
- Last Time - Displays the last time data was added to the security. (Real-Time data only)
- Low - The Low price for the selected security.
- Market Cap - The market capitalisation for the security if it is an equity.
- Name - The full name of the security.
- Net Change - The Net Change of the security is calculated by (Latest price - Previous Days Close).
- Open - The Open price for the selected security.
- Volume - The number of units traded for the day.
- Yearly Range - The range that this security has traded over the previous year.
Real-Time data only
- Ask - The cheapest price on the market the selected security can be purchased for.
- Ask Size - The number of units available on the market at the current Ask price.
- Bid - The highest price on the market the selected security has listed, as an unfilled order.
- Bid Ask Spread - The difference between the current Ask price, and the Bid price.
- Bid Size - The number of units wanting to be purchased on the market at the current Buy price.
- Lot Size - The volume of units processed in the last trade.
Fund/Portfolio Linked data onlySome Symbol Lists that Watchlists are linked to can have both Portfolio Weight and Benchmark Weight fields. Optuma uses these to calculate and display the following fields.
- ActiveWeight - The difference between the Benchmark weight and the Fund weight.
- Benchmark Weight - Considering the total weight of the benchmark, how much does this equity contribute?
- Fund Weight - Considering the total weight of the portfolio, how much does this equity contribute?
Trade Linked data onlyWhen a linked list is pointing to a portfolio that has the entry date and price, the following fields will be used to display important information about those trades.
- Average Unit Cost - The average cost for the holdings.
- Percent Profit - Displays the profit as a percentage.
- Profit Loss - Displays the profit as price.
- Total Holdings - Total number of shares/contracts being held.
- Total Value - Total value of the Holding (Shares x Last).
Note: This requires access to Professional Services and Bloomberg Terminal.
Journalling Linked data onlyOptuma has an integrated Journalling system that is designed to help clients keep notes about their trades. When that system is being used, the following fields are used in the Watchlist.
- Note - This field will display the last Journal added.
- Note Date - The date of the Last Journal entry.
- Recommendation - When using Optuma Journalling, this displays if it has been rated a Buy, Hold or Sell.
Adding a Column
Left-click on the + sign located to the right of the last Watchlist column.
In the window that displays, left-click on the column you wish to add.
The Watchlist will update to display the new column.
Removing a Column
The fastest way to remove a column from the Watchlist is to go to the column header along the top row of the Watchlist. Hover over the column you wish to remove and left-click the small red x displayed.
Moving a Column
To move a column, go to the column header along the top row of the Watchlist. Hover over the column you wish to move, left-click and hold the mouse button down while moving your cursor to the position where you'd like the column to display. Once you're in the desired location release the left mouse button and the column will drop into place.
For those who wish to track more detailed information, Optuma Watchlists include Analysis Columns. An Analysis Column allows for a formula to be entered and the result for each security in the Watchlist will be displayed. If the formula has a true or false result (e.g. is Gann Swing Up?) then that cell in the Watchlist will be coloured so it is obvious that the condition has been met.
To add an Analysis Column left-click on the + sign located to the right of the last Watchlist column.
In the window that displays, left-click on New then select Script Column.
The Add Analysis Column window will display.
In this window enter a header for the Column ("Trigger 1" for example). Then enter the formula you wish the column to display, or calculate from. For more information on the Optuma formula language, please click here.
Once an Analysis column has been added, it will either display the indicators current value, or a True / False label.
Custom Column Headings
For any columns that you add to your Watchlist, you can customise the label to something of your choosing.
To change the label, right-click on the column heading and then from the menu that displays alter the click on the column heading and then from the menu that displays, alter the Column Label as needed.
Available from Optuma v1.5 and later, the Alerts column on a Watchlist can be added. It displays the closest Alert price Above and or Below t he current closing price.
Alert prices above the close are shown on the left of the column, and those below the close are shown on the right, separated by a | symbol.
These values can be referenced in the NEARESTALERT() scripting function.
Group Column Summary Values
If a Watchlist has been set up to sort rows into various groups (GICS Level, for example) you can setup the header rows of each group to display summary values.
The options supported are:
- Portfolio Weighted Average
- Fund Weighted Total (where available)
Multi Level sorting is supported in Watchlists. For example, you may want to sort the Watchlist rows by Change % and Last Price.
In the above image, the Multi-Column sorting has been selected from the Properties menu. However, it is also possible to hold the Ctrl key down and then left-click on the Column headings that you want to sort the columns by.
Create an Alert from a Watchlist Column
An Alert can be set from a column in the Watchlist (Standard columns or Custom Script Columns), in a similar way you can set a Price / TA alert from a chart.
To do this right-click on the column value and then select Create Alert. The column values must be a number for it to support alerts.
Column Display Style
The Display Style, by default, is set to Auto which will display a value. However, this can be set to display a graphical representation of the yearly range or even as a graph.
The above example shows an RSI column set to display as a Yearly Range. CAT is at the high end of its yearly range, whereas MMM is at the lower end.
Watchlists columns (sourced from Scripts or External Data Fields) can be set to display as either text, date, a number, currency or a percentage.
In the above example, the Watchlist Column Change% Wk is using the following script:
((CLOSE() - CLOSE(WEEK(), OFFSET =1))/CLOSE(WEEK(),OFFSET=1) )
By default, the column would display the results as numerical values only; with the Column Type option, they can be displayed as actual percentages.
By default, the rows are displayed by the order you entered them in. You can adjust the order of the rows by going to the Column Headers and left-clicking on them once. (For example, left-clicking on the Code heading will sort the rows in Alphabetical order).
When the rows are being ordered by a specific column, an arrow will be displayed on the column header.
Left-clicking on the header for a second time will reverse the order (A to Z / Z to A).
Removing a Row
The fastest way to remove a row from the Watchlist is to go to the 1st column of the row. Hover over the rows you wish to remove and left-click the small red x displayed. NOTE: if the list is linked to a Symbol List then either remove the code from the source list and re-load the Watchlist, or unlink from the list in the Properties.
Row Headers / Groupings
Watchlists can be setup with Header rows, either manually (by inserting a Row Header via the Right-Click menu) or automatically (when using Bloomberg data by ticking the Automatically Group Codes checkbox).
Header Row - Update Multi Code Charts (Single Click)
When header rows are used and the Watchlist and Multi-Code chart are using the same Group Diamond (covered under the section Group Diamond further down), then it is possible to update the Multi-Code chart to display the codes as used under the header row with a single click.
In the following example, the RRG and Watchlist are both using a gold diamond grouping, clicking on the different header rows then updates the RRG to display those codes.
Row Grouping - Bins
Watchlists rows can be grouped into Bins (manual groups of between 3 and 15, with 10 being the equivalent of deciles) using values from any selected column. This Watchlist universe has been grouped into 3 based on the Change % column, with the lowest, middle and highest grouped together:
To group rows into bins right-click on a column header and expand the Group By Column section. Go to Group into Bins and select the number of sections you would like to use (Minimum 3, Maximum 15).
Each row in the Watchlist now includes a checkbox allowing you to select specific rows to perform actions on (Delete, Print, etc).
Above the Watchlist columns are a series of buttons, as per the below image. Each button performs a unique function, which are detailed below.
The Cycles button allows you to automatically cycle through the rows contained within the Watchlist.
As the rows cycle, charts linked to the watchlist will also update.
You can adjust the interval of the cycle by right clicking the new button and adjusting the value displayed.
Open List As
The Open List As button allows you to open different chart styles for the codes listed in the watchlist, e.g. RRG.
The Group Diamond setting icon appears in the Watchlist and also on charts opened from the Watchlist. Page grouping allows you to setup a combination of multiple Watchlists and charts which are sorted and linked into different groups.
For example, if you have two tiled charts alongside the Watchlist, ordinarily both charts will update to the security of the selected row. However, if one of the charts is set to a different group, e.g. an index such as XJO, only the chart that has the same coloured diamond as the Watchlist will update. The Index will remain the same.
All charts in Optuma include the Pin Chart icon. When a chart or Watchlist has been pinned to the page, it will always display over the top of any other (unpinned) chart.
Adjusting the tiling orientation will also have no effect on the size or position of a pinned chart, so it is a great way to protect your preferred page layout when wanting to make modifications (such as adding an additional chart).
The information icon displays on all charts. When enabled, help information bubbles will be displayed for all major features.
As you roll your mouse over an i icon, information on that feature will be displayed.
Before normal operation of Optuma can return, you will need to close the Information feature.
Windows Maximise / Restore
This is a standard Windows feature. Clicking the Maximise button will enlarge the Watchlist, making it fill the entire page. Clicking the same button will then restore the Watchlist to normal size.
Clicking the x icon will close the Watchlist.*
Note: This is irreversible, if you haven't saved your workbook then your Watchlist will be lost.
Actions & Properties
Clone Chart: When selected, an exact replica of the existing RRG chart will be created.
Cycle Codes: This will instigate the Cycle Row function which will cycle through each row in the Watchlist. This can also be activated by clicking the Cycle button as referenced above under the section Watchlist Buttons.
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 Watchlist, and wish to return to the standard properties originally installed with Optuma.
Save Settings as Default: If you have adjusted any of the Watchlist properties, you can save the adjustments as your new default setting. Each time you open a new Watchlist it will display using the new settings.
Send To: This option allows the current chart to be saved as either an image file or saved to the clipboard. If you have Professional Services then the additional options of sending the chart via Chat Message, to Word and Outlook are also available.
Update Charts: Will update the charts from the Watchlist with the latest available data.
Refresh Fundamental Data: When a live data feed from Bloomberg (requires Professional Services) is available this will update any available fundamental data.
Import From CSV: This option will import a symbol list from a CSV file to create the Watchlist.
Copy CSV values to Clipboard: Selecting this option will copy the rows and column values to the Clipboard which can then be inserted into another application such as Excel.
Select All Rows: Selecting this option will automatically select and tick each check box next to each row.
Deselect All Rows: Selecting this option will automatically deselect each check box next to each row.
Open List As: For each row that has been selected in the Watchlist the following can be created: Charts, RRG, Sector Map, another Watchlist, Watch tiles, Relative Comparison chart, Spread chart, Market Intelligence chart and a manual list.
Publish Selected Codes: For the rows that have been selected charts can be published as a PDF. If you have Professional services then you can also publish the charts via Word, PowerPoint, Outlook and the Web.
Layout: Allows you to create or select a previously created Watchlist Layout. For more information, click here.
Title: This property can be used to give the Watchlist a title.
Date Range: This setting allows you to choose how much historical data is used for the Watchlist. By default, the date range is set to Last Year. However, you can also choose one of the following options.
- Last Week
- Last Fortnight
- Last Month
- Last Quarter (3 Months)
- Last Year
- Last 5 Years
- Last 10 Years
- Date Range
- Selected Date
Dynamic Sort: When the Watchlist is using real-time data, you can enable the Dynamic sort option, to ensure any changes that effect the order of the rows are updated automatically. For example, if you have your rows ordered by Net Change %, if the 2nd rows value becomes larger than the 1st rows value, the 2nd row will move into the 1st position.
Highlight Changes: When this option is enabled and the Watchlist is using real-time data, any changes to a field will be highlighted.
Automatically Set Font Size: When enabled the font size will be automatically set to the largest size that can be accommodated by the current column/row configuration.
Font Size: When Automatically Set Font Size is disabled you can adjust this slider bar to change the size of the text font displayed on the Watchlist. Moving the slider to the right will increase the font size, moving the slider to the left will decrease the font size.
Linked to List: When selected the Watchlist can be linked to either a scan or symbol list.
List to Use: When Linked to List is active, this property allows you to select which list you want to use. Lets you choose from any csv files or scans that you have used as well as allowing you to import a new symbol list.
Master Currency: This property gives you the ability to adjust the price values displayed in the Watchlist columns to a different currency.
Group By: This setting will group the Watchlist rows based on the user selected field, e.g. Direction. Please note that some items will require a Bloomberg connection, e.g. GICS.
Multi-Column Sorting: When enabled the Watchlist can be sorted by the values in a selected column.
Show Summary Row: Adds a row at the top of the Watchlist (or groups if in use) where a summary value can display. Summary values can be set to Sum, Average, Count or Median.
Show Checkboxes: Unticking this option will hide the checkboxes that display on the far left of each row.
Sort By: This option appears when "Multi-Column Sorting" is enabled to allow selection of the column to be used to sort the Watchlist on.
Indent Width: Sets how far the Watchlist will be indented from the left-hand border.