Forex P/L Details

This section shows your Forex transactions, including any activity in a non-functional currency. This includes opening and closing transactions, which include closed lot details. If there is more than one closed lot, you can expand the row to display closed lot details.

Data is based on your functional currency. Totals for Proceeds, Basis and Realized P/L in your functional currency appear at the bottom of the section.

The following rules apply to this section:

  • Data is available from January 1, 2013.
  • This section is not available in consolidated statements.
  • This section is available in Advisor client statements but not in Advisor statements.

Proceeds and Cost values are computed as follows:

  • Proceeds will always be positive and Basis (Cost Basis) will always be negative. The open lot cost basis will match the transaction cost basis for buys and sells and will match the transaction proceeds for cover and sell short.
  • For a transaction that is partially opening and partially closing, the row will display both O and C in the Codes column and will include an Opening Lot Summary row in the expanded lot details.
Column Description
Account Account Number (ID)
Description The description of the activity.
Date/Time The date and the time of the activity.
FX Currency The non-functional currency involved in the activity.
Quantity The number of units in the activity. When gaining currency, quantity is positive and when losing currency, quantity is negative.
Proceeds (in your functional currency)

The proceeds in your functional currency resulting from the activity. Proceeds will always be positive.

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.

Proceeds equals quantity * the conversion rate from non-functional currency to functional currency for the report date of the transaction.
Basis (in your functional currency) Cost basis, or the inverse of the proceeds (proceeds negated). This will always be negative.
Realized P/L (in your functional currency) The realized profit and loss from the transaction or activity in your functional currency.
Code The code abbreviation.