Currency / Unit Conversions

Unit and currency conversions are available in the History dialog. However, they are not supported for intraday history. Unit and currency conversions are available on a per-symbol basis. Change the unit or currency by clicking on the down-arrow that appears in the selected symbols area of the History dialog box:

Any symbol whose unit of measure or currency has been changed to one other than its default will show the new unit of measure and currency in its description on the spreadsheet:

Unit Conversion Controls

Once a symbol is selected for display, the unit of measure in which it trades is shown. Unit conversions may be applied to symbols that have a base unit of measurement stored on the price server. For symbols that do not have a base unit of measurement, the unit of measure will not display.

The drop-down list allows you to select the target unit of measure to be used in the historical display for the symbol. The default value in the list reflects the original unit of measure assigned to the symbol. Once placed on the spreadsheet, the cell syntax also shows you what currency is being used:

Valid display units are as follows:

BBL - Barrels	KLTR - Kiloliters	MT - Metric Tons
CM - Cubic Meters	KWH – Kilowatt Hours	MWH – Megawatt Hours
GAL - Gallons	LB - Pounds	THM - Therms
GJ – Gigajoules	LTR - Liters	TOZ - Troy Ounce
GWH – Gigawatt Hours	MSCF - Thousand Standard Cubic Feet
GRM - Grams	MMB – Million British Thermal Units

Currency Conversion Controls

Once a symbol is selected for display, the currency in which it trades is shown. Currency conversions may only be applied to symbols that have a currency designation stored on the price server. For symbols that do not have a currency designation, the currency unit of measure will not display.

The drop-down list allows you to select the target currency to be used in converting price values for the selected symbol. The default value in the list reflects the original currency assigned to the selected symbol.

The currency conversion checks the conversion rate between the two currencies for the date of the historical record. The cell syntax also shows you what currency is being used:

Supported currencies are as follows:

AUD - Australian Dollar	EUR - Euro	NZD - New Zealand Dollar
BHD - Bahrain Dinar	EUC - Euro Cents	RUB - Russian Ruble
BRL _ Brazilian Real	GBP - British Pound	SAR - Saudi Arabian Riyal
CAD - Canadian Dollar	GBC - British Pence	SEK - Swedish Krona
CAC - Canadian Cents	JPY - Japanese Yen	SGD - Singapore Dollar
CHF - Swiss Franc	KRW - South Korean Won	THB - Thai Bhat
CNY - Chinese Yuan	MYR - Malaysian Ringgit	USC - U.S. Cents
DKK - Danish Krone	NOK - Norwegian Kroner	USD - U.S. Dollar
		ZAR - South African Rand

Lead/Lag

Shift:

Calendar Days, Quoted Days, Weeks

Rollover

Type: None, Number of Days, Other Commodity