Databases and software

LSEG Eikon with Datastream

LSEG Eikon with Datastream allows you to monitor real-world market trends and download historical data (stock prices, indices, macroeconomic indicators, etc.) for research purposes.

Access to the database is provided each semester to 10 students (a period from January 1st to June 30 and from July 1st to December 31st) who express their interest and sign the contract to agree to the terms of use of the user account. To obtain a username and password, visit Dagmar Schnellerova. The contact person in case of difficulties is Jiri Kukacka. There are two ways to access the LSEG Eikon database: functionally limited Web Access for quick access to data on any device without installation or Eikon application (installation for Windows only + also add the Datastream Add-On to MS Excel, the "Faculty" MS Office 365 supported, available on all computers in room No. 016) for full-featured download of data using Excel. For a detailed list of differences, see the attachment.

Both accesses are available here. Alternatively, you can "Sign In" to your LSEG MyAccount profile here (go to: "Products" - "Eikon" - "See product details" and install the Eikon app or click "Launch product" for the Web Access).

Useful online resources:

• Download & Installation tutorial for Eikon and Datastream to MS Excel.
• Datastream Quickstart: Eikon Essentials: Using Datastream and Retrieving and Analyzing Data in Excel.
• LSEG Learning Centre: online tutorials, on-demand videos, and webinars where students can freely register and take advantage of live training with instructors and specific questions on the topic.
• API for Python: Overview, Quickstart, and Documentation.

BankFocus by Moody's Analytics

The BankFocus database offers extensive financial data on over 46,800 banks across the globe and more than 10,000 other non-bank financial institutions, including both active and inactive entities. It provides historical coverage of up to 30 years, encompassing detailed financial statements, ownership structures, and credit ratings. This database enables users to perform trend analysis, benchmark performance, and evaluate risks across institutions and geographies. For a more detailed description of the database content, see the attachment.

Access to the database is automatically guaranteed to all IES Faculty members (AP and Lecturers) and interested doctoral students via their name.surname@fsv.cuni.cz or number@fsv.cuni.cz email to which the login passwords have been sent.

Students can obtain a username and password by Dagmar Schnellerova. This database can be accessed by 5 simultaneously logged users. The contact person in case of difficulties is Jiri Kukacka. For direct access, click here.

rejustify

Rejustify is an AI-enhanced ETL tool (Extract-Transform-Load) for data set preparation and merging data from multiple sources. The rejustify's algorithm analyzes an empty dataset to recognize its structure and suggests source tables from primary sources of data that match the best. Followed by a "fill" function which sends data queries to the primary sources and fills the required data into the dataset.

Rejustify has automatized merging and combining data from more than 600 million data series from over 60 most trusted statistical sources like Eurostat, ECB, UN, IMF, statistical offices, and central banks, including additional sources like CO2 emissions, Cryptocurrency prices, or COVID-19 cases.

Rejustify is an online service available through Google Sheets, R, and Python. Registration and instruction videos are at rejustify.com, and you can contact info@rejustify.com in case of any questions, suggestions, and comments.

Each semester, the first 100 students and staff of IES can claim their free access to a premium account with Jiri Kukacka.

WorldData.AI

WorldData.AI access to over 3.3 Billion datasets from 8000+ leading public and proprietary sources. It contains data sets in various subject areas, including finance, macroeconomics, weather, trade, health, agriculture, politics, labor markets, etc. The database includes the News Sentiment AI that provides text analysis of millions of news from all leading news sources for the last 10 years. Global Data provides a single platform combining the data published by leading government agencies, private agencies, and universities.

IES students and employees should create a free account in WorldData.AI using their @fsv.cuni.cz email address and automatically upgrade to the partner account. The contact person in case of difficulties is Jiri Kukacka.

Kibot Historical Intraday Data

We can provide the students with over 27 years (since 1998) of one-minute adjusted and unadjusted historical intraday data and up to 60 years of daily (EOD) data for all available US stocks and ETFs, Futures, Forex and Indexes (a total of over 28,000 instruments). On the Kibot webpage, search over the "All intraday and daily data bundle" lists of intraday files and contact Frantisek Cech with specific Symbols.

MagnusWeb

