Trades (table)
Brief
This section describes the Trades table that contains open positions data such as floating profit/loss, charged commission, cumulative interest, and so on.
Details
Name |
Type |
Description |
||||||
TradeID |
String |
The unique identification number of the open position. The number is unique within the same database
that stores the account the position is opened on. For example, |
||||||
AccountID |
String |
The unique identification number of the account the position is opened on. The number is unique within
the database where the account is stored. For example, |
||||||
AccountName |
String |
The unique name of the account the position is opened on. The name is unique within the database where
the account is stored. For example, |
||||||
AccountKind |
String |
The type of the account the position is opened on. The possible values are:
|
||||||
OfferID |
String |
The unique identification number of the instrument traded. |
||||||
Amount |
Integer |
The amount of the position. In the case of FX instruments, the amount is expressed in the base currency of the instrument. In the case of CFD instruments, the amount is expressed in contracts. |
||||||
BuySell |
String |
The trade operation the position is opened by. The possible values are:
|
||||||
OpenRate |
Double |
The price the position is opened at. In the case of FX instruments, it is expressed in the instrument counter currency per one unit of base currency. In the case of CFD instruments, it is expressed in the instrument native currency per one contract. |
||||||
OpenTime |
Date |
The date and time when the position is opened. |
||||||
OpenQuoteID |
String |
The unique identifier of the pair of prices (bid and ask) the position is opened at. |
||||||
OpenOrderID |
String |
The unique identification number of the order the position is opened by. The number is unique within the same
database that stores the account the order is placed on. For example, |
||||||
OpenOrderReqID |
String |
The identifier of the order request the position is opened by (see |
||||||
OpenOrderRequestTXT |
String |
The custom identifier of the order the position is opened by (see |
||||||
Commission |
Double |
The amount of funds subtracted from the account balance to pay for the broker's service in accordance with the
terms and conditions of the account trading agreement. It is expressed in the account currency. If commision is not
charged or has not been charged yet, the value of this field is |
||||||
RolloverInterest |
Double |
The cumulative amount of funds that is added the account balance for holding the position
overnight. It is expressed in the account currency. The value of this field can be positive or negative.
If the position has not been held overnight, the value of this field is |
||||||
TradeIDOrigin |
String |
The unique identification number of the position, the partial closing of which results in the opening of the current position. Otherwise, this field is empty. |
||||||
UsedMargin |
Double |
The amount of funds currently committed to maintain the position. It is expressed in the account currency. |
||||||
ValueDate |
String |
The simulated delivery date. The date when the position could be automatically closed. The date is provided in the |
||||||
Parties |
String |
The unique identifier of the environment that is used to open the position. The identifier is generated by ForexConnect. |
||||||
Close |
Double |
The price at which the position can be closed at the moment. In the case of FX instruments, it is expressed in the instrument counter currency per one unit of base currency.
In the case of CFD instruments, it is expressed in the instrument native currency per one contract. |
||||||
GrossPL |
Double |
The current profit/loss of the position. It is expressed in the account currency. |
||||||
Limit |
Double |
The price of the associated limit order (profit limit level). In the case of FX instruments, it is expressed in the instrument counter currency per one unit of base currency.
In the case of CFD instruments, it is expressed in the instrument native currency per one contract.
If there is no associated limit order, the value of this field is |
||||||
PL |
Double |
The current profit/loss per one lot of the position. It is expressed in the account currency. The size of one lot is obtained by |
||||||
Stop |
Double |
The price of the associated stop order (loss limit level). In the case of FX instruments, it is expressed in the instrument counter currency per one unit of base currency.
In the case of CFD instruments, it is expressed in the instrument native currency per one contract.
If there is no associated stop order, the value of this field is |