Steps:
| Table of Contents |
|---|
...
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 their the designated pages to input their data, ensuring a consistent operational workflow and reducing confusionclear 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)
...
ii. Please click on + New Trade and a new row will be added for you to input your data. Please refer to below guide and input the details as necessary.
Trade ID:ID：Input is not required, once you save your trade data, the Trade ID will be generated automatically
Trade Date*：The trade Trade date of the contract will be automatically displayed in this table for easy reference.
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, can be input/edited directly in the table
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
...
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 will appear here if you add a new row in PS Ledger with PSL Type: Payment recorded in PS Ledger will be automatically reflected here
PSL Date: PS Ledger date will appear here if you add a new row in PS Ledger with PSL Type: Payment recorded in PS Ledger will be automatically reflected here
Bal Amount: Balance Amount = Trade value - PSL Amount PS Ledger Amount will be automatically reflected here
Inv Qty: Invoice quantity will appear here if you add a new row in PS Ledger with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here
Inv Amt: Invoice amount will appear here if you add a new row in PS Ledger with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here
Un Inv Qty: Un-Invoiced Quantity = Quantity - Inv QtyInvoice Quantity will be automatically reflected here
Un Inv Amt: Un-Invoiced Amount = Trade Value - Inv AmtInvoice 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)
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:
3. Input Physical Trades Pricing Data - For Settlement Team
a. Input Pricing Data in New Physical Trade (Settlement)
...
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 will appear here if you add a new row in PS Ledger with PSL Type: Payment recorded in PS Ledger will be automatically reflected here
PSL Date: PS Ledger date will appear here if you add a new row in PS Ledger 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 will appear here if you add a new row in PS Ledger with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here
Inv Amt: Invoice amount will appear here if you add a new row in PS Ledger 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. |
...