SWIFT MT535 Securities Statement of Holdings

This dataset provides detailed records of securities holdings in custody, including account information, security positions, market valuations, and entitlements from corporate actions. It enables comprehensive portfolio analysis, regulatory reporting, and reconciliation for financial institutions and asset managers.

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

Portfolio valuation and performance tracking

Sample rows

preview · 8 of 500 rows · all 20 columns
statement_idstringstatement_typestringposition_quantityfloatcorporate_action_typestringstatement_datedatecustodian_idstringaccount_idstringaccount_namestringsecurity_idstringsecurity_typestringsecurity_namestringposition_currencystringmarket_valuefloatmarket_value_datedatecorporate_action_idstringcorporate_action_entitlementfloatcorporate_action_currencystringrecord_datedateex_datedatepayment_datedate
STMNT001periodic1000000dividend2024-04-29CUSTD001ACCNT001Helios University FoundationUS1234567890equityAlphaTech Holdings Inc.USD480000002024-04-29CA1015000USD2024-04-232024-04-252024-04-28
STMNT002periodic950blank2024-05-16CUSTD002ACCNT002Mitchell Advisory GroupGB0987654321equityBritannia Energy PLCGBP717602024-05-16blankblankblankblankblankblank
STMNT003periodic1000dividend2024-04-09CUSTD003ACCNT003blankDE2345678901fundRainier College FundEUR32250.62024-04-09CA1021500EUR2024-04-032024-04-052024-04-08
STMNT004periodic50blank2024-03-20CUSTD004ACCNT004Santos Personal PortfolioUS3456789012equityOmniFund Corp.USD81002024-03-20blankblankblankblankblankblank
STMNT005periodic25000merger2024-05-03CUSTD005ACCNT005OmniFund RetirementFR4567890123bondEurozone Sovereign Bond 2029EUR28500.52024-05-03CA103305.5EUR2024-04-272024-04-292024-05-01
STMNT006on-demand100blank2024-04-17CUSTD006ACCNT006Bari Derivatives Ltd.CA5678901234derivativeNorthwest Options FundCAD5702024-04-17blankblankblankblankblankblank
STMNT007periodic10blank2024-03-26CUSTD007ACCNT007Miramar Youth SavingsUS6789012345fundPacific Growth OpportunitiesUSD254002024-03-26blankblankblankblankblankblank
STMNT008periodic250dividend2024-05-11CUSTD008ACCNT008Kovács PensionCH7890123456fundSwiss Balanced FundCHF98602024-05-11CA104305.5CHF2024-05-052024-05-072024-05-09

What the 500 rows show

from the 500-row sample
  • 250.0median position_quantity
  • 5security types
  • 7position currencies
  • 7corporate action currencies
  • 99account names
  • 9,860median market_value
statement_type500 rows by value
0180360360periodic72%140on-demand28%
position_quantity500 rows, in bands of 100k
024048047350000000220500k1Mposition_quantity →

Median 250.0, from 0.0 to 1,000,000.

corporate_action_type134 rows with a value · 366 left blank
  1. dividend64
  2. split26
  3. merger21
  4. rights_issue13
  5. other10
20 columns by typefrom the column list below
  • string 12
  • float 3
  • date 5

Columns

20 columns in three groups
blueprint · 20 columns
columntypedescriptionexample
Text 12 columns
statement_idstringUnique identifier for the securities statement of holdingsuniqueSTMNT001
custodian_idstringUnique identifier for the custodian holding the securitiesCUSTD001
account_idstringUnique identifier for the account under custodyACCNT001
account_namestringName of the account holder or entityoptionalMitchell Advisory Group
security_idstringUnique identifier for the security (e.g., ISIN, CUSIP)US1234567890
security_typestringType of security (e.g., equity, bond, fund)equity · bond · fund · derivative · otherequity
security_namestringFull name of the securityAlphaTech Holdings Inc.
position_currencystringCurrency code for the valuation (e.g., USD, EUR)7 currenciesUSD
corporate_action_idstringUnique identifier for any corporate action entitlement related to the positionoptionalCA101
corporate_action_typestringType of corporate action (e.g., dividend, split, merger)dividend · split · merger · rights_issue · other · optionaldividend
corporate_action_currencystringCurrency code for the corporate action entitlement7 currencies · optionalUSD
statement_typestringIndicates if the statement is periodic or on-demandperiodic · on-demandperiodic
Numbers 3 columns
position_quantityfloatQuantity of the security held in the account0 or more1000000
market_valuefloatMarket value of the position as of statement date0 or more48000000
corporate_action_entitlementfloatAmount or quantity entitled from the corporate action0 or more · optional5000
Dates and times 5 columns
statement_datedateDate when the statement was generated2024-04-29
market_value_datedateDate of the market value valuation2024-04-29
record_datedateDate on which the entitlement is recordedoptional2024-04-23
ex_datedateEx-date for the corporate actionoptional2024-04-25
payment_datedatePayment date for the corporate action entitlementoptional2024-04-28

Use it for

  • median positio…250.0500 rowsmean position quantit…68.5kperiod…26.0on-dem…

    A finance dashboard

    Position_quantity by statement_type and a breakdown of corporate_action_type. Excel, Power BI or Tableau.

  • What pattern can you find in 500 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 500 rows.

  • A software demo

    Believable statements with statement_date, custodian_id and account_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 20 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 dataset500 rows20 columns
Yours1,000 rows20 columns

blueprint · swift-mt535-securities-statement-of-holdings

Behind this dataset

Same schema. As many rows as you need.

These 500 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
  • Statement reference unique (field 20C)
  • Statement date specified
  • Account identification (field 97A)
  • Statement type: opening, closing, transaction
  • Each security position listed
  • ISIN codes for all securities
  • Quantity held per security
  • Safekeeping place indicated
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
swift-mt535-securities-statement-of-holdings

More in Finance

Browse all
Also in FinanceFinancial Portfolio Risk MetricsPersonal Finance Budgeting RecordsCredit Card Fraud DetectionAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.