In the modern financial ecosystem, data is not merely information—it is the structural DNA that enables every transaction, valuation, and risk calculation. From the moment a security is issued to its final settlement, a complex web of identifiers, classifications, and temporal records governs its existence.
This comprehensive guide explores the ontology of financial value: the systematic classification and lifecycle management of financial instruments, entities, transactions, and positions. Whether you're building a trading platform, implementing a portfolio management system, or simply seeking to understand how institutional finance operates at the data layer, this framework provides the foundational architecture.
What You'll Master
- Product Master: Global identification standards (ISIN, CUSIP, FIGI) and asset-specific attributes
- Entity & Account Hierarchies: From households to sleeves, understanding ownership structures
- Transaction Lifecycle: ISO 20022 migration and structured event processing
- Tax Lot Accounting: Cost basis methodologies and corporate action mathematics
- The Three Books: IBOR, ABOR, and PBOR—separating trading, accounting, and performance views
- Performance Attribution: TWRR vs MWRR and GIPS compliance frameworks
- Risk Architecture: VaR, stress testing, and liquidity classification
- Data Engineering: Master Data Management (MDM) and bitemporal design patterns
The Product Master
The Product Master is the authoritative registry of all tradable instruments within a financial system. It serves as the single source of truth for security attributes, from basic identifiers to complex behavioral characteristics.
Think of it as the "birth certificate" for every financial instrument. Before a security can be traded, valued, or reported, it must first be defined. This definition includes not just "what it is" (equity, bond, derivative), but also "how it behaves".
Global Identification Standards
ISIN
International Securities Identification Number. ISO 6166 standard. 12-character alphanumeric code. Essential for cross-border trading and MiFID II reporting. Example: US0378331005 (Apple Inc.).
CUSIP
Committee on Uniform Securities Identification Procedures. 9-character alphanumeric code used in North America. Crucial for settlement within the DTC ecosystem.
FIGI
Financial Instrument Global Identifier. An open standard maintained by Bloomberg that remains persistent across corporate actions, unlike tickers which can change.
LEI
Legal Entity Identifier of the issuer. 20-character alphanumeric code. Mandatory under Dodd-Frank and EMIR for tracking counterparty risk.
Why Multiple Identifiers?
Different markets and regulators mandate different standards. A robust system maintains cross-reference mappings between ISIN, CUSIP, SEDOL, FIGI, and Bloomberg Ticker to ensure seamless data integration across vendors and jurisdictions.
Asset Class Attributes
Equities
Voting Rights: Essential for proxy voting workflows. Distinguishes common from preferred shares.
Free Float: Percentage of shares available for public trading. Inputs for liquidity risk models.
GICS/ICB: Sector classification driving rotation strategies, factor attribution, and benchmark construction.
Dividend Policy: Frequency (quarterly, annual), ex-dividend dates, and payment dates.
Fixed Income
Bonds are contractual cash flow machines. The Product Master must encode the legal terms that govern these flows.
| Attribute | Description | Usage |
|---|---|---|
| Coupon Logic | Fixed, Floating, Zero-Coupon | Calculating Accrued Interest (AI) |
| Day Count Convention | 30/360, Act/Act, Act/360, Act/365 | Critical for settlement amount precision |
| Embedded Options | Callable, Putable, Convertible | Calc Yield-to-Worst, OAS, Convexity |
| Seniority | Senior Secured, Subordinated | Recovery rate assumptions in default scenarios |
Derivatives
Options, futures, and swaps require contract specifications that define payoff structures.
Underlying Asset: Link to Product Master entry (e.g., SPY for SPY options)
Contract Multiplier: 100 shares per equity option, $1000 per S&P 500 futures point
Exercise Style: American (anytime), European (expiry only), Bermudan (specific dates)
Regulatory Classifications: SFDR
The EU's Sustainable Finance Disclosure Regulation (SFDR) mandates product-level sustainability classification. This metadata is now a required field for any fund sold in Europe.
Article 6
Integrates sustainability risks only. No explicit ESG promotion.
Article 8 (Light Green)
Promotes environmental/social characteristics. Must disclose how characteristics are met.
Article 9 (Dark Green)
Sustainable investment is the objective. Strictest reporting requirements.
Visual Framework: The Complete Data Architecture
This comprehensive infographic maps the entire financial data ecosystem—from product identification to performance measurement.
Entity & Account Master
While the Product Master defines what is being traded, the Entity & Account Master defines who owns it and where it resides. This hierarchical structure enables everything from consolidated wealth reporting to regulatory compliance to tax optimization strategies.
Modern wealth management platforms support multi-level account hierarchies that mirror real-world ownership structures: from households down to sleeves.
The Account Hierarchy
1. Client / Household
Top-level owner (e.g., "The Smith Family"). Aggregates Total Wealth across all accounts. Used for relationship management and consolidated reporting. Links to CRM systems.
2. Custodial Account
Legal vessel at a custodian bank. This is the level for Form 1099-B tax reporting. Each account has a unique account number and legal registration (Individual, Joint, IRA, Trust).
3. Portfolio / Strategy
Logical grouping within an account (e.g., "US Growth Equity", "Fixed Income Core"). Enables model portfolio assignment and performance attribution by strategy. Not a legal entity.
4. Sleeve / Sub-Account
Virtual partition for Unified Managed Accounts (UMAs). Enables multi-manager strategies within a single custodial account. Critical for avoiding wash sales across sleeves.
Legal Entity Controls & Compliance
Every entity in the system must be classified for regulatory compliance. These attributes drive automated screening, reporting, and risk management workflows.
KYC & AML
Know Your Customer and Anti-Money Laundering. Mandatory classification for High Risk entities, PEP, or Sanctioned individuals.
- Risk Tiers: Low, Medium, High, Prohibited
- Screening: OFAC, EU Sanctions lists
FATCA / CRS
Tax residency classification to facilitate global tax information exchange.
- W-8/W-9 Forms: Capture tax residency
- Withholding Rates: 0%, 15%, 30% based on treaty
Counterparty Risk
Linking issuers to ultimate parents to view total corporate family exposure and concentration risk.
- LEI Hierarchy: Map subsidiaries to parent
- Exposure Limits: Aggregate across all entities
Transaction Lifecycle
Transactions are the atomic events that change portfolio state. Every buy, sell, dividend, corporate action, or fee must be captured, classified, and processed through a standardized lifecycle. The industry is undergoing a historic migration from legacy messaging formats to ISO 20022.
ISO 20022 Standard
The industry is migrating from ISO 15022 (MT) to ISO 20022 (MX). This shift moves from unstructured text blocks to rich, structured XML/JSON data models capable of carrying "Ultimate Debtor", detailed remittance info, and regulatory identifiers.
Core Transaction Types
Transaction State Machine
Order submitted, awaiting execution
Trade confirmed, price locked
Cash and securities exchanged (T+2)
Matched with custodian statement
Tax Lot Accounting
A tax lot is a distinct purchase event with its own acquisition date, quantity, and cost basis. When you sell shares, the IRS requires you to specify which lots you're selling—a decision that can dramatically impact your tax liability.
Lot Selection Methodologies
FIFO (First-In, First-Out)
Simplicity; Regulatory Default
Tax Impact: Often highest tax in rising markets.
LIFO (Last-In, First-Out)
Useful in Volatile Markets
Tax Impact: Minimizes gains in rising markets.
HIFO (Highest-In, First-Out)
Optimized for Tax Loss Harvesting
Tax Impact: Maximizes realized losses.
Corporate Action Math: Tax-Free Spin-Off
When a company spins off a subsidiary (e.g., PayPal from eBay), the IRS requires you to allocate your original cost basis between the parent and the new entity based on their relative fair market values on the distribution date.
Basis Allocation Formula
The Three Books of Record
A single "position" does not exist in institutional finance. Instead, different functional areas require different views of the portfolio based on timing, settlement, and valuation rules.
IBOR (Investment Book of Record)
User: Portfolio Managers, Traders
Real-time view of available cash and securities based on Trade Date. Includes pending trades. Optimized for speed and trading decisions.
ABOR (Accounting Book of Record)
User: Accountants, Custodians
End-of-day view based on Settlement Date. Only includes completed transfers. Optimized for absolute accuracy and reconciliation.
PBOR (Performance Book of Record)
User: Performance Analysts, Clients
Historical time-series view. Requires perfect historical snapshots and GIPS-compliant valuation rules. Optimized for analytics and TWRR calculation.
Performance Measurement
Performance measurement is not simply "ending value minus beginning value." The challenge: external cash flows (deposits/withdrawals) distort returns. A portfolio that receives a large deposit right before a market crash will show poor returns—but that's not the manager's fault.
The solution: TWRR vs. MWRR.
TWRR (Time-Weighted)
Evaluates Manager Skill. Eliminates the impact of external cash flows by breaking the period into sub-periods and geometrically linking returns.
TWRR Formula
MWRR (Money-Weighted)
Evaluates Investor Experience. Equivalent to Internal Rate of Return (IRR). Weights return by capital invested—sensitive to timing of deposits/withdrawals.
MWRR Formula (Solve for r)
Risk Management
Risk management transforms IBOR positions (what you own) and Product Master attributes (how assets behave) into forward-looking loss forecasts. The goal: answer "What could go wrong?" before it does.
VaR (Value at Risk)
What is the maximum loss over time horizon T at confidence level X?
- Parametric VaR: Assumes normal distribution.
- Historical VaR: Uses actual historical returns.
- Monte Carlo: Simulates thousands of scenarios.
Stress Testing
Subjecting portfolio to hypothetical extremes (e.g., '2008 Crisis').
- Historical: Replay 2008, COVID-19.
- Hypothetical: "What if VIX spikes to 80?"
- Reverse Stress: "What breaks the portfolio?"
Liquidity Risk (LCR)
Classifying assets by ability to convert to cash.
- Tier 1: Large-cap equities (Hours)
- Tier 2: IG corporate bonds (Days)
- Tier 3: Private equity (Months)
Data Architecture
All the concepts above—Product Master, Entity Master, Transactions, Tax Lots—must be engineered into a coherent data architecture. Two design patterns are critical: Master Data Management (MDM) for resolving conflicting data sources, and Bitemporal Design for preserving audit trails.
Bitemporal Design
Tracking two timelines for every record to preserve complete audit trails and enable "as-of" queries.
Valid Time
The real-world date the data applies to. Example: "Apple's price on Jan 2, 2025 was $180". Used for performance recalculation.
Transaction Time
The date the data was entered into the system. Example: "We discovered the error and corrected it on Jan 10, 2025". Used for regulatory audits.