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 us.
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…
Systematic Literature Review – combining your search strings
Our previous posts on the systematic review have looked at: Systematic Literature Review – Where do I begin? Systematic Literature Review – Selecting your Sources Systematic Literature Review - Identifying your search terms and constructing ...
Academic writing and being critical
Academic writing is daunting. Capturing all your thoughts and analysis and putting them down onto paper in some sort of understandable fashion is a challenge. Did you know we have resources in our Cranfield Study ...
Bank holiday hours for Library Services: Monday 6 May
Library Services staff will be taking a break on Monday 6 May for the early May bank holiday. You will still be able to access all the resources and help you need via our library ...
Cranfield’s Manufacturing and Materials Students’ Showcase Innovation at Project Day
On 26 April, Cranfield University buzzed with excitement as students from across our Manufacturing and Materials MSc programmes presented their group projects at the annual Group Project Presentation Day. This annual event presents ...
Come to a virtual study session in May
What are virtual study sessions? These are online study sessions facilitated by Library staff, where you can study independently alongside other students via Teams. They are a great way for you to dedicate specific time ...
Getting started on your School of Management thesis
Writing a thesis, business plan, internship project or company project can be a daunting task, and you might have some uncertainty or questions around how to get started. This post will share some ideas and ...