Skip to content
Criée

Developers and data in capital markets

Gateways, engines, reconciliations and logs: where a bug costs real money, and what is expected of those who code.

Lesson 88 min

By the end of this lesson

  • Name the technical jobs in capital markets and their tasks
  • Explain why an order log is corrected by appending only
  • Calculate how fast a code error spreads from published figures
In this lesson4

A stock market order today is first of all a series of messages and log lines. Behind every step in the previous lessons there is software that someone wrote, tested and monitors: entry screen, gateway to the exchange, matching engine, reconciliations, dashboards. The skill in this lesson: naming the technical jobs of capital markets and what a bug costs there.

Four families of technical jobs

Who codes what

1/4Business application developer

The software of brokerage firms and management companies: order entry, client accounts, post-trade, regulatory reports.

These jobs are not separate: they translate the rules of the previous lessons. The duty to record each order in time order, on receipt, transmission and execution, and to keep unalterable records for at least ten years (COSUMAF General Regulation 2023, art. 291) is first a database design problem: you add lines, you never delete them.

Audit trail

The timestamped, append-only record of every event in an order's life, linked to the original order; a correction is a new line.

An order seen through code

The same order as in lesson 2, seen by those who write the programs. The price and quantities are calculated by the portal's engine.

An order seen through code1/5
Front officeAdviser
GatewayDeveloper
EngineMatching engineer
Back officePost-trade
DataData analyst

An entry screen

The adviser enters Awa’s order in the broker’s software. Someone programmed every field and every check on that screen.

The message in step 2 follows the FIX standard: a new order (NewOrderSingle) must carry an identifier, a side, a transaction time and an order type, and a price if it is a limit order (FIX Trading Community, NewOrderSingle). The developer track covers its life cycle in detail.

Reconciliation

Comparing two records of the same transaction (for example the exchange's notice and the client's account) to catch any gap.

From memory: why must an order log be append-only?

What a bug costs: a real case

On 1 August 2012, the American broker-dealer Knight Capital deployed new code incompletely on its servers; a defective function, left in place since 2005, came back to life. In 45 minutes its router sent more than 4 million orders to execute 212 client orders, and the firm lost more than 460 million dollars; 97 automated emails had flagged the error before the open (SEC, press release 2013-222).

The speed of an errorFictional

Using the figures published by the SEC:

  1. Orders per minute. 4,000,000 ÷ 45 ≈ 88,900 orders per minute.
  2. Per second. 88,900 ÷ 60 ≈ 1,480 orders per second.
  3. Loss per minute. 460,000,000 ÷ 45 ≈ 10.2 million dollars per minute.
  4. Compared with useful orders. 4,000,000 ÷ 212 ≈ 18,900 orders sent for each client order to be filled.

A human error is corrected at human speed; a coding error multiplies at machine speed. Hence pre-trade automatic controls and tested deployment procedures, covered in the Platform section.

A leaking rounding, fictional caseFictional

The software of a fictional brokerage firm truncates each commission to the franc below instead of rounding it. The average gap is 0.5 FCFA per transaction.

  1. Per day. 2,000 transactions × 0.5 = 1,000 FCFA.
  2. Per year. Over 250 trading days, an assumption of the example: 1,000 × 250 = 250,000 FCFA.

Nobody sees 0.5 FCFA on screen. Automatic reconciliation, however, sees the gap between what the commission engine calculates and what the client should have paid.

What is expected of those who code

Knowing how to program is not enough: you must understand the market rule you are translating, test it with edge cases and accept that no data ever disappears. Finance certifications are moving closer to this: the CFA programme offers practical modules in Python, data science and financial modelling (CFA Institute, "Overview of the CFA Program"), and the ISSEA, a CEMAC institution, offers a professional master's in data science and statistical modelling (ISSEA).

Without looking back: with 600,000 orders in 20 minutes, how many orders per second?

Your turn

In a compliant order log, a correction shows up as...

1In a compliant order log, a correction shows up as...

A FIX NewOrderSingle message for a limit order must contain a price. This is...

2A FIX NewOrderSingle message for a limit order must contain a price. This is...

Knight Capital sent more than 4 million orders in 45 minutes. About how many per minute?

3Knight Capital sent more than 4 million orders in 45 minutes. About how many per minute?

Which job uses execution logs to build dashboards?

4Which job uses execution logs to build dashboards?

For how long, at least, does a brokerage firm keep records linked to transactions?

5For how long, at least, does a brokerage firm keep records linked to transactions?

Read next: SEC, communiqué 2013-222 (Knight Capital)

A question? Ask your teacher, or an AI assistant, giving it the title of this lesson.

Share:WhatsAppLinkedIn

Going further