DECIMAL PLACES vs SIGNIFICANT FIGURES for FX Rates: Why the wrong choice can have a major impact on your company accounts
Many companies standardise on a certain number of decimal places when they use currency rates. However, this can be dangerous for low value currencies, creating very inaccurate rates or even rates of zero.
But what’s the difference between decimal places and significant figures?
When rounding to a specified number of significant figures, the process is similar to that of rounding to a number of decimal places. But the difference is that any leading zeros do not count as significant figures.
It is probably easier to see the difference by considering the examples below:
|Original number||Rounded to 5 decimal places||Rounded to 5 significant figures|
Why is this relevant to FX rates?
For many currency pairs it doesn’t really matter whether the rate is rounded by decimal places (dp) or significant figures (sf).
Take USD>EUR as an example: on 25-Jun-18 OANDA published that rate as 0.85654363040776.
This is 0.856544 when rounded to 6 dp, and 0.856544 when rounded to 6 sf
i.e. the rate is the same whether it is rounded by decimal places or significant figures.
However, rounding methods become more important when dealing with currency pairs in which one currency has a much higher value than the other.
One example of this is VND>GBP: on 25-Jun-18 OANDA published that rate as 0.00003294063435.
This is 0.000033 when rounded to 6 dp, and 0.0000329406 when rounded to 6 sf
There is now a difference between the rates, albeit a small one (0.18%).
Rounding to 5 dp/sf gives 0.00003 and 0.000032941 respectively. The difference is now around 9.8% i.e. the rate which is rounded by dp becomes more inaccurate as the number of dp decreases.
Finally, consider what happens if you round to 4dp/sf instead:
The rate is 0.0000 when rounded to 4 dp, and 0.00003294 when rounded to 4 sf.
Clearly, an FX rate of zero is meaningless, very inaccurate, and can lead to system errors – computers don’t seem to like multiplying or dividing by 0!
How does FXLoader deal with this?
In order to obtain more accurate rates, we advise rounding to at least 6dp for most currency pairs, but to round by significant figures for any rates which are less than 0.1.
FXLoader is very flexible in this regard – you can configure specific rounding values for an individual currency when it is a ‘From’ currency only; or when it is a ‘To’ currency only; or both. You can even configure rounding values to apply to one specific currency pair.