Our website uses cookies. Find out more

Rotate your phone

Once that’s done you’ll be able to
experience the AQMetrics website perfectly.

Steve Barnes, CTO, Q&A: MiFID II Transaction Reporting – how to extract and reconcile data in the ARM?


With many recent queries about ARMs and firms having to access their data, we thought we’d sit down with our CTO, Steve Barnes, to get his thoughts on how you can extract, reconcile and get the most of your MiFID II transaction reporting data using the AQMetrics ARM. 

Q 1. Why is it so important to have access to historic data?

Firms are increasingly focused on reconciliation. This in turn is identifying inaccuracies in past reporting and causing a need for back reporting. However, many ARMs only provide access to 6 months of historic data. This is going to present challenges when both reconciling and back reporting.

Q 2. What are some of these challenges then?

The vast majority of ARMs are still limiting client firms access to their own data. Often, the only way to truly access the data in the ARM for the purposes of reconciliation, is to access data via a 3rd party reporting aggregator or consolidator. That just shouldn’t be the case.

Others may only allow access to the most recent 6-9 months of data. With MiFID II transaction reporting requirements in place since 3 January 2018, firms need access to the full historic data set. Often firms are levied with additional fees to access archived data.

This is problematic in our view, and one of the main reasons AQMetrics is the only ARM to give firms full access to their own data – in fact we encourage it. It’s their data after all. 

Q 3. What are your recommendations for reconciliation and back reporting then?

For reconciliation you need to think about data in 3 locations:

1. Sources systems (e.g OMS)
2. The ARM
3. NCA portal

If a firm can reconcile source system trades against the ARM and check the ARM transaction reports against the NCA portal, it achieves an end-to-end three-way reconciliation.  

In addition, it’s recommended that you select a representative sample of transaction reports and check each data point. 

You are looking for mismatches in buyer or seller LEIs, changes in price, inaccuracies in trading date or time, and other transaction report data. At AQMetrics, we allow firms to upload CSV files from their front office systems and produce a reconciliation report for the first leg of the reconciliation. We also allow firms to upload the XML sample from the NCA portal for the second leg of the reconciliation.

Q 4. There is a source of rich transaction data in the ARM, often coming from multiple front and middle office data sources. How can firms maximise the benefit of this?

At AQMetrics, we recognise that this vast trove of data holds real value to firms – especially when they use business intelligence (BI) tools to unlock key operational and reporting insights. The ARM is often a centralised source of transaction data, fed by multiple source systems in the MiFID firm. This is where APIs come in. If the ARM provides an API, and flexible data extracts, firms should seek to integrate this rich data source with their own business intelligence tools.

With open access to transaction reporting data, firms can intelligently monitor for patterns in their trade data, performing time series analysis, shining a light on data quality and execution patterns month-on-month, year-on-year. 

Our customers are also using this data-driven feedback to handle NCA queries, to perform inhouse data quality continuous improvement, and to implement alerting and monitoring systems. And this is across all levels: there’s better monitoring in the middle office, but there’s also more efficient compliance and reporting in the back office. Overall, too, this should give better audit abilities and control over data going forward. 

So we are definitely of the view that ARMs should be encouraging firms to access their own data, rather than limiting this. We don’t want to offer siloed solutions for single problems. When we designed the MiFID II solution on the AQMetrics platform, we designed it with an eye on the horizon, solving for future regulatory needs and future business needs. 

Q 5. How do you give firms access to their data then? And how can they plug it in to their BI tools?

Access is very simple. It’ll usually be given through flexible queries and daily exports, although there is obviously flexibility if firms want the data at different intervals. In terms of integrating with other tools, we offer a RESTful API so that firms can connect their own business intelligence tools, such as Microsoft Power BI or Tableau. We are currently working with a number of multi-jurisdictional MiFID firms to integrate transaction report data across product types and jurisdictions with inhouse business intelligence tools.   


Other posts you might like

Five key things you need to know about 18F-4

Last year the SEC announced sweeping requirements for funds engaging in derivatives trading. Here, we present the… Read more

AQMetrics Regulatory Round-up: May 2021

Welcome to AQMetrics regulatory round-up, a monthly initiative that keeps readers abreast of all the latest regulatory… Read more