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

Excel Add 14

  • Select the current units:

Excel Add 15

  • Select the units to convert to:

Excel Add 16

Examples showing history on the current corn contract

No Unit Conversion:

Excel Add 17

Converted from Bushels to Tons:

Excel Add 18

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)

Excel Add 19

Excel Add 20

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)

Category: ExcelTags: