MAF CLOUD - NEW RELEASE + FIX UPDATES 2021

1. Chinese Version Upload Templates will work on:

• Paper Trades

• Physical Trade Bulk Upload

• Physical Trade Execution Update

• Proprietary Market Data

Please note that you have to upload the correct language templates eg if you are using the chinese version of the system, you need to upload the chinese upload template (with chinese headers)

Enhancement

https://mafint.atlassian.net/wiki/spaces/MCUGX/pages/137920555

https://mafint.atlassian.net/wiki/spaces/MCUGX/pages/820838446

https://mafint.atlassian.net/wiki/spaces/MCUGX/pages/1577451575

-

1. Paper Trades - Upload file with Category bug fixed

Enhancement

-

2. Portfolio - Start Date cannot be later than End Date

Enhancement

-

1. Paper Trades - MAF Upload template is now available for download and upload (select MAF C/E) according to this format:

2. MAF Trade Format:

   1. TRADE DATE: DD/MM/YYYY

   2. T PLUS: 1 means T+1, empty means T (normal)

   3. PORTFOLIO NAME: Case-sensitive 

   4. MAF PRODUCT ID: Combine ”Exchange Code“, ”/“, and ”Product Code“ e.g. SHFE/CU. You can find MAF PRODUCT ID in “View Product Data” page. Please note that you must input the correct format for MAF PRODUCT ID to upload successfully; otherwise, uploading will raise error.

   5. TRADER, CATEGORY, STRTG: Text format, will auto uppercase 

   6. BUY/SELL: Key in Buy or Sell, case-insensitive

   7. SIZE: Number format

   8. TRADE TYPE: Key in Hedge or Speculation, default is Speculation

   9. CONTRACT MONTH: Support all types: 1 - 12, 01 - 12, F - Z, JAN - DEC, JANUARY - DECEMBER

   10. CONTRACT YEAR: YYYY

   11. VALUATION DATE: DD/MM/YYYY 

   12. C/P: C means Call, P means Put, case-insensitive

   13. ACCOUNT, BROKER: Text format, will auto uppercase

   14. PRICE: Number format

   15. COMMISSION CURRENCY: Standard currency code, such as USD, CNY, CNH etc.

Enhancement

-

2. Paper Trades - Added Portfolio column to allow you to allocate portfolio directly after uploading paper trades

Enhancement

-

3. Product Data - Added MAF PRODUCT ID column

Enhancement

-

4. Portfolio - Diagnose recalculation bug fixed

Enhancement

-

5. Dashboard - Loading speed improved by allowing first few models to load first followed by the rest

Enhancement

-

-

1. Dashboard - Futures Account app bug fixed for

• Macquaire trade

• Switch Date in Settings

Enhancement

-

2. Portfolio - Close expired paper trades bug fixed

Enhancement

-

3. Physical Trades - Exp/Inc table bug fixed for:

• Cannot save if Quantity is 0

• SAVE button enhanced

• Reallocate Deal bug fixed for certain physical trades

Enhancement

-

4. Paper Trades - Bands broker daily statement can support different formats

Enhancement

-

5. Proprietary Market Data - OPS CONTRACT:

• Empty row bug fixed

• If user has no portfolio, OPS CONTRACT page will have error bug fixed

Enhancement

-

1. New Alibaba Cloud Server has been set up to improve network speed in China. You can change server location in main login page on the top right corner.

Enhancement

-

-

2. Paper Trades -

• Sucden CSV and Excel are both supported (labelled as Sucden C/E in the MAF system)

• Grouping of trades with negative price (eg MACQUAIRE file) can be supported

Enhancement

-

1. Paper Trades -

• Paper trades: Create and Update will have clearer validation message (identify which row has issues when submitting)

• Group Trades bug fixed

• Macquaire files can be uploaded successfully now

Enhancement

-

2. Physical Trades -

• Shipping Instructions can be created successfully now

• Trade Execution table will have clearer validation message (identify which row has issues when submitting)

Enhancement

-

3. Dashboard - Open Positions table can be shared successfully now

Enhancement

-

1. Demurrage -

