View Historical Profit and Loss of Trades

This activity presumes that the trading settings include creating a copy of trade profit and loss (P&L) each day. See Specify Trading Settings.

Security Note: You need the Allow the user to view the Trade Explorer security right in the Menu user group security rights group for this activity.

Activity Steps

  1. Open the Trade Explorer.
  2. To view the total P&L for each day, set the View to Historical Total.
  3. To view the mark-to-market P&L (the difference in P&L from day to day), set the View to Historical MTM.
  4. Select the P&L Start Date and P&L End Date.
  5. Enter the remaining search criteria as required.
    • Calculation Errors Only
    • Trade Name
    • Statuses
    • Organisations
    • Companies
    • Material Type
    • Products
    • Locations
    • Analyte Group
    • Reference Date
    • Start Date
    • End Date
    • Search By
    • Search Text
    • Include Date Range
    • Contract Contacts
    • Variance Category
    • Variance Subcategory
    • Variance
    • Variance Unit

    Note: See Find Trades for descriptions of these search criteria and the columns in the Trades table.

  6. Click Search or press F3.

    Note: The name of any set of mark-to-market (MTM) terms is the name of the set of MTM terms currently assigned to the despatch order. P&L amounts may have been calculated with a different set of MTM terms if the MTM has been changed on the despatch order.

    Note: The search cannot exceed the Trade Explorer Data Retrieval Threshold. See Specify Trading Settings.

  7. To recalculate the P&L:
    1. If the P&L for the trade on that date exists, right-click the P&L and select Queue Historical Recalculation from the menu.
    2. If the P&L for the trade on that date does not exist, right-click the empty table cell and select Queue Missing P&L Calculation from the menu.
    3. To recalculate the P&L for all trades missing a P&L on a date, right-click the date in the table header row and select Queue Missing P&L Calculation from the menu.

      A message about saving displays.

    4. Click OK.
    5. Click Save.

      Note: P&L cannot be recalculated for the current or a future date, nor for a date before the first available snapshot of the despatch orders in a trade. When recalculating P&L for a date, MineMarket only recalculates the P&L for trades that match the current search criteria.