9. Physical Pricing Setting

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


9. Physical Pricing Setting

This section allows you to set up your physical trade pricing index (Benchmark & MTM - pricing mode = Float/Ave, WMA & Spot) here, which will be required if you want to do bulk trade upload for your physical trades. The pricing index allows you to use a product and benchmark its price against the purchase or sale pricing of the contract so as to better calculate the positions and P/L before the contract is complete (have actual price and quantity). You will thus be able to decide which contract (without actual price yet) should be matched to which particular product's pricing in order to price the contract and calculate the P/L more accurately. If your contract has fixed or actual price, there is no need to create a pricing index, you may just input the fixed price accordingly.

Every physical trade contract will have its own Benchmark and MTM (Potential) pricing index.

Benchmark pricing: Used to price your purchase or sale contract, if fixed price is not available yet. You may input the actual price once you receive it.

Potential pricing: Used to price/mark-to-market the corresponding contract (sale or purchase), if fixed price is not available yet. This allows you to have an idea of the calculations of the positions and P/L before the contract is complete.

Every trade with the same deal number will have the same Potential Pricing index.

So the system will be able to handle the following cases for the Benchmark and MTM (Potential) pricing index:

a. Floating price is available only (no fixed or actual price yet): If your contract has no fixed or actual price, you can record the floating price by choosing pricing mode “Float/Average”, “Whole Month Average(WMA) or ”Spot“. Once you receive the actual or fixed price, you may input for your trade, more details to be provided below. For instance, for a contract (import/export), if you only have floating price, you can use LME product for Benchmark pricing and SHFE product for MTM, which will result in a difference in P/L. Once you input the actual price and actually quantity, the positions and P/L of the contract will be calculated more accurately.

 

b. Fixed price is available: If your contract has fixed or actual price, you may input the price into the "Fixed Price" column in the bulk trade upload file, more details to be provided below.

 

In summary, 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.

 

Please click on Add Row to add a new row and input the details accordingly. Once this setting is configured, you will be able to input the Pricing Code in the Benchmark Pricing and MTM Pricing columns in the Bulk Trade Upload file. Once upload, your contracts' pricing will be matched directly to the product you have matched them with. Cells in red are compulsory fields.

 

To access this section, click on 'Trade', following by 'Physical Trades' from the navigation sidebar on the left. Click on the 'PHYSICAL PRICING SETTING' tab at the top of the page to access this section.

To add a new pricing index, click on 'Add Row' and fill in all the details as necessary (cells in red are compulsory fields.)

Pricing Code: Unique name to identify the pricing index, you may come up with the names as you wish

MAF Product ID: Product to use as a pricing index, these products are obtained from various Exchanges sources and have been added into the system for your usage

Pricing Mode: Types of pricing mode, namely; Float/Ave, WMA and Spot

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

a. If Product Type is Forward, please select FLOAT/AVE and input the Pricing Start and Pricing End Date

b. If Product Type is Futures, please select WMA and input the Month and Year

 

 

c. If Product Type is Forex or Spot, please select Spot 

 

 

Trade Type: Financial instrument(s) used as an index to benchmark the pricing of your trades (Benchmark or Potential (MTM)

Premium: Premium to your benchmark index/MTM

Pricing Start: Start date of pricing, applicable for forward products

Pricing End: End date of pricing, applicable for forward products

Month: Contract month of pricing, applicable for futures products

Year: Contract year of pricing, applicable for futures products

Tax Rate: Tax rate applicable to the pricing of the index

Once done, please click 'Save' and the Pricing Code will be available for you to input in the 'Benchmark Pricing' or 'MTM Pricing' fields in the bulk trade upload

Please note that this section is equivalent to the pricing index setting as shown in the screenshot when manually creating your physical trade.