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
Andrew Alexander

Latest posts by Andrew Alexander (see all)