Normalization and Enrichment
Bring disparate fields into one schema: symbol, ISIN, asset class, currency, and price source. Convert timestamps to UTC with display-local fallbacks. Enrich rows with sector tags, beta, or risk buckets that inform rebalancing logic. Validate constraints before downstream steps proceed. Keep a reference dictionary for renames and delistings to avoid orphaned records. Post a screenshot of your current columns; we will suggest a minimal, durable structure that supports growth, defensible auditing, and decisions you can explain clearly months after execution.