ExchangeRate-API connector

Use your ExchangeRate-API data for reporting, automation and AI.

Data Panda brings your ExchangeRate-API rates together with the data from the rest of your business. From one place, we turn them into dashboards, automations, AI workflows and custom apps your team uses every day.

About ExchangeRate-API

A long-running currency conversion API with deep history.

ExchangeRate-API is a foreign-exchange rates service run by AYR Tech, launched in 2010. The product publishes indicative midpoint rates for 165 currencies used across roughly 200 countries, sourced from multiple feeds and served as JSON over a straightforward HTTPS endpoint. Standard, Pair Conversion and Supported Codes calls are open on the free tier, while Enriched Data (country codes, currency symbols, flag URLs) and Historical Data covering over thirty years are reserved for the paid Pro and Business plans.

The reason to land ExchangeRate-API in a warehouse is that a rate only matters when it is joined to a business event. One conversion call from a checkout, a quote tool or an ERP gives you a number for that one moment, but the same rate also priced the export invoice booked an hour earlier and the supplier payout that leaves tomorrow. Pulled into one place and stored per day and per currency pair, ExchangeRate-API becomes the single reference your billing system, your boekhouding and your sales tooling all read from, with timestamps and an audit trail that finance can defend.

What your ExchangeRate-API data is for

What you get once ExchangeRate-API is connected.

Rates that line up with the books

Daily ExchangeRate-API rates per currency pair, joined to the invoice, quote or payout they priced.

Multi-currency revenue restated at end-of-period closing rates per legal entity
Realised FX gain and loss per customer, per supplier and per period from one rate source
Currency-pair movement alongside the deal volume that flowed through it

Rate-driven automation

Let billing, payouts and alerts react to one warehouse-stored rate per pair per day.

New invoice in a foreign currency picks up the warehouse rate of the booking day
Outbound payout uses the locked rate from the day the supplier confirmed the order
Threshold alert fires when a tracked pair like USD/EUR or GBP/EUR moves more than X% in a day

AI workflows

Use the stored history to model FX exposure and price scenarios.

Customer-cohort margin sensitivity to USD/EUR and GBP/EUR swings
Scenario pricing for a multi-currency quote against the last twelve months of rates
Outlier detection on booked FX results against the warehouse rate of the same day

Custom apps on your data

Internal tools that read from one rate table instead of calling ExchangeRate-API ad hoc.

Quote calculator that applies the locked rate of the day to a multi-currency proposal
FX-exposure dashboard for the CFO across receivables, payables and cash
Historical-rate lookup app for finance with audit trail per pair and per date

Use cases

Use cases we deliver with ExchangeRate-API data.

A list of concrete reports, automations and AI features we have built on ExchangeRate-API data. Pick the one that matches your situation.

Daily rate snapshotOne rate per currency pair per day in the warehouse, ready to join.

Month-end revaluationReceivables and payables in foreign currency restated at the closing rate of the period.

Realised FX resultsDifference between booking-day and payment-day rates per customer and supplier.

Quote-to-invoice parityThe rate behind a quote compared with the rate used when the invoice was issued.

Multi-entity consolidationSubsidiary results converted to the group reporting currency on one rate table.

Pair-level volatilityDaily moves per pair over a window, joined to the deal volume that ran through it.

Hedging exposure baselineNet foreign-currency position by pair and bucket from receivables, payables and cash.

Cross-border pricing reviewQuoted prices in local currency back-tested against twelve months of rates.

Vendor invoice spot-checkSupplier-stated FX rate compared with the warehouse rate of the same booking day.

Audit-ready rate historyPer-day, per-pair rates kept with timestamps for finance audits and disputes.

Real business questions

Answers you will finally get.

Is the rate that priced the invoice the same one finance closes the month with?

The ExchangeRate-API daily rate per pair lands in the warehouse and is the same number the billing system, the ERP and the consolidation report all read from. Booking-day, payment-day and closing-day rates sit side by side per pair, so the FX result on the books traces back to a specific rate on a specific date instead of three different numbers from three tools.

How big is our exposure to a swing in USD/EUR or GBP/EUR next month?

Net foreign-currency position per pair from open receivables, payables and cash, multiplied by the rate range over the last twelve months. The CFO sees P&L sensitivity per pair instead of a back-of-envelope estimate, and the bucket that drives most of the exposure (one large export customer, a single foreign supplier) shows up by name.

Did the price we quoted hold up when the invoice went out?

The rate captured at quote time sits next to the rate used when the invoice was issued, joined on the deal. Margin slippage between quote and invoice from FX surfaces per customer and per pair, so the commercial conversation about whether to lock rates earlier rests on a number from your own deal book.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

One rate table the ERP, the consolidation report and the bank reconciliation all read from. Month-end revaluation runs against rates with timestamps and an audit trail per pair, instead of a per-tool number that drifts. Realised and unrealised FX gain and loss split per customer, supplier and period from the same source.

For sales leaders

