Daily Pricing Position Change Model

Return to Overview

About

The Daily Pricing Position Change model calculates the changes in the position(s) in a portfolio, due to daily pricing, for that day. A certain number of positions in the user’s portfolio will be priced by Platts each day, hence fixing their prices (and the position is changed from "open" to "closed"). This model allows users to easily track which position(s), and how much of them, have their price(s) fixed for each trading day. 

Daily Position Change = Total Position Size (for a given month) / Number of trading days in that month

The rows are the various products in the portfolio, while the columns indicate product information (such as exchange, product type, contract type), the change in position(s) for each maturity time of the product, as well as total change in position. In this model, the user can also create customised 'strategies', such as spread positions of futures with different maturities. The user can choose if the effect of the additional strategies are shown (see: Creating a Strategy Product). 

(This model follows the pricing holiday schedule of Platts for various markets worldwide, which you may find out here. Also see Futures Contracts Codes for more information on exchange and month codes, if required.)



Navigation

To access the quantitative model/report, click on 'Dashboard' from the navigation sidebar on the left. 

Select the model/report from the drop-down list and click 'Create'. Click on the 'Settings' button (gear icon) at the top right corner of the model to set up your model/report.


Sharing Model/Report/Dashboard

To share the model with your group members, click on the "Share" button next to the Title of the model followed by the email address of the group members you want to share it with. Once submitted, the model will appear in the Dashboard>Group Dashboard of the selected group members.

This is different from sharing individual or entire Dashboard models/reports, which allows any user who may or may not be users of MAF Cloud to access the individual model/entire dashboard via the shared web link (link will expire in 8 hours). In Group Dashboard, only group members can access the shared models/reports.


Group Rows

You may also group the rows (liken to the pivot table function in Microsoft Excel) to view the grouped data by dragging any column headers into the “row groups” section as highlighted:

The data in the table will be grouped according to your setting and you may drag multiple column headers into the “row groups” section to group them as necessary.



Guide

Name

Images/Description

Portfolio

Select a portfolio of interest.

Strategy Product

Add Product: Select the strategy product(s) to be included when displaying the model, if any (e.g. calendar spread, inter-commodity spread, etc).

The single contract positions (of all relevant contracts) will then be combined into the strategies' net positions (Meanwhile, an equivalent amount of the original positions will be deducted).

Please refer to Creating a Strategy Product for an example of creating a strategy product, and the effect of adding it.

Comments

The inserted comments will be displayed at the bottom of the application. This can be useful for documentation purposes or for settings description.



Input


Description

Type

Example

Portfolio

Portfolio to be analysed

Portfolio (Selection)

Sample portfolio #1

Strategy Product(s)

Strategy product(s) to be included

Product

Sugar

Comments

Any comments

Text

-



Output


Description

Type

Product/Strategy Information

The details of product(s) are indicated in the first 3 columns: product name, exchange it is traded in, and product type.

For strategy product(s), these were manually filled in by the user when creating the strategy.

Text

Position Change(s)

The remaining columns display the changes in the product's position(s) in the portfolio.

Each column shows the change for a particular Contract Year/Month (arranged in chronological order), and the last column sums up the total change for that product.

Number



Example



Functionality

  • Unit Selection: Users may choose the units (default, lots, barrels etc.) in which the position sizes are to be displayed.

  • Please refer to Table Settings for table functionalities.



Click to access: