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: