Mapping the market and portfolio data stack

Why this matters: market data is expensive. Vendor contracts are among the larger line items in an operations budget, and usage is tightly licensed. Displaying a Bloomberg price on a client-facing screen may require a different license than using it internally.

Two kinds of data

Keep these straight, because the whole stack depends on the distinction:

• Market data (dynamic): prices, quotes, and rates that change constantly.
• Reference data (static): the descriptive facts about a security. Its issuer, currency, maturity, sector, and identifiers.

Reference data lives in the security master.

The security master: the single source of truth

The security master is the central database that defines every instrument a firm can hold or trade. Think of it as the firm's official dictionary of securities.

Each entry answers: what exactly is this thing? For our Apple share, the record stores:

• Identifiers: ISIN (International Securities Identification Number, a global 12-character code), CUSIP (a North American identifier), and the vendor's own ticker.
• Descriptive attributes: equity type, USD currency, listing exchange, GICS sector.
• Corporate action history: splits, dividends, name changes.

The identifier problem

The same security carries different codes in different systems. One vendor calls it "AAPL US Equity," another uses the ISIN, a third uses an internal ID. If these do not mapmapUsing software to automate repetitive marketing tasks and campaigns, enabling personalisation at scale across channels like email, web, and social.View full definition → cleanly, a price update can attach to the wrong instrument, or to none at all.

This is why security master data management is a discipline of its own. A break in identifier mapping is a common root cause of pricing errors.

A useful free reference on global identifier standards is the Association of National Numbering Agencies, which oversees the ISIN standard.

The position-keeping system: what do we actually own?

Once we know what a security is (security master) and what it is worth (market data), we need to know how much of it we hold. That is the job of the position-keeping system, often part of a broader portfolio accounting or investment book of record (IBOR) platform.

An IBOR is the firm's real-time record of positions: every holding, across every portfolio, updated as trades settle and cash moves.

For our Apple position, the position keeper tracks:

• Quantity of shares held in each portfolio.
• Cost basis (what the firm paid).
• Corporate action adjustments (a 4-for-1 split multiplies the share count and divides the price).

Trade to position

When a portfolio manager buys Apple, the order flows through an order management system (OMS), executes, and then settles. Settlement is when cash and shares actually change hands. In most major equity markets this now happens one business day after the trade (known as T+1), following the 2024 move to T+1 in the US, Canada, and Mexico.

The position keeper reflects the holding, and the security master identifies it, and the market data values it. Three systems, one position.

Striking the NAV: turning data into a number people trust

Now the payoff. The NAV (net asset value) is the per-share value of a fund. For a mutual fund or ETF, it is calculated at least once a day and is the price at which many investors buy and sell.

The formula is simple:

The complexity is in the inputs. Striking the NAV means:

1. Pull the closing price for every holding from the agreed primary source.

2. Match each price to the correct security via the security master.

3. Multiply price by quantity from the position keeper.

4. Sum all holdings, add cash, subtract fees and other liabilities.

5. Divide by shares outstanding.

For our fund, Apple's closing price times the number of shares held becomes one line in that sum.

Who checks the number?

NAV is not struck once and trusted blindly. Firms run a price validation or tolerance check process. If today's price for a security moved more than a set threshold (say, a large percentage swing) versus yesterday, the system flags it for a human to review. Was it a real market move, or a bad data point?

Many funds also use a fund administrator, an outside firm that independently calculates NAV as a check against the manager's own number. When the two match within tolerance, confidence is high. This independent oversight is a core investor protection.

Where the stack breaks (and how firms defend it)

Understanding failure points is what separates fluency from theory.

Stale prices. A market holiday abroad, or a halted stock, means yesterday's price carries over. Good systems tag prices with a timestamp and source, so a stale value is visible, not hidden.

Corporate action errors. A missed stock split is a classic disaster. If the price divides by four but the share count does not multiply by four, the position value drops by 75 percent overnight. Corporate action processing is heavily automated and heavily monitored.

Identifier mismatches. As noted, a broken mapmapUsing software to automate repetitive marketing tasks and campaigns, enabling personalisation at scale across channels like email, web, and social.View full definition → between an ISIN and an internal code can orphan a price update. Reconciliation catches these.

Reconciliation: the daily safety net

Reconciliation is the process of comparing two independent records and investigating any differences. AWM firms reconcile constantly:

• Positions in the IBOR versus positions at the custodian (the bank that legally holds the assets).
• Cash in the accounting system versus cash at the bank.
• The firm's NAV versus the fund administrator's NAV.

A break is any unexplained difference. Operations teams spend much of their day chasing breaks to zero before NAV is finalized. This is unglamorous and absolutely central.

Data governanceData governanceData governance is the set of policies, roles, and processes that ensure data is accurate, secure, well-defined, and used responsibly across an organization.View full definition →: the layer above it all

Regulators increasingly expect firms to prove not just that a number is right, but that they can explain where it came from. This is data lineagedata lineageData lineage maps how data moves and transforms across systems, from origin to consumption, showing where it came from, what changed it, and where it goes.View full definition →: the documented path of a data point from source to report.

For our Apple price, lineage would show: Bloomberg feed, timestamp, security master match on ISIN, applied to the position keeper quantity, included in the NAV calculation, published in the fund fact sheet.

Strong data governancedata governanceData governance is the set of policies, roles, and processes that ensure data is accurate, secure, well-defined, and used responsibly across an organization.View full definition → (the policies, roles, and controls over data) turns a tangle of systems into an auditable chain. It is also what lets a firm adopt AI and automation safely, because you cannot trust an algorithm if you cannot trust its inputs.

Key takeaways

• A single price travels through four core layers: market data (the price), the security master (what the security is), the position-keeping system / IBOR (how much you hold), and the NAV strike (the trusted final value).
• The security master is the firm's single source of truth for security definitions, and clean identifier mapping (ISIN, CUSIP) is what keeps the whole chain from breaking.
• NAV is only as good as its inputs, so firms run tolerance checks and often use an independent fund administrator to validate the number.
• Reconciliation against the custodian and administrator is the daily safety net that catches breaks before a wrong NAV reaches investors.
• Data lineageData lineageData lineage maps how data moves and transforms across systems, from origin to consumption, showing where it came from, what changed it, and where it goes.View full definition → and governance make the whole stack auditable, and they are the foundation for trustworthy automation and AI.