Trading Tables

Brief

This section describes tables that contain trading-related data. See also the ER-diagram of the trading tables.

Details

Articles

Accounts (table)

This section describes the Accounts table that contains the trading account data such as funds used in trading, idle funds, profits/losses, certain account limitations, and so on.

Orders (table)

This section describes the Orders table that contains information about orders. The data is kept in this table until all the orders are executed.

Offers (table)

This section describes the Offers table that contains information about trading instruments, current prices, and high/low trading day prices.

Trades (table)

This section describes the Trades table that contains open positions data such as floating profit/loss, charged commission, cumulative interest, and so on.

Closed Trades (table)

This section describes the Closed Trades table that contains information about the positions closed during the current trading day such as realized profit/loss, charged commission, cumulative interest, and so on.

Messages (table)

This section describes the Messages table that contains information about dealing desk messages received during the current trading day.

Summary (table)

This section describes the Summary table that contains summarized information such as the average entry price, profit/loss, and so on for every instrument currently traded. Note: The Summary table is available only through the Table Manager.

back