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…
Tell us what you think of Library Services!
We want our students to have a great experience during their time at Cranfield. Each month, the University runs a short “Topic of the month” survey to focus on one service or facility and find ...
Air Transport Management alumni stories: SangHo (Henry) Han, Strategic Planning Manager in South Korea
SangHo (Henry) Han is a strategic planning manager at Air Premia in South Korea. He graduated from Cranfield University with an MSc in Air Transport Management in 2018. Here, Henry talks about his passion for ...
Life on campus and studying an Advanced Water Management MSc at Cranfield
After a year of working in the water, sanitation, and hygiene sector, I started to look for opportunities to further my knowledge about water resources. Researching water organisations on LinkedIn led me to find ...
Sign up to our ‘Making your research open access’ webinar – 9 February
Do you know your green from your gold? What are publisher deals, and how can they help you? My paper acknowledges UKRI funding, do I need to do anything special? What does an author accepted ...
How the Executive Logistics and Supply Chain Management MSc improved my career outlook
Hear from Harrison Jnr Ilodiwe, Executive Logistics and Supply Chain Management MSc, on his student experience at Cranfield. Why did you choose to study the Executive Logistics and Supply Chain Management MSc at Cranfield ...
Engineering problem to solve? Let Knovel help you find a solution
Did you know that Knovel provides you with more than just eBooks? Knovel is a key database for many engineering, mechanical and materials courses here at Cranfield University, and contains content from an extensive range ...