Run a Profit and Loss Report

Security Note: You need the Allow the user to edit Profit and Loss reports security right in the Intelligent Reporting domain security rights group for this activity.

Activity Steps

  1. Open the Profit And Loss Report.
  2. Update the following fields as required.
    • Name
    • Date—The report displays the historical profit and loss applicable for this date.
    • Comments
  3. Select the Results tab.

    There are two buttons on this tab:

    1. Search—Searches for trades that match the parameters of the Profit and Loss report. If adjustments have been added to the profit or loss of individual trades for the report, the adjustments are retained.
    2. Clear—Clears all trades from the Profit and Loss report, including any adjustments that have been added to the profit or loss of individual trades for the report.

    The buttons are only enabled if the Profit and Loss report is unlocked.

  4. Click Search or press F3.

    The profit and loss displays for trades that match the parameters of the report. For descriptions of the profit and loss line items, see Trade Profit and Loss.

    Note: You can filter the data displayed in this table. See Sort, Filter and Group Data in Tables. Clicking a hyperlinked trade name opens the Trade Detail for the date of the Profit and Loss report. If no historical P&L exists for that date, the Trade Detail displays the flash P&L.

  5. Enter a Comment for each trade as required.
  6. To factor the impact of a trade on profit and loss and journal entries, enter a Factor for the trade.

    The multiplication factor (as a percentage) affects all values in the trade and its profit and loss. If a factor is applied, only that percentage of the values contribute to the journal entries for the trade profit and loss.

  7. To prevent further adjustments to a trade, check Locked for the trade. If checked, the trade:
    • Is included in the Total Locked row in the summary of trades (if it is not Excluded)
    • Cannot have adjustments added, edited or cleared in the Profit And Loss table
  8. To exclude a trade from the report summary and from journal creation, check Excluded for the trade.
  9. Click Save.