Forex P/L Details

This section shows your Forex transactions, including any activity in a non-functional currency. This includes opening and closing transactions.

The following rules apply to this section:

  • Data is available from January 1, 2013.
  • This section is not available in consolidated statements.
Column Description
Account ID The account number.
Account Alias Account alias, if there is one.
Model Model, if applicable.
Asset Class The asset class.
Report Date The date of the statement.
Functional Currency The abbreviation of the functional currency of your account.
FX Currency The abbreviation of the non-functional currency involved in the activity.
Activity Description The description of the activity.
Date/Time The date and the time of the activity.
Quantity The number of units in the activity. When gaining currency, quantity is positive and when losing currency, quantity is negative.
Proceeds

The proceeds in your functional currency resulting from the activity. For closed lots, this is the proceeds of closing against the cost of opening. For transactions, proceeds are as follows:

  • For spot trades, the amount is the value of the nonfunctional currency expressed in your functional currency using the spot rate on the trade date.
  • For securities trades, the amount is the value of the nonfunctional currency expressed in your functional currency using the spot rate on the trade date.
  • For interest, dividends or deposits, the amount is the spot rate on the day of the transaction.

When gaining currency, proceeds are positive and when losing currency, proceeds are negative. Proceeds equals quantity * the conversion rate from non-functional currency to functional currency for the report date of the transaction.
Cost The inverse of the proceeds (proceeds negated).
Realized P/L The realized profit and loss from the transaction or activity in your functional currency.
Code The code abbreviation.
Level of Detail Transaction or Closed Lot.

 

Level of Detail

As part of setting up the Forex Transactions section for your Activity Flex Query, you select one or more Levels of Detail for data in this section from among the following choices:

  • Transaction
  • Closed Lots