What are the most common operational issues experienced by clients?

Trades are gathered from a variety of systems and repositories: portfolio management systems, order management systems, fund accounting systems, etc...We identified two major categories of issues:

 1) Incorrect Data:

Inclusion of cancelled trades or option exercises, which do not impact slippage calculations and should be excluded.

Timestamp errors, such as using local time instead of a fixed timezone like UTC.

Some participants have corporate actions (stock-splits, dividend payments,...) nested amongst the bulk of the transactions,  

2) Incomplete Data:

Unclear currency denominations, such as confusion between pounds and pence.

Missing MIC codes, which are essential to identify the trading market for trades identified by the ISIN number of the underlying asset.