• Offset List - Close header in row group will return column back into demurrage offset list table

• Search bar will work for “port”

Enhancement

-

2. Payment Record - If have validation error at the bottom, dropdown list items will not disappear

Enhancement

-

3. Dashboard (Open Position Details table) - Add portfolio column

Enhancement

-

4. My Profile - Data Mapping table will allow red cells to be saved

Enhancement

-

-

1. Paper Trades - Add T PLUS column to indicate the trade as T+1, so you can select to include or exclude the trades in your portfolio calculation in the below mentioned models with “Excl T Plus” tick box

New Feature

-

2. Portfolio - Add T PLUS column in TRADES table in portfolio page

New Feature

-

3. Dashboard - Add “Excl T Plus” tick box to exclude trades with T+1 in the portfolio calculation for:

• Hedge Ratio

• Group P/L

• FX Exposure

• Portfolio P/L Details

New Feature

-

-

4. Physical Trades - Payment Record (Invoice) - Dropdown list items will disappear after clicking on PDF bug fixed

Enhancement

-

5. Demurrage - Add PAYABLE, RECEIVABLE and NET AMOUNT columns in Demurrage Offset List

Enhancement

-

1. Bulk Trade Upload - Delete Deal No. will delete Deal ID

Enhancement

-

2. Paper Trades - Upload CIMB, CTP, FCStone file bug fixed

Enhancement

-

3. Dashboard -

• New “Open Position Details” model allows selection of multiple portfolios

• FX Exposure Model bug fixed

Enhancement

-

4. Physical Trades - Cannot reallocate deal with later trade date to another deal with earlier title transfer date fixed

Enhancement

-

-

1. Dashboard - Outstanding Physical Trades removed

Enhancement

-

-

2. Demurrage - Final amount decimal point in table and page will be same

Enhancement

-

1. Proprietary Market Data - Date format will allow ISO-8601 format from Excel

Enhancement

-

-

2. Dashboard - Open model in new window bugs fixed

Enhancement

-

-

1. Paper Trades - Add Strategy column in paper trades and portfolio page

Enhancement

-

2. Dashboard - New “Open Position Details” model is added in Dashboard, which is exactly the same as the Open Positions Table in View Portfolio page.

• End Date should not be after today’s date

New Feature

-

3. Dashboard - Group P/L: Add Group field to allow user to select whether Portfolio, Trader, Category or Strategy columns which will be shown in the model.

• It is compulsory to select Portfolio

Enhancement

-

1. Demurrage -

• MAFSpace: Upload PDF file extension case sensitive fixed

• When switching tabs, demurrage adjustment will shift bug fixed

Enhancement

-

1. Portfolio - Bugs fixed for Diagnose button to compare against P/L figure

Enhancement

-

1. Physical Trades - Bulk Trade Execution Update: Added a message at the bottom of the page to remind user which compulsory items are not filled before submitting

Enhancement

-

2. Dashboard (Portfolio P/L Details app) - Decimal point for SIZE will follow Physical Quantity Decimal Point setting (in My Profile>Layout Setting)

Enhancement

-

3. Portfolio - Added a Diagnose button to compare against P/L figure

Enhancement

-

1. Demurrage -

• Demurrage Calculations Page - Tabs' order can be shifted by clicking on the left and right arrows and the first tab will be the final tab (determines final amount and generate demurrage report)

• Demurrage Claims Types will not change to “Demurrage” for other claims after saving demurrage calculation page

Enhancement

-

2. Physical Trades -

• Bulk Trade Execution Update: Added Counterparty column

• Expense/Income Table: Drop-down list and validation enhanced

Enhancement

-

4. Group - Join group message bug fixed

Enhancement

-

-

1. Dashboard (Group P/L) - You will be able to save each date’s data into the database for accurate calculations and comparisons.

Test Example:

• Open 2 Group P/L Apps, 1st app’s end date is 1st Nov (Untick Historical GPPL), the other app’s end date is yesterday (tick Historical GPPL)

