Input Physical Trades Manually

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/Upload Physical Trades

You may choose to:

1. Manually input physical trades, please refer to below steps, or

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

 

a. Please click on Trade, followed by Physical Trade from the navigation sidebar on the left to enter the physical trade page,

 

b. Please click on + New Trade and you will be directed to a new physical trade page for data input.

 

c. You may choose the Product Group of your trade at the top left corner of the page 

and the fields to be filled in physical trade page and physical trade execution page will be adjusted accordingly to the product group you select (please remember to save the page for the product group to be saved successfully):

  • Default (for all product group except iron ore)

  • Iron Ore (includes all fields in default layout except Packer details, Laycan Period, all items from Laytime (Hours) to GT&C). After you have selected Iron Ore, the Pricing Mode in Benchmark Pricing and MTM Pricing page will automatically display Formula option for calculating the prices of iron ore products. Please refer to Formula Pricing Guide to learn more.

Once you select, the Product Group will remain as your selection until you change. You may return to this trade's page by clicking on the Edit/View button and change the product group, and the fields to be filled in physical trade page and physical trade execution page will be adjusted accordingly.

 

Please refer to below guide and input the details as necessary.

 


Description (Only fields with * sign is compulsory; fields with ^ means you only need to fill in either one - Benchmark Pricing or Fixed Pricing. Once you have made your selection, the relevant fields compulsory to fill in will be updated accordingly)

 

bi General Information

  • Deal ID:Input is not necessary, once you have saved your deal/contract, Deal ID will automatically be generated

  • Deal No. *:A deal includes one or more purchase and sale contracts. All purchase and sale contracts allocated to the same deal number will be matched with each other to calculate the net positions and P/L. Deal number is also considered a portfolio/trading book, and can be found in the Portfolio page.

  • Deal Currency*:Select the deal currency for calculating the P/L of all contracts under the deal number. The deal currency selected here will be used to calculate the P/L of all the purchase and sale contracts allocated to the deal number, which may be different from the product currency (after you select your product, the product currency is automatically displayed in the Benchmark Pricing and MTM Pricing page). For example, if the deal currency is USD and the product currency is CNY, the system will also be able to automatically convert the products with CNY to USD according to the exchange rate of the day to calculate the P/L. You will thus be able to view the P/L calculations of the deal based on the different currencies in the portfolio page.

  • Contract No.:Every purchase and sale contract should have its own contract number

For Example:

  • Deal No.

    • Contract No. 1

      • Trade Execution No. 1.1

      • Trade Execution No. 1.2

    • Contract No. 2

      • Trade Execution No. 2

  • Contract Type : For reference only, you may leave it empty

    • Spot:Spot contract

    • Term:Term contract

  • Trader:Name of trader

  • Counterparty Reference No. :Reference number of counterparty, for reference only, you may leave it empty

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

1. Offshore companies purchase from suppliers - Offshore

2. Offshore companies sell to domestic companies (exported by offshore companies) - Import/Export

3. Domestic companies purchase from offshore companies (imported by domestic companies) - Import/Export

 

  • Broking Details:

    • Broker: Broker name

    • Broking Ref No.: Broker reference number

 

bii. Trade Details

  • Trade Date*:Trade date of contract

  • Entity of Contract*:Name of your company (can be input in Settings>Company>Company Profile page)

  • Buy/Sell*:Buy or sell contract

  • Counterparty*:Counterparty name

  • Product*:Name of product eg corn

  • Category:Category is used to group various contracts. For example, in the spot copper contract, the varieties (category) may include standard copper and non-standard copper. By categorising them separately, you will be able to determine the positions and P/L of each category - standard copper and non-standard copper.

  • Specification:Product brand/specification listed in the contract, this is not a compulsory field, you may fill in if necessary eg corn starch

  • Unit*:Unit of contract/product eg metric ton

  • Option:Option to buy or sell

  • Quantity*+ Tolerance:Input the contract quantity instead of the actual quantity. Actual quantity can be input in the Trades>Physical Trades>Trade Execution page. Contract quantity of both purchase and sale contracts in the same deal number must be the same, in order for the contracts to be closed off/settled with each other.

  • Range:After filling in 'Quantity' followed by 'Tolerance' (+/- %),  the quantity range will be calculated automatically. For example, if 'Quantity' is "1,000" and 'Tolerance' is +/- "1%", the 'Range' is "990" and "1,010".

  • Pricing Description: Pricing description

  • Packer Details:

    • Packer : Name of packer company

    • Packing : Packing details

    • Packing Qty: Packing quantity

  • Unit Conversion:If you have utilise this function, the Quantity in the Benchmark Pricing and MTM Pricing (next page) will use the converted quantity you have generated

    • Conversion Factor: Input the conversion factor eg 100

    • To Unit : Select the Unit to convert the contract into

    • Converted Unit: After inputting Conversion Factor and To Unit, the system will calculate the converted quantity and unit automatically

 

