Rounding     

When

Rates are often published with many decimal places. You may wish to reduce the number of decimals prior to loading rates into your ERP. FXLoader provides options to round by decimal places or significant figures, and this can be applied to all rates; or to specific currencies or currency pairs. 

Rounding all rates

This is done within the Load Stage of a Run. Enter the required number of decimal places or significant figures in the relevant fields. For more details about the difference between decimal places vs significant figures please click here. 

The setting below will round all rates to 6 decimal places:

The setting below will round all rates to 6 significant figures:

The setting below will round all rates to either 6 decimal places or 6 significant figures, whichever is most appropriate for each particular rate:

If you are using FXLoader to populate inverse rates in your ERP you can choose whether to round those or not by using the ‘Round Inverse Rates’ field:

Rounding specific currency or currency pair

This is done using Currency Overrides within a Currency Set.

1. Firstly click on the Details button for the currency you wish to apply the override to:

   

2. On the Currency Detail page, you can choose which rounding to apply to that currency when it is a FROM currency or a TO currency or both. These parameters will be applied to all rates which contain that currency:

   

3. To apply rounding to just one specific currency pair you should use the Currency Pair Overrides section towards the bottom of the Currency Detail page.

   1. From the menu select Add Row.

      

   2. Enter the To Currency, the required rounding, and then click Apply Changes. The example shown will round your USD>EUR rate to 5 decimals.