|GUI Row Name||DB Column Name (dbo.Account)||Description|
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: Becauseit can be negative. (Example: Account balance is $1000. Margin rate: 20%. Trader opens new long position which is $2000. Cash = -$1000)
|Day Trades||DayTrades||Amount 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.|
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|
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
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||-|| |