biii. Payment Details

  • Credit Term : Terms of credit

  • Payment Term: Terms of payment

  • Days: No. of days for Payment Term

 

biv. Other Details

  • Incoterm : INCO term

  • Port/WH Name : Port/Warehouse name

  • Laycan Period: Laycan period, consisting of start and end date

  • Shipping Month/Year:Shipping month and shipping year

  • Laytime (Hours): Laytime in hours

  • Ext: Extension in hours

  • Demurrage: Demurrage fee

  • Law/Arb: Law/Arbitrary details

  • Inspection: Inspection details

  • Q+Q: Quantity and quality details

  • Delivery Rule: Delivery rules

  • GT&C: General terms and conditions

  • Remarks: Remarks

 

Once done, please click on Next to proceed to the pricing page.

If you need to input Iron Ore Specifications details, please refer to Iron Ore Product Group - Specifications


ci. Benchmark Pricing* and MTM (Potential) Pricing* (in the next page) operate the same way, please refer to below:

Each contract should have two pricing methods, Benchmark and MTM (Potential) Pricing.

Benchmark Pricing is the price at which you buy or sell

MTM (Potential) Pricing is to price for inventory so if benchmark pricing is Buy, MTM pricing will be Sell to close the positions

Every deal’s MTM (Potential) Pricing will be the same.

 

Step 1:If there is tax rate, please input under Tax Rate (%), for example if tax rate is 13%, please input 13. If there is no tax rate, you may leave it empty. You may enter this page anytime to input/edit the tax rate, and the system will automatically calculate the P/L accordingly.

 


Step 2: The quantity will be filled automatically based on the quantity you have entered in the previous page.

Screenshot from previous page:

 

In the next page (Pricing page), the system will auto fill the quantity accordingly

Screenshot from pricing page:


Step 3:Please select your Pricing Mode

Definition:

Benchmark/MTM Pricing Page - Description: (Only fields with * sign is compulsory; fields with ^ means that once you have selected the pricing mode, the relevant fields will be updated accordingly)

  • Tax Rate: Tax rate of the contract, if it is 13%, please input “13” and your P/L will be calculated deducting/excluding/net of tax rate. If you leave this field empty, your P/L will be calculated including tax rate

  • Pricing Mode*: Fix, Float/Average, WMA, Spot or Formula

  • Price + Currency^:Select FIX and input the fixed/actual price, Currency will be auto filled based on the Deal Currency in previous page

  • Product*: Product name; please click on Calculate button to select product

  • Pricing Start^:Required for forward products

  • Pricing End^:Required for forward products

  • Month^:  Contract month, required for futures products

  • Year^:  Contract year, required for futures products

 

The following pricing modes apply for both Benchmark Pricing and MTM (Potential) Pricing:

i. Fixed Price: If your contract has fixed/actual price, please select FIX from the Pricing Mode drop down list and fill in the fixed/actual price

 

ii. Floating Price (no fixed price): If your contract has no fixed/actual price yet, you may choose to select an index (“Float/Average”, “Whole Month Average(WMA)”,”Spot“ or “Formula”) to benchmark the pricing of your trades, where data will be obtained automatically from the market data (integrated from various Exchange sources) in the system to calculate the P/L of your positions. Once the trades are executed and prices have been confirmed, you may proceed to Trade Execution to input the final actual quantity and price, which will be automatically updated in portfolios to calculate the P/L.

For example: for a purchase/sale contract, fixed price is not available yet so there is only a floating price. The benchmark price of the purchase contract uses LME products, and the sale contract - MTM (Potential) pricing uses SHFE products so there will be a difference in P/L. Once available, please fill in the actual price and the actual quantity to settle the contract accurately.

Please refer to below to determine the Pricing Mode to use when pricing your purchase and sale contracts:

You may click on the drop down list under Financial Instrument to determine the Product Type (forward/futures/spot/forex), and based on the Product Type, select the Pricing Mode (WMA/Float/Spot/Formula):

a. If Product Type is FORWARD, please select FLOAT/AVE and input the  Pricing Period (Pricing Start and Pricing End Date) only. For instance, LME 3M contract is specific to a certain start and end date. Some examples include LEAD 3M, ZINC 3M etc.

 

b. If Product Type is Futures, please select WMA and input the Month and Year only. Some examples include LEAD, ZINC etc.

 

c. If Product Type is Forex or Spot, please select Spot and you do not need to input month, year or date. Some examples include LEAD 3M Rolling, ZINC CASH etc.

 

d. If Iron Ore products require formula pricing, please select Formula under Pricing Mode and refer to: Formula Pricing Guide

 

 

Therefore, you must first understand the Product Type in order to select the correct Pricing Mode.

Example:Product is COPPER CATHODE FUTURES futures contract, so please select WMA as the Pricing Mode.

 


Step 4:After selecting the Pricing Mode, please click on the blue Calculate button. We would recommend you to use this button as you only need to fill in a few items and the system will fill in the rest of the items in this page on your behalf.


Step 5:After selecting the blue Calculate button, please select/input the product

 

and select the month/year, followed by Calculate. If the product’s Product Type is FORWARD, please input the Pricing Start Date and Pricing End Date instead.

If the Product Type is SPOT/FOREX, you do not need to input any month/year or date.

 


Step 6:Once done, the system will fill in the data accordingly and your contract’s P/L will be calculated based on your inputs.

 


Step 7: Premium/Discount

If your contract has Premium/Discount, the steps are similar to the steps mentioned above (FIX, WMA, FLOAT/AVE or SPOT). If there are no Premium/Discount, you may leave this empty and click on Next to proceed.

Premium:Positive value

Discount:Negative value

 

 

Summary:

Fixed refers to fixed price.

WMA represents the floating price of futures products, which follows the price change of the futures contract.

WMA represents the floating price of forward products, which follows the price change of the forward contract.

Spot is also a floating price, but it corresponds to the daily spot index price, and there is no futures contract.

Depending on the structure of the contract, you can determine if it belongs to Float, WMA or Spot.

If the Product Group is Iron Ore, you may select Formula to calculate the pricing.

All paper and physical trades pricing logic is as follows:

To determine which Pricing Mode to use, you may double click on the MAF Product ID/Product field to determine the "Product Type" (forward/futures/spot/forex):

  1. If Product Type is FORWARD, please select FLOAT/AVE and input the Pricing Start and Pricing End Date only. For instance, LME 3M contract is specific to a certain date. Some examples include LEAD 3M, ZINC 3M etc.

  2. If Product Type is Futures, please select WMA and input the Month and Year only. Some examples include LEAD, ZINC etc.

  3. If Product Type is Forex or Spot, please select Spot and you do not need to input month, year or date. Some examples include LEAD 3M Rolling, ZINC CASH etc.

  4. If your product is iron ore and require formula pricing, please refer to Formula Pricing Guide.

 

Once done, please click on the Next button at the bottom right corner of the page to view the summary page, followed by Submit to save your data. Once the data has been saved successfully, they will appear in the Physical Trade table.


3. Physical Trade Execution

Trades - Physical Trades

In the Trades>Physical Trades>Trades tab, there are 2 tables, the top table will display all physical trades data, whereas the bottom table will display all trade execution data of the physical trades

In this page, besides bulk uploading your physical trades, you may also click on the + New Trade button to manually input physical trades data or access other functions. Please refer to Managing Physical Tradesto learn more.

