Page Comparison

1. Portfolio - Add auto-sum function for values in:

• Open Positions table

• Closed Positions table

• Trades table

Enhancement

View Portfolio Details

1. Dashboard - Add new PORTFOLIO TOP VIEW app

settings:

1. single select portfolio

2. choose pub or pvt market data

3. start date

   1. default current year 1st date

   2. cache without reset

   3. must

4. end date

   1. default today

   2. cache without reset

   3. default auto update

   4. must

5. all summary row (sum up all the columns which need to be summed in group)

New Feature

-

1. General Ledger - Auto capture item 非货币充抵变动额 when upload CTP file

Enhancement

General Ledger

1. Red/Empty columns in tables bug fixed

• Paper Trade Upload Table

• Paper Trade Grouped Trades Table

• Physical Trade Table

• Physical Trade Execution Table

• Physical Trade Deals Table

Enhancement

-

2. Paper Trades, Physical Trades and Portfolio table layout template will remain as last updated layout bug fixed

Enhancement

-

3. Physical Trades - Add Deal Trade and Duplicate Trade will duplicate the following fields:

• contract type

• trade mode

• inco term

• port/wh name

• shipping month/year

Enhancement

Managing Physical Trades

4. Physical Trades - Add a dropdown list with COPY button at top right corner to copy specifications (DMT, WMT, MOIS% and FE%) based on Contract No.

New Feature

Managing Physical Trades

5. Dashboard - Position Matrix

• Add positions conversion based on trades

  • ADD button to add new row and DEL button to del existing row

  • three columns

    1. PRODUCT

       1. select from product dropdown list

       2. show product name

       3. must

       4. must be unique (can not duplicate PRODUCTS)

    2. CO

       1. number to fill up

       2. support negative sign

       3. must

    3. EQ PRODUCT

       1. select from product dropdown list

       2. show product name

       3. must

    4. For example, if any position conversion, e.g., ‘SGX IRON ORE, 0.5, 'SHANGHAI REBAR'

       then in table, SGX IRON ORE position will time 0.5 and EQ product will be SHANGHAI REBAR

       if no position conversion:

       then in table SGX IRON ORE position no change, and EQ product will be SGX IRON ORE

  • Add one more column called EQ_product after Product column

New Feature

Position Matrix

1. Physical Trades - Allow user to edit formula name even after Actual Quantity is input

Enhancement

Managing Physical Trades

1. Portfolio P/L Details - Add translation for PVT 公共/专属价格

Enhancement

Portfolio P/L Details

1. Dashboard - Position Matrix

• Add Group Sum tick box in Setting to allow user to opt to auto sum group rows

  • Tick: When group rows, tick Group Sum check box to auto group sum month/year columns

  • Untick: When group rows, untick Group Sum check box to not auto group sum month/year columns

  • Default will be unticked

• Add Swap Flag button in Setting

  • background: some of products position will be changed based on platts in the near month (e.g., now it is Aug 2022, and for 17 Aug 2022 contract position)

    1. set up product property under Holiday Group in product data table by MAF Admin (e.g., SGX/FEF holiday group is platts_sg_metal)

       • only product with holiday will be considered.

    2. the near month contract position will be changed on working day (excluding platts holiday and weekend)

       • how to check platts holiday: https://www.spglobal.com/commodityinsights/en/our-methodology/holiday

       • platts_sg_metal holiday will track all Singapore public holiday

    3. how is the position calculated?

       • remaining business days of current month (excluding platts holiday, weekend and today date )

       • whole month business days of current month

       • ratio = remaining / whole

       • e.g., test2, testing server, 期货一部

         1. aug 2022 SGX/FEF size = 100

         2. remaining days = 10

         3. whole days = 22 (09 Aug is Singapore holiday based on Platts)

         4. the ratio = 10 / 22

         5. once tick SWAP FLAG, the position size will change from 100 to 45.4545

• Bug fixed if formula is not linked to any product

New Feature

Position Matrix

2. Physical Trades - Edit Physical Trade

• Auto keep edited data (if page is not saved) when click on Next button or Edit Specifications button, so when return back to the page, data will not be reset to original

Enhancement

Managing Physical Trades

3. Physical Trades - Formula Pricing

• Formula name will save latest trade ID’s formula, regardless of whether you change old trade formula it will always use latest trade ID’s formula

• For example, trade ID 100 and trade 101 use the same formula name A

  so if you edit trade 100’s formula, the formula will apply to trade 100 only, if choose formula name A, it will use the latest trade 101’s formula

  so if you edit trade 101’s formula, the next time you use formula name A, it will use the latest formula aka trade 101’s formula

Enhancement

Managing Physical Trades

5. Paper Trade - IDB Commission can be negative value

Enhancement

Creating New Paper Trade(s)

6. Dashboard - Portfolio P/L Details:

• Add Portfolio Name column before Deal No.

• Add Contract Key after Product

Enhancement

Portfolio P/L Details

1. Dashboard - Position Matrix

• Auto sum Month/Year positions columns once grouped rows

Enhancement

Position Matrix

1. Demurrage Table - Allow user’s latest demurrage table filter setting to overwrite user’s table template layout’s filter

Enhancement

-

1. Dashboard - Physical Trade Status -

• Choose Check Item as Invoice and Select Group as Settled bug fixed

• When remove or add Check Item as Amount, the column UNSETTLED AMT will show and hide accordingly

Enhancement

Physical Trade Status

1. AG Grid table copy paste (ctrl + shift + v) will enable empty row at the bottom bug fixed

Enhancement

-

1. Physical Trades

• DMTU variable formula calculation will auto round to 4dp

• Calculation bug fixed

Enhancement

Managing Physical Trades

2. Physical Trades - PS Ledger update:

• After selecting Contract No., certain fields will be auto filled accordingly. If Actual Qty has been input, Quantity will be auto filled with Actual Qty, otherwise Contract Qty will be filled instead

• After selecting Contract No., certain fields will be auto filled accordingly. If Actual Price has been input, Price will be auto filled with Actual Price otherwise it will be empty instead

  • In Contract No. dropdown list, add these 2 items:

    Qty: map to qty

    Price: map to price

• When add new row, Ratio will be 100 by default

• After selecting Contract No., Counterparty should not be in red bug fixed

• Price decimal point will follow user’s setting bug fixed

• Filter will remain in cache until user logs out or click on Reset Filter

Enhancement

Managing Physical Trades

3. Dashboard - Physical Trade Status update:

• Add a column called ACTUAL QTY (实际量) after CONTRACT QTY

  1. SETTLED QTY now is ACTUAL QTY

  2. UNSETTED QTY = ACTUAL QTY - SETTLED QTY

  3. UNSETTED INV QTY = SETTLED QTY - INVOICE QTY

Enhancement

Physical Trade Status

1. Paper Trades -

• Upload MAF C/E template, IDB and IDB Commission missing bug fixed

• Translation for Size in Grouped Trades changed

Enhancement

Creating New Paper Trade(s)

2. Dashboard - Group P/L: If untick Auto Update and set own date range, setting any date in between date range in Compare Date function will be allowed bug fixed

Enhancement

Group P/L