SWIFT MT540 Securities Trade Confirmation
This dataset provides comprehensive records of securities trade confirmations exchanged between brokers and clients, including detailed transaction data, settlement instructions, and status updates. It enables robust tracking, reconciliation, and audit of securities purchases and sales, supporting financial institutions in meeting regulatory and operational requirements.
Sample rows
preview · 8 of 400 rows · all 20 columns| confirmation_idstring | transaction_typestring | quantityfloat | currencystring | trade_datedate | settlement_datedate | security_idstring | security_namestring | pricefloat | total_amountfloat | broker_idstring | broker_namestring | client_idstring | client_namestring | client_account_numberstring | settlement_instructionsstring | trade_referencestring | statusstring | created_atdatetime | updated_atdatetime |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TRD-USD-20240601-01 | purchase | 4250.25 | USD | 2024-06-01 | 2024-06-03 | US5949181045 | Microsoft Corp Common Stock | 412.3 | 1750966.575 | BRK-001 | Morgan Stanley LLC | CL-101 | Pioneer Pension Fund | PTA-985421 | DVP via FedWire, delivery to Cede & Co | MSFT20240601BUY | confirmed | 2024-05-31T18:22:11 | 2024-06-04T09:17:00 |
| TRD-EUR-20240602-02 | sale | 0.87 | EUR | 2024-06-02 | 2024-06-04 | FR0003500008 | Danone SA Ord Shs | 52.15 | 45.3705 | BRK-022 | Societe Generale | CL-207 | Groupe MicroTrade | ACC-221020 | blank | blank | pending | 2024-06-02T08:03:45 | blank |
| TRD-JPY-20240602-03 | purchase | 104580 | JPY | 2024-06-02 | 2024-06-06 | JP3762600009 | Nomura Holdings Inc | 141.8 | 14830332 | BRK-201 | Nomura Securities | CL-302 | Tokyo Institutional Funds | JPX-77612032 | Delivery via JPX, DVP | NMR20240602BUY | confirmed | 2024-06-01T14:10:22 | 2024-06-07T10:25:00 |
| TRD-GBP-20240603-04 | sale | 0.0012 | GBP | 2024-06-03 | 2024-06-03 | GB0002634946 | Rolls Royce Holdings PLC | 269.55 | 0.32346 | BRK-027 | Barclays Capital | CL-214 | Edge MicroInvestors | ACC-368002 | blank | blank | pending | 2024-06-03T09:11:17 | blank |
| TRD-USD-20240603-05 | purchase | 3000 | USD | 2024-06-03 | 2024-06-05 | US0378331005 | Apple Inc Common Stock | 198.65 | 595950 | BRK-002 | JP Morgan Securities | CL-102 | Longview Asset Management | PTA-781287 | DVP via DTC, Cede & Co | AAPL20240603BUY | confirmed | 2024-06-02T17:30:00 | 2024-06-06T10:00:00 |
| TRD-CHF-20240601-06 | sale | 0.09 | CHF | 2024-06-01 | 2024-06-02 | CH0038863350 | Credit Suisse Group AG | 78.8 | 7.092 | BRK-032 | Credit Suisse Securities | CL-220 | Swiss MicroFund | ACC-8821233 | blank | blank | pending | 2024-06-01T08:15:00 | blank |
| TRD-JPY-20240604-07 | purchase | 250000 | JPY | 2024-06-04 | 2024-06-07 | JP3902900004 | Mitsubishi UFJ Financial Group | 82.55 | 20637500 | BRK-202 | Mizuho Securities | CL-303 | Asia Pacific Institutional | JPX-12345112 | JPX, DVP, Delivery vs Payment | MUFG250K20240604 | pending | 2024-06-03T18:24:19 | blank |
| TRD-USD-20240604-08 | purchase | 1550 | USD | 2024-06-04 | 2024-06-06 | US0231351067 | Amazon.com Inc Common Stock | 181.2 | 280860 | BRK-003 | Goldman Sachs & Co | CL-103 | Brightstone Advisors | PTA-913820 | DVP, DTC, Delivery to Cede & Co | AMZN155020240604 | confirmed | 2024-06-03T16:52:03 | 2024-06-07T09:12:00 |
| TRD-KRW-20240605-09 | purchase | 98000 | KRW | 2024-06-05 | 2024-06-08 | KR7005930003 | Samsung Electronics Co Ltd | 67.4 | 6605200 | BRK-250 | Mirae Asset Securities | CL-350 | Korea Sovereign Fund | KSD-4532984 | KSD, DVP | SMSN20240605BUY | confirmed | 2024-06-04T19:13:33 | 2024-06-09T14:08:21 |
| TRD-USD-20240605-10 | sale | 400 | USD | 2024-06-05 | 2024-06-07 | US92826C8394 | Visa Inc Class A | 275.5 | 110200 | BRK-004 | Bank of America Securities | CL-104 | Valor Holdings | PTA-927111 | DVP, FedWire, Delivery to Cede & Co | VISA20240605SELL | confirmed | 2024-06-04T21:10:11 | 2024-06-08T08:00:01 |
| TRD-EUR-20240606-11 | sale | 0.244 | EUR | 2024-06-06 | 2024-06-08 | DE0007100000 | Daimler AG Ord Shs | 60.1 | 14.6644 | BRK-021 | Deutsche Bank AG | CL-208 | EuroEdge MicroTrades | ACC-181920 | blank | blank | pending | 2024-06-06T08:15:00 | blank |
| TRD-INR-20240607-12 | purchase | 152000 | INR | 2024-06-07 | 2024-06-10 | INE002A01018 | State Bank of India | 75.4 | 11460800 | BRK-300 | ICICI Securities | CL-400 | India MegaFund | NSDL-781222 | NSDL, DVP, Delivery | SBIN20240607PUR | pending | 2024-06-06T22:19:59 | blank |
| TRD-USD-20240608-13 | purchase | 2100 | USD | 2024-06-08 | 2024-06-10 | US02079K3059 | Alphabet Inc Class A | 173.25 | 363825 | BRK-005 | Interactive Brokers LLC | CL-105 | BlueWater Mutual | PTA-882001 | DVP, DTC, Delivery to Cede & Co | GOOGL20240608BUY | confirmed | 2024-06-07T17:30:00 | 2024-06-11T11:05:00 |
| TRD-USD-20240609-14 | sale | 2400 | USD | 2024-06-09 | 2024-06-11 | US4581401001 | Intel Corp Common Stock | 42.25 | 101400 | BRK-006 | Citigroup Global Markets | CL-106 | Emerald Capital | PTA-112234 | DVP via DTC | INTC20240609SELL | pending | 2024-06-09T09:25:20 | blank |
| TRD-HKD-20240610-15 | purchase | 50000 | HKD | 2024-06-10 | 2024-06-13 | HK0000059686 | HSBC Holdings PLC | 50.85 | 2542500 | BRK-500 | HSBC Hong Kong | CL-520 | Asia Growth Trust | CCASS-448220 | CCASS, DVP, Delivery vs Payment | HSBC20240610BUY | confirmed | 2024-06-09T21:11:07 | 2024-06-14T11:00:00 |
| TRD-USD-20240611-16 | purchase | 1200 | USD | 2024-06-11 | 2024-06-13 | US66989H1023 | Novo Nordisk ADR | 126.1 | 151320 | BRK-007 | Macquarie Securities | CL-107 | Northstar Investors | PTA-665001 | Delayed settlement, DVP | NOVO20240611BUY | confirmed | 2024-06-10T18:52:00 | 2024-06-14T10:45:00 |
| TRD-RUB-20240612-17 | sale | 1500 | RUB | 2024-06-12 | 2024-06-15 | RU0009029540 | Gazprom PJSC | 21.8 | 32700 | BRK-800 | VTB Capital | CL-900 | Moscow Regional Fund | NSD-9002345 | NSD, Delivery | GAZP150020240612 | confirmed | 2024-06-11T21:00:11 | 2024-06-16T09:45:00 |
| TRD-USD-20240612-18 | sale | 2200 | USD | 2024-06-12 | 2024-06-14 | US1912161007 | Coca-Cola Co Common Stock | 62.35 | 137170 | BRK-008 | Wells Fargo Securities | CL-108 | Sunset Wealth Advisors | PTA-442876 | FedWire, DVP | KO20240612SELL | confirmed | 2024-06-11T19:01:00 | 2024-06-15T08:55:00 |
| TRD-EUR-20240613-19 | purchase | 0.304 | EUR | 2024-06-13 | 2024-06-15 | DE000ENAG999 | E.ON SE Ord Shs | 46.8 | 14.2272 | BRK-023 | Commerzbank AG | CL-209 | MicroQuant Fund | ACC-128911 | blank | blank | pending | 2024-06-13T10:18:00 | blank |
| TRD-USD-20240613-20 | purchase | 1600 | USD | 2024-06-13 | 2024-06-15 | US4781601046 | Johnson & Johnson | 152.85 | 244560 | BRK-009 | Raymond James | CL-109 | Crestview Funds | PTA-551309 | DVP, FedWire, Delivery | JNJ160020240613 | confirmed | 2024-06-12T22:10:00 | 2024-06-16T09:15:00 |
What the 400 rows show
from the 400-row sample- 1,275median quantity
- 2statuses
- 106broker names
- 132.1median price
- 216,170median total_
amount
Median 1,275, from 0.00 to 890,000.
- string 13
- float 3
- date 2
- datetime 2
Columns
20 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
confirmation_id | string | Unique identifier for the trade confirmation messageunique | TRD-USD-20240601-01 |
transaction_type | string | Type of securities transaction (purchase or sale)purchase · sale | purchase |
security_id | string | Unique identifier for the security (e.g., ISIN) | US5949181045 |
security_name | string | Name or description of the security being traded | Danone SA Ord Shs |
currency | string | Currency code for the transaction (ISO 4217)12 currencies | USD |
broker_id | string | Unique identifier for the broker sending the confirmation | BRK-001 |
broker_name | string | Name of the broker institution | Morgan Stanley LLC |
client_id | string | Unique identifier for the client or counterparty | CL-101 |
client_name | string | Name of the client or counterparty institution | Pioneer Pension Fund |
client_account_number | string | Account number of the client for settlement | PTA-985421 |
settlement_instructions | string | Instructions for settlement (e.g., delivery/receipt details)optional | Delivery via JPX, DVP |
trade_reference | string | Reference number for the trade, as provided by the broker or clientoptional | MSFT20240601BUY |
status | string | Current status of the confirmation (e.g., pending, confirmed, cancelled)pending · confirmed · cancelled | confirmed |
| Numbers 3 columns | |||
quantity | float | Number of securities traded0 or more | 4250.25 |
price | float | Price per unit of the security0 or more | 412.3 |
total_amount | float | Total value of the transaction (quantity x price)0 or more | 1750966.575 |
| Dates and times 4 columns | |||
trade_date | date | Date when the securities trade was executed | 2024-06-01 |
settlement_date | date | Date when the securities are scheduled to settle | 2024-06-03 |
created_at | datetime | Timestamp when the confirmation was created | 2024-05-31T18:22:11 |
updated_at | datetime | Timestamp when the confirmation was last updatedoptional | 2024-06-04T09:17:00 |
Use it for
A finance dashboard
Quantity by transaction_
type and a breakdown of currency. Excel, Power BI or Tableau. What pattern can you find in 400 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 400 rows.
- Confirmations400TRD-USD-20240601-014250.25purchaseTRD-EUR-20240602-020.87saleTRD-JPY-20240602-03104580purchase
A software demo
Believable confirmations with trade_
date, settlement_ date and transaction_ type to fill a screen in front of a buyer.
This dataset400 rows20 columns
Yours1,000 rows20 columns
blueprint · swift-mt540-securities-trade-confirmation
Behind this dataset
Same schema. As many rows as you need.
These 400 rows came out of a blueprint — 20 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
- Sender reference unique (field 20C)
- Trade date and settlement date
- Buy or sell indicator (field 22F)
- ISIN code for security (field 35B)
- Quantity of securities
- Price per unit
- Total consideration amount
- Settlement amount with currency
Open the blueprint in Data Factory
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- swift-mt540-securities-trade-confirmation