• Click on “Save” for 1st app and 1st Nov’s data will be saved into the system’s database. So you can go to 2nd app and change “Compare Date” to 1st Nov so that your yesterday’s data can be compared to 1st Nov’s data.

• 2nd Daily Change = 2nd App Total P/L - 1st App Total P/L

Enhancement

-

2. Dashboard (Position Matrix) - Product with same name bug fixed eg for Copper Cathode SHFE/CU and INE/BC.

Enhancement

-

3. Exchange rate decimal points will be displayed by default and not rounded up.

Enhancement

-

-

1. Demurrage New Features:

• Archive Function: You will be able to archive any claims that you do not need direct access to and store them in the Archive table, and unarchive them anytime.

• Multiple Tabs: You can create multiple demurrage calculations tabs to store and compare calculations, similar to the Microsoft Excel sheets concept.

New Feature

-

2. Physical Trades New Features:

• Archive Function: You will be able to archive any physical trades and their associated trade executions that you do not need direct access to and store them in the Archive table, and unarchive them anytime.

New Feature

-

3. Dashboard (Group P/L) - Added a Historical GPPL button,

• If unticked - Compare with Group P/L from open position calculation - Daily change of open position result will always use the latest position data to do calculations

• If ticked - Compare with historical Group P/L data - Historical Group P/L data will be stored in database on a daily basis and once stored, it will not be updated. (MAF will only update for yesterday data so once user reload the Group P/L app, MAF will insert or update data if the end date is yesterday.

New Feature

-

1. Demurrage - Save Demurrage Claims table pop up message fixed

Enhancement

-

1. Physical Trades - You can now bulk-reallocate a deal into a new or existing deal by ticking the trade and clicking on “Reallocate” and input the deal number

• If you reallocate into a deal which has one trade but without pricing, the MTM will use the selected trades' MTM

• After reallocating into a deal, the existing deal if empty, will be auto deleted

• After reallocating, any related expense & income item will be allocated with the trades into the new deal.

• If the existing deal has no pricing and you reallocate into another deal with no pricing, the MTM will be empty as well

New Feature

-

2. Dashboard (FX Exposure) -

• Remove PRICE ADJUSTMENT and NO NUM column

• AVG PRICE master row cannot be edited, children rows can be edited

Enhancement

-

1. Dashboard (FX Exposure) -

• Can input adjustment (ADJ) in master row, new column TOTAL ADJ is added to sum up all the adjustment values

• Input for ADJ for 1 row will not appear in other rows

Enhancement

-

2. Physical Trades - Reallocate Deal will reallocate all the associated trade and its expense and income items (from EXPENSE & INCOME table) into the new deal

Enhancement

-

3. Physical Trade (Expense & Income Table) - Delete Contract No. bug fixed

Enhancement

-

1. Physical Trade (Trade Execution Table/Page) -

• Custom Tax Rate is editable in trade execution table

• Exchange Rate is editable for Import/Export (Trade Type) only

• Added confirmation pop up message for AUTO TTD

• If pricing block is linked, link button will be green; if unlinked, link button will be red. Once save trade execution page, the link button will be in green.

Enhancement

2. Physical Trades (Expense & Income Table) -

• Expense & Income table will be enhanced to support larger amount of data

• Create or update Custom Tax Rate:

  • If the trade date is today’s date, the default Custom Tax Rate date in Expense & Income Table will be today’s date

  • If the trade date is any day before today’s date, the default Custom Tax Rate date in Expense & Income Table will be yesterday’s date

• Change Deal No., Contract No. and Execution No. bug fixed

Enhancement

-

3. Physical Trades -

• Split Trade bug fixed

• Reallocate Deal - Trade Mode becomes number format bug fixed

Enhancement

-

4. Dashboard (FX Exposure Report) -

• Add a new column PRICE ADJ to input price adjustment and click SAVE to update the data

• Deselect portfolio bug fixed

Enhancement

5. Dashboard (Hedge Ratio) -

• Deselect portfolio bug fixed

• Input for ADJ for 1 row will not appear in other rows

Enhancement

-

6. Portfolio - Expired positions should not appear even after editing Category of paper/physical trades

Enhancement

-