MagnusWeb features an extensive database of information about Czech companies. Unlike global databases available at IES (e.g., Eikon), it is not limited to a small number of large Czech companies, but it covers firms of all sizes (in total, about 1 million legal entities) from the year 2000 onwards. It contains data from company financial statements, together with information on firm ownership structure, employees, and important events (e.g., annual meetings, important contracts and investments, mergers and acquisitions, bankruptcies, and insolvencies). The database allows for the search of information about individual firms and batch downloads of time series about a large number of companies. For detailed information, see the attachment (in Czech only). The students interested in accessing MagnusWeb need to sign the contract and accept the terms of use of the user account. The 10-day access credentials are distributed by Dagmar Schnellerova. For direct access, click here.

CRIBIS (in Czech only)

The CRIBIS database, provided by CRIF – Czech Credit Bureau, a.s., is a reliable data source containing information on more than 10 million business entities and individuals from the Czech and Slovak Republics. It draws from over 43 primary, clearly unified, and comprehensive public and non-public information sources. The Cribis application offers every user convenient access to useful information resources within a single structured web application.

IES students have exclusive access to this application in room no. 602 on a designated computer located opposite the entrance door. The database can be launched via the "CRIBIS" icon on the desktop of this computer. Before using the database, it is necessary to sign a registration form at the reception desk, reflecting the agreement with the database provider. The contact person in case of difficulties is Petr Teplý.

Factiva by Dow Jones

A database of key information from business and economy, allowing access to, among others, the full text of the world's journals as well as their archives. The Factiva contains, for example, the following resources: more than 600 continuously updated news sources (newswires), incl. the exclusive combination of resources from Dow Jones and Reuters; the daily newspaper content of The Wall Street Journal, the Financial Times, The New York Times and others; general and professional periodicals such as The Economist, Forbes, Fortune; business reports, macroeconomic data, analytical tools, industry, business, and stock reports.

This database can be accessed by 5 simultaneously logged users. The contact person in case of difficulties is Jiri Kukacka. For more information, visit this FSV UK eResources Portal. For direct access, click here.

Monitoring of Social Media by Newton Media (in Czech only)

Through the Newton Social Media web interface, users can perform full-text searches in an electronic archive of both print and digital media. The Newton Media Search archive includes content from national and regional periodicals, general and specialized magazines, news from hundreds of internet servers, and transcripts of journalistic, discussion, and news programs from the Czech Republic. The archive spans back to 1996. For more information and access, visit this FSV UK eResources Portal.

Statista

STATISTA is one of the largest statistics platforms in the world, providing access to more than a million different statistics on a wide range of different topics from many sources. It covers all major research areas, providing data on economics, consumer goods, trade, advertising and media markets, sports and recreation, technology and telecommunications, transport and logistics. It includes economic and market forecasts and demographic trends.

The contact person in case of difficulties is Jiri Kukacka. For more information, visit this FSV UK eResources Portal. For direct access, click here.

Open data Ministerstva financí ČR (in Czech only)

The Ministry of Finance of the Czech Republic operates the Open Data Portal. The portal contains catalogs of data sets that the Ministry has published or plans to publish.

Open data from Národní zdravotnický informační portál (in Czech only)

The catalog provides an overview of all available National Health Information Portal (Národní zdravotnický informační portál, NZIP) outputs. Here, you can find infographics, interactive visualizations, open data sets, and data summaries. Thanks to advanced search options, you can easily find exactly what you need. If you do not find answers to your questions in the catalog, you can submit a request for specific data (consult with your supervisor first).

Other useful databases for health analyses are survey data:

• SHARE: access, registration required.
• European Health Interview Survey (EHIS): access, application is submitted through ÚZIS ČR (consult with your supervisor first).
• Survey on Income and Living Conditions (SILC): access, application is submitted through ČSÚ (consult with your supervisor first).

Management Science

Our students currently have access to Management Science, a world-leading journal devoted to quantitative analysis of organizational, managerial, group, and individual decision-making. The journal covers all aspects of management related to strategy, entrepreneurship, innovation, technology, and organizations, as well as all functional areas of business, such as accounting, finance, information systems, marketing, and operations. The articles are primarily based on computer science, economics, mathematics, psychology, sociology, and statistics. In Finance, it ranks among the top 5 journals globally. Among others, Management Science offers research in behavioral economics, decision theory, financial markets, corporate finance, and other fields of interest in economics and finance.

Downloading journal articles

Charles University EZproxy Portal (login via the Central Authentication Service password required) offers various electronic information resources from where you can download journal articles with restricted (paid) access.

