Exchange Rates
Module Overview
The Exchange Rates module provides an overview of exchange rates announced by the Czech National Bank (ČNB). It allows you to track current and historical exchange rates, compare their development over time, and use this data for calculations in other eIntranet modules.
The module automatically downloads rates from ČNB every working day and stores them in the database. Data is available in two forms - as a clear table of all rates or as a graphical representation of a selected currencys development over time.
Features
Basic Functions
- Automatic download of current rates from ČNB every working day
- Complete exchange rate history storage
- Table view of all available currencies and their rates
- Graphical display of selected currency development
- Search and filter by specific currency
- Date range selection for analysis
- Export to Excel, PDF and CSV formats
Two Display Modes
- Rates - Table overview of all exchange rates with search, sorting and filtering
- Charts - Visualization of selected currency rate development using line chart
Automatic Data Update
The system automatically downloads data from ČNB sources. Updates occur every working day automatically in background. ČNB publishes rates at 14:30, in eIntranet they are usually available from 14:35.
Working with the Module
Table View
- Open Exchange Rates module from main menu
- Click Rates tab
- Table shows: Date, Country, Currency name, Currency code, Amount, Rate
Search and Sorting
- Use Search field for fulltext search
- Click column header to sort ascending or descending
- Change records per page with dropdown
- Navigate between pages
Currency Filter
- Find Currency Filter dropdown above table
- Select desired currency from list
- Table updates automatically to show only selected currency
Data Export
- Excel - XLSX format for further processing
- PDF - PDF format for printing or sharing
- CSV - Text format for import to other systems
Chart View
- Click Charts tab
- Select currency from dropdown
- Set date range with From/To date fields
- Click Generate Chart
- Line chart shows rate development over time
Tips
- Hover over chart points to see exact values
- Use date range to analyze specific periods
- Export historical data for reporting