Page tree
Skip to end of metadata
Go to start of metadata
Here you could find all terms definitions and information about their calculation for accounts, orders and positions.

Account Info Terms

This page will help you understand what all the fields of the account mean and how we calculate them.

GUI Row NameDB Column Name (dbo.Account)Description
-Cash

Value is changed by each trade.

Buy (long and close short): cash = cash - position current market value.

Sell (short and close long): cash = cash + position current market value

Q: Why we can't show it on UI?

A: Because it can be negative. (Example: Account balance is $1000. Margin rate: 20%. Trader opens new long position which is $2000. Cash = -$1000)

Day TradesDayTradesAmount of day trades. Check the FINRA explanation about what day trades are. Contains number of day trades during last 5 bussines days (including current).
Pending Cash-It is the amount of money that is reserved to provide a transaction. This reserve is withheld from Cash when an order is placed.
Equity Total-

Means your available money plus positions money if you will close it.

Equity = Cash + Long Stocks - Short Stocks. This formula provides Equity invariability when position is opened or closed.

Margin Equity-Source: AccountBalance SOD file; field 9
Close Equity-Source: AccountBalance SOD file; field 12
Long Stocks-

Shows the sum of PCMV* of long positions. When a price of any long position security changes, Long Stocks also changes.

Short Stocks-Shows the sum of PCMV* of short positions. When a price of any short position security changes, Short Stocks also changes .
Long Options-Shows the sum of PCMV* of long positions. When a price of any long position security changes, Long Options also changes.
Short Options-Shows the sum of PCMV* of short positions. When a price of any short position security changes, Short Options also changes .
Maintenance Margin-The minimum amount of equity that must be maintained in a margin account.
Option Maintenance Margin-

The minimum amount of equity that must be maintained in a margin account for options securities

Excess-

Amount of money available for withdraw or to open new positions.

Excess = Equity - TMMR - Pending Cash - Uncleared Cash, where TMMR - Total Maintenance Margin Requirement - the sum of margin requirements for all positions per account

TMMR = Sum of all positions MMR

fot Cash Accounts Excess = Cash - Pending Cash - Uncleared Cash - Unsettled Cash

 

Stock Buying Power-

Amount of money that you are avalable to buy stocks

Stock Buying Power = Equity - (MR% * CMV), where MR% - margin requirement; CMV - current market value

Case: Assume you have a margin account with a debit balance of $20,000, a current market value of $50,000 and a margin requirement of 50 percent. Your account equity is $30,000, which is calculated using the formula $50,000 - $20,000 = $30,000.

The account's stock buying power is $5,000, which is calculated using the formula $30,000 - (0.5 * $50,000) = $5,000. In this case, you have $5,000 in buying power that you can use to purchase new stock.

Option Buying Power-

Amount of money that you are avalable to buy options.

Option Buying Power = Excess * OMR, where OMR - Option Margin Rate and equals 1

Day Open Profit/Loss-

Amount of money (Unrealized Profit/Loss) at the trading session opening.

Day Close Profit/Loss-

Amount of money (Realized Profit/Loss) for previous trading session.

Net Liquidation Value-

Current value of your account

Net Liquidation Value = Long Stocks + Long Options - Short Stocks - Short Options

Pending Orders Count-Amount of orders with status "New" or "Partially Filled".
Uncleared Cash-Amount of uncleared funds.
Unsettled Cash-Amount of unsettled funds.
Day Trader Buying Power-Amount of avalible funds for day trader account.
Cash Balance- 

*Position Current Market Value - as for cash account this parameter shows the current cost of the position. PCMV changes when underlying security price changes.

**Base - a technical parameter that shows the balance between the initial cost of long positions and initial costs of short positions + account own money. This value may be negative. It means that the initial cost of long positions > initial costs of short positions + account own money. This parameter is useless for an account holder. But it uses by the trading system to calculate Equity.

Position's Price = Last Price * Quantity

 

Position Terms

GUI Column NameDB Column Name (dbo.Position)DescriptionExample
Symbol-Ticker of position's securityAAPL
Description-Company name or definition for a security.Apple Inc.
Change-

Difference between the last price and close price (price for previous trading session).

Change = Last - PrevClose

Change= Last-PrevClose=106.00-90.00=16.00
Change %-

Difference between last price and close price in percentage of close price.

Change% = (Last - PrevClose) / PrevClose * 100

Change% = (106-90)/90*100 = 17.77%
Bid-A bid price is the highest price that a buyer (i.e., bidder) is willing to pay for a good.100.00
Ask-Ask price is the price a seller states she or he will accept for a good.110.00
Last-

Last means the price of the last regular hours trade reported to the platform.

106.00

Close  

Technical field. Must be hidden from UI

 