A simple "trick" for an effective download is the following. Imagine you would like to get, e.g., one of the most cited recent papers from the Journal of Finance by Andrei Shleifer and Robert W. Vishny, available at https://onlinelibrary.wiley.com/doi/abs/10.1111/j.1540-6261.1997.tb04820.x. Standardly, using your personal computer not connected to eduroam, you should not be able to download the paper in .pdf since the access is restricted (paid). But if you insert ".ezproxy.is.cuni.cz" after the ".com" part of the link above (i.e. you use https://onlinelibrary.wiley.com.ezproxy.is.cuni.cz/doi/abs/10.1111/j.1540-6261.1997.tb04820.x), after your CAS login you will be able to download this paper in .pdf for free.

Note: this trick does not work for all journals and publishers, but it works for most of them.

The Financial Times is one of the world's leading news organizations, recognized internationally for its authority, integrity, and accuracy. It is part of Nikkei Inc., which provides a broad range of information, news, and services for the global business community. The access is available online in the IES library on one computer (always for one user), provided by the library operator.

Logins via the Central Authentication Service password required:

Articles from The Banker (monthly) can be found in the Factiva database. For direct access, use the link and then click "Factiva".

Articles from The Wall Street Journal (daily) can be found in the Factiva database. For direct access, use the link and then click "Factiva".

Library Press Display offers previews of the current issues of many Czech (HN, LN, MF DNES, Ekonom, Respekt, ...) as well as foreign (The Washington Post, The Guardian, The Daily Telegraph, ...) newspapers and magazines.

(login via the Central Authentication Service password required)

E-books, mostly in the field of economics and finance, are available to IES users mainly from the three following databases:

• ProQuest Ebook Central
• EBSCO eBooks
• Taylor & Francis Group eBooks
• all e-books should be available also via Charles University's search engine UKAZ

BOOKPORT: a database of Czech academic and popular science e-books.

What Everyone Needs to Know: a collection of e-books Social Sciences (access is set up automatically for the CUNI computer network).

Mathematica

Wolfram Mathematica is a modern technical computing system spanning all areas of technical computing—including neural networks, machine learning, image processing, geometry, data science, visualizations, and others. Windows, Macintosh, and Linux are supported.

Mathematica is standardly available on all computers in room No. 016. Students are additionally offered "Mathematica for Students for Sites" license for educational purposes that allows installing a full copy of Mathematica on a personal computer. Follow these instructions to download the software and to obtain an activation key. The contact person in case of difficulties is Jaromir Baxa.

Note: faculty members are offered "Mathematica for Sites" license. Contact Jaromir Baxa for installation instructions.

MATLAB - a new license for the CU

MATLAB (matrix laboratory) is a multi-paradigm numerical computing environment. A proprietary programming language developed by MathWorks, MATLAB allows matrix manipulations, plotting of functions and data, implementation of algorithms, creation of user interfaces, and interfacing with programs written in other languages.

MATLAB is standardly available on all computers in room No. 016. All students and teachers can install and use MATLAB and all of the official toolboxes on their computers without the need to be connected to the faculty network via a license server. Charles University can not only use the software itself and all the toolboxes but also access a variety of online courses and online support. More information about the license and installation is available here. The English version of the site is not available, but translation via Google works quite well.

The existing users might be asked to deactivate their license during the installation process. The contact person for any difficulties is Jaromir Baxa.

Stata

Stata is a general-purpose statistical software package by StataCorp. Most of its users work in research, especially in the fields of economics, sociology, political science, and others. Stata's capabilities include data management, statistical analysis, graphics, simulations, regression, and custom programming.

Stata is standardly available on all computers in room No. 016.

In support of computationally demanding students' projects (Bc. and Mgr.) and diploma/bachelor theses, two iMac Pro computing stations are available at IES:

Computer in 507:

• 2.3GHz 18-core Intel Xeon W, Turbo Boost up to 4.3 GHz
• 64 GB 2666MHz memory DDR4 ECC
• graphics card: Radeon Pro Vega 56 with 8 GB memory HBM2
• 1 TB SSD

Computer in 602:

• 3.0GHz 10-core Intel Xeon W, Turbo Boost up to 4.5 GHz
• 32 GB 2666MHz memory DDR4 ECC
• graphics card: Radeon Pro Vega 56 with 8 GB memory HBM2
• 1 TB SSD

If you are interested in using this computing capacity, contact one of the administrators: Jozef Barunik, Lubos Hanus, or Jiri Kukacka, and then please fill in this form.