Using Datastream to find the dates when a company started or ceased trading
01/09/2015

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… YouTube, TikTok and other audio-visual material in the APA7 style?
Have you ever wondered how to include a reference to audio-visual material such as a video posted on YouTube or TikTok? If you have, you're in the right place! Referencing audio-visual material is as straightforward ...
My life at Cranfield University
My experience here at Cranfield University has been awesome! I have always wanted to study at the prestigious Cranfield University, so this year has truly been a dream come true for me. I ...
How Cranfield is creating solutions for a greener future
Cranfield University is putting immense effort into creating solutions for a greener future by giving more attention to research in areas such as hydrogen generation. Collaborating on this research with key players in industry ...
Bloomberg basics
Accessible in SOM Library from 12 dedicated terminals, Bloomberg provides access to the real world of finance through the same platform as used by the world’s leading banks, corporations and government agencies. Bloomberg provides real-time ...
Finding your reading materials
You can find all the resources you need to support your work from our library website. Using Library Search The first place to start is Library Search. This is the search box on the homepage. ...
Breaking New Ground: Organising Cranfield’s first Hult Prize OnCampus Programme
The Hult Prize is a year-long global competition challenging young people to solve the world’s most pressing issues by creating innovative social ventures. This year, the challenge was to create a for-profit social venture in ...