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

-

1. Paper Trades (Grouped Trades) - Allow editing of TRADE TYPE (Hedge/Speculation)

Enhancement

-

2. Dashboard (Group P/L) - Enable grouping of rows/categories

Enhancement

-

3. Dashboard (Hedge Ratio) - Adjustment (ADJ) display bug for master row fixed

Enhancement

-

1. Paper Trade - Allocate portfolio from creating paper trade bug fixed: If select a portfolio and delete and save, no portfolio will be allocated.

Enhancement

-

2. Group - Members available to add count bug is fixed for Admin role

Enhancement

-

3. Dashboard FX Exposure Report:

• Add Trader column

• User can only edit ADJ column in master row only

• If user clicks on ADJ column but did not add any value, it will return as 0.00 instead of empty

• In Group Dashboard, ADJ column is not allowed to edit.

Enhancement

-

4. Dashboard - Hedge Ratio & Group P/L Enhancements:

• Remove excess rows and default grouping and change to master row

• Only child row is able to edit ADJ column

• Add a column called GROUP before PORTFOLIO

• In Group Dashboard, ADJ column is not allowed to edit

Enhancement

-

5. Paper Trades - Creating Paper Trades: When uploading brokers' file statement, user can choose to tick H/S to allow the original TRADE TYPE (Hedge/Speculation) to be displayed; if unticked, TRADE TYPE will be Speculation by default

New Feature

-

6. Physical Trades - Auto fill-up Title Transfer Date

• In Trade tab page, click on AUTO TTD button above Trade Execution table and all the trades with no Title Transfer Date will be auto-filled with their Trade Date, and click on Save to bulk-update successfully.

• In Bulk Trades Upload tab page, the AUTO TTD checkbox is ticked by default. If ticked, Title Transfer Date will be auto filled based on Trade Date; if unticked, it will run as per normal

• in Bulk Exe Update page (button above Trade Execution table), the AUTO TTD checkbox is ticked by default. If ticked, the Title Transfer Date column will not appear in the Bulk Exe Update table so Title Transfer Date will not be updated (existing date will remain unchanged). If unticked, Title Transfer Date column will appear in the table for you to fill in

New Feature

-

1. Group - Bugs fixed for:

• Link/Unlink Licences

• Reactivate Group

• Associated expense/income table

Enhancement

-

2. Subscription - Bugs fixed for:

• Unpaid Invoice

Enhancement

-

1. Group - Bugs fixed for:

• Link/Unlink Licences

• Reactivate Group

Enhancement

-

2. Hedge Ratio - Enhancements for hedge ratio value when unit is PHYSICAL

Enhancement

-

3. Proprietary Market Data - OPEN CONTRACTS button: Click on the OP CONTRACTS button and the product details of open contracts will be displayed for you to input the date and settlement price.

New Feature

-

1. Physical Trade - Payment Record (Invoice): In GOODS OR SERVICES DETAILS section, when edit the Net Weight at the top section, the bottom section will be changed accordingly, and vice versa

Enhancement

-

2. Company Data - Auto Running Numbers enhancement:

• System will use the maximum number to generate the new auto running number, even in cases of manual-editing of auto running number

• Suffix can be edited for the same Index Name and the auto running number will be generated accordingly with the edited suffix, unlike Prefix

• When Prefix is edited for the same Index Name, the auto running number will restart according to the setting and will not run accordingly, unlike Suffix

Enhancement

-

1. Paper Trade - Commission decimal point setting is under Amount Decimal Point (in Settings>My Profile)

Enhancement

-

2. Product Data Mapping - Copy and paste data into Mapping Name bug fixed

Enhancement

-

3. Demurrage - Added visible buttons for Rename and Delete, can be performed in addition to right-clicking

Enhancement

1. Bulk Upload - Physical Trades

• Upload trades with existing deal number with potential premium, potential premium will appear as per normal instead of 0

• Paste existing Deal No. and Deal ID will appear accordingly

Enhancement

-

2. Demurrage Claims

• MAFSpace - Loading speed reduced when dragging and dropping file into folder

• Claims table - Bulk deleted speed reduced

Enhancement

