Data workshop: M&A / Event studies – Refinitiv Workspace/Datastream, Orbis M&A (NSM)
This workshop is intended for students Economics and Business Administration who perform an event study (e.g. M&A, IPO, venture capital) for their BA or MA thesis and (1) need help using the event study modules, and/or (2) need to download stock & index returns for their event study and calculate abnormal returns, and/of (3) need additional financial variables, ratios etc. to complement their dataset.
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. For deals, include at least company names, event dates and identifiers (ISIN, CUSIP and/or SEDOL). Please also indicate if you are a MacBook user. The Refinitiv Workspace may not fully work on a MacBook.
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 Refinitiv Workspace/Datastream, please let us know beforehand! You can install the software shortly before or during the first part of the workshop. After the workshop you can make use of Refinitiv Workspace for the rest of the day.
Location & duration
The workshop will take place in room EOS 01.570. Participants receive a zoom invitation beforehand.
Duration: 2 hours.
There is room for 2 attendants per workshop.
Related LibGuide: Library Guide Business Administration & Economics by Norma Fötsch
- Date:
- Tuesday, May 23, 2023
- Time:
- 10:30am - 12:30pm
- Location:
- EOS 01.570 Elinor Ostrom Building (NSM)
- Campus:
- Nijmegen School of Management
- Faculty:
- Nijmegen School of Management
- Categories:
- Other
Contents workshop
When conducting an event study you will usually start working with an M&A, IPO, venture capital etc. module in Orbis M&A / Refinitiv Workspace to construct your set of deals and retrieve as many variables as possible - or you gather the events somehere else (e.g. news, earning calls). How to use such a module was addressed in the event studies support sessions (see handout & step-by-step guide https:libguides.ru.nl/BE/workshops)
Because these modules only supply ready-made, non-customizable variables, you usually need to gather additional data (financials, stock and index returns, ratios etc.). Refinitiv Workspace/Datastream (Excel) contains most of such variables, with superior historical coverage. To find them, you have to link your dataset to Datastream - this can be done with company identifiers (e.g. ISIN). You can do this with Orbis or Compustat as well (not for stock prices).
This is the main focus of the workshop. In this workshop you can work with Refinitiv Workspace / Orbis M&A / Zephyr / Compustat on your own dataset. A data librarian of the NSM Library Team will be present to introduce the basics of this process and assist you further in your search.
The workshop covers elements like:
- installation of the Refinitiv Workspace software (if necessary);
- the basics of the Refinitiv Workspace add-ins;
- working with the M&A etc. module of your choice or gathering the events somewhere else;
- using company identifiers (ISIN, CUSIP, SEDOL) obtained in the module you used to locate and retrieve additional variables;
- working with a template to retrieve the stock data for specific event and estimation windows of your research;
- linking your dataset to Orbis or other databases to find additional financials;
- calculating stock betas and (cumulative) abnormal returns in Stata;
- creating one master-dataset.
