***************************************************** ***************************************************** ***************************************************** ***************************************************** ***************************************************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** This Confluence article was automatically generated from Asciidoc. Any changes you make to this document will be overridden! If you want to change the content, consider leaving a comment. You can edit the content directly here: https://gitlab.pricefx.eu/training/pricefx-knowledge-base/-/tree/dev/public/content/docs/reference/data-analytical/data-source-currency ***************************************************** ***************************************************** ***************************************************** ***************************************************** ***************************************************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING **********************
Currency conversion table is used for automatic conversion of money fields in Datamart.
Once the Datamart is set up, the exchange rates will be applied automatically. See How to Set up Currency Conversion in Datamart.
The exchange rates are looked up at the query time, meaning there is no need to refresh Datamart after updating exchange rates.
The conversion rates needed for pricing purposes usually do not change every day, typically they remain valid for a week or a month. The currency conversions can be specified either per day, or per date range.
Only if your ccy Data Source contains a conversion rate for every single day (and not a date range), define also
.To ensure correct functioning, we recommend that you include in your conversion dataset also these conversions:
From the Datamart’s base currency to all other currencies which you use in your Datamart records.
Back and forth (e.g. USD → EUR, EUR → USD).
1:1 (e.g. USD → USD).