xMap data

Exchange rates

Exchange rates puts amounts in one currency. Tenders come in euros, pounds and reais, deal values in dollars and yen: the block reads each item’s amount and its own currency and adds the same amount in the currencies you pick, at the European Central Bank’s reference rate of the day. Or it lists today’s rates against one currency, with how each moved in a day and in 30 days.

In the editor: Exchange rates from the European Central Bank’s daily euro reference rates, free and worldwide for about 30 currencies (and those with a fixed peg, such as the UAE dirham and the CFA franc): turns an amount on each incoming item, in its own currency, into one or more currencies you pick (value_in_USD), or lists today’s rates against one currency with how they moved since the day before and in 30 days. Every result says it is the ECB reference rate of that date.

Settings

Do

Pick one

Convert amounts on each item: the items that reach it go on with their amounts in other currencies. Rates today: one item per currency, for a report or an alert.

Each item that reaches this block keeps everything it had and gets its amount in the currencies you pick. Nothing is dropped.

Convert amounts on each item
Rates today

Convert to

A list you type

Up to 3 currencies. Each adds a field named after the amount it converts: value_in_USD, deal_value_in_EUR.

Up to 3 currencies. Each adds a field named after the amount, such as value_in_USD.

Pick from 38 choices.

Amount field

Text

The field that holds the amount. Automatic uses the first of value, amount, deal_value, price, budget, contract_value, estimated_value, revenue, total or cost. Amounts such as 1,250,000, EUR 1.2m or $3.5 million are read.

The field that holds the amount. Automatic uses the first of value, amount, deal_value, price, budget, contract_value, estimated_value, revenue, total or cost.

Currency field

Text

The field that says the currency. Automatic uses currency, deal_currency or currency_code, then a code or symbol written with the amount.

The field that says the currency. Automatic uses currency, deal_currency or currency_code, then a code or symbol written with the amount ($, EUR, £).

Amounts with no currency

Pick one

Amounts with no currency go on as they came, marked No currency given, unless you say which currency they are in.

Leave them as they are (they go on, marked No currency given), or say which currency they are in.

Pick from 39 choices.

Rates against

Pick one

Rates today: how many of each currency one of these buys.

How many of each currency one of these buys.

Pick from 38 choices.

Currencies

A list you type

Rates today: the currencies to list. Empty lists every currency the ECB publishes and the pegged ones.

Empty: every currency the ECB publishes, and the pegged ones.

Pick from 38 choices.

What comes out

Each item that leaves the block carries these fields, to use in the blocks after it as {{field}}.

Each incoming item, with its amount converted

Convert amounts on each item.

<field>_in_<CUR>: The amount in each currency you picked, named after the field it came from.
fx_amount: The amount in the first currency you picked, for Filter’s Converted amount and for sorting.
fx_rate_<CUR>: How many of that currency one unit of the item’s currency buys.
fx_from, fx_to, fx_date: The item’s currency, the first one you picked, and the date of the rate.
fx_source: Which rate was used, in words.
fx_note: Why an amount was left as it was: No amount, No currency given, or No ECB reference rate for a currency.

Each currency, as an item

Rates today.

name, currency, currency_name, base: The pair, the currency and what it is called.
rate, inverse: How many of the currency one of the base buys, and the other way round.
change_day_pct, change_30d_pct, rate_30d_ago: How the rate moved since the day before and in 30 days.
trend_30d, pegged: The 30-day move in words, and whether the currency is fixed to another.
date, source: The date of the rates and where they come from.

How to use it

Construction

The biggest public works tenders, in US dollars

Tenders from four countries in one currency, the ones over a million kept and the biggest first.

Finance

Monday currency note for the finance team

The currencies the company pays in, how they moved, and what that means for payments due.

Consulting

Tender pipeline in euros

A consultancy in Lisbon bids on World Bank and EU tenders in a dozen currencies.

Before: Values in rupees, shillings and dollars could not be compared.

With the flow: The pipeline is one list in euros, the big bids on top.

Sales

Won deals in one currency

A software company sells in Japan, Brazil and South Africa.

Retail

Prices against rivals abroad

A price list in pounds against rivals selling in euros and dollars.

Travel

Rates for travellers

The front desk quotes guests the day’s reference rates.

Logistics

A rate alert for a big payment

The treasurer hears when the rate for a large supplier payment moves.

Public sector

Grants in one currency

Donors pay in several currencies; the accounts need one.

Good to know

Free: it uses no credits.
The rates are the European Central Bank’s euro reference rates, published once each working day at about 16:00 Central European Time. They are for information, not the rate a bank gives you for a payment: always check with your bank before you pay or trade.
A rate between two other currencies is worked out through the euro, as the ECB does. Currencies fixed by law to another (UAE dirham, Saudi riyal, Qatari riyal, Omani rial, Bahraini dinar, Jordanian dinar, the CFA francs) use their peg, and the step says so.
About 30 currencies are published. An amount in a currency the ECB does not publish goes on as it came, with a note; nothing is dropped.
On weekends and the ECB’s holidays the latest working day’s rates are used, with their date.

Works well with

Public tenders: New public tenders (RFPs, invitations to bid) from official sources: the EU’s TED, the UK’s Find a Tender and Contracts Finder, the US SAM.gov, CanadaBuys and World Bank-funded projects in developing countries.
My data: Brings in a table you uploaded or a list you saved on the My data page: your stores, customers, target accounts or sites.
Sort and limit: Puts the items in order, and can keep only the first ones: the 10 best rated, the 20 nearest, the highest fit scores.
Filter: Keeps only the items that match a rule.
Calculated field: Adds fields worked out from the others: a number, a text or a yes/no.
xMap LLM: Tell the AI what to do in plain words.
Email: Sends one email per run with all the items, or one email per item.
Slack: Channel-based messaging platform

Help articles

Put amounts in one currency with exchange rates: The European Central Bank’s daily reference rates: each item’s amount in the currencies you pick, or today’s rates.

Try it

Build a flow with Exchange rates on the home page, no account needed, or book a call. Try it live