You may edit the following fields in the Physical Trades table directly by double-clicking the cells. Please click on Save Changes at the bottom left corner of the table to save the changes.

  • Spec

  • Port

  • Incoterm

  • Delivery Rule

  • Doc Date

Trades - Physical Trades - Trade Execution List

You may input your physical trade execution data here. For instance, once you have the actual quantity and actual price of your contract, you may input the data directly in the trade execution table, or click on the Edit button (represented by a pen and paper icon) to enter the trade execution page to input or edit data. Please refer to Managing Physical Tradesto learn more.

 

 

Description (Only fields with * sign is compulsory)

  • Trade Execution ID:Input is not required, once you save your trade execution data, the Trade Execution ID will be generated automatically

  • Trade Execution No. *:Under each contract, there may be multiple trade executions due to different pricing methods and different transportation logistics. The trade execution number is used to distinguish each trade’s execution details. If there is only one trade execution, the trade execution number can be the contract number, this field can be input/edited directly in the table

  • DEAL QTY DSP: Refers to Quantity Discrepancy, there are times when the actual quantity of the purchase and sale contract cannot be matched 100%. For example, you purchase 1001 MT of goods and sold 1001.2 MT of the same goods. But the system is unable to determine if the difference in quantity is correct or due to an input error, so the DEAL QTY DSP will be highlighted in red to remind you to check for discrepancy. Please note that if the trade does not have Actual Quantity, the system will not check so it will not be highlighted in red.

    • Cases of DEAL QTY DSP in red:

      • The actual quantity for both purchase and sales contracts are not the same, or

      • Only the actual quantity for purchase contract is input, but not for the sale contract, and vice versa

  • Status:Trade status, defined by you

  • Trade ID:Input is not required, once you save your trade data, the Trade ID will be generated automatically

  • Trade Date*:The trade date of the contract will be automatically displayed in this table for easy reference.

  • Deal No.* :The deal number of the contract will be automatically displayed in this table for easy reference. A deal includes one or more purchase and sale contracts. All purchase and sale contracts allocated to the same deal number will be matched with each other to calculate the net positions and P/L. Deal number is also considered a portfolio/trading book, and can be found in the Portfolio page.

  • 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

  • Trader:Name of trader, can be input/edited directly in the table

  • Category:Category is used to group various contracts. For example, in the spot copper contract, the varieties (category) may include standard copper and non-standard copper. By categorising them separately, you will be able to determine the positions and P/L of each category - standard copper and non-standard copper, can be input/edited directly in the table

  • Contract No.:Every purchase and sale contract will have their own contract number, can be input/edited directly in the table

  • Pricing Date:Pricing date, can be input/edited directly in the table

  • Pricing Contract :Pricing contract, can be input/edited directly in the table

  • Purchase/Sale*:Purchase/Buy or Sale/Sell

  • Counterparty Reference No.:Counterparty reference number,can be input/edited directly in the table

  • Counterparty*:Name of counterparty

  • Product*:Product name, for example Corn, can be input/edited directly in the table

  • Specification:Product specification, you may fill in for your reference if necessary, eg Product is Rubber and specification is XX1, can be input/edited directly in the table

  • For the spot brand in the spot contract, the product specification information is non-important information, and more information is filled in for the convenience of retrieval, such as corn starch, can be input/edited directly in the table

  • Contract Quantity*:Contract quantity, can be input/edited directly in the table

  • Title Transfer Date:Title Transfer Date, if you did not input, it will remain as empty or auto-filled with the trade’s Trade Date if AUTO TTD is ticked or selected, can be input/edited directly in the table

  • Payment Date:Payment date, can be input/edited directly in the table

  • LC Issuing Date: Letter of Credit issuing date

  • LC Number:Letter of Credit number

  • Presentation period: Presentation period

  • Pricing Start :Start date of pricing period

  • Pricing End:End date of pricing period

  • Formula Name:If you use FORMULA pricing as the pricing mode for your trade, the formula name will be displayed here

  • Formula:If you use FORMULA pricing as the pricing mode for your trade, the formula will be displayed here

  • WMT:Wet Metric Ton

  • DMT:Dry Metric Ton

  • FE%:Iron %

  • MOIS%:Moisture %

  • Provisional Quantity:Provisional Quantity

  • Provisional Price:Provisional price, can be input/edited directly in the table

  • Actual Quantity :Actual quantity, can be input/edited directly in the table

  • Pre-Final Quantity:System will auto-calculate, please refer to below Calculations Formula details

  • Price Unit*:Product unit eg metric ton

  • Estimated Price:Estimated price, if no Actual Price is input, the system will use Estimated Price to calculate P/L. Once you input Actual Price, the system will automatically use Actual Price to calculate P/L instead of Estimated Price. This field can be input/edited directly in the table

  • Actual Price:Actual price, can be input/edited directly in the table

  • Premium/Discount: Premium/Discount, can be input/edited directly in the table

  • Pre-Final Price :System will auto-calculate, please refer to below Calculations Formula details

  • Pre-Final Price Before Tax :System will auto-calculate, please refer to below Calculations Formula details

  • Final Price :System will auto-calculate, please refer to below Calculations Formula details

  • Tax Rate(%):Tax rate of contract, if “13%”, please input “13”

  • Priced In:System will auto-display, please refer to below Calculations Formula details

    • TRUE:If Estimated Price or Actual Price is input

    • FALSE:If Estimated Price or Actual Price is not input yet

  • Exchange Rate: Final exchange rate used for calculating P/L. If not filled, system will calculate according to the public exchange rate obtained from Exchange sources. Once you input the exchange rate, the system will use it to calculate P/L. This field can be input/edited directly in the table

  • Custom Tax Rate:Custom Tax Rate, can be input/edited directly in the table

  • Cargo Value:System will auto-calculate, please refer to below Calculations Formula details

  • Cargo Value Before Tax:System will auto-calculate, please refer to below Calculations Formula details

  • Remarks:Remarks, can be input/edited directly in the table

  

