FX rates

Download sample file: FXRates.csv

Exchange rates used for currency conversion

This FX rates file type is identified using the pattern: **FXRates*.csv (as specified by fxRatesFilePattern). This file is loaded using the FXRates topic. See the Topic Aliases table for an understanding of the topic aliases associated with each topic.

For information on the glob patterns used and how to customize them, see note on File name patterns

The Market Risk Accelerator uses the rates defined by the MarketDataSets analysis hierarchy to perform currency conversion, based on the reporting currency you set and the native currencies (from underlying/contributing facts, for a given query scope) defined as follows:

The FxRate for converting the native currency value into the reference currency value is obtained from the data in the FX Rates data store in the following lookup sequence.

1. Direct: In most cases, the algorithm simply looks up the rate based on these key fields: AsOfDate, BaseCcy, CounterCcy. Initially the algorithm will search for the rate that will have AsOfDate, NativeCurrency, ReferenceCurrency in the key fields.

2. Indirect: If the rate was not found, the algorithm searches for the rate by AsOfDate, ReferenceCurrency, NativeCurrency and takes the reciprocal of the rate if found.

3. FXCrosses: If the rate is still not found at this stage, the algorithm computes the rate using the FX crosses via the “CommonCcy” configured in the fx-rates.common-currency in the mr.properties. For example, you need JPY/EUR for conversion and both JPY/USD and EUR/USD were provided.

For more information, see FX Calculation theory