Time Series Model
Return to Overview
About
The Time Series model allows the user to display the movement of one or more product(s) for a selected time period. The user can also mouse-over to see the value of the product(s) at a given time.
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:
Guide
| Name | Image/Description |
|---|---|
| Duration |
Select the start and end time for the time series to be displayed. |
| Product(s) |
Input product(s) of interest under 'Product'. Select the position of the 'Y-axis' of the product as 'Left' or 'Right'. For more information, please refer to 'Output' below. If it is a future continuous contract, tick checkbox 'CONT' and fill in the 'Serial No.'. For more information, please refer to Future Continuous Contracts. Otherwise, fill in 'Select Month' and 'Select Year' for the product(s) of interest. Click 'Add Product' to enter a new product. Click 'red box with an X sign' icon to delete any unused product fields. |
| Select Unit |
Select the unit for the product. You may leave it at 'Default'. For more information about other units, please refer to Select Unit (Data Transformation Tool). |
| 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
| Name | Description | Type | Example |
|---|---|---|---|
| Start Date | Start of product time-series. | Date (YYYY-MM-DD) | 2015-06-01 |
| End Date | End of product time-series. | Date (YYYY-MM-DD) | 2019-06-14 |
| Product(s) | Y-axis (for more information, please refer to 'Output'). | Left/Right | Left |
| Product of interest. | Product Name | Sugar #11, Sugar #16 | |
| Contract month. | Month | July | |
| Contract year. | Year | 2019 | |
| Continuous contract (for more information, please refer to Future Continuous Contracts). | Checkbox | - | |
| Serial number of starting futures contract (for more information, please refer to Future Continuous Contracts). | Number | 1 | |
| Select Unit (for more information, please refer to Select Unit (Data Transformation Tool)). | Unit | Default | |
| Comments | Useful for documentation purposes or for settings description. | Text | - |
Output
| Name | Description | Type |
|---|---|---|
| Time-Series Graph | Each selected product will be represented by a time-series of a different colour. The legend indicating the products and their colours will be displayed at the top of each Y-axis. | Plot |
| Left Y-axis | If the "Left" Y-axis component has been selected for a product, the unit range of that product will be shown on the left Y-axis. | Plot Element |
| Right Y-axis | If the "Right" Y-axis component has been selected for a product, the unit range of that product will be shown on the right Y-axis. | Plot Element |
Example
The price of Sugar #11 has fallen steadily over the past 3 years, while the price of Sugar #16 has shown much more fluctuation in the same period.
Functionality
Displayed below are some noteworthy user interactions you can find on this application.
| Name | Description | Interaction |
|---|---|---|
| Multi Tooltip Lines (Vertical and Horizontal) | Mouse-over the graph and circle(s) will appear on the various time-series points with a tooltip that displays the values along the X-axis ('Date') and the Y-axis (corresponding index series values).
| Plot Element |
Click to access: