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). |
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. |