ISO20022 Securities Trade Confirmation (sese.001)

This dataset provides comprehensive, standardized records of securities trade confirmations between counterparties, including executed transaction details, pricing, quantities, settlement terms, and status. It enables robust trade reconciliation, regulatory compliance, and operational analytics for financial institutions and market participants.

  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Trade reconciliation and audit for financial institutions

Sample rows

preview · 8 of 400 rows · all 24 columns
confirmation_idstringsecurity_typestringtrade_quantityfloatsettlement_locationstringtrade_datedatesettlement_datedatecounterparty_1_idstringcounterparty_1_namestringcounterparty_2_idstringcounterparty_2_namestringsecurity_idstringsecurity_namestringtrade_pricefloattrade_currencystringtrade_amountfloatsettlement_methodstringtrade_typestringtrade_statusstringbroker_idstringbroker_namestringtrade_referencestringnotesstringcreation_datetimedatetimelast_modified_datetimedatetime
CFM20240000001equity0.5002DTCC New York2024-03-042024-03-04CPTY1001Crestview Capital LLCCPTY2011Summit Securities Inc.US1234567890Apple Inc. Common Stock172.35USD86.20797FOPbuyconfirmedblankblankTXN-APL-00401Fractional share purchase2024-03-04T09:31:11Z2024-03-04T09:32:53Z
CFM20240000002equity100000CREST London2024-02-292024-03-01CPTY1002BlueWave InvestmentsCPTY2009Anchor Asset GroupGB0987654321BP PLC Ordinary Shares5.47GBP547000DVPsellconfirmedBRK001Morgan StanleyTXN-BP-00402Block trade executed on leap day2024-02-29T14:03:18Z2024-03-01T10:19:42Z
CFM20240000003equity300DTCC New York2024-01-122024-01-15CPTY1023Global Alpha FundCPTY2021Eclipse CapitalUS2345678901Tesla Inc. Common Stock212.98USD63894DVPbuyconfirmedBRK002J.P. MorganTXN-TSLA-00403Portfolio rebalance2024-01-12T11:42:00Z2024-01-15T08:13:31Z
CFM20240000004equity0.0007JASDEC Tokyo2024-04-092024-04-09CPTY1017Horizon HoldingsCPTY2002Silvergate AdvisorsJP3456789012Toyota Motor Corp.1871.42JPY1.31FOPbuypendingblankblankTXN-TYO-00404Micro-trade, awaiting regulatory review2024-04-09T13:25:15Z2024-04-09T13:25:35Z
CFM20240000005equity500000DTCC New York2024-05-062024-05-14CPTY1019Summit Ridge PartnersCPTY2017Northbridge Asset MgmtUS3456789012Microsoft Corp. Common Stock385.67USD192835000DVPsellconfirmedBRK003Goldman SachsTXN-MSFT-00405Large institutional block sale2024-05-06T10:09:58Z2024-05-14T15:17:22Z
CFM20240000006equity3500Euroclear Paris2024-02-052024-02-07CPTY1021Riverside InvestmentsCPTY2015Steadfast TrustFR8765432109TotalEnergies SE59.88EUR209580DVPbuyconfirmedblankblankTXN-TTE-00406blank2024-02-05T14:34:01Z2024-02-07T16:21:09Z
CFM20240000007bond40000000Fedwire DC2024-01-222024-01-31CPTY1007Northstar Fund Ltd.CPTY2007Orion Wealth ManagementUS5678901234U.S. Treasury Bond 20430.98USD39200000DVPsellpendingblankblankTXN-TB43-00407Large bond trade, delayed settlement for compliance2024-01-22T10:15:34Z2024-01-31T11:21:03Z
CFM20240000008equity5B3 Sao Paulo2024-04-152024-04-15CPTY1012Liberty Capital LLCCPTY2023Aspire FinancialBR4567890123Vale SA ADR12.56BRL62.8FOPbuyconfirmedblankblankTXN-VALE-00408Small retail purchase2024-04-15T11:12:44Z2024-04-15T11:13:01Z

What the 400 rows show

from the 400-row sample

Bond (security type) stands out: mean trade_quantity is 6,588,706, against 48,149 for the rest.

  • 1,900median trade_quantity
  • 3settlement methods
  • 3trade types
  • 3trade statuses
  • 9trade currencies
  • 106.6median trade_price
