Steps:
1. Set up Company Profile
Settings>Company>Company Profile
a. As the physical trade contracts need to be linked to the Company Name, before you use the Physical Trades function, you may need to set up your company profile first (including parent and subsidiary company details).
The user can set up a company, or multiple companies, and the first company to input in the page has to be the Parent Company. A company can have many groups under its management, and many group members can be invited under each group. The data input by each group member can be shared to and used by other members in the same group. Please refer to Step 3. Set up Group for more details.
You may also notify MAF team (support@mafint.com) to assist you to set up your company profile, by filling in the attached file. |
Once the Company Profile Creator has login to the portal, please click on Settings>Company>Company Profile.
b. Please input the details (only fields with * are compulsory) and click on Save Details once done. Relevant fields input in this page will appear in the Physical Trades function for your convenience. Once members have been added to the same group as the Company Profile Creator, the members' Company Profile page will be auto filled according to that of the Company Profile Creator, so the members need not input the company profile on their own. Please refer to Step 3. Set up Group for more details.
For more information, please access Company Profile .
2. 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.
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: |
a. Input Basic Physical Trades Data in New Physical Trade (Trade)
i. Please click on Trade, followed by New Physical Trade from the navigation sidebar on the left to enter the physical trade page,
ii. Please click on + New Trade and a new row will be added for you to input your data. Please refer to the definitions below for more information.
Trade ID：Input is not required, once you save your trade data, the Trade ID will be generated automatically
Trade Date*：Trade date of the contract
Product*：Product name, for example Corn
Specification：Product specification, you may fill in for your reference if necessary, eg Product is Rubber and specification is XX1
Entity of Contract*：Name of your company (can be input in Settings>Company>Company Profile page)
Counterparty*：Counterparty name
Contract No.：Every purchase and sale contract should have its own contract number
Purchase/Sale*：Purchase/Buy or Sale/Sell
Match No.: Assign the same match number to the corresponding purchase and sale contracts for your reference
Contract Delivery Date: Contract delivery date
Trader：Name of trader
Trade Mode *：
Offshore refers to offshore contracts - Cannot input for Tax Rate, Exchange Rate and Custom Tax Rate
Domestic China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate
Delivery China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate
Import/Export refers to import/export contracts - Can input Tax Rate, Exchange Rate (If Deal Currency and Product Currency are different) and Custom Tax Rate
Basis Trade China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate
If an offshore company imports/exports, there are 3 trades contracts involved:
Offshore companies purchase from suppliers - Offshore
Offshore companies sell to domestic companies (exported by offshore companies) - Import/Export
Domestic companies purchase from offshore companies (imported by domestic companies) - Import/Export
Quantity*：Contract quantity
Unit*：Unit of contract/product eg metric ton
Contract Pricing Date: Contract pricing date
Margin: Collateral value deposited with the counterparty
Provisional Price: Temporary price, will be used to calculate P/L if Estimated Price or Actual Price is not available yet. The system will follow this order of priority to calculate P/L if the price is available: Actual Price - Estimated Price - Provisional Price
Pricing Date：Pricing Date
Execution Status: Status of contract eg settled, pending etc
Stock Date: The latest stock in/stock out date recorded in Stock Management Function
WH Name & Status: Name of warehouse and Stock Type recorded in Stock Management Function will be automatically reflected here
Stock Qty: Stock In/Out quantity that has been recorded in Stock Management Function
Unstock Qty: Stock In/Out quantity that has not been recorded in Stock Management Function, Un-stocked Quantity = Quantity - Stock Quantity
PSL Amt: PS Ledger amount with PSL Type: Payment recorded in PS Ledger will be automatically reflected here
PSL Date: PS Ledger date with PSL Type: Payment recorded in PS Ledger will be automatically reflected here
Bal Amount: Balance Amount = Trade value - PS Ledger Amount will be automatically reflected here
Inv Qty: Invoice quantity with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here
Inv Amt: Invoice amount with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here
Un Inv Qty: Un-Invoiced Quantity = Quantity - Invoice Quantity will be automatically reflected here
Un Inv Amt: Un-Invoiced Amount = Trade Value - Invoice Amount will be automatically reflected here
Remarks：Remarks
Once done, please click on Save Changes to save your data.
b. Input Pricing Data in New Physical Trade (Settlement)
old bulk insert and update do not support exchange rate date.
only new settlement insert and update do.
only trade with trade mode == import/export is allowed to have ex rate date.
Once done, please click on Save Changes to save your data.
c. Input Stock/Inventory Data in Stock Management
Please refer to Stock Management Function for the user guide.
Once stock data has been input, the following columns for each trade in the New Physical Trade table will be reflected automatically.
Stock Date: The latest stock in/stock out date recorded in Stock Management Function
WH Name & Status: Name of warehouse and Stock Type recorded in Stock Management Function will be automatically reflected here
Stock Qty: Stock In/Out quantity that has been recorded in Stock Management Function
Unstock Qty: Stock In/Out quantity that has not been recorded in Stock Management Function, Un-stocked Quantity = Quantity - Stock Quantity
d. Input Payment and Invoice Data in PS Ledger
Please refer to Managing Physical Trades for the user guide.
Once PS Ledger data has been input, the following columns for each trade in the New Physical Trade table will be reflected automatically.
PSL Amt: PS Ledger amount with PSL Type: Payment recorded in PS Ledger will be automatically reflected here
PSL Date: PS Ledger date with PSL Type: Payment recorded in PS Ledger will be automatically reflected here
Bal Amount: Balance Amount = Trade value - PS Ledger Amount will be automatically reflected here
Inv Qty: Invoice quantity with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here
Inv Amt: Invoice amount with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here
Un Inv Qty: Un-Invoiced Quantity = Quantity - Invoice Quantity will be automatically reflected here
Un Inv Amt: Un-Invoiced Amount = Trade Value - Invoice Amount will be automatically reflected here
3. 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.
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:
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.
Add Comment