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

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

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

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

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

Enhancement

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

Enhancement

2. Paper Trades - Options contracts will aggregate accordingly

Enhancement

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

New Feature

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

New Feature

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

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

-

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

-

8. Dashboard - Inventory Summary Model

New Feature

-

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

Enhancement

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

Enhancement

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

-

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

-

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

Enhancement

-

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

-

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

-

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

Enhancement

-

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

-

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

-

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)

New Feature

-

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

-

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

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

Enhancement

-

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

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

-

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

-

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

Enhancement

-

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

-

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

-

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

-

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

-

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

New Feature

-

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

Enhancement

-

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

Enhancement

-

1. Dashboard - new Fund NAV Report

New Feature

-

-

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

Enhancement

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

Enhancement

-

1. Dashboard - Display for some data bug fixed

Enhancement

-

-

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

Enhancement

-

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

Enhancement

-

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

-

4. Group P/L - NaN data bug fixed

Enhancement

-

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

-

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

Enhancement

-

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

Enhancement

-

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

Enhancement

-

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

-

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

Enhancement

-

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

Enhancement

-

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

Enhancement

-

2. Dashboard (Group P/L) - Same Portfolio, Category and Trader but different Strategy will be able to save successfully

Enhancement

-

3. Dashboard Models eg Portfolio Performance Chart - Bugs fixed in mobile web version

Enhancement

-

-

1. Portfolio Yearly Settlement for Paper Trades will apply for the following models:

• Futures Account

• Portfolio P/L Details

• Group P/L

• FX Exposure

• Portfolio Performance Chart

Enhancement

-

2. Portfolio Yearly Settlement for Paper Trades enhancements:

• Paper Trades table will have a SYSTEM NO. column. All settled portfolio’s trades will be listed as MAF YSI

• Settlement price in Yearly Settlement button in portfolio page is compulsory item

Enhancement

-

3. Paper Trades - Added error reason for failure to upload BANDS TXT file with no trades.

Enhancement

-

1. Portfolio Yearly Settlement for Paper Trades enhancements:

• All paper trades portfolios with open positions and open contract details will be able to do yearly settlement in portfolio

• All paper trades portfolios with no open positions and no open contract details will not be able to do yearly settlement in portfolio

• All portfolios with physical trades, if have open positions and open contract details, will raise error if do yearly settlement as the function is not ready for physical trades yet

• Cannot do yearly settlement again for portfolio that is already settled (have Settled Year) - the system will raise error

• User is not allowed to add new trade (both paper and physical trade) with any date before the last date of the settled year (eg 31-Dec-2022) into the settled portfolio

• User is not allowed to edit/update any trade (both paper and physical trade in the settled portfolio) 's trade date to any date before the last date of the settled year (eg 31-Dec-2022)

• If portfolio is already settled and settled year is 1 year before the current year, if user tries to settle the portfolio again, the system will raise error. E.g., current year is 2022, if settled year is 2021 then the system will raise error. If settled year is 2020 or 2019, system will still settle it normally

• If portfolio yearly settlement does not show contract details and settlement price, Settle button will be disabled

Enhancement

-

2. Portfolio - Start date must be before End Date bug fixed

Enhancement

-

3. Physical Trade (Hedge) - When click on Hedge button for a physical trade, the corresponding paper trade’s Trader and Category will be auto filled accordingly

Enhancement

1. Company Data (Paper Brokers) - For MAF user accounts with multiple companies (subsidiaries), you can now bind your Company Name (Company ID) with Broker and Account for Paper Trades, so as to calculate P/L and positions of paper trades based on companies.

You can click on Settings>Company>Company Data and click on Paper Brokers. Click on Add Row to add the Company Name, Broker and Account and the system will automatically perform calculations accordingly.

New Feature

-

2. Portfolio Yearly Settlement for Paper Trades - Portfolio calculations will have a year end cut off option now so you can choose to exclude P/L calculations for previous years in the new/current year. For instance, you can opt for the P/L of your trades in 2021 to be excluded in the P/L calculations for 2022.

You can go to Portfolio>View Portfolio, tick the portfolio and click on Yearly Settlement and confirm the necessary details to settle/close off all positions (this portfolio will be known as the portfolio with settled year). All open positions will be closed off automatically to become closed positions and realised P/L will be calculated accordingly.So once eg 2021 trades are closed off/settled, you can proceed to the View Portfolio Details page of the portfolio.

For portfolio with settled year, the Settled Year will be displayed under the Portfolio Information section eg 2021 in the page. Start Date will be used to determine the cut off for the P/L calculations. For instance, if you select Start Date before 01/01/2022, the system will add all P/L and commission for 2021 (until 31/12/2021) and add into the new year P/L (which means all accumulated P/L in 2021 will be added into the calculations for 2022 if the Start Date is before 01/01/2022). If Start Date is on or after 01/01/2022, the portfolio P/L will not include any P/L from 2021 and will only include P/L from 01/01/2022 onwards.

For Diagnose button, it will only calculate total P/L for the current/new year (after settled year) eg 2022.

Relevant Dashboard models will reflect Yearly Settlement related figures accordingly.

This function will work on paper trades for now, physical trades function is in progress.

New Feature

-

1. Physical Trade - Bulk Trade Upload Estimated Price bug fixed

Enhancement

-

1. Physical Trade - Bulk Trades Upload date format bug fixed

Enhancement

-

2. Portfolio - Open Positions table size bug fixed

Enhancement

-

1. Paper Trade - Download Template placement button fixed

Enhancement

-

2. Dashboard -

• (Group P/L) start date fixed

• Open Position Details app for China server fixed

Enhancement

-

3. Portfolio - Diagnose button display fixed

Enhancement

-

1. Physical Trades (Payment Record) -

• Add more space above “Signature” for electronic signatures

• Default rows displayed will be 500, “Rows per page” drop down list will be available to adjust the number of rows displayed in the table.

Enhancement

-

2. Demurrage -

• Offset List will include “Payable”, “Receivable” and “Net Amount” columns for “Initial Amount”

• Default rows displayed will be 500, “Rows per page” drop down list will be available to adjust the number of rows displayed in the table.

Enhancement

-