Retrieving a company’s share price on Datastream – CJBS Information and Library Services Blog

Datastream provides access to an extensive historical archive of international company and economic data, which can be exported to Excel.

To retrieve a time series of a company’s share price:

Open Excel, click on ‘Add-ins’, ‘Datastream-AFO’ and then on ‘Time Series Request’. Click on the Navigator button
Click on ‘Set Criteria’ and search by company name, e.g. ‘Marks & Spencer’. Click on ‘Search’. Click on the appropriate company from the results list. ‘MKS’ appears in the search window.
Click on the ‘Datatype Picker’ button Type in ‘price’ in the ‘Find’ box at the top of the screen and click on ‘Filter/Search’. Choose ‘P’ Price (Adjusted Default).
Modify the frequency (i.e. daily, monthly, quarterly, yearly) plus the start and end dates as appropriate. Click on ‘Submit’.

This information is also available as a video tutorial.