Versions Compared

Key

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

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

Warehouse Details

Before you begin to input warehouse details, you will be required to set up your warehouse name (WH Name) in the Company Data>Warehouses page.

To fill in warehouse details, tick "Show Warehouse" in the trade execution page. Pleas note that if you fill in "WH Record Date", "WH Name" must be filled in too, and vice versa. Otherwise, you may leave it empty.

  • WH Start Date must not be later than WH End Date. WH Start Date and WH End Date can be the same.
  • WH Storage and Entry Cost cannot be negative

The warehouse details will appear in the Physical Trade Inventory in the Dashboard for your reference.

Image Added

FX Exposure

NO NUM: Refers to nominal amount/number and the master row of NO NUM is the sum of all children row. So if master row only has one child row, then master row value = child value.

If open position is +5, contract size = 1000 Metric Ton, price now is 100 USD/metric Ton, the NO NUM (nominal amount) = 5  * 1000 * 100 = 500,000 (this can be validated using the filters to view the summary amount in OPEN POSITIONS table)


Group

Each licence entitles the user to create 1 group and invite up to 5 users (including the inviting user) into the group.

Demurrage

b. For Demurrage Claims only: Generating a report by clicking 'Report' at the end of the Demurrage Calculations page and a PDF report will be generated in another tab. Scroll to the end of the demurrage report and you will be able to see a token (MAF Link Token: XXXXXXXXXXXX).

...

You can easily access your desired portfolio's ledger by selecting the portfolio from the drop-down list in the top left corner of the page, and the associated general ledger information will be displayed. 

Image Modified


...

Adding a Ledger

...

This section displays the details of your term contracts and whether they have been fulfilled:

  • 'TOTAL QTY': Total quantity to be fulfilled according to the contract.
  • 'TRADED QTY': Quantity fulfilled so far.
  • 'OUTSTANDING QTY': Outstanding quantity not fulfilled yet ('TOTAL QTY'-'TRADED QTY').

You may refer to the 'Physical Trades List' table below in the page to view the physical trades that contribute to the changes in quantity.

Several functions are available to assist in the selection of data: 

  • Search bar: Search for keywords in the search bar for relevant data to be displayed
  • Table Headers: 'Sort' and 'Filter'data using the functions in the table headers (Please refer to Table Settings for table functionalities).

Click here to learn how to create a term contract.

Please refer to List of Definitions: Trades for the definitions of the fields.

Image Modified

...

In general, you need to identify the type of contracts when inputting your data:

1. SPOT:

Scenario A: Purchase/Sale contract with agreed total quantity eg 800 but it is split into 2 shipments with 2 quantities and different prices (500 and 300). You can create 1 trade as per normal and in the 'Benchmark' pricing page, let the quantity for the 1st pricing block be 500 and add the 2nd pricing block to include the quantity 300. You will need to make sure the quantity in the previous page matches exactly (800) to the total quantity in the pricing blocks.

Scenario B: Alternatively, if you have 2 trades with quantity 500 and 300 under the same contract, you can also key it as 2 separate trades and name it as "P1/P2" (purchase contract) or "S1/S2" (sale contract). You will be able to see the outstanding quantity that is not purchased/sold yet under DEALS tab.

The effects and outcome of Scenario A and B are the same, so it depends on which method is more suitable according to your requirements.

2. TERM:

Scenario C: Purchase/Sale contract with agreed total quantity eg 1500 and only 1000 has been purchased/sold, remaining 500 has not been purchased/sold and details are unknown yet. You will key this as a term contract to allow you to monitor the quantity that has been completed and the outstanding quantity that is not purchased/sold under TERM DETAILS tab. You will first need to key in the trade as per normal for the 1500 quantity, and key in the 500 later once you have the details.



...

  1. INVENTORY: Display the details of your inventory.
  2. STORAGE SETTINGS: Manage the details of your storage and its settings.

...

1. If you have a purchase trade transaction ('PURCHASE') and have storage in the Storage Settings, you will be able to store and manage the stocks in your inventory. Under 'Actions' in the table, click the 'Settings' button (represented by a 'gear' icon) of the row and click 'Stock In'. To set up your storage settings, click here.

For example, Company A purchased 10,000 metric tons of Lead from Company B.

Image Modified


2. You will be directed to a new 'Create New Physical Trade' page to key in the details. Some fields will be automatically filled up and you will be required to fill in 'Counterparty' before moving to the next step. 'Counterparty' will be the name of your storage as set up here. You may change 'Quantity + Tolerance' and other details as necessary. 

Complete the pricing stage of the trade and click 'Submit'

Company A stocks in 10,000 metric tons of Lead into Storage X ('Storage Name'), at float/ave pricing of Lead 3M, with 1 day pricing period of 18 Nov 2020.

Image Modified


3. 2 linked trades will be automatically generated in the 'View Physical Trades' table to signify:

a. You ('Entity of Contract') storing/selling ('SALE') your stocks in/to storage name ('Counterparty')

Company A stores 10,000 metric tons of Lead in Storage X by selling to Storage X.

...

b. Storage name ('Counterparty') purchasing ('PURCHASE') your stocks from you ('Entity of Contract'). Your storage name will be the name of 'Deal No.'.

Storage X purchases 10,000 metric tons of Lead from Company A to store.


These 2 trades are linked and editing/deleting either trade will automatically update/delete the other. Click here to learn how to edit/view your trades.

...

1. If you sell your stocks, you can record the transactions by clicking on the 'Stock Out' button of the storage trade (Trade 3 above, Deal No. = Storage Name, Purchase/Sale = Purchase). 



2. You will be directed to a new 'Create New Physical Trade' page to key in the details. Some fields will be automatically filled up and you will be required to fill in:

  • 'Counterparty' to indicate the party you are selling to.
  • 'Quantity' to indicate the quantity you are selling.

Once done, you can move onto the pricing stage and click 'Submit' when completed. Click on the 'INVENTORY' tab at the top of the page to view outstanding quantity and P/L positions.

Company A sells 2,000 metric tons of Lead in Storage X to Company C.

Image Modified

There are 8,000 metric tons of Lead left in Company A's inventory. The same steps can be taken until all stocks are sold out.

Image Modified


Your inventory and portfolio will automatically be updated with the changes associated with both 'Stock In' and 'Stock Out' functions. Repeat Step 1 and 2 until your stocks are sold out.

You may refer to List of Definitions: Trades for the definitions.

...

You may refer to the 'Physical Trades List' table below to view the details of the physical trades that contribute to your inventory.

...