Pull Open Exchange Rates data into Microsoft Excel
A finance workbook should not carry a rate someone typed last quarter. Load Open Exchange Rates into your data warehouse, join it to orders and invoices by date and currency, and pull the Data Mart into Excel.
Open Exchange R…ConnectedHistorical excha…
Microsoft ExcelDateBaseCurre…Daily 09:00The finance workbook in Microsoft Excel still converts this month's invoices at a rate someone typed in last quarter.
Paste this into your AI assistant. It loads Open Exchange Rates into your data warehouse, joins the rates to orders and invoices by date and currency, and pulls that Data Mart into Microsoft Excel through the add-in.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/open-exchange-rates-connector-to-microsoft-excel.md. The task: give me a Microsoft Excel workbook of this month's orders and invoices converted to our base currency at each day's Open Exchange Rates rate, refreshable before close. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
Open Exchange Rates Endpoints
1 Open Exchange Rates endpoints you can import. Each lands in its own table in your data warehouse.
Why Open Exchange Rates does not go straight to Excel
A rates feed can be pasted into Excel, but not reliably, at scale or business-ready. A typed rate goes stale, and two workbooks quietly use two different rates. The data warehouse keeps one rate table and joins it to the money first.
- Open Exchange Rates publishes the rate, not how your numbers use it
- The data analyst joins rates to orders and invoices by date and currency
- Every workbook converts on the same basis
Open Exchange…Rates by currencyMicrosoft Exc…
Data warehouseJoined by idStep 1: Load Open Exchange Rates into your data warehouse first
Create a Data Mart with Open Exchange Rates as the source and choose where the data lands. Any popular warehouse works.
- One endpoint, Historical exchange rates data, with four fields: date, base, currency and rate
- Authorize with your Open Exchange Rates App ID
- Open the Open Exchange Rates connector for your data warehouse below
Open Exchan…Data MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databricksopen_exchange_rates.historicalStep 2: Link Open Exchange Rates to orders and invoices
In your data warehouse the model joins the rate table to orders and invoices by date and currency code. Pick an industry to see the shape of its model.
- One rate per currency per day, shared by every report
- Orders and invoices join by SQL keys, not a rate typed into a cell
- settled_revenue is defined once
Open Exchange…Historical exchan…Step 3: Pull Open Exchange Rates data into Excel with the add-in
In Excel, add the OWOX Data Marts add-in and sign in. Choose the published Open Exchange Rates Data Mart (Historical exchange rates data), tick the columns you want and press Create & Run.
- Tick date, currency and rate; base comes along
- The workbook reads your data warehouse, so the App ID stays out of the file
Microsoft ExcelYour columns staydatecurrencyrateStep 4: Refresh the Open Exchange Rates workbook when you need it
Refresh when you close a period. The imported columns update; the converted-amount column you added keeps pointing at them.
- A formula multiplying amount by rate survives
- Refresh on demand, with no job to configure
Microsoft ExcelYour column staysdatecurrencyrateYoursStep 5: Reuse Open Exchange Rates inside OWOX MCP
The rate table is reusable in OWOX MCP, your assistant for data. Request any report, chat with it, then get it in Google Sheets or Excel in one click.
- Ask for revenue by currency and month
- Chat and workbook share settled_revenue
Google SheetsOpenExcelOpen
- 0.41.0Rotating a connector key is one change: Sources share reusable Credentials
- 0.39.0Reload a year of history in one backfill, not twelve
- 0.37.0Clearer connector errors, and custom connectors that handle more APIs
- 0.37.0Unchecking a column in the OWOX Extension no longer fails Save & Run
- 0.36.0Start a connector run without expanding the Input Source card
Why OWOX for Open Exchange Rates in Excel
A pasted rates tab keeps Excel moving. OWOX keeps one rate table that every workbook reads.
- One rate for every report. Orders and invoices join the same table by date and currency.
- Currency logic defined once. settled_revenue lives in the data model, not in forty workbooks.
- Your conversions stay. Refresh rewrites the imported rate columns only.
- Maintained for you. No feed to re-paste when a currency is added.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.