Follow these steps to find the market value of a set of companies via the Datastream Excel Add-In.
- Open Excel and click on ‘Add-In’ and then on ‘Datastream AFO’. Select ‘Static Request’ from the menu that appears.
- Click on the Navigator button. Set ‘Data Category’ to ‘Equities’. Search for the company by name. Click on ‘Use Selected’.
- Type ‘MVC’ (‘Market Value for Company’) in the ‘Datatypes/Expressions’ field.
- Select ‘Latest Value’ from the drop-down list in ‘Date’ and click ‘Submit’.
This information is also available as a video tutorial.
Information & Library Services
Latest posts by Information & Library Services (see all)
- Interview? Let’s make sure you stand out from the crowd - 3 June 2024
- Same but different - 29 April 2020
- Bloomberg Breakfasts – a great way to start your day! - 21 October 2019