Investment Data Management
Where investment data becomes decision evidence.
OneBook connects instrument identity, market and fundamental data, filings, portfolio state, risk, reports, API, SDK and MCP access into one governed data layer. The goal is not another warehouse table; it is source-to-decision replay.
Custodian files
Sharadar
SEC EDGAR
Gov data
Portfolio events
Market data
canonicalize
asset_id Identity -> Facts -> Decisions lineage, quality, freshness, permissions
PM Brief
Security360
Risk
Reports
SDK
MCP
Identity, facts and decisions separated so evidence can be replayed.
OneBook structures, validates, resolves and serves investment data across market, instrument, portfolio, risk and reporting workflows. The core split is deliberate: identity lives in Instrument Master, facts live in Warehouse, decisions live in portfolio and reporting workflows.
QJ Data Plane
A foundation built to be trusted, queried and replayed.
Investment teams need more than a warehouse table. They need canonical identity, point-in-time facts, pipeline observability, source priority, lineage, tenant controls and APIs that can support humans and agents without weakening governance.
Multi-asset data model
Normalize public, private, fund, derivative, macro, filing, portfolio and event data into asset-linked contracts that downstream workflows can trust.
Interoperability
Expose clean data through UI, REST, Python SDK, exports, notebooks, webhooks and MCP while preserving tenancy, permissions and audit.
Native evidence surface
Use curated intelligence tools and governed agent access against structured portfolio, risk, warehouse, EDGAR, government and market data.
Auditable workflows
Track source files, raw payloads, canonical transformations, freshness, approvals and point-in-time snapshots behind each number.
Data ops and governance
Monitor coverage, freshness, quality events, unresolved identities, source priority and vendor-specific pipeline health.
Identity-first architecture
Resolve tickers, CIKs, CUSIPs, FIGIs, permatickers and exchange-specific listings to stable asset_id keys before data reaches models.
Investment data management meets governed access
Stop chasing data. Start replaying the workflow.
Manage your portfolio data in one governed layer.
- Holdings, lots, exposure, cash and liquidity
- Current and historical market values
- Prices, fundamentals, estimates, factors and benchmarks
- Corporate actions, filings, institutional ownership and events
- Risk, scenario, compliance and portfolio intelligence context
- Transactions, activity, reconciliation and reporting evidence
Make the same data actionable through API, SDK and MCP.
- Ask questions against governed QJ data without bypassing permissions
- Generate PM briefs, security360 snapshots and portfolio intelligence from curated tools
- Trigger multi-step workflows that combine portfolio, risk, warehouse and event data
- Produce reports and Decision Packets from frozen, replayable inputs
- Feed BI tools, notebooks, internal models and agents from the same trusted layer
Centralized data is only useful when it explains the decision.
OneBook turns the data foundation into operating workflows for portfolio oversight, reports, client-ready evidence, direct access and operational controls.
Total Portfolio Oversight
Bring portfolio state, warehouse facts, risk context and external events into one reconciled view for PMs, CIOs, risk and operations.
- Cross-asset holdings, exposure and concentration views
- Scenario, stress and risk context from the same data foundation
- Daily and intraday freshness checks against controlled sources
- Shared data model across investment, risk, finance and reporting
Client Reporting and Decision Packets
Turn trusted data into reproducible reports, investor packets, CIO briefs and decision evidence without rebuilding calculations by hand.
- Frozen report snapshots with source lineage
- Performance, holdings, risk and event context in one artifact
- White-label and internal packet workflows
- Replayable inputs for audit, diligence and committee review
Direct Data Access
Give analysts, quants and internal platforms immediate access to normalized data through governed APIs, SDK contracts, exports and MCP.
- Python SDK access through the QJ Data BFF
- Endpoint manifests for warehouse, instruments, profiles, events and portfolios
- Notebook, BI, model and agent-ready contracts
- No direct dependency on private service databases
Data Operations Control Plane
Operate the pipelines as a product: monitor freshness, coverage, quality events, unresolved identities, replay and publication batches.
- Bronze/Silver/Gold pipelines for vendor and official-source data
- Point-in-time reconstruction and source priority resolution
- Pipeline SLOs, probes, trigger audit and replay workflows
- Vault-first secrets, tenant enforcement and scoped access
Total portfolio Positions + cash + exposure
Warehouse facts Prices + metrics + factors + events
Decision layer Reports + packets + API + MCP
CoverageFresh
LineageAttached
ReplayReady
What QJ adds
More than data management: source-to-decision infrastructure.
Data management becomes distinctive when the platform can show which identity, fact, source snapshot, portfolio state and model context supported a decision, report, API response or MCP workflow.
Canonical asset_id resolution, listings, issuers, corporate actions, universes, fuzzy search and unresolved identity workflows.
Canonical loaders, PIT prices and fundamentals, 200+ metrics, 69 factors, screeners, Timescale rollups and Dagster orchestration.
Link identity, facts, portfolio state, risk context and report snapshots to the decision or workflow that used them.
Read-only access to warehouse facts through 50+ route files for dashboards, APIs, coverage, events, instruments and intelligence views.
Bronze/Silver/Gold ingestion for SF1, SEP, SFP, DAILY, SF2, SF3, TICKERS, ACTIONS, SP500 and INDICATORS.
SEC filings, XBRL standardization, PIT accepted dates, Form 4, 13F, 8-K, activist, short interest, signals and RSS stream.
Excel/CSV-first client data ingestion with raw, normalized and canonical payload lineage before portfolio state mutation.
Python access plus high-level MCP tools for PM briefs, security360, portfolio intelligence, risk workflows and Decision Packets.
From data management to decision evidence.
See how instrument identity, warehouse facts, portfolio state, risk, reports, API, SDK and MCP access become one traceable decision layer.