As seen in this tweet, it’s possible to group watchlists by deciles (or quartiles, custom number of bins, or +/- sign) and calculate average values for any column for each group (note: this advanced grouping option is only available for clients with either a Professional or Enterprise Services subscription).
Here are the steps:
1. Open a watchlist (e.g. of the S&P500 from the Optuma Symbol Lists if enabled on your account), and add YTD custom column:
2. Right-click on the YTD column heading and select Group By Column > Decile:
[You can also format the column to 2 decimals by right-clicking again and change the Column Type option to Number and set the Price Display Format to 0.00, or alternatively divide the formula above by 100 and change the Column Type to Percentage to display with % sign.]
3. Collapse the groups by clicking the – in the top-left of the watchlist, and right-click in the grey horizontal bar in the Change % column and select Average from the Summary Type, and repeat for the YTD column:
4. Click on the Open Group As icon and select Open as RRG or any other type:
It’s not possible to use deciles in the scanning manager – only in a watchlist. You can create a list of the indices you are interested in (or open the Global Indices Optuma Symbol List). To change all to USD change the Master Currency property, and then you will be able to group in to deciles as described above.
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.