Using the Datastream List Wizard
19/10/2016
Datastream offers many pre-defined constituent lists for market indices, allowing you to extract data such as share price, market value, etc. for a number of companies at the same time. In a previous post, on Creating and Using Datastream Constituent Lists, we outlined one way you can create your own bespoke list of companies.
Here we introduce you to the List Wizard, a useful tool within Datastream, allowing you to create a new list from scratch, or edit existing lists that you have created previously.
To get started, select ‘List Wizard’ from the Datastream AFO Menu in Excel.
In the List Wizard dialogue box, select the option to either ‘Create a new list’ from scratch, or ‘Edit an existing list’. You can also choose to download a pre-defined constituent list from Datastream here. When ready, click on Next.
If you have chosen to create a new list, the ‘Find Series’ button allows you to look up individual companies and create your own defined list. Alternatively, it’s here you can add/delete companies from an existing list.
Clicking on the ‘Find Series’ button opens up the ‘Datastream Navigator’ where you can select your companies.
Once you have added your companies, make sure to give your list a name in the ‘List Description’ box, and then click on Next. On the next screen, ensure you give the ‘List File’ a name you will remember (it must end in .LLT), and click on Finish.
Next time you run your Time Series or Static Request, you’ll be able to find your list of companies by clicking on ‘List Picker’ button.
As always, if you have any questions about using Datastream, please contact MIRC.
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…
Working on your internship report
Instead of producing a traditional thesis, as covered in our earlier post, some students in the School of Management - and perhaps some in other Cranfield Schools too - will embark upon on an internship ...
Embracing a Marketing and Leadership MSc Apprenticeship.
A Q&A with Faizah Azeem. Why did you decide to undertake a postgraduate apprenticeship in Marketing and Leadership? Cranfield delivers a unique programme that sits well with professionals wanting to develop themselves into expert ...
What is ‘Digital Forensic Science’?
Despite being a fundamental tool for many organisations and criminal justice systems around the world, arguably digital forensic science as a discipline does not always get the recognition it deserves in media broadcasts. Therefore, public ...
Pandemic PhD to prospects PhD
Hello, my name is Danni and I’m a third-year PhD student in the School of Water, Energy, and Environment specifically within the Soil, Agrifood and Biosciences department. My PhD focuses on how biostimulants (seaweeds, ...
Connected and Autonomous Vehicle Engineering (Automotive) MSc alumnus Sohan Pookolayil Varghese on Cranfield, his career path, and why the automotive industry is such an exciting place to be
Sohan Pookolayil Varghese completed the Connected and Autonomous Vehicle Engineering (Automotive) MSc in 2022. Here, he talks about his lifelong love of cars, why he chose Cranfield, and his career at Jaguar Land Rover where ...
Design as a Tool for Change
Design as a Tool for Change: Exploring Circular Economy and Sustainability through a visit to the Design Museum Design has become increasingly important in creating sustainable solutions for a better future. At the forefront ...