What is FX exposure, and how do you track it in Metabase?
What does an FX exposure chart look like in Metabase?
Chart net exposure by currency as horizontal bars at one valuation date, sorted by the reporting-currency amount at risk, and read concentration before anything else. Here EUR carries roughly double the exposure of the next currency, so a euro move dominates FX gain or loss — that is the position to hedge or net first.
Definition
FX exposure is the reporting-currency value at risk from balances, receivables, payables, and committed cash flows denominated in foreign currencies. Gross exposure shows both sides; net exposure applies an approved netting policy by currency and entity.
What data do you need?
- Foreign-currency cash balances
- Open receivables and payables by currency and due date
- Committed transfers or forecast cash flows
- Approved spot or accounting rates with timestamps
- Legal-entity and hedging or netting rules
SQL pattern
SELECT
valuation_date,
currency,
SUM(native_amount) AS net_native_exposure,
MAX(reporting_fx_rate) AS reporting_fx_rate,
SUM(native_amount * reporting_fx_rate) AS reporting_currency_exposure
FROM modeled_fx_exposure
WHERE valuation_date = {{valuation_date}}
AND currency <> {{reporting_currency}}
GROUP BY 1, 2
ORDER BY ABS(SUM(native_amount * reporting_fx_rate)) DESC;Common pitfalls
Where does this metric apply?
This metric commonly uses data from Wise, Airwallex, NetSuite, SAP, Plaid, Paystack, Flutterwave, plus any reconciled warehouse or ledger models that provide the same business grain.