Workshops box
Data workshop: financials, stock, index & ESG/CSR data - LSEG Workspace/Datastream, Compustat/WRDS, Orbis (NSM)
This workshop is intended for students Economics and Business Administration working with CSR/ESG data, financials, financial ratios and/or stock/index returns for their BA or MA thesis - and to give the process of data-retrieval in LSEG Workspace/Datastream, Compustat and/or Orbis a kick start.
Participants are strongly advised to send information about their research topic, e.g. the desired dataset, variables and timeframe, to datasupport-NSM@ubn.ru.nl at least 24 hours before the workshop.
If you have other topics you would like to address or have further questions do not hesitate to communicate this beforehand!
If you need to use LSEG Workspace/Datastream during the workshop, please inform us beforehand! About the Workspace: https://libguides.ru.nl/BE/LSEGWorkspace
You can install the software before or during the first part of the workshop. After the workshop you can make use of LSEG Workspace for a few hours if necessary. For MacBook-users: notify us that you have a MacBook, the procedure might be different.
Location & duration
The workshop will take place in EOS (Elinor Ostrom building). Participants receive an invitation with the exact location beforehand. If necessary, the workshop can also be held via Teams.
Duration: 2 hours.
There is room for 4 attendants per workshop.
Related LibGuide: Library Guide Business Administration & Economics by Norma Fötsch
- Date:
- Wednesday, May 22, 2024 Show more dates
- Time:
- 10:30am - 12:30pm
- Campus:
- Nijmegen School of Management
- Faculty:
- Nijmegen School of Management
- Categories:
- Other
Contents workshop
When you need company financials, financial ratios and/or stock or index data, you can use LSEG Workspace/Datastream, Compustat or Orbis (latter 2 not for stock & index data). Here you'll find a great number of such variables for companies listed on stock exchanges worldwide. CSR/ESG data is only available in LSEG Workspace/Datastream (detailed board data is available in BoardEx as well; cf. the BoardEx workshops).
The support sessions on Orbis, financials & equities and CSR/ESG & board data (see for the slides: https://libguides.ru.nl/BE/workshops) offered an overview of the basics. In this follow-up workshop you can actually start working with the databases for your own topic. This is a great opportunity to learn to work with LSEG Workspace/Datastream, Compustat and/or Orbis. A data librarian of the NSM Library Team will be present to assist you.
The needs of the participants determine what is treated in the workshop, such as
- creating a sample of firms based on certain criteria (e.g. constituents of an index, all (listed) firms in multiple countries or in certain industries);
- efficiently working with company lists in LSEG Workspace/Datastream or Compustat
- efficiently use advanced filter options for Orbis, e.g. on ownership or multinational firms;
- finding the variables you need (financials, ratio's, stock data) and retrieving them efficiently for the companies in your sample;
- finding ESG/CSR variables and retrieving them efficiently for the companies in your sample;
- discriminating between companies by industry;
- changing/adding currencies, finding exchange rates etc.;
- finding related variables (e.g. GPD, benchmarks);
- combining datasets from different databases in Excel, R or Stata;
- creating a panel dataset in R or Stata;
- linking your dataset with lists to the Eikon Screener (desktop version) to obtain additional variables (e.g. auditor firms, credit ratings)