-

3. Paper Trades - CTP file upload minor bugs fixed

Enhancement

1. Hedge Ratio Modification

• New column has been added: HEDGE POS ADJ (eg physical position is 700, HEDGE POS ADJ is -200, total physical position will be 500). HEDGE POS ADJ will be summed up in group master row.

• User is able to input and edit value (positive/negative sign) and click on SAVE button to save the value.

Enhancement

-

2. Demurrage Claims View Page - Copy from Internal Comments and Remarks fixed

Enhancement

-

1. Dashboard - Allow members in the same group to view the models in Dashboard (click on Dashboard Panel>Group)

• You can allow other group members to view the models by ticking the checkbox next to the title of the model. Any model with the ticked checkbox will appear in the Group Dashboard which will be accessible by all group members

This is different from Share Dashboard link, which allows any users who may or may not be users of MAF Cloud to access the dashboard (link will expire in 8 hours) and all models in dashboard will be shared. In Group Dashboard, only group members can access the dashboard and only ticked models will be shared.

Enhancement

-

2. Physical Trades - New tab called DAILY CHANGE after PHYSICAL PRICING SETTING tab to handle physical trade average pricing daily position change for HEDGE RATIO model

• Start Date will be 1st day of current month and End Date will be today’s date by default

• You need to delete physical trade daily change data first before related physical trades or physical trades pricing can be deleted

• In HEDGE RATIO app: If there are any linked daily changes in Daily Change table

  • Cut off day will be current date (today), so for any rows with any date beyond today’s date, the position will not appear in the HEDGE RATIO app

  • Sum of all average daily change amount based on pricing ID will form the ACCUM QTY in Daily Change table

  • If the trade has estimated price or actual price (PRICED_IN = TRUE), there will be no open position and so will not appear in HEDGE RATIO

  • New physical position should be = Normal Position Qty - ACCUM QTY if normal position qty > 0; otherwise, will be = ACCUM QTY

  • ACCUM QTY Value: Final value will appear in the 1st row of the ACCUM QTY of each pricing ID group

  • REMAIN QTY Value: TOTAL QTY - ACCUM QTY

For example,

Case 1:

1. Benchmark: -1000 MT SHFE/CU

2. Premium: -1000 MT SHFE/AL

3. Potential: + 1000 MT SHFE/CU

4. Daily change for Benchmark and Premium will be 200 MT each

5. So sum up accordingly and the positions will be shown

   • SHFE/AL: -800

   • SHFE/CU: 200

New Feature

1. Demurrage Report “Prepared by” fixed - Updated user name will be reflected in demurrage report

Enhancement

-

2. Hedge Ratio App - New default calculation for Hedge Ratio = Sum (all paper positions with exchanges in China) / sum (rest of the positions) * 100 %

Exchanges in China: [SHFE, DCE, ZCE, HXCCE, CFFEX, INE, COTC]

Enhancement

-

1. My Profile - Can change user name. Go to Settings>My Profile to change user name and save

Enhancement

-

2. Physical Trade Deals - MTM Update in Deals tab

• Can use MTM Update for original trade with different pricing currency (eg original is USD; MTM Update product can be CNY)

• Cannot use MTM update for original trade with different units (eg original is Metric Ton, MTM Update product cannot be Barrels)

Enhancement

-

3. Physical Trade - Duplicate trade

• If the original trade’s deal currency is USD, you cannot duplicate the trade and change to other currency eg CNY.

  • Original trade has exchange rate - Due to deal currency being USD, but pricing currency is CNY, so there may have exchange rate

  • When duplicate to a new deal with different currency eg CNY, but pricing currency is CNY, so there should not have exchange rate

Enhancement

-

4. Dashboard - Hedge Ratio: You may choose to place different products on the numerator or denominator according to your needs. If you did not set up the setting, hedge ratio's calculation will use the default method - sum of negative positions (short positions) / sum of positive positions (long positions) in same portfolio, category and trader.

Enhancement

-

5. Demurrage - Remarks in Demurrage Report unsupported text format fixed

Enhancement

1. Physical Trade Execution - Enable editing of Contract Quantity in trade execution table and Bulk Execution Update table

• Can change Contract Qty in trade execution table and bulk execution update table even when Actual Qty is filled

• Cannot change Contract Qty in trade execution table and bulk execution update table if the trade has multiple pricing blocks (eg 1000 MT split into 400 MT and 600 MT)

Enhancement

-

2. Dashboard - Group P/L app: Allow user to choose which date to compare with for “Daily Change”. If left empty, the app will automatically use the previous weekday to compare against.

Enhancement

-

3. Demurrage - Enhancements made:

• Company letterhead format has been enhanced; all items in company letterhead will be auto uppercase

• Remove MAFLink token in demurrage report

Enhancement

-

4. Physical Trade Deals tab - Physical Trade List table has been removed

Enhancement

-

5. Physical Trade Execution Table & Expenses/Income table - Drop column to form row group fixed

Enhancement

-

6. Portfolio - Recalculate button allows you to choose a start date to select the earliest trade date to recalculate trades from. If empty, the system will use the earliest possible trade date to perform recalculations.

Enhancement

-

7. AG Grid tables - Highlight multiple cells and delete issue fixed

Enhancement

-

-

8. Company Profile - Logo resizing is flexible now

Enhancement

-

9. Physical Trade Invoice - Exchange rate’s decimal point set to no limit

Enhancement

-

1. Demurrage Claims bugs fixed:

• Upper case all items in demurrage report, including date, hours and minutes

Enhancement

-

2. Trade Execution - Bulk Exe Update issues fixed:

• When upload file in bulk exe update, Actual Quantity will be uploaded

Enhancement

-

1. Demurrage Claims bugs fixed:

• If Payable/Receivable is left empty and MAFLink is used, Payable will be auto-filled

• Drag-and-drop of rows for calculation portion and ops adjustment in demurrage summary fixed

• Edit Valid Laycan Start value and save will be successful

• Ratio for Cargo Proration will be kept at 2dp in demurrage report

• Delete ops adjustment row fixed

Enhancement

-

2. Trade Execution - Bulk Exe Update issues fixed

• When use bulk exe update, Estimated Price will not be auto-replaced

• When upload file in bulk exe update, premium will be uploaded

Enhancement

-

3. Physical Trade Table Layout - After deleting template layout, can select new template layout fixed

Enhancement

-

1. Trade Execution Bulk Update - Loading speed for bulk updating multiple rows (above 100) in trade execution table will be faster

Enhancement

-

2. Table Template Layout bug fixed - After deleting layout template, you can choose another layout immediately

Enhancement

-

-

3. Physical Trades Table Saved to Cache - If use search bar and update trade execution table, the search bar result will remain in the table until you refresh the page

Enhancement

-

4. Demurrage - All inputs will be converted to upper case. You may need to enter each demurrage calculations page and click on “Save Claims” and refresh to view the update

Enhancement

-

1. Trade Execution - Bulk Exe Update bug fixed: Leaving the fields empty and saving will replace any existing fields

Enhancement

-

2. Paper Trades - Grouping trades bug fixed for options

• C/P and Strike price will appear according to inputs

• Trades with different C/P and Strike price cannot be grouped together

Enhancement

-

3. Physical Trades bug fixed for Deals - MTM Update: After inputting actual quantity, you can use MTM Update in DEALS tab as per normal

Enhancement

-

4. Dashboard - Group P/L app’s daily change column will exclude weekends in its calculations

Enhancement

-

1. Options are added into system - Can create product and market data with Options product type (forward options, futures options and spot options); C/P and Strike Price columns added into Market Data, Product Data and Paper Trade page

• 4 (FUTURES OPTION)

  • year, month, c/p, strike must have value

  • value date must be empty

• 5 (FORWARD OPTION)

  • value date, c/p, strike must have value

  • year, month must be empty

• 6 (SPOT OPTION)

  • c/p, strike must have value

  • year, month, value date must be empty

• 1 (FUTURES)

  • year, month must have value

  • value date, c/p, strike must be empty

• 2 (FORWARD)

  • value date must have value

  • year, month, c/p, strike must be empty

• 3 (FOREX or SPOT or SPOT FX)

  • value date, year, month, c/p, strike must be empty

New

-

2. Paper Trades - Edit grouped trades fixed

Enhancement

-

3. Market Data -

• Create or update market data fixed

• If have duplicated data will have error message

Enhancement

-

4. Product Data - Create or update market data fixed

Enhancement

-

5. Error Handler fixed:

• Add/Edit New Paper Trade

• Add/Edit New Physical Trade

• Add/Edit Product Data

• Add/Edit Market Data

• Proprietary Market Data

• Proprietary Product Data

• Data Mapping in Settings

Enhancement

-

-

6. Physical Trades (Deals) - MTM Updates fixed: When user did not input benchmark pricing or MTM pricing for the deal, user will not be able to use MTM Update. So an error will pop up to prompt user to go to one of the trades of the deal to add pricing first.

Enhancement

-

7. Proprietary Market Data upload issue fixed

Enhancement

-

8. Physical Trade Execution - Estimated Price column is removed from Bulk Exe Update table

Enhancement

-

1. Physical Trades - MTM premium will follow product (Financial Instrument)'s currency

Enhancement

-

-

2. Demurrage - MAFLink token will prevent “-” from appearing as the back which will cause error

Enhancement

-

-

1. Table Layout issue fixed - all features such as Paper Trades & Demurrage

Enhancement

-

-

2. Market Data - Data cannot be duplicated, will show error message

Enhancement

-

-

3. Group - Unregistered user can join group automatically once he/she clicks on the group invitation email to sign up for an account first.

Enhancement

-

1. Trade Execution - Add Estimated Price column in trade execution table and allow editing of Estimated Price directly in trade execution table

Enhancement

-

2. Trade Execution - Pre-Final Price and Pre-Final Price before Tax will be shown as 0 if it is 0 instead of empty

Enhancement

-

3. Trade Execution - Pre-Final Price = Estimated Price or Actual Price + Premium fixed

• If pricing mode of a trade is FIXED, its Estimated Price cannot be input

• If pricing mode of a trade is FIXED, its Actual Price cannot be empty

• If a trade has Premium, it can be 0.0 (can be edited) but cannot be deleted in the trade execution table

• If Estimated Price and Actual Price are not input but Premium is input, Pre-Final Price will remain empty until Estimated Price and Actual Price are input

Enhancement

-

4. Product Data - Created product data will be auto converted to upper case

Enhancement

-

5. Subscription page updates:

• All amount will be in 2 decimal points

• Billing History table is fixed

• Subscription plans' descriptions updated

Enhancement

-

6. Physical Trade - Deals tab allow direct updating of MTM pricing indexes. Update the MTM Pricing code, tick the deal row and click on the “Update MTM” button to update the MTM pricing for the trade.

• MTM Update of premium for existing trade’s premium will only work if pricing mode of existing premium is FIXED. Otherwise, error message will appear.

• Tax rate in pricing code in Physical Premium Setting fixed - tax rate will auto appear in the corresponding physical trade.

• If the existing trade’s trade mode is “Offshore”, using a pricing code with tax rate for MTM update will not be allowed.

• If unit of pricing code in Physical Pricing Setting is different from the physical trade’s unit, error message will appear.

• If pricing code in Physical Pricing Setting table is deleted, the existing pricing index details will remain in the physical trade page.

Enhancement

-

7. Paper Trades - Upload FCStone files' commission

• For SGX/UC, system will use the files' label “Commission” to obtain the commission values and commission currency will be USD

• For the rest, system will use the files' label “Total Charge” to obtain the commission values and commission currency will follow P/L currency

• If one of the rows' commission is empty, but any other rows under the same group has commission currency, system will use that commission currency

Enhancement

-

8. Product Data - Copying of product type and mapping name onto the table fixed

Enhancement

-

9. Paper/Physical Trade - If product is used in paper/physical trade, cannot delete the product in Product Data table. Will have to remove the product from the paper/physical trade before deleting

Enhancement

-

