What does the FX rates source provide?

One table of daily rates, with a row per ECB business day per currency. It covers about 30 currencies published by the European Central Bank, the fixed US dollar pegs for AED and SAR, and USD itself at 1.0.

Do I need an account or an API key?

No. The rates come from the public Frankfurter API, so there is nothing to create. You only choose the date the history starts from.

What about weekends and holidays?

The ECB publishes on business days only, so those dates have no row. Rig joins each transaction to the latest rate on or before its date, and it is wise to limit how old that rate may be.

What happens when a rate is missing?

A missing rate means the amount cannot be converted. Treat it as an error or leave the value empty, and avoid defaulting to 1.0.

Billing & finance Supported

FX rates (ECB) integration for Rig

The easiest way to connect FX rates (ECB) to Claude and other AI tools

FX rates (ECB) is a daily table of reference exchange rates, taken from the European Central Bank through the public Frankfurter API, that expresses about 30 currencies against the US dollar.

Try Rig Book a demo

What Rig syncs from FX rates (ECB)

Once connected, Rig models these objects so questions resolve to the right tables and joins:

Daily rates by currency
ECB reference rates
Fixed USD pegs for AED and SAR
USD at 1.0

How FX rates (ECB) connects to Rig

Rig Ingest syncs the daily rates into your warehouse on a schedule, with no account or key. You choose the date the history starts from, and each sync re-reads the last few days in case the ECB corrects a rate.

Read the step-by-step FX rates (ECB) setup guide

Convert multi-currency revenue to US dollars

Currency conversion turns amounts booked in pounds, euros or other currencies into one reporting currency. The rates table has one row per business day per currency, with `rate` as units of currency per 1 US dollar, so Rig can divide a local amount by the rate on its date and report revenue in a single currency.

Ask Rig

What was revenue last quarter in US dollars, converted at each invoice date?
Show monthly bookings by currency and the converted US dollar total
How much of our revenue is exposed to euro and sterling?

Measure the impact of currency movements

FX impact is the change in reported figures that comes from exchange rates moving, apart from any change in the underlying business. With a daily rate history, Rig can hold rates constant and compare, so you can see how much of a swing in revenue or cost came from the currency.

Ask Rig

How much did revenue change this year at constant exchange rates?
Which currency moved most against the dollar over the last 12 months?
What would last month's spend have been at the rate from a year ago?

Normalise spend across entities and bank accounts

Spend in several currencies cannot be added up until it shares one unit. Joining the rates table to transactions from your banking, billing or accounting sources puts every entity and account on the same basis, so cross-entity totals and comparisons are consistent.

Ask Rig

What is total spend across all bank accounts in US dollars?
Show cash balances by currency converted to one currency
Compare cost per entity once everything is in US dollars

Ask your FX rates (ECB) data in Claude, ChatGPT or Cursor

Rig serves your FX rates (ECB) data to AI assistants over MCP. Once FX rates (ECB) is synced into your warehouse, you can ask questions in plain English from the tool you already use, and every answer is backed by validated, governed SQL.

Frequently asked questions

What does the FX rates source provide?: One table of daily rates, with a row per ECB business day per currency. It covers about 30 currencies published by the European Central Bank, the fixed US dollar pegs for AED and SAR, and USD itself at 1.0.
Do I need an account or an API key?: No. The rates come from the public Frankfurter API, so there is nothing to create. You only choose the date the history starts from.
What about weekends and holidays?: The ECB publishes on business days only, so those dates have no row. Rig joins each transaction to the latest rate on or before its date, and it is wise to limit how old that rate may be.
What happens when a rate is missing?: A missing rate means the amount cannot be converted. Treat it as an error or leave the value empty, and avoid defaulting to 1.0.