Page Comparison

1. New Physical Trade -

Trades Table

• Hide some columns in Trades table by default

  • DEAL NUMBER
    PHY PRICING ID

• Remove green highlights in table

• Allow input in Exchange rate for Offshore trade mode

• Add New Trade Mode:

  • 1、ENTREPOT 转口

  • 2、OFFSHORE-CROSS CCY 离岸-跨币种

  • 3、EFP 期转现

  • 4、LONG ORDER 长单

  • 5、Delete BASIS TRADE CHINA

• Add new columns

  • CONTRACT AMT

    after CONTRACT ACTUAL PRICE

    Chinese: 合同金额

    if ACTUAL PRICE FLAG = TRUE, CONTRACT AMT = CONTRACT ACTUAL QTY * CONTRACT ACTUAL PRICE

    If ACTUAL PRICE FLAG = FALSE, CONTRACT AMT = CONTRACT ACTUAL QTY * PROVISIONAL PRICE

  • Add sum function

Settlement/Updated Settlement Table

• Fixed Pricing Ccy should be same in Settlement and Updated Settlement tabs

• If there is no Contract Actual Price, Estimated Price will be auto filled with Provisional Price. If there is Contract Actual Price, Estimated Price will be empty as per logic

• 1、PRICE BEFORE TAX

  after ESTED.PRICE

  Chinese: 不含税单价

  PRICE BEFORE TAX = SETTLEMENT PRICE * (1- SETTLEMENT TAX RATE(%))
  if no SETTLEMENT PRICE, PRICE BEFORE TAX = ESTED.PRICE * (1- SETTLEMENT TAX RATE(%))

  2、SETTLEMENT AMT

  after CUSTOM TAX AMOUNT

  Chinese: 结算金额
  SETTLEMENT AMT = SETTLEMENT QTY* SETTLEMENT PRICE/ESTED.PRICE (Same logic as PRICE BEFORE TAX)

   

  3、SETTLEMENT AMT BEFORE TAX
  after SETTLEMENT AMT

  Chinese: 不含税结算金额

  SETTLEMENT AMT BEFORE TAX = SETTLEMENT AMT * (1- SETTLEMENT TAX RATE(%))

   

  add sum function for 2 and 3

• Add new columns

  • TRADE MODE

  • DEAL NO.

  • UNIT

  • DEAL CCY after CONTRACT NO.

  • BM PRICING

  • SETTLEMENT TAX RATE (% )

  • MTM PRICING after CONTRACT CCY

  • all columns are in SETTLEMENT tab, they should not be editable in this tab.

• Add all columns in Trades tab to Updated Settlement tab

• Add Sum function in updated settlement tab

  columns:
  SETTLEMENT AMT

  SETTLEMENT AMT BEFORE TAX

PS Ledger

1、For PS LEDGER tab, set PSL TYPE as PAYMENT default and can’t be modified.

2、Add upload csv file function, plz refer to the attached file.

• I have highlight all the required information

• DATE = 交易日期时间

• COMPANY = 账户名称

• COUNTERPARTY = 对方户名

• LEDGER TYPE: if amount is on “借” column，LEDGER TYPE = RECEIVED; if amount is on “贷“ column，LEDGER TYPE = PAID

• AMOUNT = amount on ”借“ or ”贷“ column

• CCY = 币种

General

• Deals tab and Physical Pricing Setting tabs will be moved to New Physical Trade page

• Undo function - Will only undo copy & paste data, and will not work in add row/deleted data/bulk delete

Enhancement

New Physical Trades

2. Dashboard - Group P/L Chart in windows computer bugs fixed

Enhancement

3. All Ag Grid tables -

• Should not allow add shift rows (Ctrl + Shift + V) for tables with no Add Rows function

• For existing deal number - if delete Deal No., Deal ID and Deal Ccy should be deleted

Enhancement

4. Bugs fixed:

• Fixed pricing ccy applies to both bm pricing and settlement price

  if select bm pricing, dont need to key fixed pricing ccy

  if key settlement price, fixed pricing ccy is must item as per message below table

• Upload bulk trade issue for China Server bug fixed

• In updated settlement tab, only import/export, entrepot and offshore cross ccy can input exchange rate and exchange conversion date

• Bug in portfolio P/L details after relocate deal number

• Bug in new physical trade

1. Dashboard -

• Auto Update function should only update end date and not affect start date. This means that when Auto Update is ticked, End Date will auto reset to yesterday’s date, if unticked, End Date will remain as the user’s selected date; all without affecting the user’s selected Start Date

• Physical Trade Status App Start Date and End Date should be the same in shared link and shared Group Dashboard

Enhancement

Individual & Group Dashboard Guide