Discover our blogs

Aerospace | Cranfield University

Aerospace

Agrifood | Cranfield University

Agrifood

Alumni | Cranfield University

Alumni

Careers | Cranfield University

Careers

Careers | Cranfield University

Defence and Security

Design | Cranfield University

Design

Energy and Power | Cranfield University

Energy and Power

Environment | Cranfield University

Environment

Forensics | Cranfield University

Forensics

Libraries | Cranfield University

Libraries

Libraries | Cranfield University

Manufacturing

Libraries | Cranfield University

School of Management

Libraries | Cranfield University

Transport Systems

Water | Cranfield University

Water

Homepage / Using the Datastream List Wizard

Using the Datastream List Wizard

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.

List wizard0

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.

List wizard box

List wizard3

 

 

 

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.

List wizard2

 

 

 

 

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.

List picker

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/

Written by: Tracey Nunn

Written By: Tom Jaycocks

Categories & Tags:

Leave a comment on this post:

Sign up for more information about studying master’s and research degrees at Cranfield

Sign up now
Go to Top