SWIFT MT306 Currency Option Confirmation
This dataset provides detailed records of currency option confirmations as per SWIFT MT306 standards, including contract terms, counterparties, premiums, expiry, and exercise provisions. It is ideal for financial institutions to track, audit, and analyze currency option transactions, ensuring regulatory compliance and operational transparency.
Sample rows
preview · 8 of 300 rows · all 24 columns| confirmation_idstring | exercise_stylestring | premium_amountfloat | settlement_currencystring | trade_datedate | option_typestring | buyer_partystring | seller_partystring | currency_pairstring | notional_amountfloat | strike_pricefloat | premium_currencystring | premium_payment_datedate | expiry_datedate | exercise_start_datedate | exercise_end_datedate | settlement_datedate | settlement_methodstring | underlying_amountfloat | underlying_currencystring | trade_referencestring | statusstring | creation_datetimedatetime | last_update_datetimedatetime |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CONF001 | European | 42500 | USD | 2023-03-15 | call | Goldman Sachs Intl Plc | HSBC Bank USA N.A. | EUR/USD | 150000000 | 1.1098 | EUR | 2023-03-16 | 2023-09-15 | 2023-09-15 | 2023-09-15 | 2023-09-16 | physical | 150000000 | EUR | EU-TRD20230315-001 | confirmed | 2023-03-15T10:15:00 | 2023-03-15T10:15:32 |
| CONF002 | Bermudan | 2500 | blank | 2023-02-20 | put | UBS Asset Mgmt Ltd | Morgan Stanley LLC | USD/JPY | 2000000 | 135.22 | JPY | 2023-02-21 | 2023-08-20 | blank | blank | blank | cash | 2000000 | USD | JP-TRD20230220-002 | pending | 2023-02-20T09:45:00 | 2023-02-20T09:45:15 |
| CONF003 | European | 38000 | USD | 2023-01-03 | call | BNP Paribas S.A. | Deutsche Bank AG | GBP/USD | 75000000 | 1.267 | GBP | 2023-01-04 | 2023-07-03 | 2023-07-03 | 2023-07-03 | 2023-07-04 | physical | 75000000 | GBP | UK-TRD20230103-003 | confirmed | 2023-01-03T11:20:00 | 2023-01-03T11:20:36 |
| CONF004 | Bermudan | 0 | blank | 2023-04-28 | put | Citadel Fund Ltd | ING Bank N.V. | AUD/CAD | 0.01 | 0.8987 | CAD | 2023-04-28 | 2023-06-28 | blank | blank | blank | cash | 0.01 | AUD | blank | pending | 2023-04-28T13:10:00 | 2023-04-28T13:10:43 |
| CONF005 | American | 12000 | CNY | 2023-05-09 | call | J.P. Morgan Chase Bank | Mizuho Securities Co. | USD/CNY | 50000000 | 7.1285 | USD | 2023-05-09 | 2023-11-09 | 2023-05-10 | 2023-11-09 | 2023-11-10 | cash | 50000000 | USD | CN-TRD20230509-005 | confirmed | 2023-05-09T09:25:00 | 2023-05-09T09:25:45 |
| CONF006 | Bermudan | 95 | blank | 2023-06-22 | put | Manulife Asset Mgmt | Societe Generale SA | SGD/PHP | 5000 | 41.12 | SGD | 2023-06-23 | 2023-12-22 | blank | blank | blank | cash | 5000 | SGD | blank | pending | 2023-06-22T14:05:00 | 2023-06-22T14:05:21 |
| CONF007 | American | 15000 | BRL | 2023-07-10 | call | Barclays Bank Plc | Citi Global Markets | USD/BRL | 100000000 | 4.8815 | USD | 2023-07-11 | 2024-01-10 | 2023-07-12 | 2024-01-10 | 2024-01-11 | cash | 100000000 | USD | BR-TRD20230710-007 | confirmed | 2023-07-10T08:40:00 | 2023-07-10T08:40:52 |
| CONF008 | American | 8100 | blank | 2023-08-21 | put | Zurich Insurance Plc | BNY Mellon Bank | INR/USD | 25000000 | 81.1 | INR | 2023-08-22 | 2024-02-21 | 2023-08-22 | 2024-02-21 | blank | cash | 25000000 | INR | IN-TRD20230821-008 | pending | 2023-08-21T15:18:00 | 2023-08-21T15:18:14 |
| CONF009 | European | 250000 | GBP | 2023-09-29 | call | Blackrock Advisors LLC | Santander Bank SA | EUR/GBP | 500000000 | 0.8645 | EUR | 2023-09-29 | 2024-03-29 | 2024-03-29 | 2024-03-29 | 2024-03-30 | physical | 500000000 | EUR | UK-TRD20230929-009 | confirmed | 2023-09-29T12:35:00 | 2023-09-29T12:35:41 |
| CONF010 | Bermudan | 850 | blank | 2023-10-02 | put | Toronto Dominion Bank | ANZ Banking Group Ltd | CAD/AUD | 320000 | 1.0487 | CAD | 2023-10-03 | 2023-12-02 | blank | blank | blank | cash | 320000 | CAD | CA-TRD20231002-010 | pending | 2023-10-02T13:11:00 | 2023-10-02T13:11:35 |
| CONF011 | European | 11000 | HKD | 2023-11-13 | call | Wells Fargo Bank NA | Standard Chartered Plc | USD/HKD | 250000000 | 7.821 | USD | 2023-11-14 | 2024-05-13 | 2024-05-13 | 2024-05-13 | 2024-05-14 | physical | 250000000 | USD | HK-TRD20231113-011 | confirmed | 2023-11-13T10:00:00 | 2023-11-13T10:00:44 |
| CONF012 | Bermudan | 110 | blank | 2023-12-05 | put | Nordea Bank Abp | SEB Group AB | SEK/NOK | 100000 | 1.0025 | SEK | 2023-12-06 | 2024-02-05 | blank | blank | blank | cash | 100000 | SEK | blank | pending | 2023-12-05T09:17:00 | 2023-12-05T09:17:31 |
| CONF013 | American | 6800 | KRW | 2023-12-12 | call | Credit Suisse Group | State Street Bank | USD/KRW | 85000000 | 1328.22 | USD | 2023-12-13 | 2024-06-12 | 2023-12-14 | 2024-06-12 | 2024-06-13 | cash | 85000000 | USD | KR-TRD20231212-013 | confirmed | 2023-12-12T08:50:00 | 2023-12-12T08:50:27 |
| CONF014 | Bermudan | 0.01 | blank | 2023-06-30 | put | KBC Group NV | Rabobank Nederland | EUR/USD | 0.01 | 1.1032 | USD | 2023-06-30 | 2023-07-30 | blank | blank | blank | cash | 0.01 | EUR | blank | pending | 2023-06-30T11:13:00 | 2023-06-30T11:13:33 |
| CONF015 | European | 320000 | CHF | 2023-07-25 | call | Royal Bank of Canada | UBS Switzerland AG | CAD/CHF | 990000000.99 | 0.6724 | CAD | 2023-07-26 | 2024-01-25 | 2024-01-25 | 2024-01-25 | 2024-01-26 | physical | 990000000.99 | CAD | CH-TRD20230725-015 | confirmed | 2023-07-25T13:26:00 | 2023-07-25T13:26:58 |
| CONF016 | Bermudan | 60 | blank | 2023-08-14 | put | Macquarie Bank Ltd | First Abu Dhabi Bank | AUD/SGD | 45000 | 0.892 | SGD | 2023-08-15 | 2024-02-14 | blank | blank | blank | cash | 45000 | AUD | SG-TRD20230814-016 | pending | 2023-08-14T10:33:00 | 2023-08-14T10:33:18 |
| CONF017 | American | 7900 | blank | 2023-09-01 | call | Fidelity Intl Ltd | Banco do Brasil SA | USD/BRL | 5000000 | 5.0408 | BRL | 2023-09-02 | 2024-03-01 | 2023-09-03 | 2024-03-01 | blank | cash | 5000000 | USD | BR-TRD20230901-017 | pending | 2023-09-01T08:46:00 | 2023-09-01T08:46:21 |
| CONF018 | Bermudan | 100 | blank | 2023-09-22 | put | ABN AMRO Bank N.V. | Danske Bank A/S | EUR/DKK | 750000 | 7.4575 | EUR | 2023-09-23 | 2024-03-22 | blank | blank | blank | cash | 750000 | EUR | blank | pending | 2023-09-22T11:41:00 | 2023-09-22T11:41:36 |
| CONF019 | European | 205000 | CNY | 2023-10-18 | call | HSBC Holdings Plc | ICBC Bank Ltd | USD/CNY | 800000000 | 7.3099 | USD | 2023-10-19 | 2024-04-18 | 2024-04-18 | 2024-04-18 | 2024-04-19 | physical | 800000000 | USD | CN-TRD20231018-019 | confirmed | 2023-10-18T09:51:00 | 2023-10-18T09:51:29 |
| CONF020 | European | 280000 | USD | 2023-11-07 | put | Scotia Capital Inc | Bank of Montreal | CAD/USD | 999999999.99 | 0.7499 | CAD | 2023-11-08 | 2024-05-07 | 2024-05-07 | 2024-05-07 | 2024-05-08 | physical | 999999999.99 | CAD | US-TRD20231107-020 | confirmed | 2023-11-07T14:29:00 | 2023-11-07T14:29:58 |
What the 300 rows show
from the 300-row sampleEuropean (exercise style) stands out: mean premium_
- 3,940median premium_
amount - 2option types
- 2settlement methods
- 2statuses
- 25underlying currencies
- 26premium currencies
Median 3,940, from 0.0 to 380,000.
- string 12
- float 4
- date 6
- datetime 2
Columns
24 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
confirmation_id | string | Unique identifier for the currency option confirmationunique | CONF001 |
option_type | string | Type of option (call or put)call · put | call |
buyer_party | string | Legal name of the party buying the option | Goldman Sachs Intl Plc |
seller_party | string | Legal name of the party selling the option | HSBC Bank USA N.A. |
currency_pair | string | ISO currency codes for the option (e.g., EUR/USD) | EUR/USD |
premium_currency | string | ISO currency code for the premium payment | EUR |
exercise_style | string | Option exercise style (European, American, Bermudan)European · American · Bermudan | European |
settlement_currency | string | ISO currency code for settlementoptional | USD |
settlement_method | string | Method of settlement (physical, cash)physical · cash | physical |
underlying_currency | string | ISO currency code of the underlying amountoptional | EUR |
trade_reference | string | Reference code or number for the tradeoptional | EU-TRD20230315-001 |
status | string | Current status of the confirmation (confirmed, pending, cancelled)confirmed · pending · cancelled | confirmed |
| Numbers 4 columns | |||
notional_amount | float | Total notional amount of the option contract0.01 or more | 150000000 |
strike_price | float | Strike price agreed for the option0 or more | 1.1098 |
premium_amount | float | Premium paid for the option0 or more | 42500 |
underlying_amount | float | Amount of underlying currency for the option0.01 or more · optional | 150000000 |
| Dates and times 8 columns | |||
trade_date | date | Date the currency option transaction was executed | 2023-03-15 |
premium_payment_date | date | Date the premium is due or paid | 2023-03-16 |
expiry_date | date | Date the option expires | 2023-09-15 |
exercise_start_date | date | Start date for option exercise (if applicable)optional | 2023-09-15 |
exercise_end_date | date | End date for option exercise (if applicable)optional | 2023-09-15 |
settlement_date | date | Date the option is settledoptional | 2023-09-16 |
creation_datetime | datetime | Timestamp when the confirmation record was created | 2023-03-15T10:15:00 |
last_update_datetime | datetime | Timestamp of the last update to the confirmation record | 2023-03-15T10:15:32 |
Use it for
A finance dashboard
Premium_
amount by exercise_ style and a breakdown of settlement_ currency. Excel, Power BI or Tableau. Why do the 146 European rows have a mean premium_
amount of 100,383? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Confirmations300CONF00142500EuropeanCONF0022500BermudanCONF00338000European
A software demo
Believable confirmations with trade_
date, option_ type and buyer_ party to fill a screen in front of a buyer.
blueprint · swift-mt306-currency-option-confirmation
Behind this dataset
Same schema. As many rows as you need.
These 300 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.
- Option reference unique
- Trade date and expiry date
- Option type: call or put
- Currency pair specified
- Strike price/rate agreed
- Notional amount of option
- Premium amount and payment date
- Exercise style: European or American
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-mt306-currency-option-confirmation