11. Create/Manage Quantitative Models & Reports

Owned by IT Support
Last updated: May 30, 2023
5 min read

Input Physical Trades Data

The New Physical Trade function allows users from different departments/teams to access the designated pages to input their data, ensuring a consistent operational workflow and clear delegation of responsibilities for different teams.

Please note that all data input in New Physical Trade will appear in the old Physical Trade page, and vice versa. Trades created in the New Physical Trade page will have their Actions column button disabled, which disallows editing of the trades in the old Physical Trade page.

Alternatively, you may choose to use the old methods to input your data:

1. Manually input physical trades, please access: Input Physical Trades Manually

2. Bulk upload physical trades, please access: Physical Trades 101 - Bulk Upload

11. Create/Manage Quantitative Models & Reports

Dashboard - Individual

You must first input paper trades and physical trades data to generate the following figures:

1. Positions and P/L data: Positions and P/L data (including any commission, expense and income and other costs, etc.) are calculated after paper trades and physical trades data are input.

  • Input data such as positions, price and commission etc in Paper Trades and Physical Trades

  • Input data such as expense and income items and other costs etc in General Ledger . When selecting Type in the table, please choose EXP/INC and input:

    • Expense/Costs: Negative value eg -100

    • Income: Positive value eg 100

Please assign the trade/item to tag them to the corresponding portfolio before saving the data. The system will then automatically calculate the positions and P/L according to your data and display in the model/report accordingly.

 

2. Initial Fund, Fund In/Out data: If necessary, you may input as follows:

  • Paper Trades: Please upload or manually enter data in Portfolio>General Ledger>FCM Statement

    • Please select FCM under FCM TYPE column, and then enter data such as margin, total equity, collateral etc.

  • Physical Trades: Please upload or manually enter data in Portfolio>General Ledger

    • Initial Fund: In General Ledger page, please select INIT FUND under TYPE column and enter the data accordingly

    • Fund In/Fund Out: In General Ledger page, please select FUND IN/OUT under TYPE column and enter the data accordingly

Please assign the trade/item to tag them to the corresponding portfolio before saving the data. The system will then automatically calculate the positions and P/L according to your data and display in the model/report accordingly.

 

a. After allocating paper trades (and physical trades) into the portfolio, you may create quantitative models and reports to determine the performance of your portfolios/trades. Please click on Dashboard>Individual from the navigation sidebar on the left to access the Dashboard page.

 

b. Various quantitative models/reports can be created and displayed in the dashboard. If you need to customise any models/reports, please notify us at support@mafint.com. You can select a model/report in the drop-down list and click 'Create' to create a new model/report.

The model/report you have just created will be displayed as empty at the beginning, which requires you to set up the details by clicking on the Settings (gear icon) button at the top right corner of the app.

 

 

c. Most Dashboard Models/Reports have similar steps. You may choose to select individual or multiple portfolios to be calculated and displayed. Please confirm other details in the Settings page before clicking Submit to proceed. You may edit the details anytime as necessary.

You may filter, arrange and categorise the rows, columns and groups according to your preferences, and may also enlarge the window accordingly.

Public/Proprietary:

PUB (PUBLIC) MARKET PRICE: If selected, the system will use the public market/settlement price obtained from various Exchange sources to perform calculations

PTY (PRIVATE/PROPRIETARY) MARKET PRICE: If selected, the system will use the proprietary market/settlement price that you have input/uploaded in Proprietary Market Data

 

Auto-Update：

Tick: Resets the dates to default once you leave the ‘Dashboard’ page.

Untick: Dates according to your settings remain unchanged once you leave the ‘Dashboard’ page.

 

 Historical GPPL (related to Historical Group P/L app)：

The Historical check box in Settings page is used to determine if you want the Compare Date to use Existing Calculated Data or Historical Saved Data for P/L comparison. This means that if you have saved the historical data for the specific End Date, you may:

  • tick the Historical check box to compare End Date data against Compare Date (use historical saved data) - Compare with historical Group P/L data - Historical Group P/L data will be stored in database on a daily basis and once stored, it will not be updated. (MAF will only update for yesterday data so once user reload the Group P/L app, MAF will insert or update data if the end date is yesterday).

  • untick the Historical check box to compare End Date data against Compare Date (use existing calculated data) - Compare with Group P/L from open position calculation - Daily change of open position result will always use the latest position data to do calculations

  • If historical data is not available (no data is saved for the specific End Date), the respective CHG will remain as empty or 0 or the app will display a message (NO VALID OPEN POSITIONS).

 

For more information, please refer to Guide to Dashboard.

 

Physical Trades App/Reports Lists

 

Physical Trade Inventory App/Reports Lists

Please refer to Physical Trades - Dashboard Models/Reports Summary to learn more.