European Equities Market Volume Summary User Guide
The European Equities Market Volume Summary pivot table allows users to arrange European venue market share data across all markets that are covered by Cboe Europe. The table is adjustable using these three key areas:
- Date selection: provides day, 5-day, month-to-date and calendar selection options.
- The data category tabs across the top of the page to filter by the type of data to show.
- The configuration bar allows date selection and provides additional display options and layout configurations.
By default the data shown is for a single date, with values representing either the selected date or the average across a past date range ending at the selected date. If the selected date is the current date then the table will automatically refresh itself every 60 seconds. You can see the timestamp of the most recent data in the top-right corner. Use the calendar icon on the left side of the configuration bar to select a date to display. For each date you can view these date ranges:
- Day: shows only the selected date’s data.
- 5-day average: shows the averages across the 5 trading dates that precede the selected date (but not including the selected date).
- Month-to-date: shows the average across the trading dates in the selected date’s month, up to and including the selected date.
A trading date is defined as a day during which any of the markets that Cboe Europe covers was open for trading.
Type of Data
Each data selection option (On-book, Off-book, etc.) represents a grouping of market data that is organised within industry-standard definitions. Each data group may have its own sub-groupings (categories, venues …), or the data could be shared across multiple sub-groupings.
All configuration changes made by the user are stored in the url. To share a link to what you’re seeing, simply copy and paste the url from the address bar.
Category, Market and Venue allow users to select which of these items are displayed in the table. Only selected items will affect the totals, with the exception of Market, which allows you to toggle whether all markets should count towards the total with the ‘Include all markets in total’ checkbox.
Metrics configures the type of market data being displayed in the table, and how it is formatted. Values can be shown as regular numbers or as percentages of either the column’s total or the table’s total.
Table provides options for the display of the table. For each data selection option (Category, Venue, Market) users can choose:
- How to display it: as a row, a column, or not at all (aggregating the values), by dragging each card to a section.
- How to sort it : by name, by value or using the default sort order
- Expand or collapse it: to collapse or expand all rows underneath each row of a data selection option. This is only used as a default; any user selection will override the default when the user clicks on a particular row to expand or collapse it. This user override will stay in place until the table layout changes. The default expand/collapse setting are updated in the url, but individual row overrides are not.
The table displays market statistics according to the configuration specified by the data category and the options selected in the configuration bar. In addition to the user-defined configuration there are three additional columns present in the table:
- Market share percentage for an alternate date range, for comparison purposes. This is either the per-day total or the 5-day average depending on which date range is selected.
- The market share percentage for the selected date range. This percentage is calculated from the total value as displayed in the total column, divided by the row’s total.
- The total row value as a number. This is the sum of all column values.
Note that the total may not match up with the sum of all column values if the ‘Include all markets in total’ checkbox is selected.
Some rows have a down arrow: this allows for expansion of the row to drill down into that row’s sub-data.
Amounts may be represented as percentages or rounded up to the nearest thousand (k) or million (M). Hovering over each value will show you the full number. You can change this from the Metrics menu in the configuration bar.
The "Reports" menu allows you to download CSV files containing the source data for the table that is displayed on-screen. Note that the source data is unfiltered, so it will not change based on the selections made in the menus (Category, Venue, etc.). This data is provided in a 'flat' format (it always has the same columns) to make it easier to import into Microsoft Excel as a pivot table.
Note that each report link is based on the selected date, so the Month-To-Date report contents will vary depending on which date of the month is selected.