Close Expired Positions
...
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.
...
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.
...
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.
...
- INVENTORY: Display the details of your inventory.
- 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.
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.
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.
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.
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.
...
Type | Description | Example |
|---|---|---|
| Deal ID | Unique Deal ID tagged to each portfolio, auto-generated by system | 763 |
| Deal No | Deal number of trade | MAF2001 |
| Outstanding Quantity | Outstanding/Remaining quantity of the trade, yet to be purchased/sold | 33,400 |
| Unit | Unit of trade | Kilogram |
| Currency | Currency of trade | Yen |
| Realised P/L | Amount of profit/loss that has been converted to cash | +10,000 |
| Unrealised P/L | Potential profit/loss that is on paper but has yet to be converted to cash | +15,000 |
| Commission | Commission paid by user to the broker | 15 |
| Total P/L | Total amount of profit/loss from realised and unrealised profit/loss | 25,000 |
| Created By | User who creates the deal | Alex |
| Created On | Date/Time when deal was created | |
| Last Updated By | User who updated the trade last | Brad |
| Last Updated On | Date the trade was last updated on |
Additional Note:
In EXPENSE/INCOME table, expense amount should be input as a negative value, and income amount should be input as a positive value.
This amount will be reflected accordingly in the Portfolio P/L Details model but in the opposite direction (+ will become - and vice versa) in the Group P/L model.
In GENERAL LEDGER table, expense amount should be input as a positive value, and income amount should be input as a positive value.
This amount will be reflected in the opposite direction as -1 * original 
or 
sign (+ will become - and vice versa) in Portfolio P/L Details model but reflected as per normal in the Group P/L model.
With these different calculation methods, the total P/L value will be the same.
...