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.