FlowRunner
PricingContact
Theme
Start Free

CNB Exchange Rates

Finance

The Czech National Bank publishes koruna exchange rates, PRIBOR and CZEONIA money market rates, and FX forward points through an open API. Agents pull daily, monthly, and average rate series with no account or key required.

Verified 23 actions No credentials available
CNB Exchange Rates website Platform Documentation Capability data verified 2026-08-25
The month-end close job runs after 14:30 Prague time on the last business day
Get Daily Exchange Rates pulls the central koruna list for the closing date
The agent reads validFor on the returned rows to learn which day the list is really for
Convert Amount revalues each open foreign currency balance, dividing by the quoted unit
Revalued balances append to the close workbook with rate, unit, and validFor beside every figure
The agent posts the revaluation summary and calls out any row whose validFor is not the closing date
The controller decides whether to book against the last published list or hold the close for the requested date

What This Integration Enables

Most currency APIs sell you a market rate. The Czech National Bank publishes something narrower and more useful: the official koruna rate list that Czech accounting, tax filing, and statutory reporting are measured against. That distinction is the whole reason to build on this connector rather than a market feed. When an auditor asks where a revaluation figure came from, the answer you want is the central bank's published list for a named day, not a vendor's snapshot of a trading venue.

FlowRunner agents read the daily list of roughly thirty currencies, the separate monthly list of roughly one hundred and thirty, and the three average series that Czech practice actually uses: monthly for a month of transactions, cumulative for a year to date figure, quarterly for quarterly reporting. The same connectors layer reaches PRIBOR and CZEONIA for loan repricing, open market operations, FX forward points, and short term securities settlement. The API is open, so there is no key to rotate and no account to provision. What the connector adds is the arithmetic discipline the raw feed does not: Convert Amount reads the rate, divides by the amount the rate is quoted per, and reports the rate, the unit, and the effective date it used.

Without FlowRunner

Rates retyped by hand Somebody opens the bank's daily list and copies figures into the close workbook
The unit trap A rate quoted per hundred units gets multiplied as though it were per one, and the result still looks plausible
No note of which day The workbook holds a number with nothing recording which published list produced it

With FlowRunner

The list arrives on schedule A flow reads the central list after publication and feeds it straight into the close
The unit is handled at the source Convert Amount divides by the quoted unit and reports the unit it applied
Every figure carries its date Each converted amount is stored alongside the rate, the unit, and the validFor date behind it

Use Case Scenarios

  • Month end revaluation that survives an audit

    At close, an agent lists every open foreign currency balance from the ledger in NetSuite or Xero, then calls Convert Amount once per currency against the closing date. Each result comes back with the published rate, the unit that rate is quoted per, and the validFor date, and all three are written next to the revalued figure in a Google Sheets tab. Nobody has to remember that the afghani row is quoted per one hundred, because the connector already divided. The revaluation pack that reaches the auditor shows its own source for every line.

  • Year to date reporting without a manual extract

    A reporting flow calls Get Cumulative Averages For Currency for the currencies the group trades in, plus Get Monthly Averages For Year for the full grid. The averages land in BigQuery beside the transaction data, so the finance team can pivot a year of foreign currency activity against the exact average series a Czech return expects. Get Quarterly Averages For Year covers the quarterly filings from the same job. What used to be a quarterly download and reshape becomes a table that is already current.

  • Watching a floating rate loan reprice

    A treasury agent calls Get PRIBOR For Term on a schedule for the term the group's facility reprices on, and compares the published fixing against the covenant thresholds held in Airtable. Get Daily CZEONIA adds the traded overnight rate and the volume behind it, which is a different signal from a quoted one. When a fixing moves through a threshold, the agent posts the fixing, the term, and the affected facilities into Slack so treasury sees the repricing before the interest run does.

Human-in-Loop Highlight

The bank does not fail a request for a day it has not published. Ask for a Sunday, a Czech public holiday, or today before 14:30 Prague time, and the API returns the last valid list instead of an error. That behavior is convenient for a dashboard and dangerous for a close, because a revaluation posted against Friday's list and dated Sunday is a wrong number that no status code will ever flag. So the close agent compares the validFor field on the rows against the date it was asked to book, and when they disagree it stops. It posts: "Requested closing date 2026-06-30 is a Sunday. The most recent published central list is validFor 2026-06-27. Book the revaluation at the 27 June list, or hold the close until the next publication?" The controller answers, because that figure goes into a statutory filing and the choice belongs to the person who signs it.

Agent processes routinely
Detects exception requiring judgment
Clear match Continues automatically
Ambiguous Routes to human via preferred channel
Human decides
Agent resumes with decision

Agent Capabilities

23 actions

Exchange Rates

3
  • Get Daily Exchange Rates Reads the central koruna list for one day, roughly thirty currencies. Used as the rate source for any same day conversion or revaluation.
  • Get Exchange Rates For Year Returns every daily row published in a calendar year in one call. Used to backfill a warehouse or rebuild a historical series without looping day by day.
  • Get Currency Rates For Month Returns one currency across one month, a row per business day. Used to chart or reconcile a single exposure over a period.

Averages

6
  • Get Monthly Averages For Currency Returns every monthly average published for one currency. Used when a month of transactions is converted at the month's average rather than at spot.
  • Get Monthly Averages For Year Returns the monthly average grid for every currency in a year. Used to load a reporting table in one pass.
  • Get Cumulative Averages For Currency Returns the January to month average series for one currency. Used for year to date figures on a tax return.
  • Get Cumulative Averages For Year Returns the cumulative average grid for every currency in a year. The bulk form of the same series.
  • Get Quarterly Averages For Currency Returns every quarterly average published for one currency. Used for quarterly reporting.
  • Get Quarterly Averages For Year Returns the quarterly average grid for every currency in a year.

Other Currencies

3
  • Get Other Currency Rates For Month Reads the monthly list of roughly one hundred and thirty additional currencies. Used for exposures the daily list does not carry.
  • Get Other Currency Rates For Year Returns twelve monthly lists in one call. Used to build the full year of the monthly series.
  • Get Other Currency Rates For Range Returns one currency from the monthly list across a range of months. Used to track a single minor currency over time.

Money Market

5
  • Get Daily PRIBOR Returns all nine quoted terms for one day, from overnight to one year. Used to capture the fixing that floating rate facilities reprice against.
  • Get PRIBOR For Year Returns every term for every business day of a year. Used to load history for analysis rather than to read today's fixing.
  • Get PRIBOR For Term Returns one term across a year. Used when a facility reprices on a single named term and the other eight are noise.
  • Get Daily CZEONIA Returns the traded overnight index and the deposit volume behind it for one day. Used when a workflow needs an actual traded rate rather than a quoted one.
  • Get CZEONIA For Year Returns the overnight index for every business day of a year.

Monetary Operations

2
  • Get Daily Monetary Operations Returns the open market operations settled on one day, including their type and liquidity impact. Used by treasury workflows tracking central bank activity.
  • Get Monetary Operations For Year Returns the same operations across a full year.

Forward Points

2
  • Get Daily Forward Points Returns the published forward points for both quoted pairs and both maturities on one day. Used to build a forward rate from the spot rate.
  • Get Forward Points For Range Returns a chosen pair and maturity across a date range, or all of them at once. Used to follow the forward curve over a period.

Securities

1
  • Get Daily Securities Settlement Returns the short term bond issues settled through the bank's system that day. Used by workflows that reconcile settlement activity.

Conversion

1
  • Convert Amount Converts an amount in either direction using the published rate, dividing by the amount the rate is quoted per. It reports the rate, the unit, and the validFor date it used, so the result is auditable rather than a bare number. It reads the daily list first and falls back to the monthly list, naming which one answered.

Frequently Asked Questions

What can FlowRunner do with CNB Exchange Rates?

FlowRunner agents can run Get Daily Exchange Rates, Get Exchange Rates For Year, and Get Currency Rates For Month in CNB Exchange Rates, plus 20 more actions.

Does connecting CNB Exchange Rates to FlowRunner require OAuth?

No. CNB Exchange Rates needs no credentials at all, so there is no key to obtain, store, or rotate.

Can CNB Exchange Rates trigger a FlowRunner workflow automatically?

CNB Exchange Rates doesn't currently expose triggers in FlowRunner. It connects as an action step inside workflows started by another trigger.

Start building with CNB Exchange Rates

Free plan, no card required. Connect in minutes.