Norges Bank Currencies connector

Pull the official NOK reference rates straight into your books.

Data Panda streams Norges Bank's daily middle rates for every currency you trade against the Norwegian krone into your warehouse, alongside your ledger and CRM. From one place, we revalue NOK receivables, track exposure per business unit, and feed your closing reports without anyone copying numbers from a website.

Data Panda Reporting Automation AI Apps
Norges Bank Currencies logo
About Norges Bank Currencies

The Norwegian central bank's open FX feed, in your warehouse.

Norges Bank is the central bank of Norway. Each business day around 16:00 CET it publishes middle rates between the Norwegian krone and roughly forty other currencies, calculated as the mid-point of buying and selling rates in the interbank market. Daily, monthly and annual quotations sit in the same data warehouse, free to access, with no API key required.

The feed lives behind an SDMX REST API at data.norges-bank.no/api/data/EXR. A query is positional: frequency, base currency, quote currency, tenor. EXR/B.USD.NOK.SP returns the daily spot rate for USD against NOK. The same path supports CSV, Excel, JSON and full SDMX-ML, with startPeriod and endPeriod for backfills running back decades. The bank flags the rates as indicative, not binding, but Norwegian and EU finance teams use them as the official reference for statutory NOK reporting and for closing-day revaluation.

Pulling the feed into a warehouse is not about replacing your treasury system. It is about putting the rate the auditor expects next to the booking that uses it: the NOK invoice from a Norwegian customer at the rate of the booking date, the open AR balance revalued at month-end close, the margin on a Norwegian deal compared to the day the quote was sent. Once it is a table, every report that touches NOK uses the same number.

Ideas

What you can automate with Norges Bank Currencies.

Pair with Exact Online

Revalue NOK receivables in Exact Online

Open AR and AP balances in Exact Online that are denominated in NOK get revalued each business day against the Norges Bank middle rate of that day. Finance closes the month with the same reference the auditor checks, and the unrealised FX line on the P&L stops being a spreadsheet calculation.

Pair with MS Dynamics 365 Business Central

Feed daily NOK rates into Business Central

The exchange-rate table in Dynamics 365 Business Central pulls in the Norges Bank EXR feed each morning, so NOK invoicing, posting and intercompany settlement use the central bank rate without anyone keying it in. Closing entries on Norwegian entities run on the same reference as statutory reporting.

Pair with Salesforce

Show NOK exposure on Salesforce accounts

Each Salesforce account with open NOK pipeline or invoiced revenue shows the current NOK-EUR rate next to the deal value, plus the rate at the day the opportunity was created. Account managers see the FX swing on a Norwegian deal before the customer call, not after the booking.

Pair with HubSpot

Quote Norwegian leads at today's middle rate

Deals on Norwegian companies in HubSpot get the current Norges Bank NOK rate stamped on the quote line, with the rate of the close date stored on the deal. Sales sees the rate the customer will see, and finance reconciles the booked margin against the rate at quote-out.

Pair with Slack

Alert treasury when NOK moves outside a band

When the daily NOK-EUR or NOK-USD middle rate moves outside a configured band versus the previous close, a focused Slack message goes to the treasury channel with the new rate, the move in basis points, and the open NOK exposure on the books. The conversation about hedging starts on the day of the move, not at the next monthly review.

Pair with monday.com

Track NOK exposure per business unit on a Monday board

A monday.com board lists every Norwegian customer and supplier with open NOK balances, the EUR-equivalent today and at the booking date, and the unrealised FX swing per business unit. The CFO scans one board to see where Norwegian exposure sits and which entity carries the most risk.

Data model

Tables we make available.

These are the 1 tables we currently pull from Norges Bank Currencies into your warehouse. Query them directly in SQL, join them to the rest of your stack, or build reports on top.

  • Currencies

Missing a table you need? We can extend the sync. Tell us what is missing and we will build it for you.

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 Norges Bank Currencies data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From Norges Bank Currencies to answers in three steps.

01

Connect securely

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

02

Land in your warehouse

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

03

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.

  • Norges Bank Currencies 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.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your Norges Bank Currencies setup and the systems around it. Together we pick the first thing worth building.