About FX rates
If you have any cross currency agreements where an entity and an agreement are in a different currency, or when you have multiple entities in different base currencies and want to have a look at numbers in some consolidated currency, you need to have FX rates here in Foreign Exchange Rates table.
FX register
In the FX register view you will have a summary view of all of all your currency pair rates. New rates can be created from “Add new”-tab, import from excel, or if you already have rates, simply copy the existing one and just change the data.
Fields in FX rate details view:
Rate type
If you are inserting a closing rate (fixing rate), just select Fix. Other selections are for forward rates (used for FX hedge valuations).
Currency base
This is the base currency in the pair that you are inserting.
Currency cross
This is the cross currency in the pair that you are inserting.
Rate Bid
This is the closing/forward bid side of the pair. If you are only inserting an average rate, you can put both Bid and Ask at the same rate.
Rate Ask
This is the closing/forward ask side of the pair. If you are only inserting average rate then you can put both Bid and Ask at the same rate.
Date
This is the date of currency pair quote.
Excel import for Rates
Click the first Import tab. Then, from ‘Download sample’ you can get the import excel template that you can use for the import. You can bring 1 000 Rates at once. Once you have filled in all your Rates and saved the file into your computer you need to check the file and make sure it is readable. Then, click import. Remember to use the date format as: yyyy-mm-dd.
Rate update
You can get rates every weekday with our api. The ecb rates and riks bank rate are free of cost whereas databond rates comes with some price. Whatever rate source you choose, you need to make currency active(by default they are inactive) for which you want to get rates for.