Feature Checklist
Order Management
- Trade blotter by trade date with filters for status, execution desk, trade purpose, sector, market, account, account group, and trading system
- Low to High, High to Low, Weighted Average, and APS price allocation methods
- Support for partial fill allocation, with automatic trade creation for the balance
- Customizable account sort order for fill allocation
- Contracts per million, target level, and contracts per trade default breakdown methods
- Trading level can be a constant or formula based
- eMail and FTP communication of trades, fills, and account activity with customizable data file formats
- PDF document and customizable data file formats for trades, fills, and account activity
- Multiple trading systems (strategies) per trade, including net-zero trades
- Combine multiple orders (same or multiple trading systems) into a single order
- Counter-party notification configurable at the account/exchange level
- Per-Trade and/or Per-Day trading activity notifications on a per-recipient basis
- Back-dated trade changes
- Multi-order placement to broker
- Virtual trade date allowing global trading
- Account-level executing broker rules enforce execution agreements
- Trading desks can be limited to the exchanges it trades
- Market and position limit checks on order placement
- Sector and Market trading restrictions at the account level
- Support for synthetic markets
- User-defined fields can be attached to orders
- Command-line order import utility
- API-based order entry
- FIX 4.2/4.4 drop copy support allows automatic order capture from a wide variety of execution platforms
- Execution gateway provides electronic order execution and reporting to clearing brokers as well as several advanced order handling options
Reconciliation
- Automatically obtain emailed of FTP downloadable statements
- Extract data from human readable brokerage statements
- Convert data from disparate statement formats into a single format defined by the user
- Reconcile Balances, Trade Confirmations, Open Positions, Trading Commissions by firm, clearing broker, and user-defined group of accounts
- Present trade breaks by trade or by account
- Detail position reconciliation and net position reconciliation
- Balance reconciliation at currency level and rolled up to account’s reporting currency
- Identify missing trades and late pickups
- Top day reconciliation of trade confirmations
- Maintain issues list recording open reconciliation issues at the broker level
- eMail break sheet to clearing broker with optional comments and optionally include all open issues
- Maintain a statement archive allowing access to prior statements and data on line at all times
- Copy extracted statement data to applications such as Microsoft® Excel®
- Print statements multi-pages per page
- Support for more than 130 different broker statements
Position Management
- Unlimited number of trading systems
- Maintain positions by system and positions net to the street simultaneously
- Real-time and batch trade matching
- Multiple settlement prices per instrument per day allowing broker-specific exchange rates and FX prices
- Trading and position activity on a specific day (present or past) and well as for a time range, net to the street or by system
- Detailed positions as well as net positions by account or selected accounts with the ability to show/hide flat FX and LME positions
- Re-state results into any currency
- Account sizing wizard builds trades for account open, close, resize events
- Pending rolls report uses roll rules to provide a one-week horizon into pending rolls
- Exit, Roll, Reversal trade generation from selected positions
- Option exercise and assignment
- Back-dated trade changes automatically update positions
- Spread-trade matching, FIFO and others when performing trade matching configurable at the clearing broker level
- Synthetic instrument support
- Settlement prices and exchange rates can be imported from broker statements
- Auto-expiration for cash settled markets
- Position valuation on the tick
Trade Accounting
- Multi-currency chart of accounts
- Balance sheet, performance table, trading cash flow, and income statement views of accounts or groups of accounts
- Accounts can be domiciled in any currency and reported on in another currency
- Formula-based management and incentive fee calculations with automatic high-water marking and daily accruals
- Formula-based interest and expense accruals at the account level
- Back and forward dated transactions
- Trading commissions at the account/market level
- Broker-based trading commissions with separate fixed and variable charges for execution-only, cleared-only, and executed and cleared scenarios
- All commission and fee structures are date-based allowing structure changes over time allowing back-dated accounting and trade changes
- Account hierarchies allow results from multiple trading accounts to be combined for the purpose of performance and fee calculations
- Single and batch transaction entry when manual posting is required
- Batch transactions can be saved and recalled for application at a later time
- Currency fluctuation (FX gain/loss) income calculated
- Daily NAV calculations with automatic monthly and yearly returns
- A currency sweep function for those advisors that sweep their foreign balances rather than trade them
- All transactions are time stamped and the user who made the entry is recorded along with the transaction
- Daily compounded returns method provides daily liquidity and NAV
- Transaction search tool for locating transactions by account, transaction, performance table column affected, ledger column affected, and value over time
- Advisor fee invoicing on monthly, quarterly, or custom time frame basis with invoices available in PDF, Word®, Excel®, and HTML formats
Risk Management
- Stop-loss analysis
- Options for system to propose protective stops based on user-definable risk parameters
- Margin to equity and margin to trading equity at the account, market, and sector levels
- Historic margin to equity
- Ability to set warning levels for account margin utilization
- Value at Risk for an arbitrary portfolio
- User-settable VAR options for confidence interval, look-back period, and instrument proxies
- Scenario analysis allows investigation of a selected portfolio’s reaction to market shocks
- Evaluate a single event or a number events simultaneously
- Chart and tabular views of results with sector and market-level details
- Re-state results into any currency
Data Manager
- Unified price data repository for research and signal generation purposes
- Bar sizes as small as one minute with virtualization to any larger size bar as required
- Ability to define virtual trading days, allows the creation of daily bars based on any timeframe
- Obtain data from a variety of sources and store in a single, consistent format
- Flexible continuous contract building
- Roll continuous contracts based on actual trading history
- Derived data capabilities allowing user-defined construction of price streams based on other price streams
- Data downloads are schedulable by market and can occur multiple times per day
- Export data in a wide variety of standard formats
- User-define export formats including symbol translation and numeric scaling
- Data viewer with charting and data tables allowing zooming and panning through the data
- Overlay studies such as moving averages and others
- Overlay actual trading history including running positions and P&L
- Automatic compare of price streams from multiple sources with user-defined rules for conflict resolution
Outbound Communications
- Built-in eMail and FTP
- Ability to automatically encrypt all communications (trade files and reports)
- Send log retains all outbound communications
- Send log viewer displays status, item, and recipient information
- Easily locate all communication related to a specific order
- Forward, re-send, cancel, and delete send log entries
- Pause sending with ability to release selected items
- Preview before sending
- To, CC, BCC on all communications
- Optional send log purging reduces system management requirements
- Automatic encryption of files and reports
Reporting
- Browser-based end-user reporting
- All reports available in PDF, Excel®, Word®, Text, HTML, and CSV formats
- Any report can be configured to be automatically emailed or FTPed to any contact in any format on a daily, monthly, and annual basis
- Reports that include the current day are valued on the tick and incorporate top-day trading activity
- Web-based access can be provided to clients with restrictions on what accounts and reports the client can see
- Built-in support for mobile devices
- Performance Explorer™ provides an interactive, graphical tool for examining performance at the portfolio, account, sector, and market level
- Built-in support for Barclay indices with monthly updates of indices
- VAMI, drawdown, volatility, Sharpe Ratio, Sortino, Omega calculations
- User-defined benchmarks allow comparison of portfolios to industry standards of your choosing
- Customizable color schemes and ability to include your logo and company information on reports
- Reports can be presented in any currency desired
- Reports that include the current day can auto-refresh on a per-user schedule
- Ability to define arbitrary groups of accounts and report on them as a single composite
- Most reports are available by trading system as well as net of all trading systems
- Templates for easy production of monthly performance summary (Tear sheet)
- End-user report designer allows easy development of customized reports with full integration into TheBooks for sending to clients
Instrument Support
- Futures
- Forwards (LME)
- Foreign Exchange
- Equities
- Cash Swaps
- Options on Futures
- Options on Forwards
- Options on Foreign Exchange
- Options on Equities
- Options on Cash Swaps
- Calendar Spread Options
- Delivery Point Spreads
- ICE OTC energy contracts such as Henry Hub swing swaps, electricity, and other daily settled power contracts
- New Zealand and Australian electricity contracts
Technology
- Three-tier client server architecture
- Microsoft SQL Server 2008, 2012, 2014, 2016 (32 and 64 bit versions)
- 32 and 64 bit versions of Microsoft Windows 10, Microsoft Windows 8.1, Microsoft Windows 7 Professional, Windows Server 2008, Windows Server 2012 R2
- Browser-based reporting
- COM+, .NET, and stored procedure programming interfaces with event model
- Built-in eMail (SMTP, POP, IMAP) and FTP (FTP, sFTP, FTPS) support
- FIX 4.2/4.4 drop copy (execution report) as well as trade routing