Using Datastream to find the dates when a company started or ceased trading
When retrieving financial data for a company or group of companies over a period of time, it can be helpful to know when each company either began or ceased trading. If you are using a group of companies you can use either a pre-formatted constituent list, e.g. LFTSE100, or if you have already created your own list of companies in Datastream, you can use this to retrieve the relevant dates (see our previous post on Creating and using constituent lists for more information).
Once you have your company or your list, follow these simple steps:
- Open an Excel spreadsheet and click on the Datastream tab or Add-Ins tab > Datastream.
- From the menu select ‘Static Request’
- Using either the orange ‘Find Series’ button or the list picker option below, select the list or the individual company that you need the dates for. In this example I’m using a list I’ve created called FT1002009.LLT.
- Next select your Datatypes. The datatypes you need are:
- NAME – You need to include this or the name of the companies will not be displayed
- BDATE – this is the base date ie the date from which Datastream holds information about the issue; for the UK the base date is one day before trading in the stock starts.
- TIME – this records the date or time of the latest equity price data. ie the last date on which the company has traded on a stock exchange.
- Click on submit.
Your results will be displayed as follows:
If you have any comments or would like further help please contact MIRC staff.
Feature image from Pixabay. Available at: https://pixabay.com/photos/business-stock-finance-market-1730089/
Categories & Tags:
Leave a comment on this post:
You might also like…
How do I reference… a newspaper article in the APA7 style?
If you're using newspaper content in your work, you may be wondering how to reference it. Is it exactly the same as a journal article reference? Well, it's pretty similar. Here's a short guide. To ...
Resource trial: Writefull
Throughout June, Library Services are running a trial for Writefull which provides tools to help with academic writing. Writefull's support includes proofreading, spelling and grammar checking your work. It can also help you craft your ...
Working smarter, cleaner and greener: The future of manufacturing and materials
Everything we own, use or interact with in life starts with a material or materials. But even we in the industry admit that materials are a huge part of what has led us to where ...
Hubert Ovie Madise: My group design project
'Hubert Ovie Madise, what have you been up to the past ten weeks?' The Cranfield School of Water, Energy and Environment (SWEE) Group Design Project (GDP) module - that's what! The SWEE GDP module ...
The importance of big ideas: How small businesses can maximise their impact
Every year the Bettany Centre for Entrepreneurship hosts our annual entrepreneurship conference VentureDay. We are proud to have some small and medium enterprise (SME) owners on staff, including Heni Cloake and Gabriela Pearson, who share ...
How do I access the full-text of Harvard Business Review (HBR)?
This is one of the most frequently asked questions in the School of Management Library, presumably because HBR is such a key management journal and is renowned worldwide. The short answer is via EBSCO Business ...