Database Query Form
Submitting queries is simple!
  • Simply fill in relevant information in the form below or use one of our Standard Queries.
  • Where appropriate, a '-' separated range of values is valid. (ie. 0-88)
  • Where appropriate, a ',' separated list of values is valid. (ie. ERTS,IBM,AAPL)

Query returns:
Orders
Executions
Standard Queries

Tally Results?

Order Information
ClientID * Defaults based on client
BranchID * Defaults based on client
OrderID
 
Order Classification
Symbol
Order Side
Order Type
Order Market
Entry Time
 
Exception Information
Missed Trade Exception
Non-Display Exception
 
Order Restrictions
Number of Executions
Quantity
Unexecuted Shares
Order Size Classification
Order Entry Classification
Order Duration in seconds
Avg. Effective Spread
Avg. NBBO effective spread
Total Trigger Improvement
Number of Improvements
Number of Disimprovement
Total NBBO Improvement
Number of Improvements
Number of Disimprovement
Total VWAP Improvement
Number of Improvements
Number of Disimprovement
Number of Liquidity Enhanced Execs
Total Liquity Enhancement Shares
Number of Execs w/ Lost Liquidityee
Total Shares w/ Lost Liquidity
 
Execution Information
Execution Number
Per Share Trigger Improvement
Per Share NBBO Improvement
Per Share VWAP Improvement
Time since Entry in seconds
Time since First Execution in seconds
Execution Quantity
Executing Market
Liquidity Enhancement
Effective Spread
NBBO Effective Spread
 
Cancellation Restrictions
Duration in seconds
Unexecuted Shares
Number of executions before cancellation
Cancellation Confirmation Time