Quote calculators apply the locked rate of the day to a multi-currency proposal, so the price the customer sees matches the price the books expect. Account owners see margin slippage on past deals from FX between quote and invoice, instead of finding it weeks later in a P&L variance.

For operations

Outbound payouts pick the rate for the day the order was confirmed, so supplier reconciliation lands on the agreed amount. Threshold alerts on tracked pairs fire when a daily move crosses a set band, so pricing or hedging adjusts before the next batch goes out.

Ideas

What you can automate with ExchangeRate-API.

Pair with Exact Online

Apply ExchangeRate-API rates to Exact Online foreign-currency invoices

Each Exact Online invoice in a foreign currency picks up the ExchangeRate-API rate of the booking day from the warehouse, and the rate is written onto the invoice line. Month-end revaluation in Exact runs against the closing rate of the period from the same source, so realised and unrealised FX results trace back to one daily rate instead of two.

Pair with MS Dynamics 365 Business Central

Push ExchangeRate-API rates into Business Central

The daily rate per currency pair posts into Business Central as the exchange-rate of the day, so AR and AP entries in foreign currency revalue against one source. The closing rate at month-end consolidation matches the rate the warehouse stored, instead of a manually loaded sheet.

Pair with Salesforce

Quote in Salesforce against the locked rate of the day

When a multi-currency opportunity is quoted in Salesforce, the locked ExchangeRate-API rate of the day is written onto the opportunity and the quote line. The handover to invoicing carries that rate forward, so margin slippage between quote and invoice from FX is visible per deal instead of buried in a finance variance.

Pair with HubSpot

Show locked FX rates on the HubSpot deal

The rate captured at quote time pushes onto the HubSpot deal as a property and a timeline event. Account owners see the rate behind the deal value, and a deal that closed on a stale rate gets flagged for re-quote before invoicing instead of after the books catch it.

Pair with Shopify

Reconcile Shopify multi-currency orders against the rate of the day

Each Shopify order in a foreign currency is matched against the ExchangeRate-API rate of the order day in the warehouse, alongside the rate Shopify itself applied at checkout. The FX delta between Shopify's checkout rate and the warehouse reference lands per order, so finance sees per-store and per-currency margin impact instead of a single platform-wide number.

Pair with Stripe

Compare Stripe settlement rates with ExchangeRate-API

Each Stripe charge in a foreign currency lands next to the ExchangeRate-API rate of the same day, with the Stripe presentment, settlement and reference rates kept on the row. The spread Stripe captured on conversion shows up per payout and per currency, so finance reads the actual cost of card-network FX instead of estimating it.

Pair with Slack

Alert on currency-pair moves in Slack

When a tracked pair like USD/EUR or GBP/EUR moves more than a set percentage on a single day, a finance Slack channel gets the move with the open exposure and the deals priced against the previous rate attached. The team adjusts a quote or pulls forward a payout in minutes instead of waiting for the next FX review.

Pair with monday.com

Track FX-revaluation tasks in monday.com

Each currency pair with a material month-end revaluation creates a board item in monday.com, with the closing rate, the open exposure and the legal entity attached. Finance works through one prioritised list per close instead of chasing rates and exposures across spreadsheets.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your ExchangeRate-API data lives.

Power BI Microsoft

Fabric Microsoft

Snowflake Data warehouse

BigQuery Google

Tableau Visualisation

Excel Sheets & pivots

Three steps

From ExchangeRate-API to answers in three steps.

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

ExchangeRate-API connector configured and running
Warehouse set up in your cloud account
Clean access for your Power BI, Fabric or Tableau team
Documentation on what's in the data model
Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

Everything in Self-serve
Dashboards built to the questions your team actually asks
Automations between your systems
AI workflows scoped to real tasks your team runs
Custom apps where a dashboard does not cut it
Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

Which ExchangeRate-API endpoints does the connector cover?

The Standard, Pair Conversion, Historical and Supported Codes endpoints. Each call lands per day and per currency pair in the warehouse, with the source endpoint and timestamp kept on the row, so a downstream join knows whether a rate came from a same-day standard call or a back-fill of historical rates.

Do we need a paid plan to back-fill history?

Yes. The free plan covers latest rates and pair conversion. Historical Data and Enriched Data (country codes, currency symbols, flag URLs) sit on the Pro and Business plans, so a one-time back-fill of the full thirty-plus-year history needs at least a Pro subscription. After the back-fill, daily refresh continues on whichever tier you stay on.

Can we use a base currency other than USD or EUR?

Yes. ExchangeRate-API lets you change the base currency on every endpoint, and the connector stores the rate per pair regardless of which side you query. Whether you call USD as base or EUR as base, the warehouse model is the same, so switching reporting currency does not force a re-load.

GDPR-compliant

Data stays in the EU

You own the warehouse

A first deliverable live in four to six weeks.

We review your ExchangeRate-API setup and the systems around it. Together we pick the first thing worth building.

Book a call See our other connectors