The problem
Commodity contract prices are often not fixed at signature but “fixed” progressively against the futures screen over a period. Common difficulties:
- pricing instructions are given over WeChat and the phone, records are scattered and do not tie up afterwards;
- average prices and formula prices are calculated in Excel, with no clear record of pricing dates or price versions;
- priced and unpriced quantities are not totalled in real time, so exposure lags and hedging falls behind;
- pricing, shipments and settlement are kept in three separate ledgers, and final settlement needs repeated checking.
How Tranexio handles it
- Pricing terms: contracts and orders select a pricing method; price-fixing contracts specify the pricing market, pricing period, premium or discount and who fixes (buyer, seller or by agreement).
- Market data: a single market data store maintains exchange and physical price quotations, price versions and trading calendars; external market data sources come in through the integration hub.
- Fixing: pricing instructions are entered in the pricing terminal, the system takes the price as agreed and generates a price confirmation; TAS trades at the settlement price of the agreed day.
- Averages and formulas: the average price calculation takes daily prices over the period and averages them; formula pricing supports quality adjustments and valuation, with a version chain from provisional to final price.
- Exposure and linkage: once a fixing takes effect, pricing exposure updates automatically and a hedging recommendation is produced, feeding the hedging process.
- Settlement: settle first on the provisional price, then run final pricing settlement and true-up once the final price is set.
Key controls
| Control | How it works |
|---|---|
| Pricing authority | Pricing instructions can be given only by authorised staff within the pricing period |
| Price trail | Every fixing records the pricing market, pricing date and price version |
| Quantity control | Cumulative priced quantity may not exceed the contract quantity |
| Visible exposure | Unpriced quantities are summarised daily as pricing exposure |
| Consistent prices | Settlement and invoice prices come from the pricing order and cannot be entered by hand |