SWIFT MT300 Treasury Money Market Deal Notification
This dataset provides comprehensive notifications of treasury money market and foreign exchange deals between financial institutions, including full trade details, involved parties, settlement instructions, and confirmation timestamps. It is ideal for regulatory compliance, risk management, reconciliation, and operational analytics within the finance sector.
Sample rows
preview · 8 of 400 rows · all 30 columns| deal_idstring | trade_directionstring | amount_1float | currency_2string | trade_datedate | value_datedate | deal_typestring | instrumentstring | currency_1string | amount_2float | exchange_ratefloat | counterparty_bicstring | counterparty_namestring | counterparty_address_streetstring | counterparty_address_citystring | counterparty_address_statestring | counterparty_address_postal_codestring | counterparty_address_countrystring | our_bicstring | our_namestring | our_address_streetstring | our_address_citystring | our_address_statestring | our_address_postal_codestring | our_address_countrystring | trade_statusstring | trade_referencestring | settlement_instructionsstring | confirmation_datetimedatetime | remarksstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MM-2024A01 | Buy | 1000000 | blank | 2024-03-01 | 2024-03-04 | Money Market | Time Deposit | USD | blank | blank | CHASUS33 | JPMorgan Chase Bank N.A. | 270 Park Ave | New York | NY | 10017 | US | HSBCGB2L | HSBC Bank PLC | 8 Canada Square | London | Greater London | E14 5HQ | GB | Confirmed | TD-20240301-JPM | Fedwire USD Settlement | 2024-03-01T14:05:24 | blank |
| FXSPT-0001 | Sell | 250000 | EUR | 2024-03-04 | 2024-03-04 | FX Spot | USD/EUR | USD | 231250 | 0.925 | BNPAFRPP | BNP Paribas | 16 Blvd des Italiens | Paris | blank | 75009 | FR | CITIDEFF | Citibank Europe PLC | 1 North Wall Quay | Dublin | blank | D01 T1X5 | IE | Confirmed | USD/EUR-20240304-BNP | TARGET2 EUR Settlement | 2024-03-04T09:15:09 | blank |
| FXFWD-0051 | Buy | 50000 | JPY | 2024-05-18 | 2024-11-18 | FX Forward | GBP/JPY | GBP | 9500000 | 190 | SMBCJPJT | Sumitomo Mitsui Banking Corp. | 1-1-2 Marunouchi | Tokyo | blank | 100-0005 | JP | BARCGB22 | Barclays Bank PLC | 1 Churchill Place | London | Greater London | E14 5HP | GB | Pending | FWD-GBPJPY-20240518-SMB | RTGS JPY Settlement | 2024-05-18T15:03:45 | blank |
| DRV-INTSWAP01 | Sell | 75000000 | blank | 2024-02-10 | 2034-02-10 | Derivative | Interest Rate Swap 10Y | USD | blank | blank | BOFAUS3N | Bank of America N.A. | 100 N Tryon St | Charlotte | NC | 28202 | US | UBSGCHZH80A | UBS AG | Bahnhofstrasse 45 | Zurich | blank | 8001 | CH | Confirmed | IRS10Y-20240210-BOFA | Fedwire USD Settlement | 2024-02-11T12:30:31 | blank |
| MM-2024B02 | Buy | 20000000 | blank | 2024-04-05 | 2024-04-05 | Money Market | Certificate of Deposit | GBP | blank | blank | LLOYGB2L | Lloyds Bank PLC | 25 Gresham Street | London | Greater London | EC2V 7HN | GB | NWBKGB2L | NatWest Bank PLC | 250 Bishopsgate | London | Greater London | EC2M 4AA | GB | Confirmed | CD-20240405-LLOYDS | CHAPS GBP Settlement | 2024-04-05T10:15:10 | blank |
| FXSPT-0002 | Buy | 1200000 | CHF | 2024-03-12 | 2024-03-12 | FX Spot | EUR/CHF | EUR | 1170000 | 0.975 | UBSWCHZH | UBS Switzerland AG | Bahnhofstrasse 45 | Zurich | blank | 8001 | CH | DEUTDEFF | Deutsche Bank AG | Taunusanlage 12 | Frankfurt | blank | 60325 | DE | Confirmed | EUR/CHF-20240312-UBSW | SIC CHF Settlement | 2024-03-12T16:45:22 | blank |
| MM-2024A03 | Sell | 500000000 | blank | 2024-03-21 | 2024-03-28 | Money Market | Repo | EUR | blank | blank | BNPAFRPP | BNP Paribas | 16 Blvd des Italiens | Paris | blank | 75009 | FR | CITIDEFF | Citibank Europe PLC | 1 North Wall Quay | Dublin | blank | D01 T1X5 | IE | Pending | REPO-20240321-BNP | TARGET2 EUR Settlement | 2024-03-22T08:10:12 | blank |
| FXSPT-0003 | Buy | 750000 | KRW | 2024-03-16 | 2024-03-16 | FX Spot | USD/KRW | USD | 1014750000 | 1353 | KOEXKRSE | Korea Exchange Bank | 66 Euljiro | Seoul | blank | 100-753 | KR | HSBCGB2L | HSBC Bank PLC | 8 Canada Square | London | Greater London | E14 5HQ | GB | Confirmed | USD/KRW-20240316-KOEX | Fedwire USD Settlement | 2024-03-16T11:12:06 | Emerging market FX |
| DRV-LIBORFUT1 | Sell | 3600000 | blank | 2024-04-02 | 2024-04-02 | Derivative | USD 3M LIBOR Future | USD | blank | blank | MIZUJPJT | Mizuho Bank Ltd. | 1-5-5 Otemachi | Tokyo | blank | 100-8176 | JP | BOFAUS3N | Bank of America N.A. | 100 N Tryon St | Charlotte | NC | 28202 | US | Confirmed | LIBOR-20240402-MIZUHO | Fedwire USD Settlement | 2024-04-02T13:49:05 | blank |
| FXSPT-0004 | Sell | 10000 | AUD | 2024-03-19 | 2024-03-19 | FX Spot | GBP/AUD | GBP | 19000 | 1.9 | ANZBAU3M | Australia & NZ Banking Group | 833 Collins St | Melbourne | VIC | 3008 | AU | CITIAU2X | Citibank Australia Ltd. | 2 Park St | Sydney | NSW | 2000 | AU | Pending | GBPAUD-20240319-ANZ | RTGS AUD Settlement | 2024-03-19T10:42:11 | blank |
| MM-2024C04 | Buy | 5000000 | blank | 2024-05-01 | 2024-05-02 | Money Market | Overnight Call | INR | blank | blank | SBININBB | State Bank of India | Madame Cama Road | Mumbai | MH | 400021 | IN | ICICINBB | ICICI Bank Ltd. | Bandra Kurla Complex | Mumbai | MH | 400051 | IN | Confirmed | CALL-20240501-SBIN | RTGS INR Settlement | 2024-05-01T17:16:41 | blank |
| FXSPT-0005 | Buy | 2000000 | TRY | 2024-03-25 | 2024-03-25 | FX Spot | USD/TRY | USD | 64800000 | 32.4 | ISBKTRIS | Isbank Turkey | Cumhuriyet Cad. | Istanbul | blank | 34367 | TR | HSBCTRIX | HSBC Turkey | Buyukdere Cad. | Istanbul | blank | 34398 | TR | Confirmed | USDTRY-20240325-ISBK | CBRT TRY Settlement | 2024-03-25T16:31:44 | Minimum exchange rate precision |
| DRV-INTSWAP02 | Sell | 100000000 | blank | 2024-01-15 | 2044-01-15 | Derivative | Interest Rate Swap 20Y | EUR | blank | blank | SGFOSGSG | Societe Generale Singapore | 8 Marina Blvd | Singapore | blank | 018981 | SG | DEUTSGSG | Deutsche Bank Singapore | One Raffles Quay | Singapore | blank | 048583 | SG | Confirmed | IRS20Y-20240115-SGFOSG | TARGET2 EUR Settlement | 2024-01-15T10:05:59 | Long-term swap |
| MM-2024D08 | Buy | 18000000 | blank | 2024-06-01 | 2024-06-01 | Money Market | Commercial Paper | CHF | blank | blank | CRESCHZZ80A | Credit Suisse AG | Paradeplatz 8 | Zurich | blank | 8001 | CH | UBSGCHZH80A | UBS AG | Bahnhofstrasse 45 | Zurich | blank | 8001 | CH | Confirmed | CP-20240601-CSAG | SIC CHF Settlement | 2024-06-01T09:12:22 | blank |
| FXFWD-0052 | Sell | 85000 | AUD | 2024-04-25 | 2024-06-25 | FX Forward | CAD/AUD | CAD | 92750 | 1.091 | NATBAU33 | National Australia Bank | 800 Bourke St | Melbourne | VIC | 3008 | AU | CITICAEX | Citibank Canada | 123 Front St W | Toronto | ON | M5J 2M3 | CA | Confirmed | FWD-CADAUD-20240425-NATB | RTGS AUD Settlement | 2024-04-25T13:23:38 | blank |
| FXSPT-0006 | Buy | 150000000 | ZAR | 2024-03-14 | 2024-03-14 | FX Spot | CLP/ZAR | CLP | 2800000 | 0.01867 | SBZAZAJJ | Standard Bank of South Africa | 5 Simmonds St | Johannesburg | blank | 2001 | ZA | BCICHCLM | Banco de Chile | Bandera 100 | Santiago | blank | 8320000 | CL | Pending | CLPZAR-20240314-SBZA | RTGS ZAR Settlement | 2024-03-14T10:28:19 | Emerging market FX |
| DRV-IRS05Y03 | Buy | 20000000 | blank | 2024-03-22 | 2029-03-22 | Derivative | Interest Rate Swap 5Y | SGD | blank | blank | DBSSSGSG | DBS Bank Ltd. | 12 Marina Blvd | Singapore | blank | 018982 | SG | OCBCSGSG | OCBC Bank | 65 Chulia St | Singapore | blank | 049513 | SG | Confirmed | IRS5Y-20240322-DBS | MAS SGD Settlement | 2024-03-22T17:02:33 | blank |
| MM-2024E09 | Sell | 800000000 | blank | 2024-07-10 | 2024-07-17 | Money Market | Term Loan | JPY | blank | blank | MIZUJPJT | Mizuho Bank Ltd. | 1-5-5 Otemachi | Tokyo | blank | 100-8176 | JP | SMBCJPJT | Sumitomo Mitsui Banking Corp. | 1-1-2 Marunouchi | Tokyo | blank | 100-0005 | JP | Pending | TL-20240710-MIZUHO | Zengin JPY Settlement | 2024-07-10T08:44:41 | blank |
| FXSPT-0007 | Sell | 500000 | IDR | 2024-03-20 | 2024-03-20 | FX Spot | USD/IDR | USD | 7960000000 | 15920.00001 | BMRIIDJA | Bank Mandiri | Jl. Jend Sudirman | Jakarta | blank | 10220 | ID | HSBCIDJA | HSBC Indonesia | Jl. Jend Sudirman | Jakarta | blank | 10220 | ID | Confirmed | USDIDR-20240320-BMRI | BI RTGS IDR Settlement | 2024-03-20T14:12:55 | Emerging market FX |
| MM-2024F10 | Buy | 10800000 | blank | 2024-08-18 | 2024-08-18 | Money Market | Time Deposit | INR | blank | blank | HDFCINBB | HDFC Bank Ltd. | Sandoz House | Mumbai | MH | 400015 | IN | ICICINBB | ICICI Bank Ltd. | Bandra Kurla Complex | Mumbai | MH | 400051 | IN | Confirmed | TD-20240818-HDFC | RTGS INR Settlement | 2024-08-18T09:03:12 | blank |
What the 400 rows show
from the 400-row sample- 5,000,000median amount_
1 - 3trade statuses
- 4deal types
- 9currency 1s
- 14counterparty address states
- 15our address states
Median 5,000,000, from 0.01 to 1,000,000,000.
- string 24
- float 3
- date 2
- datetime 1
Columns
30 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 24 columns | |||
deal_id | string | Unique identifier for the treasury money market deal notificationunique | MM-2024A01 |
deal_type | string | Type of deal (e.g., FX Spot, FX Forward, Money Market, Derivative)FX Spot · FX Forward · Money Market · Derivative | Money Market |
instrument | string | Financial instrument involved in the deal (e.g., USD/EUR, Interest Rate Swap) | Time Deposit |
currency_1 | string | ISO currency code for the first currency in the transaction9 1s | USD |
currency_2 | string | ISO currency code for the second currency in the transaction (if applicable)8 2s · optional | EUR |
counterparty_bic | string | BIC code of the counterparty financial institution | CHASUS33 |
counterparty_name | string | Name of the counterparty financial institution | JPMorgan Chase Bank N.A. |
counterparty_address_street | string | Street address of the counterpartyoptional | 270 Park Ave |
counterparty_address_city | string | City of the counterpartyoptional | New York |
counterparty_address_state | string | State or province of the counterpartyoptional | NY |
counterparty_address_postal_code | string | Postal code of the counterpartyoptional | 10017 |
counterparty_address_country | string | Country of the counterpartyoptional | US |
our_bic | string | BIC code of the notifying institution | HSBCGB2L |
our_name | string | Name of the notifying institution | HSBC Bank PLC |
our_address_street | string | Street address of the notifying institutionoptional | 8 Canada Square |
our_address_city | string | City of the notifying institutionoptional | London |
our_address_state | string | State or province of the notifying institutionoptional | Greater London |
our_address_postal_code | string | Postal code of the notifying institutionoptional | E14 5HQ |
our_address_country | string | Country of the notifying institutionoptional | GB |
trade_direction | string | Direction of the trade (Buy/Sell)Buy · Sell | Buy |
trade_status | string | Status of the trade (e.g., Confirmed, Pending, Cancelled)Confirmed · Pending · Cancelled | Confirmed |
trade_reference | string | Reference number for the trade provided by the institutionoptional | TD-20240301-JPM |
settlement_instructions | string | Instructions for settlement of the transactionoptional | Fedwire USD Settlement |
remarks | string | Additional remarks or notes regarding the dealoptional | Emerging market FX |
| Numbers 3 columns | |||
amount_1 | float | Amount of the first currency in the transaction0.01 or more | 1000000 |
amount_2 | float | Amount of the second currency in the transaction (if applicable)0.01 or more · optional | 231250 |
exchange_rate | float | Exchange rate applied to the transaction (if applicable)0 or more · optional | 0.925 |
| Dates and times 3 columns | |||
trade_date | date | Date when the trade was executed | 2024-03-01 |
value_date | date | Date when the funds are settled or exchanged | 2024-03-04 |
confirmation_datetime | datetime | Date and time when the deal notification was confirmed | 2024-03-01T14:05:24 |
Use it for
A finance dashboard
Amount_
1 by trade_ direction and a breakdown of currency_ 2. 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.
- Deals400MM-2024A011000000BuyFXSPT-0001250000SellFXFWD-005150000Buy
A software demo
Believable deals with trade_
date, value_ date and deal_ type to fill a screen in front of a buyer.
blueprint · swift-mt300-treasury-money-market-deal-notification
Behind this dataset
Same schema. As many rows as you need.
These 400 rows came out of a blueprint — 30 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.
- Common reference between counterparties (field 22A)
- Trade date and value date specified
- Currency pair for FX deals
- Exchange rate agreed
- Buy and sell amounts calculated
- Party A and Party B identification
- Settlement instructions included
- Deal type: spot, forward, swap, deposit
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
- swift-mt300-treasury-money-market-deal-notification