The Client Screener is a powerful search engine designed to efficiently filter data across multiple parameters. It enables users to apply various criteria on a single page, providing access to a consolidated view of client, account, order, and position data. The Client Screener can be utilized for a wide range of use cases, such as identifying clients with negative cash balances, filtering clients by their city of residence, and analysing margin utilization. This tool enhances data management and client analysis by offering comprehensive insights all in one convenient location.
Explore, My Views, and Standard Views
The client screener offers multiple views, categorized into three types:
- Explore: The Explore view serves as the default landing page of the client screener, presenting users with all data related to clients, accounts, orders, and positions without any pre-selected filters. From this view, users can apply available filters to customize the grid according to their needs. It is important to note that any filters applied in the Explore view are temporary and not saved, so upon returning to Explore, users will see the client screener in its original default state.
- My Views: Given the extensive data and array of filters, sorting options, and column configurations available in the client screener, it can be cumbersome for users to reapply these settings each time. To streamline the process, users can save a customized view. By applying necessary filters, selecting preferred columns, and organizing sorting options, users can create and save a view under a custom name.
- Standard views
There are also some standard views available for quick access. These views are curated with the most common use cases in mind.
How to Create a New View
- Navigate to the client screener.
- Apply the necessary filters.
- Select preferred columns across all four grids.
- Configure desired sorting options.
- Click the content menu next to the filter.
- Select "Save as a New View."
- Name the view and enable autosave for automatic updates each time changes are made.
Saved views allow users to quickly access customized settings from the saved views list, eliminating the need to reapply filters and settings.
The image below is provided to help users visualize the entire process.
Filters
The client screener offers a range of filters applicable to both client and account-level properties, enabling efficient screening of the client list. These filters are global, impacting all data across Clients, Accounts, Orders, and Positions.
Refer to the image below for an overview of the available filters for client and account-level properties.
Users can customize their view by clicking the "Edit Filters" button to show or hide filters according to their needs, providing a clutter-free and focused display.
Some of the most used filters include:
Cash: Allows users to identify clients with a negative cash balance. This filter is currency-agnostic, meaning it will return clients whose cash balance is equal to or greater than the specified amount, regardless of the currency (e.g., 100 USD, 100 EUR, 100 SGD).
Margin Utilization: Enables users to view clients whose margin utilization exceeds a certain percentage.
City of Residence: Permits users to filter clients based on their geographic location or region.
Account Type: Provides the ability to filter clients by specific account types. For example, users can view all clients holding a Pension account type.
Additional Filters for Positions and Orders Tabs
The screener includes additional filters tailored specifically for the Orders and Positions pages. These filters are exclusive to their respective tabs, enabling users to screen orders and positions according to criteria such as instruments, exchange, issuer, and more.
Grid Structure
The grid is organized into four distinct tabs:
- Clients: Displays a list of all active clients as determined by the selected filters. By default, with no filters applied, the grid shows all clients accessible to the logged-in user.
- Accounts: Lists all active accounts based on the selected filters.
- Orders: Provides a view of all open orders according to the applied filters.
- Positions: Shows a list of open positions filtered by the chosen criteria.
Clients Tab
The Clients tab displays a list of clients. By default, users can view the entire list of clients. To ensure performance and efficiency, only 200 rows are visible at a time, with the option to view more by clicking "Next Page" at the bottom of the screen. Filters explained in the Filters section above can be applied to refine the client list. Users can perform multiple actions from the Clients tab, detailed below.
Downloading Reports in bulk
The client screener enables users to download reports for specific clients or all clients. For further details, please refer to the following article.
Column Management
Users can customize which columns are displayed in the grid by clicking the cogwheel icon on the far right, as illustrated in the screenshot. Upon clicking the cogwheel, the column management dialog appears, allowing users to add or remove columns according to their needs. Column order can be rearranged by dragging selected columns up or down.
Export Screen Content: Users can also export the grid content in excel by selecting the clients (max 200) and clicking on export icon on right alongside the cogwheel.
Context Menu: The three-dot context menu on the grid provides quick access to navigate directly to the client page and client details with a single click.
Accounts Tab
The Accounts tab displays a list of accounts corresponding to all clients. By default, the full list is shown, which can be filtered using available filters. Multiple actions can be performed from this view.
Column Management and Export Screen Content: Like the Clients tab, users can add or remove columns in the Accounts tab and export the grid content using the same controls.
Context Menu: In the Accounts grid, users with trading rights can initiate a trade using the context menu. Note that the 'New Trade' option is unavailable to users without trading access.
Orders Tab
The Orders tab shows a list of all open orders across all clients, sorted by the time of order placement with the latest orders first. Users can change sorting by clicking on any column label. Filters are available above and in the orders section to refine the list.
For example, users can filter to view all long orders placed today under the NASDAQ exchange using the filters as shown below.
Columns Management and Export Screen Content: Similar to the Clients and Accounts tabs, users can add or remove columns in the Orders tab and export grid content using the same controls.
Context Menu: The Orders tab supports multiple actions from the context menu for quick user access. The screenshot below highlights different available actions. Note that all trading-related actions, such as canceling, changing to market, and modifying orders, are only accessible to users with trading rights
Positions Tab
The Positions tab displays a list of all open positions, sorted by Exposure by default to show positions with the highest exposure at the top. The grid supports sorting on all columns, allowing users to choose different sorting options according to their needs.
Additional filters are available above the global filters to refine the open positions list further. For example, these filters can be used to view all open positions on a specific instrument.
Columns Management and Export Screen Content: Like the Client and Account tabs, users can add or remove columns in the Positions tab and export grid content using the same controls.
Context Menu: The Positions tab includes a context menu for quick access to frequently performed actions. The screenshot below illustrates available actions within the positions grid. Note that trading-related actions, such as new trades and option strategies, are only accessible to users with trading rights.
Comments
0 comments
Please sign in to leave a comment.