Calculations Formula - If the relevant data has been input previously in physical trades page, the system will automatically calculate:

Calculation formulas - If the relevant data has been entered, the system will automatically calculate these:

  • PRE-FINAL QTY = ACTUAL QUANTITY or CONTRACT QTY: If ACTUAL QTY has been input, ACTUAL QTY will be displayed. Otherwise, CONTRACT QTY will be displayed instead.

  • PRE-FINAL PRICE = (ACTUAL PRICE or ESTIMATED PRICE) + premium: If ACTUAL PRICE is input, ACTUAL PRICE will be displayed. Otherwise, if ESTIMATED PRICE is input, ESTIMATED PRICE will be displayed instead. It will then be added with PREMIUM to form PRE-FINAL PRICE. If both ACTUAL PRICE and ESTIMATED PRICE are not input yet, this field will remain empty 

  • PRE-FINAL PRICE BEFORE TAX: PRE-FINAL PRICE/(1+tax rate) or CARGO VALUE BEFORE TAX / PRE-FINAL QTY

  • FINAL PRICE: ACTUAL PRICE + PREMIUM (if actual price has value)

  • CARGO VALUE = PRE-FINAL PRICE * PRE-FINAL QTY (this is offshore amount, sort of like purchase amount)

  • CARGO VALUE BEFORE TAX = CARGO VALUE * EXCHANGE RATE + CUSTOM TAX AMOUNT / (1+tax rate) eg cargo value before tax = cargo value (2k) * ex rate (5) + custom tax (10) [10010] / 1.05 (tax rate = 5%) = 9533.33

  • PRICED IN = TRUE (if actual price or estimated price has value), otherwise will be FALSE

 


4. General Ledger - Input Funds, Expense & Income Data

Portfolio - General Ledger

a. Please click on 'Portfolio' from the navigation sidebar on the left, followed by 'General Ledger' to enter the general ledger page to input data such as expense and income, initial fund, fund in/out and other costs etc. You may directly upload your file and relevant data will be automatically captured, reducing the need to manually input.

