Power Query function · Free
ČNB currency rates
Load Czech koruna reference rates with quotation units handled explicitly.
Review build. Scoped native checks are listed under What you need. Full acceptance is incomplete. Purchases are disabled.
Will it fit your work?
- Your input
- A date range and optional currency codes.
- Your result
- Daily rates, RatePerUnit and publication date; optional weekend carry-forward.
- What you need
- Power Query and anonymous access to www.cnb.cz. It ran inside the Power BI model refresh; 4 offline edge cases and 1 live case passed in Power BI Desktop (17 Oct 2026), and the 4 offline cases plus 3 live cases in Excel Power Query (19 Oct 2026). Live refresh in the Power BI Service not yet tested.
- Check this first
- Confirm your accounting policy and date convention. No future rates are supplied.
Start with one known example
- Extract the whole ZIP and read START_HERE.md.
- Start with
CNB_FX.pqon a copy. - Use the example below; replace input paths and settings.
- Reconcile rows and totals before using real data.
CNB_FX(#date(2026,1,1), #date(2026,1,31), {"EUR", "USD"})Each package includes the source file or workbook, its PDF guide, a short setup path, verification status and a support checklist.
Free builds are for evaluation; validate the result in your own environment. Price shown for a paid tool is the proposed one-time price, before any applicable checkout taxes.
Data stays in your own files except for configured service calls. VIES receives VAT numbers; currency services receive requested dates and currency codes. No tracking or signup is used by this static preview.