Česká národní banka


CNB > FAQ > Format of the foreign exchange market rates on the CNB website

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:
http://www.cnb.cz/en/financial_markets/foreign_exchange_market/exchange_rate_fixing/daily.jsp?date=DD.MM.YYYY

DD - day
MM - month
YYYY - year

  • TXT format

URL for access:
http://www.cnb.cz/en/financial_markets/foreign_exchange_market/exchange_rate_fixing/daily.txt?date=DD.MM.YYYY

or

http://www.cnb.cz/en/financial_markets/foreign_exchange_market/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:

http://www.cnb.cz/en/financial_markets/foreign_exchange_market/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.