Closed Trades (table)

Brief

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.

Details

Name

Type

Description

TradeID

String

The unique identification number of the position. The number is unique within the same database that stores the position account. For example, MINIDEMO or U100D1. The uniqueness of the position itself is assured by the combination of the database ID and the value of this field. It corresponds to the TradeID field in the Trades table.

AccountID

String

The unique identification number of the position account. The number is unique within the database where the account is stored. For example, MINIDEMO or U100D1. The uniqueness of the account itself is assured by the combination of the database ID and the value of this field.

AccountName

String

The unique name of the position account. The name is unique within the database where the account is stored. For example, MINIDEMO or U100D1. The uniqueness of the account itself is assured by the combination of the database ID and the value of this field. It is the name that the FX Trading Station displays to its user.

AccountKind

String

The type of the position account. The possible values are:

32

Self-traded account, funds manager account (only LAMM), managed account (only LAMM).

36

Funds manager account (only PAMM).

38

Managed account (only PAMM).

OfferID

String

The unique identification number of the instrument traded.

Amount

Integer

The amount of the closed 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:

B

Buy.

S

Sell.

GrossPL

Double

The profit/loss of the position. It is expressed in the account currency.

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 commission has not been charged, the value of this field is 0.0.

RolloverInterest

Double

The cumulative amount of funds added to 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 0.0.

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.

OpenQuoteID

String

The unique identifier of the pair of prices (bid and ask) the position is opened at.

OpenTime

Date

The date and time when the position is opened.
The time zone is defined by the system properties SERVER_TIME_UTC and BASE_TIME_ZONE.

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, MINIDEMO or U100D1. The uniqueness of the order itself is assured by the combination of the database ID and the value of this field.

OpenOrderReqID

String

The unique identifier of the order request the position is opened by (see RequestID column in the Orders table).

OpenOrderRequestTXT

String

The custom identifier of the order the position is opened by (see RequestTXT column in the Orders table).

OpenOrderParties

String

The unique identifier of the environment that is used to open the position. The identifier is generated by ForexConnect.

CloseRate

Double

The price the position is closed 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.

CloseQuoteID

String

The unique identifier of the pair of prices (bid and ask) the position is closed at.

CloseTime

Date

The date and time when the position is closed.
The time zone is defined by the system properties SERVER_TIME_UTC and BASE_TIME_ZONE.

CloseOrderID

String

The unique identification number of the order the position is closed by. The number is unique within the same database that stores the account the order is placed on. For example, MINIDEMO or U100D1. The uniqueness of the order itself is assured by the combination of the database ID and the value of this field.

CloseOrderReqID

String

The unique identifier of the order request the position is closed by (see RequestID column in the Orders table).

CloseOrderRequestTXT

String

The custom identifier of the order the position is closed by (see RequestTXT column in the Orders table).

CloseOrderParties

String

The unique identifier of the environment that is used to close the position. The identifier is generated by ForexConnect.

TradeIDOrigin

String

The unique identification number of the position, the partial closing of which results in the opening of the current position. Otherwise, the value of this field is blank.

TradeIDRemain

String

The unique identification number of the position opened as the result of the current position partial closing. Otherwise, the value of this field is blank.

ValueDate

String

The simulated delivery date. The date when the position could have been automatically closed. It is provided in the yyyyMMdd format.
This field is applicable for positions opened on accounts with the day netting trading mode (see MaintenanceType field in the Accounts table).

back