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…
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 ...