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:
- Open a watchlist (e.g. of the S&P500 from the Optuma Symbol Lists if enabled on your account), and add YTD custom column:
- 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.]
- 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:
- Click on the Open Group As icon and select Open as RRG or any other type: