Position Screen Delivered Row
A new row above the Floating line called “Delivered” has been added to the Position screen. This row shows all quantities that are logistically delivered but one of the 2 sides is not yet priced. Note that the total will typically be zero because for those cases there are always 2 sides (Purchase + Sale or Inventory + Sale).
Mark to Market Screen Filter Changes
The filters on the Mark to Market Screen have been taken out of a Filters section. Like filters are now grouped together and displayed at the top of the Mark to Market table.
Mark to Market Screen Data Export
Mark to Market screen data may now be exported to an Excel spreadsheet. There is a new permission which controls access to the functionality called “Export MTM data” under the MTM permissions. A user with this permission will see a download button on the Mark to Market screen.
Selecting this button will begin the spreadsheet download. (Note that the download may take a while to complete.)
The spreadsheet will consist of all the underlying asset records; not just the summaries that appear on the Mark to Market main screen but all assets as they would occur in all Mark to Market details screens. All information is displayed in 1 excel sheet. When there is no data, a cell will be blank. It will include columns for all asset types. The data is not summarized or totaled but will be sorted by the same default grouping-order and sort-order as the Mark to Market summary screen.
Hedge Allocation Trade Date Range and Excel Download
It is now possible to specify a range of trade dates on the Hedge Allocation screen. Two date fields are available at the top right of the Hedge allocation table. The Speculative button has been removed and the Automatic allocation button moved between the two columns.
A download button has also been added next to the Trade date filters. Selecting this button downloads an Excel spreadsheet with hedge allocation data.
The data contained in the spreadsheet export is as follows:
Broker Name of the exchange broker from the futures upload record
Upload Name of the uploaded file, or empty if the trade was entered manually
Upload date Date that the broker statement was uploaded, or empty if the trade was entered manually
User name User who uploaded the broker statement, or empty when the trade was entered manually
Audit date Date and time the user uploaded the broker statement, or empty when the trade was entered.
Trading date Futures trade date
Exchange The exchange on which the futures were traded
Futures Futures instrument name
Period Futures period (month)
Year Futures period (year)
Price Futures price for 1 quantity unit
Traded lots Number of lots traded of these futures at this price and this trade date
Lots Number of lots that a specific line in the Excel is about
Purpose Indicates what was done with the lots (position allocation, price fixing, hedging a contract, rolling, position rolling, not allocated
Counterparty Name of counterparty from the physical contract
Position Position to which the lots were allocated, or empty if not allocated to a position
Delivery nr. contract delivery line to which the lots were allocated, or empty if not allocated to a contract
.