FX() - Currency Conversion
To convert data into another currency the
FX() function can be used.
when using the Master Currency option in the Watchlist properties all data and columns get converted - using the
FX() function converts only the data you wish. Also, the conversion process requires being subscribed to the Foreign Exchange data.
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: