Skip to content
PokutsoftPokutsoft
GlobalAccounting/Localizations
Exchange Rate Auto Update icon

Exchange Rate Auto Update

Automatic multi-source FX rate fetching with history, rounding and buy/sell margin

Odoo 20.0Odoo 19.0Odoo 18.0
Compatible with Odoo 18.0 · 19.0 · 20.0
OPL-1 license · 35+ languages · Community & Enterprise
Exchange Rate Auto Update for Odoo — preview banner

Exchange Rate Auto Update

Automatic multi-source FX rate fetching with history, rounding and buy/sell margin

Exchange Rate Auto Update keeps res.currency.rate fresh automatically instead of updating exchange rates by hand. Pick a data source, set a base currency and a schedule, and the scheduled action does the rest, working out of the box with a free source and requiring no API key.

Key Features

Multi-Source Rate Fetching

Choose the European Central Bank (free, no API key, default source), Open Exchange Rates (bring your own key) or exchangerate.host (bring your own key) as the FX data provider.

Scheduled Fetch with Full History

A configurable-interval cron job (hours/days/weeks/months) writes dated res.currency.rate records, preserving full rate history; a fetch never overwrites a previous day's rate, only today's.

Manual Update Now

An on-demand 'Update Now' action refreshes rates immediately outside the scheduled interval.

Rounding & Buy/Sell Margin

Configurable rounding precision and an optional buy/sell margin (spread) is applied on top of the fetched mid-market rate, with the resulting buy and sell rates stored alongside the mid rate for reference.

Fetch Log with Error Visibility

Every fetch is recorded in a log with status, currency count, applied source and a clear error message whenever a provider cannot be reached or returns bad data.

Configurable Base Currency & Cross-Rate Rebasing

The base currency is configurable independently of the company currency, with automatic cross-rate rebasing when the source's native base differs from the configured one.

Use Cases

✓Get daily ECB exchange rates into Odoo automatically without any manual entry or API key
✓Switch to Open Exchange Rates or exchangerate.host for currencies not covered by the ECB feed
✓Apply a buy/sell margin on top of the fetched mid-market rate for a business that trades at a spread
✓Diagnose why a scheduled rate fetch failed by checking the fetch log's error message
✓Trigger an immediate rate refresh on demand ahead of a month-end close instead of waiting for the schedule

Screenshots

Exchange Rate Auto Update — 02 Fetch Log List in Odoo

02 Fetch Log List

Exchange Rate Auto Update — 03 Fetch Log Form in Odoo

03 Fetch Log Form

Why Choose This Module

Manually keying in exchange rates every day is tedious and error-prone, and Odoo's built-in currency rate mechanism does not fetch anything on its own. This module closes that gap with a scheduled, auditable fetch pipeline that works out of the box with a free ECB feed, supports paid providers when broader currency coverage is needed, and keeps a full dated history so no past rate is ever silently overwritten.

Specifications

  • Compatible: Odoo 18.0 / 19.0 / 20.0
  • License: OPL-1
  • Languages: 35+
  • Author: Pokutsoft
  • Dependencies: base
  • Support: support@pokutsoft.com
  • Update date: 2026-09-25

Related modules