Position Matrix

Return to Overview

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.

About

The Position Matrix displays all paper and physical trades with open net positions. Please note that only open positions will be displayed in the Position Matrix. Open positions refer to trades without actual price but with/without title transfer dates. This means that any trades with actual price will be considered closed and not show in the Position Matrix. This works differently from the open positions in the portfolio page where trades without actual price and/or title transfer date will remain open.

The rows are the various products in the portfolio, while the columns indicate product information such as exchange, product type, contract type, time to maturity, and their net positions. In this model, the user can create customised 'strategies', such as spread positions of futures with different maturities. The user can choose if the effect of the additional strategies will be shown (see: Creating a Strategy Product).

(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:

The data in the table will be grouped according to your setting and you may drag multiple column headers into the “row groups” section to group them as necessary.

Guide

Name	Image/Description
Portfolio	Select a/multiple portfolio(s) of interest.
Aggregation Type	Combination - If this aggregation type is selected, the system will categorise and combine all the trades with the same following details to the position: Contract ('Exchange', 'Product Name', 'Contract Code') Trade Type ('Benchmark', 'Potential', 'Premium') Separate - This is the default setting. If this aggregation type is selected, the system will categorise and combine all the trades with the same following details to the position: Contract ('Exchange', 'Product Name', 'Contract Code') Trade Type ('Benchmark', 'Potential', 'Premium') Account ('Account' is case-insensitive and is one of the elements for grouping trades to position. You can fill in the 'Account' column when creating or editing your paper trades.) None - If this aggregation type is selected, the trades will not be categorised and combined, and will be displayed individually.
Group Sum	Allow user to opt to auto sum group rows: Tick: When group rows, tick Group Sum check box to auto group sum month/year columns Untick: When group rows, untick Group Sum check box to not auto group sum month/year columns Default will be unticked
Swap Flag	Add Swap Flag button Background: some of products position will be changed based on platts in the near month (e.g., now it is Aug 2022, and for 17 Aug 2022 contract position) set up product property under holiday group in product data table by MAF Admin (e.g., SGX/FEF holiday group is platts_sg_metal) only product with holiday will be considered. the near month contract position will be changed on working day (excluding platts holiday and weekend) how to check platts holiday: Pricing Holiday Schedule platts_sg_metal holiday will track all Singapore public holiday how is the position calculated? remaining business days of current month (excluding platts holiday, weekend and today date ) whole month business days of current month ratio = remaining / whole e.g., test2, testing server, 期货一部 aug 2022 SGX/FEF size = 100 remaining days = 10 whole days = 22 (09 Aug is Singapore holiday based on Platts) the ratio = 10 / 22 once tick SWAP FLAG, the position size will change from 100 to 45.4545
Position Conversion	Add positions conversion based on trades ADD button to add new row and DEL button to delete existing row three columns PRODUCT select from product dropdown list show product name must must be unique (can not duplicate PRODUCTS) CO number to fill up support negative sign must EQ PRODUCT select from product dropdown list show product name must For example, if any position conversion, e.g., ‘SGX IRON ORE, 0.5, 'SHANGHAI REBAR' then in table, SGX IRON ORE position will time 0.5 and EQ product will be SHANGHAI REBAR if no position conversion: then in table SGX IRON ORE position no change, and EQ product will be SGX IRON ORE Add one more column called EQ_product after Product column to show converted product
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

	Description	Type	Example
Portfolio	Portfolio of interest.	Portfolio (Selection)	ABC
Aggregation Type	Type of aggregation to be used.	Type	Combination
Strategy Product(s)	Strategy products to be evaluated together according to the aggregation type.	Product	Coffee, Sugar
Comments	Useful for documentation purposes or for settings description.	Text	-

Output

The output table shows the net positions of each contract of the portfolio, with the following information:

Name	Description	Type
Product/Strategy Information	The details of product(s) are indicated in the first 3 columns, which include the product name, broker, account, instrument and type of product(s). For strategies, these were manually filled in by the user when creating the strategy. You can click on the Unit dropdown list and select the units you want your trades to be displayed in. If PHYSICAL is selected, it will show the positions quantity in its original physical units, whereas METRIC TON will show the positions quantity calculated in metric ton. FORMULA PRICING: You may also tick the checkbox of the Decompose button to break down your trades (if their pricing method is FORMULA) into their financial products. default untick, tick setting cached into BE db apply to share API and also group dashboard To check: check individual dashboard, group dashboard, share dashboard and share app check if tick reset API: decompose = True if tick else False check decompose logic: if any formula position or paper trade, will decompose into financial products. After decomposing, quantity will be in paper lots. 1 lot = 100 MT. all spec, pricing_var, sub_var will be ignore if the formula variables do not have any financial products, the trade will not appear if click on “decompose” if variable sign is +, position sign is the same as formula position if variable sign is -, position sign is different as formula position You may also hover your mouse over the Formula Name and the relevant formula variables and calculations will be displayed in a pop-up.	Text
Product/Strategy Positions	The remaining columns display the positions of the products and/or strategies; they are arranged in chronological order, with the month indicated at the heading of each column.	Number

Please note that once the positions have expired, they will not be shown in the model. You can go to View Portfolio to view all your open and closed positions.

Example

For example,

Buy 1 contract with trade type: speculation

Sell 1 contract with trade type: hedge

Put them into same portfolio and in Position Matrix, if Separate in Aggregation Type is selected, the trades will show separately like this:

If Combination in Aggregation Type is selected, the trades will net off and will not appear in the Position Matrix like this:

Functionality

Unit Selection: Users may choose the units (default, lots, barrels etc.) in which the position sizes are to be displayed.
Please refer to Table Settings for table functionalities.

Click to access: