Open the LSEG Workspace Excel Add-in. (It requires Microsoft Excel for Windows.)
Click on the Workspace tab and Sign In with your LSEG user ID and password if you have one (Professors and RA) or ask the Library staff for password (students and staff).
Make sure you are connected (online).
Use the tools on the “Datastream” menu.
The Datastream Formula button (in Excel) offers a good starting starting point for generating data extracts. Here you can search for Static or Historical Time Series data.
Time Series Request
The Time Series request function allows you to collect historical data over a period, for example, the daily share price for Apple from 1st January 1990 to 31st December 2010.
To find data using the Time Series Request, click on the Series Editor to open the Find Series dialogue box.
Click on the Find Series and search for a company, index, or economic variable (e.g. AAPL, FTSE100, or GDP data)
When you are done, click OK to add your selection to the series list.
Next use the Datatype Editor to select your datatypes (variables) and click OK to add. (e.g. price, return, market value)
Set Date range
For historical data enter the number of years, for example if 2 or 5 years historical data is required, enter -2Y or -5Y in the From field.
Data Frequency
Select the appropriate Frequency. Depending on the variable, the frequency can be daily, weekly, monthly, quarterly or yearly.
Options
In the options field the Display Row and Column Titles are pre-selected. Check in the boxes to select the other options such as transpose data.
Click on Insert at the bottom right of the screen to begin the download.
Static Request
The Static Request function can be used to request data for a specific date, e.g. search for the share price, dividend yield and market value for Amazon on Monday 1st February 2010.
To use the Static Request, from the Datatypes/Expression, click on the pull down and select As of. You can then use the series and datatype editors to select your entities and variables.