b. At the top right corner of the page, hover your mouse over the “…” and click on the broker name to upload your file. The relevant data will be captured and displayed in the table, and you may need to select from the TYPE column to determine if the item is FUNDS IN/OUT, expense/income (EXP/INC) or initial fund (INIT FUND). Please note that if the item is under type EXP/INC, it will be calculated in P/L, but FUNDS IN/OUT will not be calculated in P/L.

Alternatively, you may click on Add Row to input your data manually. Cells highlighted in red are compulsory to be filled. Once done, please click on Save to save your data.

 


Description (fields with * are compulsory to be filled:

  • ID:Input is not required, system will auto-generate

  • Date*:Date of transaction

  • Type*:

    • FUND IN/OUT:

      • Fund In: Positive value eg 100

      • Fund Out: Negative value eg -100

    • EXP/INC:

      • Expenses/Costs:Negative value eg -100

      • Income:Positive value eg 100

    • INIT FUND:Initial fund (can support positive and negative value)

  • Description*:Description of item

  • GL Details:General ledger details

  • Amount*:Amount

    • Please input the negative sign as necessary:

      • If Type is Income or Fund In: Amount is positive value (+)

      • If Type is Expense or Fund Out: Amount is negative value (-)

      • If Type is Initial Fund: Amount is positive value (+) or negative (-)

      • For example, If Type is Expense, Amount will be -1000

  • Currency*:Currency of item’s amount

  • Broker:Broker name; Once you input Company Name to be linked to Broker and Account in Settings>Company>Company Data>Paper Brokers, when you select Broker or Account in the respective functions, the corresponding Account or Broker or Company Name will be auto filled. Please refer to How to Set Up Brokers and Accounts Data and Link to Multiple Companies? to learn more.

  • Account:Account name; Once you input Company Name to be linked to Broker and Account in Settings>Company>Company Data>Paper Brokers, when you select Broker or Account in the respective functions, the corresponding Account or Broker or Company Name will be auto filled. Please refer to How to Set Up Brokers and Accounts Data and Link to Multiple Companies? to learn more.

  • Company Name:Your company name, if you have multiple companies, please select the company name accordingly. Once you input Company Name to be linked to Broker and Account in Settings>Company>Company Data>Paper Brokers, when you select Broker or Account in the respective functions, the corresponding Account or Broker or Company Name will be auto filled. Please refer to How to Set Up Brokers and Accounts Data and Link to Multiple Companies? to learn more.

  • GL CP: General Ledger Counterparty

  • Invoice Date:Invoice/Receipt Date

  • Invoice Amount:Invoice Amount

  • Invoice Number:Invoice number

  • Tax Rate :If tax rate is 13%, please input 13

  • Contract No.:Once you select Contract No., you need to select the corresponding portfolio (it will auto fill if your contract number only has 1 portfolio; otherwise you may select from the drop down list). If you want to allocate the item to a contract to be calculated as part of its P/L, please select Contract No. and the corresponding Portfolio (also known as Deal No.). The system will calculate the P/L of the contract accordingly.

  • Portfolio:Portfolio is required to be filled if Contract No. is selected. Otherwise, it is not required. If you want to allocate the item to a portfolio to be calculated as part of its P/L, please select the corresponding Portfolio (also known as Deal No.) and the system will calculate the P/L of the portfolio accordingly

  • Category:Category

  • Trader:Trader

  • Remarks:Remarks


The 'From' and 'To' dates are set 1 week by default, ranging from 1 week before to today's date. You may adjust the dates and click 'Search' for the data to be filtered and displayed in the table accordingly. Note: The dates you set will remain unchanged unless you log out and re-login, and the dates will reset to default.

Please note: The dates you set will remain unchanged unless you log out and re-login, and the dates will reset to default. You can also utilise the filters function at the top of the table to filter your paper trade. Please refer to Table Settings to learn more.


5. 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 https://mafint.atlassian.net/wiki/spaces/MCUGX/pages/1577451575

 

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 https://mafint.atlassian.net/wiki/spaces/MCUGX/pages/209977405.

 


Physical Trades App/Reports Lists

 

Physical Trade Inventory App/Reports Lists

Please refer to https://mafint.atlassian.net/wiki/spaces/MCUGX/pages/1936818177 to learn more.