1. Paper Trades - Upload SFSG or FCStone files fixed:

   • If the uploaded file has an empty or 0.0 commission row and uploaded into the system, system will sum up together with other rows' commission,

   • If the uploaded file has an empty or 0.0 commission row and uploaded into the system, it will use the commission currency of its group

Enhancement

-

1. Paper Trade - Upload paper trade with ‘AGGR’ ticked is fixed

Enhancement

-

2. Physicsl Trade - Upload bulk physical trades and premium is shown correctly in edit physical trade page

Enhancement

-

1. Trade Execution - Change actual price for trades with pricing mode (WMA/FLOAT/SPOT) without linking physical pricing will prompt a pop up message to notify user to link the trade with pricing first

Enhancement

-

2. Subscription page enhancement

Enhancement

-

1. Physical Trades - Fixed/Actual price = 0 is now supported in the system.

Fix/Actual price = 0 can be supported in all related features:

• Physical Trades

• Trade Execution

• Bulk Execution Update

• Physical Bulk Trade Upload

• Exp/inc table

• Portfolio

• Dashboard Models eg Portfolio P/L Details

Enhancement

-

2. Dashboard - CP Risk Summary model will now include paper trades only and exclude physical trades

Enhancement

-

3. Fixed price = 0 issues fixed:

• P/L Details app - Fixed price = 0 will be shown as PHYSICAL PRICED IN

• Trade Execution - Change actual price = 0 to other value will update portfolio and related models

• Fixed price cannot be empty (must have value = or > 0), otherwise it will remain as original value

• Payment Record (Invoice) - If fixed price = 0, invoice can be generated

Enhancement

-

4. Physical Trades - If pricing mode is WMA/FLOAT/SPOT, actual price can be changed to 0 in trade execution table fixed

Enhancement

5. Physical Trades - Changing Exchange Rate or Custom Tax Rate for trades with split quantity in trade execution page fixed

Enhancement

1. Portfolio - Date range in View Portfolio Page will apply to Open Positions, Closed Positions and Trades table

Enhancement

-

2. Paper Trades - New Brokers added:

• BPI Trades (亮点)

• BANDS Trades (.txt) (磐石)

New Feature

-

1. All tables - Add Reset Filter button at the top of the table

Enhancement

-

-

2. Dashboard (FX Exposure) - Filters in table fixed

Enhancement

-

3. Paper Trades - Upload newly created product data/market data (futures or forward products) fixed

Enhancement

-

4. Dashboard - All models can now be shared in Chinese

Enhancement

-

5. Paper Trades - System can now support uploading of swap trades

New Feature

6. New broker - JR 金瑞 has been added into system

Enhancement

-

-

1. Portfolio (Open Positions Table) -

a. Show negative in size column (eg -40.123) if it is sell; show positive in size column (eg 40.123) if it is buy.

b. Add summary row to sum up:

• Size

• Unrealised P/L

Enhancement

-

2. Dashboard (FX Exposure app) -

a. You can now select multiple portfolios and we have added Portfolio Name column in front of Category column

b. Calculations will be adjusted to NET EXPOSURE = GROSS EXPOSURE + FX HEDGE + ADJ

Enhancement

3. Proprietary Market Data - From and to date will display 1 week of data by default. You may change the from and to date as necessary.

Enhancement

-

4. Dashboard (Futures Account app) - Can choose to use public market data or proprietary market data

Enhancement

-

5. Paper Trades - Aggregate button in create paper trades has been replaced by an “AGGR” tick.

Tick = Aggregate trades by product ID, buy/sell, year, month, valuation date

Untick = Display trades separately

Enhancement

6. Demurrage - Unable to save 0 in NOR+___ field is fixed

Enhancement

-

1. Demurrage - Placed Metric Ton and Barrels at the top in UNIT drop down list

Enhancement

-

2. Portfolio - Edit portfolio details fixed

Enhancement

-

3. Dashboard - FX Exposure model bugs fixed

Enhancement

-

4. Add PVT column to Portfolio (Open Position table) and P/L Details model

Shows PUB = trade is calculated using public data

Shows PROP = trade is calculated using proprietary/private data

Shows empty = Priced_In = true : trade has price (estimated/actual price) so column will be empty/blank

Enhancement

-

