Pull Bank of Canada data into Microsoft Excel
Canadian reporting needs the official rate, not a quote from a random site. Load Bank of Canada rates into your data warehouse, convert orders and invoices to CAD there, and pull the Data Mart into Excel.
Bank of CanadaConnectedExchange Rates
Microsoft ExcelDateLabelRateDaily 09:00Canadian reporting in Microsoft Excel runs on a rate copied from some website, not the official Bank of Canada rate.
Paste this into your AI assistant. It loads Bank of Canada rates into your data warehouse with OWOX Data Marts, converts orders and invoices to CAD there, and publishes the Data Mart for the Excel 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/bank-of-canada-connector-to-microsoft-excel.md. The task: load Bank of Canada exchange rates into my data warehouse, convert my orders and invoices to CAD by date, and publish the result as a Data Mart I pull into Microsoft Excel with the add-in. 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
Bank of Canada Endpoints
1 Bank of Canada endpoints you can import. Each lands in its own table in your data warehouse.
Why Bank of Canada does not go straight to Excel
The published rates can be pasted into Excel, but not reliably, at scale or business-ready. A pasted tab has no history of its own and no link to your orders. The data warehouse keeps the official series and joins it to your money first.
- Bank of Canada publishes the rate, not how your reports use it
- The data analyst converts orders and invoices to CAD by date and currency
- Finance opens a workbook with an audit trail behind each rate
Bank of CanadaOfficial FX ratesMicrosoft Exc…
Data warehouseJoined by idStep 1: Load Bank of Canada into your data warehouse first
Bank of Can…Data MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databricksbank_of_canada.exchange_ratesStep 2: Link Bank of Canada rates to orders and invoices
In your data warehouse the model puts the official rate table beside orders and invoices, joined by date and by currency code plus CAD (a EUR order matches EURCAD). Pick an industry to see the shape of its model.
- Every rate is quoted against the Canadian dollar, so CAD is the natural basis
- Orders and invoices join on date and their currency code plus CAD
- Revenue in CAD is calculated in one place
Bank of CanadaExchange RatesStep 3: Pull Bank of Canada data into Excel with the add-in
In Excel, add the OWOX Data Marts add-in and sign in. Choose the published Bank of Canada Data Mart (Exchange Rates), tick the columns you want and press Create & Run.
- Tick date, label and rate: the three fields of Exchange Rates
- The add-in needs no Bank of Canada login because it reads the data warehouse
Microsoft ExcelYour columns staydatelabelrateStep 4: Refresh the Bank of Canada workbook when you need it
Refresh at period end. The imported rate rows update; the CAD column you added beside them recalculates from the new values.
- A formula in your own column keeps working after refresh
- Pull when the books close, not before
Microsoft ExcelYour column staysdatelabelrateYoursStep 5: Reuse Bank of Canada inside OWOX MCP
The Bank of Canada Data Mart also runs in OWOX MCP, your assistant for data. Request any report, chat with it, then take it to Google Sheets or Excel in one click.
- Ask for revenue in CAD by month
- The chat and the workbook share settled_revenue
Google SheetsOpenExcelOpen
- 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
- 0.35.0Resume an interrupted manual backfill from the last fully loaded date
Why OWOX for Bank of Canada in Excel
Hand-pasted rate tabs get CAD into Excel. OWOX keeps the official series and your conversions on the record.
- One official rate table. Every workbook converts with the Bank of Canada series stored in your data warehouse.
- An audit trail for finance. Each converted figure traces back to a dated rate row.
- Your columns stay. Imported columns are the only ones a refresh touches.
- Maintained for you. No source to monitor or credentials to rotate.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.