Answers

By industry

Positions, risk and audit trails: keeping every version of the data your AI works on.

• How do I let AI analyse trading positions and risk?

  Load the positions into a database (one version per business day) and connect your AI to it. It can then total exposure by desk, find the largest positions, and compare days,...

• How do I see what my positions looked like on a past date?

  Keep each day's positions as a dated version of one table, then query it `AS OF` that date: `SELECT ... FROM risk.book AS OF LASTDATA BETWEEN #2026-10-01# AND #2026-10-01#`...

• How do I keep every version of a table so I can audit changes?

  Write each change as a new version instead of overwriting: every load, sync or `replace_rows` in mcpdata is kept, with its time. `AS OF ALLVERSIONS` reads all of them at once,...