Regression Model

Return to Overview


The Regression model plots the price of one product against another, with the points plotted to be the respective prices of each product at each point in time in the duration selected.

Regression analysis can be used to study whether the movements of two products are correlated (ie. if they tend to move together or in opposite directions), and measure how responsive the change in the price of one product is relative to the other. The line of best fit equation, as well as the strength of correlation (both R-squared and adjusted R-squared), are displayed.

Additionally, the products' recent price movements in the past few days are displayed as a curve in the plot, while density of data points is also shown as bar charts along the axes.


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.



Select start and end date for the period of analysis.


Input product(s) of interest under 'Product'.

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 the 'Contract Month' and 'Contract Year'.

Select Unit

Select the unit for the product. You may leave it as "Default". For more information about other units, please refer to Select Unit (Data Transformation Tool).


Number of days for which the products' latest price movements are shown.


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


Start DateStart date of period for analysis.Date (YYYY-MM-DD)2015-06-01
End DateEnd date of period for analysis.Date (YYYY-MM-DD)2019-06-14
Product(s)Products of interest.Product (Selection)ICE Gas Oil LS, Crude Oil Brent
Contract month.MonthDecember
Contract year.Year2019
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).Numerical Value1
Unit (for more information, please refer to Select Unit (Data Transformation Tool)).UnitDefault
DaysNumber of days to view the latest price movement.Number10
CommentsUseful for documentation purposes or for settings description.Text-


Regression Plot

Scatter-plot of prices of one product against the other. Each point represents the prices of the 2 products at a given point in time.

Product codes and their respective unit ranges are shown on each axis.

Line of best fit is a green line cutting across the plot, and its 95% confidence interval is coloured grey.

Recent Movement CurveThe points representing the latest price pairs are connected (in chronological order) into a curve, to show the latest movements of the product prices. Most recent point is highlighted in orange.Plot Element
Density ChartThe density of data points (for each axis) is shown as bar charts along the axes. This allows the user to visualise the price distribution of both products.Bar chart

Significant regression statistics displayed are: RR-squaredadjusted R-squared, and line of best fit.



The prices of 2 Rubber futures traded on SGX – RSS3 (RT) and TSR20 (TF) – have a high but imperfect correlation with each other. (R=0.951)

Click to access: