MAF CLOUD - NEW RELEASE + FIX UPDATES JAN & FEB 2022

1. General Ledger - When upload file with existing Broker, Account and Company Name in Paper Brokers table, Company Name will be auto filled

Enhancement

General Ledger

https://mafint.atlassian.net/browse/MAF-2879

2. Physical Trades Execution -

• If both WH START DATE and WH END DATE have value, and WH END DATE is earlier than WH START DATE, it will show in red for you to rectify.

• WH Storage Cost and WH Entry Cost are not allowed to have negative value

Enhancement

Managing Physical Trades

https://mafint.atlassian.net/browse/MAF-2875

3. Physical Trades Table - Add Doc Date (原件归档日) column after Remarks (备注) column and allow both columns to bulk edit in the table

Enhancement

Managing Physical Trades

https://mafint.atlassian.net/browse/MAF-2882

1. Dashboard - Futures Account: Tick “Show Options Value” to include options value calculations

Enhancement

Futures Account

https://mafint.atlassian.net/browse/MAF-2863

2. Paper Trades - Options contracts will aggregate accordingly

Enhancement

Creating New Paper Trade(s)

https://mafint.atlassian.net/browse/MAF-2873

3. Company>Company Data - Added Warehouse tab to input warehouse details

New Feature

Company Data

https://mafint.atlassian.net/browse/MAF-2850

4. Physical Trade Execution - Added Warehouse details in trade execution page and table

New Feature

Managing Physical Trades

https://mafint.atlassian.net/browse/MAF-2851

5. Dashboard (Physical Trade Inventory) -

• Added “Inventory Rule” in settings to opt to use “Title Transfer Date” or “Warehouse” to determine inventory details. Default will be “Title Transfer Date”

• Added “WH Name” (Warehouse Name) column before “Title Transfer Date”

Enhancement

Physical Trade Inventory

https://mafint.atlassian.net/browse/MAF-2853

6. Dashboard - Share Portfolio Performance Chart logic:

Start date is not following settings; auto update not including start date; if start date settings value is empty, use default rule; else: use settings values.

Enhancement

-

https://mafint.atlassian.net/browse/MAF-2852

7. Physical Trades - Negative quantity (Contract Quantity/Actual Quantity/Size) will not be allowed, it will auto convert to positive value after saving but will show in red and not allowed to save unless it is change to positive

• Create and Edit Physical Trades

• Physical Trades Bulk Upload

• Physical Trade Execution

• Physical Trade Bulk Execution Update

• Expenses & Income

• Create and Edit Paper Trades

Enhancement

-

https://mafint.atlassian.net/browse/MAF-2871

8. Dashboard - Inventory Summary Model

New Feature

-

https://mafint.atlassian.net/browse/MAF-2868

1. Bulk Trades Upload - Copy & paste date and deal no. from excel fixed

Enhancement

Managing Physical Trades

https://mafint.atlassian.net/browse/MAF-2867

1. Deals tab - Copy & paste Pricing Code into MTM Pricing Code fixed

Enhancement

Managing Physical Trades

https://mafint.atlassian.net/browse/MAF-2869

1. Dashboard - When create new models, the windows will appear at the top instead of the bottom

Enhancement

-

-

2. Language setting at the top right corner of the page will auto update tables' translation immediately without the need to refresh page

Enhancement

-

-

1. Dashboard (Group Dashboard) - The models shared to Group Dashboard will be exactly the same as original models in Individual Dashboard

Enhancement

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

-

2. General Ledger -

• When select Broker or Account, corresponding Company Name will be auto filled

• When select Company Name, Broker or Account are not compulsory to be filled

• When copy and paste Broker and Account which has multiple Accounts, cell will appear in red for you to select from the dropdown list

Enhancement

General Ledger

-

3. Proprietary Market Data - When copy and paste into row and delete, add row again and the deleted row will not appear

Enhancement

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

-

4. Dashboard -

• When click “Reset Layout” in Dashboard, will have dropdown list to allow user to select to reset the model’s layout to half or full width

• Before creating a new model, you may tick the checkbox (Create Model with Full width) to create a new model in full width. Untick to create model in half width. Default layout will be full width instead of half.

• Newly created models will appear at the top instead of bottom

Enhancement

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

-

5. Language settings will appear at the top of the page for convenience. Before changing language, please ensure that your data is saved, otherwise, the page will reload and your unsaved data will be lost

Enhancement

-

-

1. Physical Trade Bulk Upload bug fixed - some cells will appear in red and cannot submit

Enhancement

Managing Physical Trades

-

1. Paper Trades - CTP function is able to update trades now

Enhancement

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

-

1. Group Dashboard - Click on the “Share” button next to the name of each model and select the group members to share the models with. The shared model will appear in the member’s Group Dashboard

Open

New Feature

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

-

2. Dashboard - Add Company column in Group P/L and P/L Details models. For Group P/L, you need to go to “Settings” and select “Company” from the “Group” drop-down list in order for it to appear in the table

Open

Enhancement

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

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

-

3. Demurrage - New Audit Trail tab: Input Claim ID and you will be able to view the previous updates of the claim (system will save last updated data for up to 7 times only)

Open

New Feature

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

-

4. General Ledger - When select Company Name, Broker and Account column will not be compulsory items (appear in red), if you have one or many Broker and Account under the same Company Name, you may opt to choose from dropdown list to select.

Enhancement

General Ledger

-

1. Dashboard (Group Dashboard):

a. The models shared to Group Dashboard will be exactly the same as original models in Individual Dashboard:

• Group P/L

• Portfolio P/L Details

• FX Exposure

• Futures Accounts

• Position Matrix

• Hedge Ratio

The other models will be updated in the next version.

b. Skipped models will not appear as blank in Group Dashboard

Enhancement

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

https://mafint.atlassian.net/browse/MAF-2798

https://mafint.atlassian.net/browse/MAF-2810

2. All tables' error validation rows (1, 2, 3…) will run in order even after deleting rows in between

Enhancement

-

https://mafint.atlassian.net/browse/MAF-2799

3. General Ledger - If currencies that are not in the portfolio is selected, will not show error and can submit successfully - will affect Group P/L and Portfolio Performance Chart

Enhancement

General Ledger

https://mafint.atlassian.net/browse/MAF-2805

4. Portfolio P/L Details - Bought Price and Sold Price will have no decimal point limit by default

Tax Rate and Exchange Rate will have no decimal point limit by default

Enhancement

-

https://mafint.atlassian.net/browse/MAF-2802

1. General Ledger: Upload CTP file bugs fixed:

• Company Name will be automatically mapped according to Paper Brokers table set up

• If choose incorrect Company Name, Broker and Account will show in red instead of empty; if choose correct Company Name, Broker and Account will pass validation

• If Broker and Account are in the database list, Company Name will be auto-filled accordingly

Enhancement

General Ledger

-

2. General Ledger: Company Name should be mapped according to Paper Brokers table set up

Enhancement

General Ledger

-

1. Demurrage -

• When click SAVE in demurrage calculation page, selection will be first option (Current Final Amount) by default

• When click REPORT in demurrage calculation page, the amount at the top will always follow calculated amount result

Enhancement

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

-

1. Paper Trades (Broker and Account)

If you have set up Broker and Account lists in Settings>Company>Company Data>Paper Brokers table:

• Once you select Broker, the corresponding Account as set up in the Paper Brokers table will auto appear, and vice versa. If there are multiple Brokers/Accounts linked, you will need to select from the dropdown list

• Validation in red (cells) will appear if the Broker and Account do not match the Company’s broker and account data in Paper Brokers table

If you did not set up Broker and Account lists, you may proceed to input/upload your Broker and Account fields as per normal, no validation will occur

Enhancement

Creating New Paper Trade(s)

-

2. Error validation has been added into all the editable tables to identify which row has issues when submitting:

• Create and Edit Paper Trades

• Paper Trades Grouped Trades

• Physical Trade Execution

• Physical Trade Bulk Upload

• Physical Trade Expenses and Income

• Physical Trade Pricing Setting

• Proprietary Market Data

• Proprietary Product Data

• Accounting

• Company>Company Data

Enhancement

-

-

3. General Ledger - Added Company Name column to tag/link each item’s Broker and Account to individual Company

Enhancement

General Ledger

-

4. Date range validation has been added into all the tables to ensure Start Date is not later than End Date:

• View Paper Trades page

• Paper Trades>Grouped Paper trades page

• Paper Trades>All trades page

• General Ledger

• Market Data

• Proprietary Market Data

Enhancement

-

-

5. Proprietary Market Data - Open Contracts button has been enhanced to allow the table to display the open contracts from the portfolio(s) you select

Enhancement

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

-

6. Grouped Rows in Table - You can now set up to 3 colours for the grouped rows in all tables and models/reports in dashboard. Once the column headers have been grouped, the colours will appear accordingly. For 4th rows onwards, the rows will remain as the default colours.

Settings>My Profile>Layout Settings

Open

Open

New Feature

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

-

7. Trade Execution Table - Product column can be edited now

Enhancement

Managing Physical Trades

-

8. Dashboard - Fund NAV Report shareable link has been added

Enhancement

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

-

1. Dashboard - new Fund NAV Report

New Feature

-

-

2. Portfolio (General Ledger) - Added Initial Fund under Type

Enhancement

General Ledger

3. Market Data - Allow input Base Number for creating new market data

Enhancement

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

-

1. Dashboard - Display for some data bug fixed

Enhancement

-

-

2. Market Data - Added “4” in Base Number

Enhancement

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

-

1. Paper Trades (Grouped Trades tab) - T PLUS column can be edited now

Enhancement

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

-

2. MAF Product Code drop-down list search function improved in all related forms eg Physical Trade and Product Code

Enhancement

-

-

3. Physical Trades Pricing page - ? icon updated to reflect:

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.

Enhancement

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

-

4. Group P/L - NaN data bug fixed

Enhancement

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

-

1. Dashboard - Hedge Ratio:

• Added Paper Position Adjustment and Physical Position Adjustment (both can support negative values)

• If Adjustment columns have error, system will clear cache and user will be able to submit to refresh

Enhancement

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

-

2. Dashboard - Physical Trade Inventory: Size is NaN bug fixed

Enhancement

Physical Trade Inventory

-

3. Proprietary Market Data - Will allow negative and 0 value in Settlement Price

Enhancement

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

-

4. Physical Trades - Platts holiday value is missing for pricing calculation

Enhancement

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

-

5. MAF Product Code drop-down list search function improved in all related tables

Enhancement

-

-

6. AG Grid Tables Enhancement:

• Add EXP/COL button - Right click and select to expand or collapse group rows

• Highlight colour in grouped row in all levels with different colours. We will use hardcode now for colour settings; in next version, we will allow user to set in Profile settings

Enhancement

-

-

1. General Ledger - Copy paste positive amount into general ledger will become negative amount bug fixed

Enhancement

Managing Physical Trades

-

2. Paper Trades - Upload paper trades (SFSG Position) fixed

Enhancement

Creating New Paper Trade(s)

-

1. Physical Trades - Trade Execution filter for columns such as Contract No. bug fixed (related to rows per page)

Enhancement

Managing Physical Trades

-

1. Paper Trades enhancement - Broker & Account must match the Company’s broker and account data in Paper Brokers table