Units conversion will convert the symbol(s) from one unit to another, just as barrels to gallons, or bushels to tons.
- Start by selecting Quotes, History, or Charts
- Enter or look up the symbol(s) you want to display
- Click on the Action button
- Select the current units:
- Select the units to convert to:
Examples showing history on the current corn contract
No Unit Conversion:
Converted from Bushels to Tons:
MULT Function
The MULT function is a special function created specifically for doing unit conversions on historic data that has been linked via RTD. This is automatically applied to the Excel Add-in unit conversion or can also be accomplished with a manual link.
The MULT function is used in the Symbol parameter as shown in the Excel formula bar as shown below. It will ensure that if the underlying symbol is blank then the converted value will also be blank.
Syntax: “MULT(Symbol,Conversion Factor)” (make sure to enclose the entire formula in quotes)
This example shows both the incremental (minute) prices for corn and the same instrument for the converted value of the underlying corn price. Notice the MULT parameter. Remember, if you use the units conversion selection in Excel Add-in this formula will be created automatically. You would modify the formula MULT Function
Syntax: “MULT(Symbol,Conversion Factor)” (make sure to enclose the entire formula in quotes)