XCA enables users to easily identify and analyze existing trading costs, including Brokerage rates and Exchange Fees. XCA offers multiple ways to filter your specific needs to display the dataset you are analyzing. In this article you will learn about performing searches and the various available filters when viewing data. .
Select Your View
XCA currently supports options to view By:
- Product – display costs for a single product across all counterparties
-
Broker – display costs for your entire product roster for a given Executing Broker
View by Product
Within this view, you may search for a given product by clearing code, vendor symbol, or text string.
i.e. type ‘ES’ for XCME ES E-mini S&P 500 Futures
View by Broker
When using the broker view, you'll first need to select an Executing Broker from the drop down, noting that you can select either an individual legal entity, or the group-level Institution.
Refine Results
After selecting your product or broker, you'll be able to refine your results using filters to drill down your data set, along with specifying currency and quantity to adjust your results as desired.
| Filter Name | Description |
| Exec Type | The default is Y-Electronic, user can select from a list of different execution types used in Give Up Agreements (GUA) |
| Trade Type | The default is Regular Trade; users can select from a list of different Trade Types supported in Give up Agreements (GUA) |
| Spread Type | The default is ‘All’, users can select from a list of different Spread Types supported in Give up Agreements (GUA), or expressly selecting "None" to exclude Spread rates. |
| Membership | The exchange membership that determines the applicable exchange fee. A default membership is applied automatically, noting that the nomenclature may differ by exchange. Users may select another option from the dropdown as appropriate. |
| Cost Type | The Cost Element type being displayed and aggregated in the grid. Currently users may select to show only Brokerage (from GUA) or ‘All’ to incorporate Exchange Fee data (available as part of a free trial until end of year). |
| Document State | Agreement State for displayed data. The default is Executed, however users may opt to include draft Give up Agreements as well, in Composition, Execution, and Stale states. |
| Client Entity | Customer or Trader legal entities to be included in the underlying dataset. |
| EB | Allows you to filter to specific executing broker(s) |
| CB | Allows you to filter to specific clearing broker(s) |
| View In | Allows you to change the display currency of your results |
| Qty | For use in modeling total trade costs. By default this is set as 1, however may be updated to view costs for a given trade size. |
Review Results
Once all selections have been completed, results will be updated in the main grid of your selected view.
Cells include conditional formatting to rapidly identify your lowest cost (in light green) and second lowest cost (in dark green). Any broker pairings that do not have a rate for the specific product will display ‘— ‘ in their cell. In cases where a single unique cost is not available (ex. due to multiple different rates appearing on underlying GUAs) the cell will display "Multiple".
After selecting a cell, a detail grid will display at bottom of the page, showing the applicable cost elements for the selected counterparty pairing. If multiple values are available for a given cost type, you will see all associated cost elements, and may use the radio buttons in the Detail view to apply the appropriate value to display in the top grid. Additionally, the Details grid will display a hyperlinked Source ID associated with a given Cost Element, including the GUA ID, or Databank Product Reference.
Details Grid
"Multiple" in Details Grid
Next Steps
After review, you may remediate any issues you have identified by clicking on the GUA link and updating GUA(s) accordingly. The GUA agreement link will take you directly to the agreement page in Docs in a new tab. You can then update the rate schedule on the agreement through the standard Docs rate schedule workflow or through FCR. Please note: the necessary Docs/FCR user permissions are required to make changes to Docs agreements. For more info on rate schedule creation in Docs please go here: Rate Schedule Creation in Docs
Comments
0 comments
Please sign in to leave a comment.