Trades

The archive of all the exchange's buying and selling. Each row is one trade, with type (buy/sell), currency and amount, rate, counterparty, fee, profit, and trader. This page is both for "finding" and for "correcting".

Where This Page Fits

• Record a new trade: Currency Buy & Sell or Cash Buy & Sell.
• Clicking the voucher number opens the full voucher page (adjust/cancel from there).
• Aggregate stats are in P&L, Trader Commission, and Customer Profit.

Working With the List

• The form above the table only carries a date range and grouping; every other filter (currency, counterparty, type, amount, rate, fee, profit, trader, recorder, voucher search) lives in the filter row under the column headers. Excel/PDF export is built with those same active filters.
• The "Currency" column is a selector defaulting to "All currencies"; the "Profit" column offers Profitable / Loss-making and the "Fee" column offers Incoming / Outgoing / No fee.
• Column order follows the traditional ledger style: type, currency, amount, rate, against, opposite amount.

Notes

• Adjusting a trade doesn't erase the earlier voucher; an "adjusting voucher" is issued so the full trail remains (a reversal).
• "Changing the trader" doesn't touch the books and is only for the commission report; it's recorded in the activity log.
• The "Currency" column filter brings up trades where that currency is on either side; the "Against" column filters exactly the counter-side currency of the row.
• When grouping is on, rows are ordered by the group key first and the column sorting applies inside each group.

Table Filtering and Sorting

• There is a filter row right under the column headers: in a text column type part of the value, in a numeric column give a "Min" or a range ("100-500" means between the two, "-500" means at most 500), in an option column pick from the list. The filter applies to every record on the server, not just the page you are looking at.
• Column headers carrying the ⇅ mark sort when you click them: ⇅ neutral, ▲ ascending, ▼ descending.
• Changing a column filter, the sorting, the page or "per page" happens without reloading the page: only the table body is swapped, so your filters and scroll position stay put. The page address only changes with the filters in the form at the top of the page (date range and grouping).
• Active filters are kept while you page through the list, and the Excel/PDF export sees exactly the same ones. To clear one, empty the field or leave the "All" option.
• On mobile the less important columns are folded away; the round + button at the start of each row opens the rest of the information as "label: value".

Excel and PDF export

Both exports look the same: a dark header with the report and exchange name, an info card (report filter — the very date range and search active on the page — and the generation date), a cream header row, and borders only around cells that contain data.

• Excel: the date, time and Gregorian date columns (a real Excel date, for sorting and formulas) come first in the table. The header row is frozen and the amounts are real numbers in Latin digits, so you can write formulas straight on them. The colors mean the same as they do on the page.
• PDF: the same layout, but without the Gregorian date column — space is tight in a PDF.

Reference-rate columns: for every trade, each side's rate against the reference currency is stored at booking time and shown in the "Reference rate" and "Counter reference rate" columns — trades older than this feature show a dash. Both columns support range filtering and sorting like the rest, and appear in Excel/PDF exports.

The “Average” column

With the “Profit & loss report” permission, an “Average” column sits next to the profit column: the average cost of the sold currency at the moment of the trade (in the reference currency), i.e. the figure the profit was measured against. The “Mixed” badge means part came from the holding and part opened a new short; “Short” means the sale happened while short (no realized profit); “Cover” means a purchase that closed a short, and the figure is the short’s average sale rate. A dash means it was not recorded for that trade (older trades whose history could not be replayed exactly). The column is included in Excel and PDF exports and supports numeric sorting and filtering.

• Column order: the trade’s own facts first (type, currency, amount, rate, counter currency, counter amount, fee, people, date) and the profit-calculation columns last (reference rates, average, profit). Related columns share a light background: the traded currency with its amount and rate in blue, the counter currency with its amount in amber, calculations in grey; each group starts with a separator line.