Select Unit (Data Transformation Tool)

Return to Overview

This feature allows users to perform manipulations on the raw data by selecting from the 'Select Unit' drop-down list:



The function of each selection is described below:

Selection

Description

Formula*

Default

Displays the raw data of the product’s value

pt

Change

Shows the change in the product’s value compared to its previous value (typically on the previous day)

Change from Previous Year

Shows the change in the product’s value compared to its value 1 year ago

Percentage Change

Shows the change in the product’s value in terms of percentage increase of its previous value

Percentage Change from Previous Year

Shows the percentage change in the product’s value compared to its value 1 year ago

Compounded Annual Rate of Change

Calculates the annualised percentage change of the product’s value compared to its previous value

Continuous Compounded Rate of Change

Calculates the continuously compounded rate of change

Continuous Compounded Annual rate of Change

Calculates the continuously compounded annualised rate of change

Index Scale to 100

Expresses the product’s value as a percentage of its value on a chosen reference date; can be used to compare different products using a common baseline

Natural Log

Takes the natural logarithm of the product’s value

ln(pt)

*Note on formula: “Interval” refers to the number of times the product’s value is updated in a year, which depends on its trading frequency:

Frequency

Interval

Daily (excluding weekends)

260

Weekly

52

Monthly

12

Quarterly

4

Annually

1

For more information about its application, please refer to [New Feature] Data Unit Transformation Tool is now available!.



Click to access: