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…
How do I reference journal articles… in the NLM style?
References for journal articles are one of the most used reference types for postgraduate research as these sources are frequently used in assignments. In the NLM Numbered Referencing Guide they are listed under periodicals. Periodicals ...
Royal Air Force Officer Kathy: Why I chose to study Safety and Human Factors in Aviation MSc
Growing up in Southampton with her father, an Air Cadet Instructor, Kathy had an interest in aviation from an early age and was committed to join the Royal Air Force from the age of ...
My journey since completing my Counterterrorism MSc
Richard Robinson, a Chevening Scholar, completed his course in Counterterrorism MSc in the Summer of 2023. After traveling to Cranfield from Montego Bay, Jamaica, Richard was the Head of School for the Caribbean Special ...
Net zero in asset management: The concept and the challenge
The concept of net zero has emerged as a key solution in addressing the pressing global challenges of climate change and environmental sustainability. Industries across various sectors increasingly recognise the need to reduce their ...
My career after doing a Design Thinking MSc
Hello, my name is Chioma Ezeanaka and I am currently working as a Technical Liaison Officer at CHAP. The Design Thinking MDes programme was a positively transformative experience for me, and in hindsight, I ...
Use academic libraries across the UK for free!
If you are studying or working away from our two University sites, you may find it more convenient to use a library service nearer to you. The SCONUL Access scheme gives all our staff and students free ...