Data in, documents out.
X-INFORM brings in what a valuation needs – custodian files, prices, FX rates, corporate actions, curves – and checks it before anything is calculated.
- 100+
- bank order types mapped to booking types
- 266
- bank fee codes, sorted into eight categories
- 26
- currencies with government yield curves
- 16
- kinds of to-do that hold a valuation until its data is complete
Three questions an operations lead asks
- Question Do we have to key in bank statements?
No. The custodian’s transaction files are read, mapped to booking types and imported with their fees and trading venue. Advice PDFs are linked to the booking they belong to.
- Question Where do prices and rates come from?
From the provider you set per data kind, asset type or instrument – with the cost estimated before each run.
- Question What happens when data is missing?
The valuation waits. A to-do names the gap, and the valuation resumes by itself once it is closed.
Custodian files, read line by line.
The custodian’s transaction files are recognised by their headers and mapped to booking types: trades, transfers, FX, coupons, dividends, corporate actions, margin. Funds, instruments and cash accounts that do not exist yet are created.
- More than a hundred bank order types mapped to booking types
- Itemised fees from the file, sorted into eight categories
- Trading venue by MIC, from a register of 2'856 venues
- Subscriptions and redemptions become share-class transactions
- Duplicates are skipped; the original file is always kept
- A message per row: info, warning or error
Files arrive in a watched folder or by upload.
Market data from the provider you choose.
Credentials are stored encrypted and tested from the application. Every call is logged with its request, its response and its duration.
A fetch job shows the estimated provider units before it starts, and can be paused, stopped and resumed.
- 01Prices
- End-of-day prices by ISIN or ticker, for a single day or a whole history, carried over exchange holidays.
- 02FX rates
- Rates at the London 4 pm fix and central-bank reference rates every day, with history back to 1999 and derived cross rates.
- 03Dividends and splits
- Once switched on, fetched daily for what the funds hold, announced distributions included – the receivable exists on the ex-date without a recalculation.
- 04Reference data
- Base data with sector classification, reference fields, corporate actions, fundamentals and option chains.
- 05Identifiers
- Identifiers found from an ISIN, a ticker or a name – enough to set up an instrument.
- 06Provider rules
- Per data kind: an override on the instrument, then a rule for the asset type, then the house rule by priority.
Gaps found before the valuation, not after.
Exchange calendars tell X-FOLIO on which days a price is due. What is missing becomes a to-do; what looks wrong becomes a finding.
- Sixteen kinds of to-do, from a missing price to a missing target-fund valuation
- Fetch the missing data straight from the to-do
- Checks for jumps, spikes, stale and non-positive prices and rates
- Thresholds per asset type
- Dividends not booked, not listed, or booked with another amount
- Findings reviewed with a comment, then checked again
A to-do holds the valuation. A finding never does – it asks for a second look.
Curves and calendars, kept current.
Once switched on, yield curves are imported daily from the central banks; credit curves and inflation indices are loaded by file. Exchange and holiday calendars decide when a price is expected and when a valuation is due.
- Official curves from central banks and treasuries, imported daily
- Government yields for 26 currencies in all
- Nominal and real curves, six tenors from three months to thirty years
- Credit-spread curves and inflation indices by CSV
- Exchange calendars per venue; prices carried over holidays
- Holiday calendars per country and region
Yield curves serve X-RISK and are imported where it is licensed and an administrator has switched the import on.
Import anything, in three formats.
Master data, prices, transactions and field values are loaded in bulk. An editor in the browser checks every row against the schema before the import runs.
- CSV for fifteen kinds of record, from funds and prices to benchmark returns
- XLSX with seven sheet types in one file
- JSON: one file, imported in dependency order
- File type recognised from its headers
- Templates and documentation to download
- Every imported file kept, single or as a ZIP
Advice PDFs, linked to their booking.
Bank advices are read from their text layer: reference, document type, dates, amount, currency, ISIN. The reference number links each PDF to its transaction.
- Linked automatically by reference number
- Tried again every five minutes for a week
- Link, unlink and retry by hand
- The PDF and its extracted text to view and download
- Duplicates recognised by checksum
PDFs are linked, not booked – the booking comes from the transaction file. Scans without a text layer are not read.
What you see of your data.
X-INFORM produces no client documents. It produces certainty about what went into them.
- On screen
Import list
Every file that came in, and what became of it.
- Status per file: importing, finished, partial, error – live
- Messages per row: info, warning, error
- The original file to download, single or as a ZIP
- On screen
To-do dashboard
What is missing, and which valuations wait for it.
- Open gaps by kind
- Valuations on hold, and what holds them
- Fetch or enter the missing value in place
- On screen
Data findings
What looks wrong without being missing.
- Price and FX anomalies
- Share-class flows without cash, cash without a flow
- Dividend and withholding-tax findings
- Review with a comment, then a new check
- On screen
Fetch plan and fetch log
What a run will cost, and what it did.
- Plan with estimated provider units before the run
- Jobs that pause, stop and resume
- Every provider call with status, duration and values delivered
- File
Exports
Data leaves as openly as it arrived.
- Any table as CSV or XLSX, over the full result
- A fund as one JSON bundle with instruments, transactions, prices and rates
- The original import files
- On screen
System dashboard
The state of the plumbing.
- Errors by source: fetch, import, calculation, report, delivery
- The database and every background worker
- Free space in the file store
From bank file to valuation.
Five steps before a single figure is calculated.
- 1 Receive
Custodian files and advices land in the watched folder or are uploaded.
- 2 Map
Order types, fee codes and venues are translated. Unknown codes register themselves.
- 3 Fetch
Prices, rates and corporate actions are requested from the chosen provider.
- 4 Check
Calendars, gaps and plausibility are checked; to-dos and findings are raised.
- 5 Release
With every gap closed, the valuation runs.
Methods, by name.
Connected today.
Custodian files
- Transaction files, recognised by their headers
- Separate cash and securities files
- 266 fee codes in 8 categories
- MIC register with 2'856 venues
- Duplicate key and file checksum
- Advice PDFs, linked by reference
Market data
- End-of-day prices
- FX fixings and reference rates
- Dividends and splits
- Reference data and identifiers
- Fundamentals and option chains
- Provider rules per data kind
- Rate limit per provider
Curves and calendars
- Central-bank and treasury curves
- 26 currencies in all
- Nominal, real, credit, inflation
- Exchange calendars
- Holiday calendars
Import
- 15 kinds of CSV record
- 7 XLSX sheet types
- JSON bundle
- Browser editor with schema check
- Templates and documentation
Quality
- 16 kinds of to-do
- Price and FX checks with thresholds
- Dividend and tax findings
- Fetch log
- System health
Master data
- 109 asset types
- 8 field types
- Field values with validity dates
- Your own fields with allowed values
- Legal entities with LEI
- Search across everything
Not in the module today Position statements and reconciliation with the custodian, a direct bank interface, reading of scanned PDFs, automatic fail-over between providers, a client portal and a public API.
