Finding a company’s market value on Datastream

Follow these steps to find the market value of a set of companies via the Datastream Excel Add-In.

  1. Open Excel and click on ‘Add-In’ and then on ‘Datastream AFO’. Select ‘Static Request’ from the menu that appears.
  2. Click on the Navigator button. Set ‘Data Category’ to ‘Equities’. Search for the company by name. Click on ‘Use Selected’.
  3. Type ‘MVC’ (‘Market Value for Company’) in the ‘Datatypes/Expressions’ field.
  4. Select ‘Latest Value’ from the drop-down list in ‘Date’ and click ‘Submit’.

This information is also available as a video tutorial.

Andrew Alexander

Andrew Alexander

Andrew is the Deputy Information & Library Services Manager at Cambridge Judge Business School

We are using cookies on our website

Are you happy to accept our analytics cookies, which help us learn about our website visitors and their use of this site? Learn how to disable all cookies.