Page tree
Skip to end of metadata
Go to start of metadata
GUI Column NameDB Column Name (dbo.Order)Description
IdIdDisplays an unique identification number for each Order
Symbol-

A name of a security in general or:

  1. Spread = Security name + "Spread" (GOOG Spread)
  2. Option name = Security name + Expiration date + Strike + Call/Put (GOOG Jan 2015 Put)
  3. OTO/OCO = Security name 1 + Triggers/Cancels + Security name 2 + "Spread" (APPL Triggers FAB Spread)
CreatedCreateDateDate of an order creation
ModifiedDateDate of an order modification (Replace or Cancel)
ExecutedTransactionDateDate of last order filling
Status

Status:

0 - New

1 - Partially Filled

2 - Filled

3 - Done For Day

4 - Canceled

5 - Replaced

6 - Pending Cancel

7 - Stopped

8 - Rejected

9 - Suspended

10 - Pending New

11 - Calculated

12 - Expired

13 - Accepted For Bidding

14 - Pending Replace

15 - Error

Displays current order state:

  1. New - Outstanding order with no executions
  2. Partially Filled - Outstanding order with executions and remaining quantity
  3. Filled - Order completely filled, no remaining quantity
  4. Done For Day - Order not, or partially, filled; no further executions forthcoming
  5. Canceled - Canceled order with or without executions
  6. Replaced - Replaced order with or without executions
  7. Pending Cancel/Replace - Canceled order with or without executions
  8. Stopped - Order has been stopped at the exchange
  9. Rejected - Order has been rejected by broker. NOTE: An order can be rejected subsequent to order acknowledgment, i.e. an order can pass from New to Rejected status
  10. Suspended - Order has been placed in suspended state at the request of the client
  11. Pending New - Order has been received by brokers system but not yet accepted for execution
  12. Calculated - Order has been completed for the day (either filled or done for day). Miscellaneous fees have been calculated and reported in this execution message
  13. Expired - Order has been canceled in broker's system due to time in force instructions
  14. Accepted For Bidding - Order has been received and is being evaluated for pricing
  15. Error - Internal status for ETNA. Appears if an error is uccured while an order executing
Duration

TimeInForce:

0 - Day

1 - GTC

Duration means how long an order will remain in the market until it is canceled:

  1. Day - A day order automatically expires at the end of the regular trading session if it has not been executed. 
  2. GTC - Good-till-Canceled - An order that lasts until it's completed or it's canceled. Or

Set from Trade Ticket or Option Ticket widgets (or popups)

Historical Cost BasisAveragePriceA price at which an order was filled or if an order has Partially Filled status then Historical Cost Basis will have average value after every filling
LastLastPrice

Last means the last trade reported to the platform, or the most recent price available. Last is changed only at market hours*

Price-Price means current instrument price. Price is changed at pre/post-market and market hours*
Description-An order description. Standard formula: Side + Quantity + Symbol + "@" + Stop/Limit Price +Type (Buy 101 AAPL @ $120.00 Stop)
LimitPriceA predetermined Limit price. Set from Trade Ticket or Option Ticket widgets (or popups)
StopStopPriceA predetermined Stop price. Set from Trade Ticket or Option Ticket widgets (or popups)
AON

ExecInst:

0 - AON is disabled

65536 - AON is enabled

All or None. A condition used on a buy or sell order to instruct the broker to fill the order completely or not at all. If there is insufficient supply to meet the quantity requested by the order then it is canceled at the close of the market.

Set from Trade Ticket or Option Ticket widgets (or popups)

Type

Type:

0 - Market

1 - Limit

2 - Stop

3 - Stop Limit

InitialType:

19 - Trailing Stop

20 - Trailing Stop Limit

TrailingStopAmountType:

0 - $ Trailing Amount

1 - % Trailing Amount

TrailingLimitAmountType:

 0 - $ Limit Offset

1 - % Limit Offset

Order type:

  1. Market
  2. Stop
  3. Limit
  4. Stop Limit
  5. Trailing Stop
  6. Trailing Stop Limit

Set from Trade Ticket or Option Ticket widgets (or popups)

See more information about the order types at Short Trading Lectures page

Side

Side:

0 - Buy

1 - Sell

4 - Sell Short

9 - Buy To Cover

Side of order:

  1. Buy (Buy To Open for options and spreads) - open a long position
  2. Sell (Sell To Close for options and spreads) - close an existing long position
  3. Sell Short (Sell To Open for options and spreads) - open a short position
  4. Buy To Cover (Buy To Close for options and spreads) - close an existing short position
QuantityQuantityAmount of shares to buy or sell. Set from Trade Ticket or Option Ticket widgets (or popups)
Open/FillLeavesQuantity/ExecutedQuantityOpen - aren't filled shares. Fill - bought shares
ExchangeExchangeExchange of an order. You can choose it from Trade Ticket or Option Ticket widgets (or popups)
Replace-Button which opens the Trade/Option Ticket popups to modify an order. Actual for orders with "New" status
Cancel-Button which cancels an order. Actual for orders with "New" status

 

*Difference between Last & Price values:

Trade HoursPriceLast
Pre-Market Hourslast trade priceclose price
Market Hourslast trade pricelast trade price
Post-Market Hourslast trade priceclose price
Non-Market Hours

Close = Last = Price

  • No labels