Eight functions, every day
They run in this order and each one is logged, so any number can be traced back to the file it came from.
From download to monitor
Scheduled connectors fetch each source; the file is stored untouched with date, source and checksum.
Format, completeness and range checks. A failed file is quarantined, an alert is sent, yesterday's good data stays live.
Common dates, decimals, currencies and units; duplicates removed; gaps flagged, never silently filled.
One NXW code per instrument, linked to ISIN, ticker, exchange and vendor codes.
Corporate actions build adjusted and total-return series; raw prices are kept beside them.
Returns, FX conversion, market cap, free-float cap, sector, country and asset class.
Curated tables saved point in time, then published as files and through the API.
A dashboard of every source and table: last update, open issues, corrections waiting for approval.
See what goes in and out
The sources the DMS reads and what each app receives.