1. Demurrage - Add No. of Berth Demurrage Claims page.

Enhancement

-

2. Paper Trade - All paper trades tab’s from and to date will display 1 week of data by default. You may change the from and to date as necessary

Enhancement

-

3. Paper Trade - CTP trades upload’s ACCOUNT and BROKER red cells fixed

Enhancement

-

4. Demurrage - If select company type as OWNER, cargo quantity will disappear after saving

Enhancement

1. Demurrage - Add Cargo Quantity and Unit in Demurrage Claims page.

Cargo Quantity will be linked to the Cargo Proration section

Enhancement

-

2. Paper Trades - Upload paper trades for slower connection fixed

Enhancement

-

3. Dashboard - New FX Exposure Model

New Feature

-

4. Demurrage - MAFSpace limit to increase total upload size to 100mb for uploading of multiple files at any one time.

Enhancement

1. Trade Execution - Allow editing of fields directly from the trade execution table; namely,

• Trader

• Category

• Contract Number

• Title Transfer Date

• Actual Price

• Actual Quantity

• Exchange Rate

• Premium

Enhancement

-

2. Trade Execution - Allow bulk trade execution update - click on ‘Bulk Exe Update’ button and input the changes/upload the file and the existing details will be auto-replaced by the new details.

Enhancement

3. Portfolio - Allow row-grouping function for Open Positions table

Enhancement

-

4. Edit Grouped Trades - Commission and commission currency will remain original

Enhancement

5. Bulk Trades Upload - Add Execution Number as one of the columns

Enhancement

6. Dashboard - Portfolio search bar for numerical values eg 1 is fixed

Enhancement

7. Dashboard - CP Risk Summary and P/l by Instrument models fixed - exchange rate input in trade execution will be reflected accordingly

Enhancement

8. Demurrage - MAFSpace size limit per file is 50mb instead of 10mb

Enhancement

1. All AG GRID tables - After filtering data in the table, and returning to the same page, the data will remain filtered until you click the Reset Filter button or right-click and click on Reset Filter. This works even when changing template layout

Enhancement

-

-

2. Portfolio page P/L and Portfolio P/L Details model in Dashboard will have the exact same value as both take into account specific exchange rate (eg OTC^USD/CNY input in Proprietary Market Data).

Group P/L model and Portfolio P/L Details model in Dashboard will have the same total P/L value

Enhancement

-

3. General Ledger - If expense amount is negative, in group p/l and portfolio performance, the amount will use the original sign (negative); but in portfolio p/l details, the amount will be -1 * original sign (positive)

Enhancement

4. General Ledger - Upload SFSG file date fixed

Enhancement

5. Trade Execution - Exchange Rate field fixed - if deal currency and product settlement currency is the same eg CNYCNY, Exchange Rate field will be disabled (cannot fill in)

Enhancement

7. Dashboard - Changes in the following models to ensure all commission is negative as it is a cost and all costs will be negative and income will be positive.

1. group p/l

2. p/l details

3. performance chart

Enhancement

1. Portfolio - To close expired positions (paper trades only) manually in the portfolio page, tick the checkbox(es) of the trade(s) and click on 'EXPIRE POSITIONS' at the top right corner above the table, and they will be closed on the trade date or settlement date, whichever is later. Please note that the system will check and auto-expire positions (with last settlement date more than 2 weeks from today) on a daily basis.

Enhancement

-

2. Market Data - Data for the past 3 months will be displayed by default instead of 1 year. You can use the date filter to search for data from the past few months/years.

Enhancement

-

1. Add Deal Trade - Category will be auto-filled when add deal trade

Enhancement

-

2. Product Data - Edit product data will link to correct product data, PRODUCT CODE column is removed, CREATED BY column is fixed

Enhancement

-

3. The numbers will be default, no round

• open positions:

  • average price

  • settlement price

• close positions:

  • bought price

  • sold price

• trades:

  • price

  • phy settlement price

Enhancement

4. Proprietary Market Data - Exchange rate (eg OTC^USD/CNY) will use the input DATE’s exchange rate or any date before that (if exact DATE is not available) in prop market data page

Enhancement