Outstanding Physical Trade Matrix
- IT Support
- MAF Intern (Unlicensed)
Return to Overview
About
The Outstanding Physical Trade Matrix provides an overview of all of your uncompleted/outstanding physical trades, display the outstanding quantity (value is more than 0 or value is 0 but unrealised P/L is not 0) and contract details accordingly. You will be able to filter the data using start and end date, based on 'Contract Date'. This is directly extracted from the table in the TRADES tab.
All your outstanding physical trades and their outstanding quantity will be displayed. The rows are the various products in the portfolio while the columns indicate product information such as Trade ID, Deal No., Contract No., Contract Type, Trader, Trade Date, Entity of Contract, Purchase/Sale, Counterparty, Product, Specification, Quantity, Outstanding Quantity, Unit.
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.
Navigation
To access the quantitative model/report, click on 'Dashboard' from the navigation sidebar on the left.
Select the model/report from the drop-down list and click 'Create'. Click on the 'Settings' button (gear icon) at the top right corner of the model to set up your model/report.
Sharing Model/Report/Dashboard
To share the model with your group members, click on the "Share" button next to the Title of the model followed by the email address of the group members you want to share it with. Once submitted, the model will appear in the Dashboard>Group Dashboard of the selected group members.
This is different from sharing individual or entire Dashboard models/reports, which allows any user who may or may not be users of MAF Cloud to access the individual model/entire dashboard via the shared web link (link will expire in 8 hours). In Group Dashboard, only group members can access the shared models/reports.
Group Rows
You may also group the rows (liken to the pivot table function in Microsoft Excel) to view the grouped data by dragging any column headers into the “row groups” section as highlighted:
Guide
Name | Images/Description |
|---|---|
Outstanding Deals | All outstanding deals (value is more than 0 or value is 0 but unrealised P/L is not 0) will automatically be displayed |
| Duration |
Select the start and end date to determine the range of period and cut-off date for the calculations of P/L. Start Date will be empty by default. You are free to fill in as necessary. End Date will be today's date by default. You are fill to edit the dates as necessary. |
Comments |
The inserted comments will be displayed at the bottom of the application. This can be useful for documentation purposes or for settings description. |
Input
Name | Description | Type | Example |
|---|---|---|---|
| Start Date | Start of product time-series (based on Contract Date). Empty by default, you are free to fill in as necessary. | Date (YYYY-MM-DD) | 2019-06-01 |
| End Date | End of product time-series (based on Contract Date) Today's date by default. | Date (YYYY-MM-DD) | 2019-06-30 |
| Comments | Useful for documentation purposes or for settings description. | Text | - |
Output
Description | |
|---|---|
Outstanding Physical Trades | Deal details are indicated in the columns: Trade ID, Deal No., Contract No., Contract Type, Trader, Trade Date, Entity of Contract, Purchase/Sale, Counterparty, Product, Specification, Quantity, Outstanding Quantity, Unit. You can reorganise the way the data is displayed by clicking on the header of each column. |
Example
Functionality
- Please refer to Table Settings for table functionalities.
Definition of Terms
Please refer to List of Definitions: Trades.
Click to access: