FRTB compliance is about more than just managing your data, tracking its journey is essential; EUCplus is here to help

Sep 24, 2019 | Articles, EUCplus, Featured, Practice - Data, Products

Complying with financial regulations is not an easy task, but it is one that is made much easier if you take control of your business-critical information.

In most cases, the quality and supporting infrastructure of an institution’s data is fundamental to achieving compliance and the Fundamental Review of the Trading Book (FRTB) is no different.

Take control of your business-critical data

FRTB, part of the Basel III rules aimed at significantly transforming the way banks manage their capital requirements and how they are structured and managed internally, necessitates a number of specific data challenges in terms of understanding the data, the volumes of data required, the quality of that data and most importantly, tracking the flow of the data. One example relating to understanding the data is the distinction of the boundary between banking and trading books. Transactional data needs to be strictly classified into one of these two categories, with robust governance to ensure compliance with the rule set making that distinction.  

One of the key requirements for FRTB is PLA (profit and loss attribution). For this, the organisation’s HPL (hypothetical profit and loss) and RTPL (risk theoretical profit and loss) ideally leverage the same underlying data, so that all business decisions and reporting are made on the same information. If the organisation fails the quarterly PLA tests through unexplained P&L, then the use of internal models is revoked, and the standard approach applied. This has capital consequences for the organisation and requires a 12-month wait until the institution can reapply to use its own models again.

Watch out for data held in spreadsheets

Another concern is the real-time reporting requirement for intraday risk and the comparison between risk management and pricing models. In addition, the management of reference data in terms of client, book, instrument and market remains a challenge with respect to maintenance, especially as the volumes of data increase. As with BCBS 239 and other banking regulations, reliable golden sources of data that can be independently validated are crucial to achieving compliance.

Spreadsheets are often used to collect front office prices/marks – and this is where problems may arise. Data is typically passed to internal pricing services where risk factors are generated. These marks are then passed to the enterprise data repository where additional validation is applied and the EOC, or golden copy, is compiled and published to downstream applications for their close of business processing and reporting. Under the FRTB regulations, organisations will need to demonstrate lineage between the trader marks, the risk factors generated, and real price observations seen in the marketplace, so the accuracy of trader marks (which may originate in spreadsheets) and an ability to demonstrate alignment, is essential.

So how best to achieve this?

At the root of this ultimately very sensitive data, are the spreadsheets that the front office uses to collate and publish their view of the products they trade. Of course, there are checks and balances both in the pricing service and the enterprise data repository, but the marks also need to prove they are representative of the prices in the market (which could be very illiquid). The fundamental accuracy of the marks and the maintenance of the lineage of those marks is therefore of paramount importance.

Whilst front office spreadsheets may initially have a centralised design, it naturally gets modified over time. While it is impractical to completely lock down the sheets as new products, term structures, correlations and spreads will be added, it is essential that any changes are also captured by HPL and RTPL, otherwise the lineage between the decision making and the reporting is lost.
Ensuring this business-critical information is up-to-date and sufficiently accurate to face scrutiny from the regulators is no mean feat, especially when the original source is quite likely to be a simple spreadsheet. EUCplus, our new application that scans and secures all essential spreadsheets, addresses this concern.
Efficient and simple-to-use, EUCplus gives visibility and control over all spreadsheets and provides a reliable and accurate audit of all version changes. This allows irregular data to be removed or corrected and prevents opportunities for tampering, mistakes or cross-contamination. In business terms, it leaves you with increased visibility and control over your own information and an accurate and impenetrable log for compliance purposes.
For more information about how EUCplus can help address the challenges associated with accurate data recording and regulatory compliance, email i[email protected] or call 0203 693 2605 to arrange a meeting. 

We are an award-winning transformational consultancy with the drive, skills, knowledge and experience to help you change your business for the better. Let us show you what we can do.