Mean trade_quantity by security_type400 rows
04M8M54,438equity305 rows6.6Mbond34 rows1,250derivati…15 rows21,741other46 rows
trade_quantity400 rows, in bands of 5M
0195390389511010111025M50Mtrade_quantity →

Median 1,900, from 0.00 to 50,000,000.

settlement_location400 rows · top 10 of 17 values
  1. DTCC New York283
  2. CDS Toronto18
  3. CME Chicago15
  4. JASDEC Tokyo12
  5. CREST London11
  6. Fedwire Washington11
  7. Euroclear Frankfurt9
  8. Euroclear Paris8
  9. B3 Sao Paulo8
  10. ASX Sydney8
24 columns by typefrom the column list below
  • string 17
  • float 3
  • date 2
  • datetime 2

Columns

24 columns in three groups
blueprint · 24 columns
columntypedescriptionexample
Text 17 columns
confirmation_idstringUnique identifier for the trade confirmation documentuniqueCFM20240000001
counterparty_1_idstringUnique identifier for the first counterparty involved in the tradeCPTY1001
counterparty_1_namestringLegal name of the first counterpartyCrestview Capital LLC
counterparty_2_idstringUnique identifier for the second counterparty involved in the tradeCPTY2011
counterparty_2_namestringLegal name of the second counterpartySummit Securities Inc.
security_idstringUnique identifier for the security traded (e.g., ISIN)US1234567890
security_namestringName or description of the security tradedApple Inc. Common Stock
security_typestringType of security (e.g., equity, bond, derivative)equity · bond · derivative · otherequity
trade_currencystringCurrency code in which the trade was executed (ISO 4217)9 currenciesUSD
settlement_locationstringLocation or system where the securities will be settledDTCC New York
settlement_methodstringMethod of settlement (e.g., DVP, FOP)DVP · FOP · otherFOP
trade_typestringType of trade (e.g., buy, sell, transfer)buy · sell · transfer · otherbuy
trade_statusstringStatus of the trade confirmation (e.g., confirmed, pending, cancelled)confirmed · pending · cancelledconfirmed
broker_idstringUnique identifier for the broker facilitating the trade (if applicable)optionalBRK001
broker_namestringName of the broker facilitating the trade (if applicable)optionalMorgan Stanley
trade_referencestringExternal reference or transaction identifier from trading systemoptionalTXN-APL-00401
notesstringAdditional notes or comments regarding the trade confirmationoptionalPortfolio rebalance
Numbers 3 columns
trade_quantityfloatQuantity of securities traded0 or more0.5002
trade_pricefloatPrice per unit of the security at which the trade was executed0 or more172.35
trade_amountfloatTotal monetary value of the trade (trade_quantity x trade_price)0 or more86.20797
Dates and times 4 columns
trade_datedateDate on which the securities trade was executed2024-03-04
settlement_datedateDate on which the securities are scheduled to settle2024-03-04
creation_datetimedatetimeTimestamp when the confirmation record was created2024-03-04T09:31:11Z
last_modified_datetimedatetimeTimestamp when the confirmation record was last modified2024-03-04T09:32:53Z

Use it for

  • median trade q…1,900400 rowsmean trade quantity b…54.4kequi…6.6Mbond1.3kderi…21.7kother

    A finance dashboard

    Trade_quantity by security_type and a breakdown of settlement_location. Excel, Power BI or Tableau.

  • Why do the 34 bond rows have a mean trade_quantity of 6,588,706?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable confirmations with trade_date, settlement_date and counterparty_1_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 24 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset400 rows24 columns
Yours1,000 rows24 columnssettlement_location: UK only

blueprint · iso20022-securities-trade-confirmation-sese001

Behind this dataset

Same schema. As many rows as you need.

These 400 rows came out of a blueprint — 24 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Trade date and time specified
  • Buy or sell indicator
  • Security identification ISIN
  • Quantity traded
  • Price per unit
  • Total consideration calculated
  • Settlement instructions included
  • Counterparty details confirmed
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
iso20022-securities-trade-confirmation-sese001

More in Finance

Browse all
Also in FinanceSWIFT MT540 Securities Trade ConfirmationCredit Card Fraud DetectionBank Transaction Categorization SampleAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.