The "Transaction list" evaluation
The "Transaction list" report lists all transactions of a holder (or portfolio). By default, this table is grouped by holders/portfolios and accounts.
Proceed as follows to open the transaction list of a holder:
- If necessary, first use the search function at the top right of the ribbon to search for the owner to be analyzed.
- Open the workspace of this owner by double-clicking on it in the search result.
- Then switch to the transaction list in the worksheets, which you will find (as delivered) on the "Transactions" worksheet.
The most important columns in detail:
Column | Description |
|---|---|
Date, time | Time of the transaction. |
Type | Transaction type (purchase, sale, dividend, fixed-term deposit...). |
Securities | The security or note affected by the transaction (e.g. in the case of bookings). |
Nominal value | Number/nominal value of the security for this transaction. |
Order price | Price at the time of the order. |
Amount accounted for | Amount in the trading currency. The amount payable includes any expenses, fees and taxes. |
Amount to be paid | Amount in the account currency. |
Profit and loss statement [account] | Profit or loss in the account currency. |
Booked by | In this column you will see the name of the user who recorded the transaction. This column is hidden by default. You can find out how to show columns in the chapter Tables. |
Cancellation? | In this column you can quickly find the transactions that have already been canceled. These have the entry "yes". |
Execution venue | If you have specified a trading venue when entering the underlying transaction, e.g. a purchase, the venue will appear in this column. |
| MLA user | The Infront Portfolio Manager user who entered the Money Laundering Act commentary for this transaction. |
| MLA date | The date on which the Money Laundering Act commentary on this transaction was recorded. |
| MLA Commentary | The text entered in the comment field of the Money Laundering Act commentary for this transaction. |
| MLA compliance user | The Infront Portfolio Manager user who entered the Money Laundering Act compliance comment for this transaction. |
| MLA compliance date | The date on which the Money Laundering Act Compliance Commentary was recorded for this transaction. |
| MLA Compliance Commentary | The text entered in the comment field of the Money Laundering Act Compliance Commentary for this transaction. |
| MLA compliance status | The current anti-money laundering compliance status of the transaction. |
Issue surcharge [account value] | These and other columns, which are hidden by default, are used in particular to fulfill the MiFID requirements for detailed disclosure of transaction costs (in account currency). |
Double-clicking on a transaction opens the "Resubmission" dialog box, in which you can edit the selected order or posting. You can also find the REPLACE command at the top of the context menu of the selected line.
Incidentally, this also works in other tabular evaluations such as the yield statement.
In the context menu of the transactions or lines, you will find further useful commands - e.g. for linking transactions to orders.
Siehe auch: