Format of the foreign exchange market rates
The CNB declares foreign exchange market rates in HTML and TXT formats (the latter being suitable for further processing) through dynamic applications on the CNB website in the following form:
Foreign exchange market rates as of a given date
Foreign exchange market rates as of a given date are updated only once a day (every working day after 2.30 p.m.).
Unwarranted and excessive access to these pages will be considered undesirable and will be limited in the interests of security.
- HTML format
URL for access:
https://www.cnb.cz/en/financial-markets/foreign-exchange-market/central-bank-exchange-rate-fixing/central-bank-exchange-rate-fixing/index.html?date=DD.MM.YYYY
DD - day
MM - month
YYYY - year
- TXT format
URL for access:
https://www.cnb.cz/en/financial-markets/foreign-exchange-market/central-bank-exchange-rate-fixing/central-bank-exchange-rate-fixing/daily.txt?date=DD.MM.YYYY
or
https://www.cnb.cz/en/financial-markets/foreign-exchange-market/central-bank-exchange-rate-fixing/central-bank-exchange-rate-fixing/daily.txt (without parameter, only for current exchange rates)
DD - day
MM - month
YYYY - year
Description of TXT format:
The first line of the file consists of the date for which the exchange rate was declared in DD.MM.YYYY format. After the date there are 2 spaces and a # sign together with the sequence number of the rates published within the year. Example 1st line:
03.Jan.2000 #1
This line is followed by the exchange rates, with the first line consisting of a header in the following form:
Country|Currency|Amount|Code|Rate
The other lines contain the data themselves. Each line contains one currency. The individual figures are separated with a '|' sign; in the case of figures with a decimal part the decimal place separator is a '.' sign. Example for a specific currency:
Australia|dollar|1|AUD|23.282
The foreign exchange market rate data are followed by a blank line separating the data from the calculated rates (only for years 1999-2001). These start with the header:
Country|Currency|Amount|Code|Rate
The data themselves follow on the subsequent lines (the separator being a '|' sign).
Example line of data:
Belgium|frank|100|BEF|89.762
Foreign exchange market rates for a given year
Data are available in TXT format only, from 1991 up to the present
URL for access:
https://www.cnb.cz/en/financial-markets/foreign-exchange-market/central-bank-exchange-rate-fixing/central-bank-exchange-rate-fixing/year.txt?year=YYYY
YYYY - year
Description of TXT format:
The first line contains a header and the other lines the data. The individual figures are separated with a '|' sign; in the case of figures with a decimal part the decimal place separator is a '.' sign. The header, which also determines the format of the data lines, has the following form:
Date|<<currency amount 1>> <<currency code 1>>|<<currency amount 2>> <<currency code 2>>|…..
Should the structure of the published rates change during the year, a new updated header will be located between the data lines prior to the date on which the change occurred.
Example: The header of exchange rates after 1st January 2005 - change in extent of published rates:
Date|1 AUD|1 BGN|1 HRK|1 DKK|1 EUR|1 EEK|1 HKD|100 ISK|100 JPY|1 ZAR|100 KRW|1 CAD|1 CYP|1 LTL|1 LVL|100 HUF|1 MTL|1 XDR|1 NOK|1 NZD|1 PLN|10000 ROL|100 RUB|1 SGD|100 SKK|100 SIT|1 SEK|1 CHF|1 TRY|1 USD|1 GBP
Selected exchange rates
Data are available in HTML, Excel and ASCII format. The Excel format is adjusted for MSIE 5 or higher.
Selected exchange rates - charts
Description of the Y axis: Currency pairs are stated in the common format under the conventions of the financial markets. It means that the base (main) currency is stated as first. Hence this format cannot be taken as a mathematical expression of the number of units of the first currency for one unit of the second currency but the other way around. Because the Czech national bank sets the exchange rates fixing uniformly as a number of korunas per particular currency such currency is considered as a base one and therefore stated as first.