| Account ID |
A unique Integer based key. Each user is assigned an account ID at account creation time. |
| Account Created |
The time and date the users account was first created. |
| Cash Balance |
The current cash balance in the users account. This does not include current stock holdings. |
Company |
The full company name for an individual stock. |
| Current Gain/Loss |
The total gain or loss of this account, computed by substracting the current sum of cash/holdings minus the opening account balance. |
Current Price |
The current trading price for a given stock symbol. |
| Gain/Loss |
The current gain or loss of an individual stock holding, computed as (current market value - holding basis). |
| Last Login |
The date and time this user last logged in to Trade. |
| Market Value |
The current total value of a stock holding, computed as (quantity * current price). |
| Number of Holdings |
The total number of stocks currently owned by this account. |
| Open Price |
The price of a given stock at the open of the trading session. |
| Order ID |
A unique Integer based key. Each order is assigned an order ID at order creation time. |
| Opening Balance |
The initial cash balance in this account when it was opened. |
| Order Status |
orders are opened, processed, closed and completed. Order status shows the current stat for this order. |
| Price Range |
The low and high prices for this stock during the current trading session |
| Purchase Date |
The date and time the a stock was purchased. |
| Purchase Price |
The price used when purchasing the stock. |
| Purchase Basis |
The total cost to purchase this holding. This is computed as (quantity * purchase price). |
| Quantity |
The number of stock shares in the order or user holding. |
| Session Created |
An HTTP session is created for each user at during login. Session created shows the time and day when the session was created. |
| Sum of Cash/Holdings |
The total current value of this account. This is the sum of the cash balance along with the value of current stock holdings. |
| Symbol |
The symbol for a Trade stock. |
| Total Logins |
The total number of logins performed by this user. |
| Total Logouts |
The total number of logouts performed by this user. |
| Total of Holdings |
The current total value of all stock holdings in this account given the current valuation of each stock held. |
| Top gainers |
The list of stocks (matching LIKE CLAUSE 's:1__%' per WebSphere Trade 6.1 behavior) gaining the most in price during the current trading session. |
| Top Losers |
The list of stocks (matching LIKE CLAUSE 's:1__%' per WebSphere Trade 6.1 behavior) falling the most in price during the current trading session. |
| Trader Stock Index (TSIA) |
A computed index of the top 20 stocks (matching LIKE CLAUSE 's:1__%' per WebSphere Trade 6.1 behavior) in Trade. |
| Trading Volume |
The total number of shares traded for stocks (matching LIKE CLAUSE 's:1__%' per WebSphere Trade 6.1 behavior) during this trading session. |
| Txn Fee |
The fee charged by the brokerage to process this order. |
| Type |
The order type (buy or sell). |
| User ID |
The unique user ID for the account chosen by the user at account registration. |
| Volume |
The total number of shares traded for this stock. |