Page Comparison

Return to Overview

...

The Group P/L model provides an overview of all trades and their total P/L, with daily change in P/L, commission and expenses/income details displayed for your convenience. To categorise the trades according to your needs, you can reorganise your data by dragging-and-dropping the columns at the top of the table to 'set row groups'. Columns like daily change in P/L, commission and expenses/income will be summed up accordingly.

The 'Start Date' will be 1st day of the year (1 Jan 2021) by default and 'End Date' will be today's date by default. You can select the cut-off date ('End Date') to determine your P/L for that period and the close/settlement date of each trade is crucial as it will determine which month/year's P/L it will belong to. 

The rows are the various categories of assets in the portfolio while the columns indicate product information such as portfolio name, trader and total P/L. The table acts like a pivot table and can be categorised and organised by groups according to your needs. You can click here to learn how to customise the table by arranging and filtering the columns based on your preference, and saving the table layout(s) as a template. Also see Futures Contracts Codes for more information on exchange and month codes, if required.

Note: For expense/income items to appear in the expense/income column, you will be required to select the contract number to be linked to the specific expense/income item in the expense/income table.

When you group any header rows, and click on "Save", a successful pop up message will appear and the header row remains in the grouped row.

...

...