These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Stock Trading Platform
- Data model and import order
The tables behind Stock Trading Platform
Stock Trading Platform ships with 15 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 15
- Features
- 7
- Change it
- Add fields and tables in Proto
How the model is organised
Instructions:
Instructions, record attachments. Trading instructions with counterparty, amount, revision and provider reference, plus supporting files.
Independent review:
Review decisions. Approve, reject or return decisions on an instruction revision.
Trading orders:
Trading orders, Executions. Market and limit orders with broker executions taken once each.
Evidence and reconciliation:
Execution evidence, execution receipts, operation receipts. Provider evidence lines, approved execution receipts and a receipt for every guarded operation.
Positions:
Position snapshots. Provider snapshots by account, instrument and date.
Reference data:
Organizations, Counterparties, trading accounts, Instruments, team members, Users. Entities, eligible counterparties, custodied accounts, tradable instruments and desk staff.
Every table, by feature
- Instructions5
- Independent review4
- Trading orders4
- Executions and evidence4
- Execution receipts and reconciliation4
- Positions4
- Counterparties, accounts and instruments6
- Instructions
Trading instructions prepared, authorized and submitted to providers
Linked to Organizations, Team members, Counterparties - Record attachments
Supporting files attached to instructions
Linked to Instructions, Team members - Counterparties
Brokers and counterparties eligible for instructions
Linked to Organizations - Organizations
Legal entities operating the trading desk
- Team members
Desk staff with platform identity and role scope
Linked to Organizations, Users
- Review decisions
Independent reviewer decisions on instruction revisions
Linked to Instructions, Team members - Instructions
Trading instructions prepared, authorized and submitted to providers
Linked to Organizations, Team members, Counterparties - Execution receipts
Broker-confirmed execution reconciliation records
Linked to Instructions, Organizations, Trading orders, Instruments - Team members
Desk staff with platform identity and role scope
Linked to Organizations, Users
- Trading orders
Orders submitted to the broker connection
Linked to Trading accounts, Instruments - Executions
Deduplicated broker executions per order
Linked to Trading orders - Trading accounts
Custodied trading accounts used for orders
- Instruments
Tradable instruments with venue and quote currency
- Execution evidence
Provider execution evidence lines awaiting verification
Linked to Instructions - Executions
Deduplicated broker executions per order
Linked to Trading orders - Instructions
Trading instructions prepared, authorized and submitted to providers
Linked to Organizations, Team members, Counterparties - Trading orders
Orders submitted to the broker connection
Linked to Trading accounts, Instruments
- Execution receipts
Broker-confirmed execution reconciliation records
Linked to Instructions, Organizations, Trading orders, Instruments - Operation receipts
Durable receipts for guarded workflow operations
Linked to Instructions - Review decisions
Independent reviewer decisions on instruction revisions
Linked to Instructions, Team members - Instructions
Trading instructions prepared, authorized and submitted to providers
Linked to Organizations, Team members, Counterparties
- Position snapshots
Provider position snapshots by account and instrument
Linked to Trading accounts, Instruments - Trading accounts
Custodied trading accounts used for orders
- Instruments
Tradable instruments with venue and quote currency
- Executions
Deduplicated broker executions per order
Linked to Trading orders
- Counterparties
Brokers and counterparties eligible for instructions
Linked to Organizations - Trading accounts
Custodied trading accounts used for orders
- Instruments
Tradable instruments with venue and quote currency
- Organizations
Legal entities operating the trading desk
- Team members
Desk staff with platform identity and role scope
Linked to Organizations, Users - Users
Users
Linked to Users
Keys and references
An instruction references its organization, owner and counterparty; evidence lines, execution receipts, operation receipts, review decisions and attachments reference the instruction. Trading orders reference the account and instrument; executions reference the order; execution receipts also reference the order and instrument. Position snapshots reference the account and instrument. Keep provider event IDs, provider execution IDs, external order IDs and external account IDs exactly as the provider sends them; they are how repeats are recognised.
Migration order
- Load Users, Organizations and team members.
- Load Counterparties, trading accounts and Instruments.
- Load open Instructions with their record attachments and current revision.
- Load working trading orders and their Executions.
- Load the latest position snapshots for each account.
- Reconcile open instructions, orders and positions with the current system and test permissions before go-live.
Set up Stock Trading Platform your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.