NeuroTraderInstitutional
Data & Admin

Normalization

Raw source to standardized portfolio object
DEMO DATA
Desktop recommended — this workflow is dense. It works here; tables scroll inside their panels.
What changed

1,076 source records in six different structures resolved into 23 standardized positions worth $248.6M.

Why it matters

Nothing downstream re-reads a source file — drift, policy and research only see the normalized object.

Watch / decide

Six positions carry a confidence caveat, and one private-credit vehicle is classified by hand rather than by identifier.

Object confidence 96%
Six source structures, one standardized portfolio object

Normalization Pipeline

1,076 records → 23 positions
What arrived, and in whose structure?

Each source delivers its own schema. Custody speaks CUSIP and lot ids, the brokerage speaks tickers, the chain observers speak addresses and the alternatives statement speaks fund names.

What happens here
  • →Capture file or payload with a content hash and arrival timestamp
  • →Preserve the original record verbatim for audit
  • →Detect schema against a known source template
Exceptions at this stage 0 rejected at intake
What the rest of the system reads

Portfolio Object Inspector

Watch
Raw source record
TECHNOLOGY SELECT SECT SPDR | 81369Y803 | QTY 91,240 | "TECH"
Arrived from Fidelity Institutional · ETF Sleeve
Why this object is caveated

Classification override in force — the vendor sector tag was too coarse for policy.

FieldNormalized valueSourceConfidence
InstrumentXLK · Technology Select Sector SPDRResolved from CUSIP 81369Y803.Security masterHigh
AccountETF Sleeve · Taxable — GrowthSingle account, no aggregation required.BrokerageHigh
Asset ClassUS EquitySecurity masterHigh
SectorInformation TechnologySource sent "TECH"; remapped to the GICS sector policy is written against.Manual overrideMedium
Market Value$18.42MReconciles to the book of record within $0.4K.Brokerage price · Oct 5 closeHigh
CurrencyUSD (native)No conversion applied.BrokerageHigh
LiquidityImmediate · T+1 settleADV coverage 41x position size.DerivedHigh
Tax Lot6 lots · $12.1M basis · $6.3M unrealised gainOldest lot Feb 2021; all long-term.AddeparHigh
Risk FactorsGrowth · Momentum · Rates-sensitive durationLargest single contributor to portfolio risk.Risk modelMedium
SourceBrokerage → security master → overrideThree-step lineage, fully recorded.ProvenanceHigh
Confidence92%Reduced from 98% by the manual sector override.CompositeHigh