Quality of Execution of Transactions

The COMMISSION DELEGATED REGULATION (EU) 2017/ 575 defines a requirement for trading venues to provide reports on the quality of execution of transactions. Reports are published on a quarterly basis, with a three months delay to the end of the quarter that is reported. This means that Q1 reports are published on the 30th of June, Q2 reports on the 30th of September, and so on.

The reports are made available on this URL: https://qoeot.ngm.se/

The COMMISSION DELEGATED REGULATION (EU) 2017/ 575 specifies different information to be published according to tables specified.

All tables, except for table 5 are reported on a per trading day basis, where all tables and all instruments are provided in the same file, one file per trading day. Table 5 is reported on a per quarter basis.

Format of the reports

All tables except table 5

NGM provide the reports in the CSV format.

The order of the columns are: trading_date,market_id,instrument_id,table_id, <table data>, ...

Column Format
trading_date YYYY-MM-DD
market_id MIC
instrument_id Elasticia instrument identifier
table_id TABLE1, TABLE2, etc. as per table referenced in the delegated regulation.
<table data> Depends on the table in question. Formatted in accordance with the templates set out in the Annex of the delegated regulation with descriptive column and row headers.

 

Table 5

NGM provide the reports in the CSV format.

The order of the columns are: period,market,table_id,<table data>, ...

Column Format
period YYYY-QQ (example: 2018-Q1)
market Always NGM (all instruments on the NGM exchange are included, for market data costs Spotlight Stock Exchange is also included, since it cannot be separated).
table_id Always TABLE5 (refers to the table in the deletaged regulation)
<table_data> Formatted in accordance with the templates set out in the Annex of the delegated regulation with descriptive column and row headers.

 

0+