Skip to main content

Using Currency Rate Import

Preview of currency rates​

From the Currency Exchange Rate Service card, click "Preview" to view the results of the current currency rate import in a new page.

image-20231228-143344.png

Manual currency rates import​

Manually update currency rates by opening the Currency list and selecting the action "Update Exchange Rate." This action uses the enabled Currency Exchange Rate Service.

image-20231228-143526.png

Automatic currency rates import​

From the Currency Exchange Rate Service card, select the action "Job Queue Entry" to set the frequency and start time for automatic currency import.

image-20231228-143844.png

Import Historic Rates (Backfill)​

When the scheduled Job Queue fails or is paused for several days, you may need to backfill missing exchange rates for a period. Use the Import Historic Rates feature to import rates for a specific date range.

How to use​

  1. Open Currency Exchange Rate Services list page

  2. Click Import Historic Rates action in the ribbon

    image-20260204-140105.png

  3. Set filters:

    • Service Code: Select specific service(s) or leave blank for all enabled services

    • Period Start: Enter date range (e.g., 01/01/26..15/01/26)

      image-20260204-140141.png

  4. Click OK to start the import

The system will process each date in the selected range and import rates from the configured services.

Progress and Results​

During import, a progress dialog shows:

  • Current service being processed

  • Current date being imported

After completion, a summary displays:

  • Imported: Number of new rates successfully imported

  • Skipped: Rates that already existed (not overwritten)

  • Warnings: Dates outside service limits or other issues

Provider Historic Data Support​

Not all providers support historic data equally:

Fiat Currency Services

  • ECB — 90 days (uses hist-90d.xml feed)

  • Sveriges Riksbank — Unlimited (data since 1993)

  • Bank of England — Unlimited (data since 1975)

  • Danmarks Nationalbank — 5 days only (API limitation)

  • Open Exchange Rates — Unlimited (requires paid plan)

Cryptocurrency Services

  • CoinGecko — Unlimited (data since coin inception)

  • CryptoCompare — Unlimited (extensive historical data)

  • CoinMarketCap — Not supported (requires Enterprise plan)

CoinMarketCap does not support historic rate import. The service will be skipped with a warning when processing historic dates.

Danmarks Nationalbank only provides the last 5 trading days via their API. For older dates, you may need to use StatBank or another source manually.

Use Cases​

  • Job Queue Recovery: Backfill rates after scheduled import failed

  • New Service Setup: Import historical rates when enabling a new service

  • Data Correction: Re-import rates for a specific period if issues were detected

  • Initial Migration: Populate exchange rates when first setting up the system