The leading knowledge platform for the financial technology industry
The leading knowledge platform for the financial technology industry

A-Team Insight Blogs

Czech Securities Trader RSJ Uses Kx’s kdb+ to Handle 255 Million Records a Day

Prague-based securities trader RSJ evaluated a number of open source databases and SAP’s Sybase IQ solution before selecting Kx Systems’ kdb+ database platform to support its algorithmic trading. Kdb+ replaces in-house developed proprietary solutions at RSJ, which is the largest trader of financial derivatives in the Czech Republic, the biggest trader on NYSE Liffe and a trader on other derivatives exchanges including the CME in Chicago and Eurex in Frankfurt.

RSJ selected kdb+ as it best matched requirements for speed and ability to process complex requests and large datasets. The company worked with DEVnet, a strategic sales and consultancy partner to Kx Systems that is based in Munich and operates in local languages across Europe and Asia, to implement the first phase of a kdb+ based project.

Martin Duchá?ek, head of algorithmic system development at RSJ, explains: “DEVnet helped us a lot at the beginning of the first phase of the project. We had a three-day workshop here in Prague where we went through all the concepts and prepared a first version of the kdb+ database. We are now planning another workshop in which we would like to consult on the performance of the current solution and consider the next steps with kdb+.”

The database platform has been in production since early 2013 and is delivering substantial improvements in speed of data access and transformation.

Duchá?ek says: “As well as significant reductions in processing times – previously a query on a day’s data would take a couple of hours, which is far too slow – with kdb+ we can write a query in a couple of minutes and see the results in seconds. This allows us to react to market situations almost immediately. kdb+ also provides us with quick support for brainstorming and allows us to do things we were previously unable to do.”

RSJ has integrated kdb+ with its own proprietary .NET algorithmic trading application and uses its own transformed data to drive trading. The company declines to specify the frequency of intra-day simulations and how long they take, but in the context of speed and performance notes that, depending on overall trading activity in markets, it handles an average 255 million trade records a day.

Looking forward to further phases of the project, Duchá?ek says: “We are still in the process of exploring the capabilities of kdb+ and expect to be able to do much more with it as the project progresses and anticipate even better performance as we optimise more processes.”

For Kx Systems, RSJ is its first customer in the Czech Republic. Simon Garland, chief strategist at Kx Systems, says: “RSJ is the ideal client for making good use of Kx’s combination of powerful language and high-performance database. It collects huge quantities of tick data and needs to access and query it very quickly in order to create and test models, test strategies, identify unusual market situations and react to them.”

Considering the company’s target markets, he notes ongoing work with large customers as they build out to support additional asset classes and new wins with customers such as RSJ that are using kdb+ to develop low-latency infrastructures to support their proprietary trading expertise.

Related content

WEBINAR

Recorded Webinar: Building the data foundations for your digital transformation journey

Digital transformation is a requirement to succeed in today’s information economy. As business leaders begin to acknowledge this necessity, they seek to navigate a successful path to digitisation, but they must start with a foundation of data understanding, maturity and trust – a crucial prerequisite for the digital transformation adventure. This webinar will consider the...

BLOG

TickSmith Partners with BMLL to Help Firms Monetise Their Data, and Integrates with Snowflake’s Data Cloud

Montreal-based TickSmith has announced a collaboration with BMLL, the data and analytics company, that will enable data producers, including exchanges, trading venues and data vendors, to generate new revenue streams by creating and distributing analytics derived from their data. TickSmith’s Enterprise Data Web Store allows data-rich firms to create their own customisable data web store,...

EVENT

Data Management Summit Virtual

The Data Management Summit Virtual brings together the global data management community to share lessons learned, best practice guidance and latest innovations to emerge from the recent crisis. Hear from leading data practitioners and innovators from the UK, US and Europe who will share insights into how they are pushing the boundaries with data to deliver value with flexible but resilient data driven strategies.

GUIDE

The Trading Regulations Handbook

Need to know all the essentials about the regulations impacting trading infrastructure? Welcome to the first edition of our A-Team Trading Regulations Handbook which provides all the essentials about regulations impacting trading operations, data and technology. A-Team’s Trading Regulations Handbook is a great way to see at-a-glance: All the regulations that are impacting trading technology...