Blog2Blog Maak je eigen Blog2Blog | Gratis je eigen blog c.q weblog op internet
Financial Databases and Research - Practical tips for Event Studies in Datastream
Financial Databases and Research

Practical tips for Event Studies in Datastream

Posted in Datastream

People who want to study the impact of certain events on company performance do what is called an event study. An example is: what effect does the announcement of quarterly financial results have on the stock of a company? To answer this question you need to find out what the major listed stocks of a company are and what the dates are when the results were announced over a certain period of time. Next you need to download the stock prices for the company at certain fixed windows in time surrounding the announcement dates. There are, of course, many more examples of event studies.

Datastream has a good tool that allows you to do this type of research: the Request Table tool in Excel. Some time ago I posted some examples on how to do an event study using the Request Table tool/Macro in Excel. Over time I have also posted several items on this blog that will make it easier to do an event study in Datastream using Excel. I thought it would be a good idea to make a short list of all posts related to an event study. I have also put them in the correct order:

NB: Another more general useful tip may be: how to remove duplicate company identification codes using Excel 2003, Excel 2007 or Microsoft Access 2007.

Author information: LinkedIn


12:07 PM - 15 September 2011

Last Page
Next Page
This weblog will deal with all kinds of tips and tricks on the use of several financial databases.

User Profile
--- Amadeus
--- Company.Info
--- Datastream
--- GMID
--- General
--- International Statistics
--- LexisNexis
--- SDC Platinum
--- S&P Indexes
--- Wharton
--- Zephyr
Recent Entries
- Announcement: New Blog
- International Human Development Indicators
- Global Reporting Initiative
- WorldScope company coverage update
- World Bank Commodity Prices - update November 2011

External Links:
--- NYSE Euronext
--- Finabase Blog
--- VU Law Blogspot