Sample sheets and request tables can help when using Datastream Advance for Office.

Finding sample sheets for Datastream in Excel

Looking for curated, dynamic sets of data including Economic, Social and Corporate Governance (ESG)

Note: this post has been replaced, please go to:

How can I find sample sheets for Datastream in Excel such as ASSET4? - Library Help

Browse the list of sample sheets.

Sample sheets (or templates) can be used to download a curated set of data about one particular equity, economic indicator or sector at a time. They are found in the Excel ribbon under ‘Datastream > Request Table > Sample Sheets’. Scroll to sheet you want, tick it, then click ‘Download & Open’.

Where to find the hidden download folder with your chosen sample sheet.

Please note, the sample sheets download to a hidden folder (not very helpful!). This is C:\ProgramData\datastream\datastream advance\User\— type it in the Windows Explorer address bar.

The most commonly requested sample sheet is ASSET4 Environmental, Social and Corporate Governance Data.

Use the buttons, tick boxes and drop-down menus within a sample sheet to control it. Usually, a button labelled ‘Go’ or similar will update the other sheets.

Note, any data you download via a sample sheet can also be obtained via a regular Datastream request. If you find a particular datatype you want to use for different entities, make a note of its code.

There is further, more detailed guidance on using ASSET4 sample sheet on our blog.

Work at a larger scale or customise your retrieval with a Request Table

A request table with some helpful annotations.

If you want to plan a custom structured or larger scale download, use a Request Table. Details of how to use these are in the PDF User Guide (‘Datastream > Help > User Guide’) or the ASSET 4 training video. To view the ASSET 4 training video you will need to provide your name and University email address.