--- title: "FX rates (ECB) Integration for Rig: Query FX rates (ECB) Data in Plain English" description: "Connect FX rates (ECB) to Rig and query your FX rates (ECB) data in plain English, or ask it in Claude, ChatGPT and Cursor. Governed, validated answers from your warehouse." canonical: "https://rig.so/integrations/fx-rates" format: markdown --- Browse integrations ![FX rates (ECB) logo](https://img.logo.dev/ecb.europa.eu?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=112&format=png&retina=true) 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](https://app.rig.so/signup)[Book a demo](https://rig.so/book-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](https://rig.so/guides/connect-fx-rates) ## 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. - [Claude](https://rig.so/integrations/claude) - [Claude Code](https://rig.so/integrations/claude-code) - [Cursor](https://rig.so/integrations/cursor) - [ChatGPT](https://rig.so/integrations/chatgpt) - [Codex](https://rig.so/integrations/codex) - [Gemini](https://rig.so/integrations/gemini) ## 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. ## Related integrations [![Agree logo](https://img.logo.dev/agree.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)AgreeContract, milestone and payment-schedule analytics from Agree.](https://rig.so/integrations/agree)[![Light logo](https://img.logo.dev/light.inc?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)LightGeneral ledger, payables, receivables and card spend from Light.](https://rig.so/integrations/light)[![Mercury logo](https://img.logo.dev/mercury.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)MercuryCash, spend and transaction analytics from your Mercury accounts.](https://rig.so/integrations/mercury)[![Microsoft Dynamics 365 Finance & Operations logo](https://img.logo.dev/dynamics.microsoft.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)Microsoft Dynamics 365 Finance & OperationsLedger, orders and invoices from your Dynamics 365 ERP.](https://rig.so/integrations/dynamics-365-finance-operations)[![NetSuite logo](https://img.logo.dev/netsuite.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)NetSuiteRevenue, GL and order analytics from your NetSuite ERP.](https://rig.so/integrations/netsuite)[![QuickBooks logo](https://img.logo.dev/quickbooks.intuit.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)QuickBooksP&L, AR and accounting analytics from your QuickBooks data.](https://rig.so/integrations/quickbooks) ## Connect FX rates (ECB) data to AI tools like Claude Rig builds a governed context layer over your data so every team, and every AI tool, asks questions and gets answers they can trust. [Try Rig](https://app.rig.so/signup)[Book a demo](https://rig.so/book-demo) --- - [This page as HTML](https://rig.so/integrations/fx-rates) - [Site map for language models](https://rig.so/llms.txt) - [API and agent documentation](https://rig.so/developers)