The price that represents the last price of the last completed trading session. The Close is equal to PrevClose during ongoing regular trading session. It differs from the PrevClose value only after the ongoing session is finished.

Pre-market: Close = PrevClose

Regular market hours: Close = PrevClose

After-market: Close = Last

Non-market before [date change time] hours: Close = Last

Non-market after [date change time] hours: Close = PrevClose

For example close price for 2 days:

1.05 - 100

2.05 - 200

Current day/timePrevCloseClose
2.05 PreMarket 100100
2.05 Market100100
2.05AfterMarket100200
2.05 NonMarket100200
3.05 NonMarket200200
3.05 PreMarket200200
PrevClose The price that represents the last price of the previously completed trading session (opposite to Close price that represents the last price of the last completed trading session).90.00
Ext H Price-

Ext H Price means the last extended hours trade reported to the platform. It shows "-" during the regular session.

-
Mark StocksOptions

Stocks:

1.Trading hours:

Bid=143.65 Ask=143.74 Last=143.34 => Mark=143.65

Options:

Bid=12.25 Ask=12.85 Last=13.20 =>Mark=12.55

1.Trading hours:

Last, if Bid < LastPrice < Ask;

Ask, if Last >= Ask ;

Bid, if Last =< Bid;

2. After-market: Close

3. Pre-market: Close

4. Non-trading hours: Close

1. Trading time:

Mark = (Bid + Ask) / 2 

2. ExtendedHours-Trading: the same logic as during trading-hours

3. Non-trading hours: the same logic as during trading-hours

QuantityQuantityAmount of shares/contracts100
Contract Size
(not shown on UI) 
 

A contract size is the deliverable quantity of commodities or financial instruments underlying futures and option contracts that are traded on an exchange

Contract Size = 1 for Stocks

Contract Size = 100 for Options

Avg Open PriceAverageOpenPrice

An average price for position (position lot).

AS-IS (Average)

Calculated only with orders which have the same direction (for e.g. if you have LONG position it will be calculated by orders with positive side, sell orders will be ignored) or vice versa.

Avg Open Price = all open transactions (Quantity* Fill Price) / all open transactions (Quantity)

TO-BE (FIFO based)

Avg Open Price = position lots (Quantity * Fill Price) / position lots (Quantity)

 

Daily Cost Basis

Technical field. Must be hidden from UI

DailyCostBasis

Amount of all order transactions and it is calculated only day (at the night it resets to PrevCloseMktValue).

Daily Cost Basis[n] = Daily Cost Basis[n-1] + P[n]

P = Cost Basis from Orders widget

 

Cost BasisCostBasis

Amount of all order transactions.

Cost Basis = ∑all related transactions (Quantity * Contract Size * Fill Price)

Quantity used in that formula can be negative (sell transactions)

Note! Cost basis can be negative.

  1. Bought shares with Quantity 10 at 10.00$,
    Cost Basis = 100
  2. Bought shares with Quantity 10 at 15.00$,
    Cost Basis = 100 + 150
  3. Sold shares with Quantity 5 at 15.00$.
    Cost Basis = 100 + 150 - 75
Market Value-

Current market value of the position

Market Value = Mark * Quantity * Contract Size

 
RPL Day 

Realized profit\loss for today (set to 0 every day during overnight maintenance)

AS-IS (Average)
RPL Day = ∑today closing transactions (Fill PriceAverageOpenPriceof existing position) * Quantity* Contract Size

TO-BE (FIFO based)

RPL Day = ∑today closed position lots(Close Priceposition lot Open Priceposition lot) * Quantityposition lot * Contract Size

 

 
P/L Day 

Unrealized profit/loss compare to yesterday close position price

P/L Day = Qty * Mark * Contract Size - DailyCostBasis - RPLDay

 

PrevCloseMarketValue

[not shown on UI]

 Close Price * Quantity * Contract Size 
P/L Open-

Unrealized P&L (Profit and Loss) is the current profit or loss on an open position. The unrealized P&L is a reflection of what profit or loss could be realized if the position were closed at that time.  The P&L does not become realized until the position is closed.  

P/L Open = Market Value - Average Open Price * Quantity * Contract Size

 
P/L %-

Unrealized P/L (Profit/Loss) in percent. Profit/Loss that you will get if close a position at the moment in percent to amount on money you've spent for openning the position.

P/L % = (P/L Open) / (Average Open Price * Quantity * Contract Size) * 100

 
CreatedCreateDateDate of a position creation. 
ModifiedModifyDateDate of a position modification (modification means any position's modification for e.g. closing; buying shares to a position or selling shares of a position). 
Security Type-Type of a security in position (for e.g. Common Stock, Option). 
Close-Button which closes a position. 

Order Terms

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