Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Steps:

Table of Contents

...

1. Set up Company Profile

...

2. Input Physical Trades Data - For Operations Team

The New Physical Trade function allows users from different departments/teams to access their designated pages to input their data, ensuring a consistent workflow and reducing confusion.

Alternatively, you may choose to use the old methods to input your data:

1. Manually input physical trades, please refer to below steps, oraccess: Input Physical Trades Manually

2. Bulk upload physical trades, please access: Physical Trades 101 - Bulk Upload

a. Input Basic Physical Trades Data in New Physical Trade (Trade)

i. Please click on Trade, followed by New Physical Trade from the navigation sidebar on the left to enter the physical trade page,

...

bii. Please click on + New Trade and a new row will be added for you to input your data. Please refer to below guide and input the details as necessary.

...

Once done, please click on Save Changes to save your data.

b. Input Stock/Inventory Data in Stock Management

Please refer to Stock Management Function for the user guide.

Once stock data has been input, the following columns for each trade in the New Physical Trade table will be reflected automatically.

  • Stock Date:

  • WH Name & Status:

  • Stock Qty:

  • Unstock Qty:

...

3. Input Physical Trades Pricing Data - For Settlement Team

a. Input Pricing Data in New Physical Trade (Settlement)

b. Input Payment and Invoice Data in PS Ledger

Please refer to Managing Physical Trades for the user guide.

Once PS Ledger data has been input, the following columns for each trade in the New Physical Trade table will be reflected automatically.

  • PSL Amt: PS Ledger amount will appear here if you add a new row in PS Ledger with PSL Type: Payment

  • PSL Date: PS Ledger date will appear here if you add a new row in PS Ledger with PSL Type: Payment

  • Bal Amount: Balance Amount = Trade value - PS Ledger Amount

  • Inv Qty: Invoice quantity will appear here if you add a new row in PS Ledger with PSL Type: Invoice

  • Inv Amt: Invoice amount will appear here if you add a new row in PS Ledger with PSL Type: Invoice

  • Un Inv Qty: Un-Invoiced Quantity = Quantity - Invoice Quantity

  • Un Inv Amt: Un-Invoiced Amount = Trade Value - Invoice Amount

...

4. Create/Manage Quantitative Models & Reports - For Settlement Team

Dashboard - Individual

You must first input paper trades and physical trades data to generate the following figures:

1. Positions and P/L data: Positions and P/L data (including any commission, expense and income and other costs, etc.) are calculated after paper trades and physical trades data are input.

  • Input data such as positions, price and commission etc in Paper Trades and Physical Trades

  • Input data such as expense and income items and other costs etc in General Ledger . When selecting Type in the table, please choose EXP/INC and input:

    • Expense/Costs: Negative value eg -100

    • Income: Positive value eg 100

Please assign the trade/item to tag them to the corresponding portfolio before saving the data. The system will then automatically calculate the positions and P/L according to your data and display in the model/report accordingly.

 

2. Initial Fund, Fund In/Out data: If necessary, you may input as follows:

  • Paper Trades: Please upload or manually enter data in Portfolio>General Ledger>FCM Statement

    • Please select FCM under FCM TYPE column, and then enter data such as margin, total equity, collateral etc.

  • Physical Trades: Please upload or manually enter data in Portfolio>General Ledger

    • Initial Fund: In General Ledger page, please select INIT FUND under TYPE column and enter the data accordingly

    • Fund In/Fund Out: In General Ledger page, please select FUND IN/OUT under TYPE column and enter the data accordingly

Please assign the trade/item to tag them to the corresponding portfolio before saving the data. The system will then automatically calculate the positions and P/L according to your data and display in the model/report accordingly.

...