Databases and software

MagnusWeb

MagnusWeb features an extensive database of information about Czech companies. Unlike global databases available at the IES (e.g. Eikon), it is not limited to a small number of large companies, but it covers firms of all sizes (in total about 1 million legal entities) from 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, insolvencies). The database allows searching information about individual firms and also batch downloads of time series about a large number of companies. For detailed information see the attachment. 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 rights are allocated by Dagmar Schnellerova.

Factiva (by Dow Jones)

A database of key information from business and economy, allowing access to, among others, the fulltext 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 at present accessed by 5 simultaneously logged users. For more information, visit this FSV UK Library webpage. Contact person in case of difficulties: Jiri Kukacka. For direct (remote) access, click here.

LSEG Eikon with Datastream

LSEG Eikon 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 12 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. Contact person in case of difficulties: 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).

For new users of the Eikon database, regular introductory online tutorials are held twice a year. The focus is on database control and effective data retrieval and download. The tutorials take place on February 25 and October 20 (provided it is a working day) from 10:00 a.m. to approximately 11 a.m. online via Microsoft Teams. Nicolas Destrez from the London Stock Exchange Group will guide you through the tutorial. It is recommended to have a functional version of Eikon with the MS Excel Datastream Add-On installed on your personal computer.

It is necessary to register at least 1 day in advance at jiri.kukacka@fsv.cuni.cz. Connect at the given time via the provided link.

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: What is it?, Quickstart and Documentation.

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, first 100 students and staff of IES can claim their free access to 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. The 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. Contact person in case of difficulties: Jiri Kukacka.

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 top 5 journals globally. Among others, Management Science offers research in behavioral economics, decision theory, financial markets, corporate finance and other fields of interests in economics and finance.

Downloading journal articles

Charles University EZproxy Portal (login via the Central Authentication Service password required) offers various electronic information resource 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 dowlload this paper in .pdf for free.

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

The Financial Times is one of the world’s leading news organisations, recognised 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. 
Actually is available online in the IES library, always for 1 student, access on 1 computer is provided by the library operator.

(following logins via the Central Authentication Service password required):

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

Articles from The Wall Street Journal (daily) can be found in the Factiva database. For direct access use 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 the FSV users mainly from the three following databases:

• ProQuest Ebook Central
• EBSCO eBooks
• Taylor & Francis Group eBooks (Log in "With Shibboleth or OpenAthens" and search for "Charles University")
• all e-books should be available also via Charles University’s discovery service UKAZ

The database of Czech academic and popular science e-books:

• BOOKPORT

Collection of e-books Social Sciences (access is set up automatically for the CUNI computer network):

• What Everyone Needs to Know

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 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. Contact person in case of difficulties: 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 license server. Charles University can not only use the software itself and all the toolboxes, but also a variety of online courses and access to 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. Contact person in case of difficulties: 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 were purchased for IES.

Computer in 503:

• 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, Jiri Kukacka and then please fill in this form.