FX() - Currency Conversion

Author: Optuma Team Last updated: Aug 24, 2022 00:03

To convert data into another currency the FX() function can be used.

By default it will convert the closing price to US Dollars, as per this watchlist example. The US$ Change % column is calculated using CHANGE(FX())/100 (divided by 100 to display as a % in the watchlist):


To choose another currency, click on the FX() function and select it from the dropdown. You can either use the search box or click the arrows to show all the currencies: