Creating New Paper Trade(s)

Return to Overview

MAF Cloud allows you to input details of each paper (as well as physical) trade, so as to track and manage them easily in one platform. The market data are automatically integrated from various exchange sources and are updated daily to provide the latest figures. Paper trades created may be selected/added into your portfolio(s), which can then be used for further analysis, monitoring and risk management purposes.

Creating Paper Trade(s)

1. Under 'Trade' in the navigation sidebar on the left, click 'Paper Trade'.

2. Click '+ New Paper Trade' on the top right corner to create new paper trade(s).

3. Before you input/upload your paper trades data, you can choose to select the "Aggregate" (AGGR) function and "Hedge/Speculation" (H/S) function to display your data accordingly.

Aggregate

To allow you to view the aggregated summary of your paper trades, click on the “Aggregate” (AGGR) checkbox to tick or untick.

Tick: If you tick the checkbox and upload your file, your data will be categorised according to PRODUCT CODE>BUY/SELL>CONTRACT YEAR>CONTRACT MONTH>VALUATION DATE for you to check against any transaction summary.

Untick: If you untick the checkbox and upload your file, it will be uploaded as per normal according to the statements.

This is applicable for all types of products - futures, forward, spot and options products etc.

Hedge/Speculation

Tick: Tick the “H/S” checkbox to allow the original “TRADE TYPE” (Hedge/Speculation) in the file to be displayed.

Untick: If unticked, “TRADE TYPE” will be displayed as Speculation by default for all trades.

Input/Upload Data

Click '+ Add Row' and you will be able to capture new paper trade(s) by:

• Manually keying the data into each cell (select your product from 'MAF PRODUCT ID' and the next 3 columns will be automatically filled)
• Copying and pasting data into the table
• Importing data using a .CSV file (click on the '...' located at the top right corner and select the format). Choose the file format based on your broker's name and please ensure that the headers in your .CSV or Excel file match exactly as the ones provided in the table. If the file is listed as C, it means it supports .csv file only. If it is listed as E, it support Excel file only. C/E will support both .csv and Excel files.

• Download MAF format template by clicking on the "Download Template" and once the information has been filled up, you may click on the '...' located at the top right corner and select MAF C/E to upload the file. Please be reminded to upload the correct language version of the file into the system. For instance, if you are using the English version in the system, you will be required to upload the file with the English headers. 

  • MAF Trade Format:

    • TRADE DATE: DD/MM/YYYY

    • T PLUS: 1 means T+1, empty means T (normal)

    • REFERENCE ID: Text format, must be unique and cannot be repeated

    • PORTFOLIO NAME: Case-sensitive 

    • 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.

    • EXCHANGE: Text format, will be auto filled once MAF Product ID has been filled

    • TRADER, CATEGORY, STRTG: Text format, will auto uppercase 

    • PRODUCT CODE: Text format, will be auto filled once MAF Product ID has been filled
    • PRODUCT NAME: Text format, will be auto filled once MAF Product ID has been filled

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

    • SIZE: Number format, cannot be negative value

    • TRADE TYPE: Key in Hedge or Speculation, default is Speculation

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

    • CONTRACT YEAR: YYYY

    • VALUATION DATE: DD/MM/YYYY 

    • C/P: C means Call, P means Put, case-insensitive

    • STRIKE Price: Number format
    • IDB: Text format, will auto uppercase

    • ACCOUNT, BROKER: Text format, will auto uppercase

    • PRICE: Number format, can be negative value

    • TRADE VALUE: Can be left blank, once saved, system will auto calculated based on SIZE and PRICE
    • REMARKS: Text format
    • COMMISSION: Number format
    • IDB COMMISSION: Number format, can be negative value

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

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.

Broker and Account

If you want to tag each broker and account to specific company/subsidiaries to calculate P/L and positions separately, you will be required to set up in the Paper Brokers table (Setting>Company>Company Data>Paper Brokers). Please note that you have to make sure that the Broker and Account input in Creating Paper Trades page have to be exactly the same as those in the Paper Brokers table, otherwise you will not be able to save successfully. When you select Broker, the corresponding linked Account will be displayed accordingly, and vice versa.

• 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

Otherwise, you may choose not to set up the Paper Brokers table and input your Broker and Account accordingly.

IDB COMMISSION 撮合费 and IDB 撮合商 will appear in Paper Trades:

• view table

• edit table

• create new trade table

• grouped trade table (view)

• all trades table

for future reference, commission and IDB commission will be split into 2 accordingly when grouped trades into 2 etc. IDB Commission can be negative value.

IDB COMMISSION 撮合费 will also appear in Portfolio:

• Meta table
• Trades table

as well as in Dashboard:

• Group P/L app

• Portfolio P/L Details app

Currently we only add IDB commission amount into those 4 places to do p/l calculation, the rest will exclude idb commission at this moment.

1. portfolio details page

2. portfolio details page diagnose

3. group P/L app (individual/group dashboard, shared)

4. group P/L his save and view in Group P/L app (means try to click on Save button in Group P/L, and in setting tick historical group P/L data and check if it works well)

   • i guess you tick historical in settings. but you did not save any data before.

     if you wanna loading historical data

     1. untick historical in settings

     2. submit and reload

     3. click save

     after that try tick historical in settings and submit load. it should have data

5. portfolio position p/l details app (individual/group dashboard, shared)

T PLUS logic (Choose T+1 or leave it empty): 

You may choose to input T+1 for certain paper trades

In China futures markets, night trading session is considered next day trade (if user trades at 07 Dec 2021 in night session, the trade date is 08 Dec 2021, so the trade is only shown in 08 dec 2021 statement). However, in some of exchanges, e.g, CME, there is no such arrangement. It will be considered 07 Dec 2021 trade date and shown in 07 Dec statement.

There will be a case where user wants to standardise the date when he/she does trade spread trading (e.g., BUY SHANGHAI COPPER and Sell COMEX COPPER in night session). In broker statements, SHANGHAI COPPER shown in 08 Dec 2021, COMEX COPPER shown in 07 Dec 2021.

So we have added a “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

So once you tick “Excl T Plus”, and end date is 07 Dec 2021, then COMEX COPPER trade will be filtered out on the end date and portfolio P/L and positions will be recalculated.

Please note that 'Trade Date' should not be after today's date and if COMMISSION CURRENCY is not input, the commission's currency will follow the portfolio's currency.

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

Options

To support options, C/P and Strike Price columns can be filled or will be auto-filled when uploading trades (click on "CTP Position" from the upload drop-down list).

After selecting MAF PRODUCT ID, if you have set up the Category for the product in Proprietary Product Property, the Category will be auto-filled accordingly.

To delete unnecessary row(s), tick the checkbox of the row and click 'Delete Row' at the top right corner above the table.   

Before you save, you can check out the grouping function in the table which acts like a pivot table (click here to learn more) and can be categorised and organised by groups according to your needs. You can click here to learn how to customise the table by arranging and filtering the columns based on your preference. 

For more information about the terms used when creating a paper trade, please refer to List of Definitions: Trades.

4. Once you are done inputting your data, you may input the Portfolio Name directly in the table by double clicking on the cell or tick the trade and input or select the portfolio you wish to allocate the trade(s) into at the bottom of the page. Otherwise, leave it empty. If you have not created a portfolio, you can simply allocate them later (Please refer to Creating New Portfolio).

5. Click 'Submit' and you are done! Your newly created paper trades will be reflected in the Managing Paper Trades page.

Alternatively, you may allocate the trades into your portfolio(s) in this page while viewing them.

In the Managing Paper Trades page, tick the checkbox(es) of the trade(s) you wish to allocate, and click on "Allocate Portfolio". You will be directed to the page to select the desired portfolio from the drop-down list ('Select Portfolio') below the table.

Once you select the portfolio from the dropdown list, it will appear in the "Portfolio Name" column. Click 'Save Portfolio' once done, and the trades will be allocated into the portfolio accordingly.

You may easily change the portfolio allocation of (allocated) trades here as well, with the same procedures. To remove the allocated trade(s) from the portfolio, tick the checkbox(es) of the trade(s) you wish to unallocate, and select 'Remove Portfolio' from the drop-down list ('Select Portfolio') below the table. Click 'Save Portfolio' below to save the changes.

• Note: If you trade any Chinese futures instruments via CTP (click here to learn how to link your CTP account), you can update your CTP trades in the Managing Paper Trades page. Simply click on 'CTP', select the account, and click 'Update CTP Trades'. Once updated, your (new) CTP trades will be displayed in the table, along with other trades you may have captured earlier and/or from elsewhere. (Please refer to CTP Accounts for more information).
  
  

Functionality

Please refer to Table Settings for table functionalities.

Definition of Terms

Please refer to List of Definitions: Trades

Additional Definitions:

• 'Add Row': Adds an additional row into the table
• 'Delete Row': Deletes the selected row
• 'Submit': Saves data in the table and submits to the system