- Library Research Plus provides expert insight from The University of Manchester Library’s Research Services for researchers in all disciplines including business.
- My Learning Essentials, the Library’s award-winning skills progamme includes online resources with a wealth of useful tips on searching, referencing, writing to support personal and professional development.
Exploring our resources – try the Business and Management Resources page (Subject Guides), scroll down to category or tag cloud in the right-hand column or search this blog (top right). For latest news see @MBSLibrary Follow @MBSLibrary
Once you have understood the basics of the Datastream Request Table for performing bulk financial or economic data enquiries, a common question is raised about the output. By default, each line in the request table will write to a separate, new sheet in the current workbook. The field labelled “Data Destination” allows one to set the first cell of the results explicitly, for example “Sheet1!$A$1″ for Sheet 1, Cell A1. If this field is blank, the next new sheet is created, in the series Sheet1, Sheet2, Sheet3… always in the top-left cell A1. This is the default destination.
Sometimes we want to put all of the results into the same destination sheet. For example, if looking up the share price on the date and days prior to a company’s initial public offering, for a list of companies. The start and end date will be different for each company, so, if using the default destinations, a request table will contain something like:
Each row: Update: Y, Request Type: TS, Format: RCT, Datatype: UP, Freq: Daily.
|Series Lookup||Start Date||End Date||Data Destination|
The Data Destination field will fill in automatically if left blank. Running this request table will look like this:
The key to making the request table write all the output to the same sheet is to know how many rows or columns to leave. If this is the same for every line, you can use Excel short cuts to save typing in each destination by hand. In this example, each request takes two rows, so the sequence should be something like this.
- Create a new sheet, re-name it “All”.
- For the first line, edit the Data Destination to “All!$A$1″.
- For the second line, edit the Data Destination to “All!$A$3″ — gives two lines for the previous response (since 1+2=3).
- Select both of the two edited cells. When the mouse cursor is at the bottom-right and turns into a black plus symbol (+), drag down to copy the sequence values.
- Now the destination row numbers are 1, 3, 5, 7, 9, run the table again.
|Series Lookup||Start Date||End Date||Data Destination|
Related Excel tips
- Cell references to different sheets in the same workbook have the format “SheetName ExclamationMark CellReference” (without spaces).
- Dollar signs in cell references mean that the reference is “locked”, i.e. it will not change if you copy and paste the contents of that cell to another location.
One of the fundamental concepts of Thomson Reuters Datastream is the distinction of two classes of datatypes (variables), namely static and time series. Their requests (searches) are performed separately and in different ways. This blog post summarises the difference and shows how to combine them in a single request. It assumes you are familiar with the basic Datastream request concept of selecting an entity, a datatype and date period. It uses the Datastream Advance for Office Excel add-in (DAO); the principle equally applies to the newer 64-bit Datastream for Office add-in (DFO).
What are static and time series requests?
- A time series request looks at datatypes which change with regular frequency (daily to yearly) and includes a specified date range and frequency. Examples of time series datatypes include share price, market value, GDP and turnover.
- A static request looks a datatypes which seldom or never change, with often just the latest value available. Examples of static datatypes include company name, base date, currency of a stock and country of origin.
There is a separate command in Datastream to request each of these classes of datatypes. If you want to get some of both for a list of entities or companies, you could perform two separate requests and carefully line up the results of both in Excel. There is an easier way, however.
How do I add static data into a time series request?
You can include static datatypes in the header of a time series request. Follow these steps to get the monthly price and market value for the last two years for Tesco, Sainsbury and Morrison supermarkets along with their ISIN codes and price currency.
- Start a new Time Series Request as usual. Select the entities (e.g. TSCO, SBRY, MORW) and time series datatypes (e.g. P, MV) as usual, but do not click “Submit” yet. Set the date period and frequency (e.g. -2y and monthly).
- In the Options panel, choose the option “Display Headings” and “Display Custom Header” then click the “Edit” button next to the latter.
- In the new dialog window, click the “Datatypes” button. Use the Datastream Navigator to restrict the search to just Static datatypes (you may need to “Stop Filtering” a previous search), then search as usual and tick the variables you wish to use (e.g. ISIN, PCUR). Click the blue “Use” link when finished.
- Remember to click the plus “+” button to add this selection of static datatypes to the “Selector” box. Click “OK”, then click “Submit”.
- The results should look like this (below).
When using Datastream, what do you do if the “Datatypes” button is disabled, or the “No datatype” box is greyed out? There are two common reasons why this happens, with easy but unexpected resolutions.
This only applies to Datastream Desktop, (we use version 5.1).
You may have chosen to perform a static request, under the option “Analysis, Single Series – Data, Static Data”. In this case, the datatype is selected under the blue “Settings” button (above the “Run Now!” button). From here, you can select up to nine datatypes using the “Datastream Navigator” button .
If you have chosen a report, such as “Analysis, Overview of Company Performance”, no datatype selection is available.
Reason 2: Time series request button bug
If you have chosen to perform a time series request, under the option “Analysis, Single Series – Data, Time Series Data”, the “Datatypes” button should be clickable. Next to it is a “No Datatype” tick box which will enable and disable the “Datatypes” button.
Occasionally, this tick box gets stuck. You can fix it by doing the following.
- Tick the “Expert” tick box
- Untick the “Expert” tick box
- Now you can untick the “No datatype” box
The keyboards in the Bloomberg Suite at The University of Manchester Library have been upgraded.
The new keyboards, called “Starboard” by Bloomberg, are lighter and quieter to use, with the full-size layout of numeric keypad, cursor keys and bank of keys above the numeric pad.
The extra row of keys across the top are mostly the same, as are the colours. The main differences that may affect you are as follows.
- The F1 function is now “Help” instead of “Law”. Previously, the Help key was just above the F1 key.
- The “End/Back” key is now better labelled; previously, it was labelled “End/Menu” and users often did not know that pressing it was the easiest way to go back one screen.
- There is a built-in microphone as well as speakers, and the headphone socket on the rear also accepts the single plug headphones and microphone layout common to mobile phone earphones (including the iPhone remote). We request users consider others in the room when using these features.
- The volume keys are on the top-right above the numeric pad. The microphone on/off key lights up when the microphone is active.
Let us know if you have any comments about these new keyboards. I hope you enjoy using them.
Avid users of University of Manchester Library resources relating to business data will be familiar with Manchester Business Answers 24/7. This is the database of Frequently Asked Questions that The University of Manchester shares with many other universities around the world.
Manchester Business Answers 24/7 will be closing on 30 June 2015, but rest assured that the content you value from the database will not be lost. Over the summer, we will be migrating content from Manchester Business Answers 24/7 to this blog. Those of you who are blog subscribers may see a temporary increase in new posts in your inbox.
If you have questions or concerns, please contact us via a comment on this post.
The next phase of the University’s £1 billion campus redevelopment, which will transform over 20,000 square metres of teaching and learning facilities in MBS, is about to begin. To support the development, important changes to MBS library facilities are announced.
Between Monday 9 March and Monday 13 April, Eddie Davies Library, located in Devonshire House, will be vacated and its facilities will transfer across two sites. All printed resources will transfer to the lower floor of Precinct Library.
Specialist resources, including the Finance Zone and Bloomberg Suite, will transfer to a new facility at Dover Street, which will open on Monday 13 April.
Eddie Davies Library will close to all library users on Friday 20 March.
Library facilities will remain operational during the transition period, but users will experience some temporary disruption to stock access and services. Here is a summary of the key dates, activities and impact for users:
- Week commencing Monday 16 March
- Remaining book stock to relocate from Eddie Davies Library to Precinct Library.
- Eddie Davies Library to close to all library users on Friday 20 March
- Finance Zone and Bloomberg Suite access to relocate to Precinct Library from Saturday 21 March (until Sunday 12 April).
- Week commencing Monday 6 April
- Usual lending and stock access to resume at Precinct Library from Tuesday 7 April.
- Week commencing Monday 13 April
- New Dover Street facility to open to library users on Monday 13 April.
- Access to Finance Zone and Bloomberg Suite available at Dover Street.
During this phased program of activity, partial closures and contingency measures, including a retrieval service for borrowing books, will be in place at Precinct Library from Monday 9 March.
There will be also be reduced access to Finance Zone and Bloomberg Suite resources at Precinct Library, until Dover Street opens on Monday 13 April.
Precinct Library will remain operational during the transition period, but it is expected to be busier than usual and less study space will be available.
Students requiring study space are encouraged to consider other library sites across the campus, most notably Joule and Kantorowich libraries. Students should also consider accessing online resources whenever possible.
For enquiries about library services and facilities during the transition period, please speak to a member of library staff at Precinct or Eddie Davies, email firstname.lastname@example.org or telephone 0161 306 3200.
MBS and University Library Twitter followers can also track key updates using the hashtag #MBSchanges.
As you may or may not be aware, Thomson ONE Banker (the service platform for company data) is no longer supported by Thomson Reuters. We have been running Thomson Reuters’ new service platform ThomsonONE.com, in parallel with Thomson ONE Banker, for over a year now. This is a necessary transition arrangement as staff and students require training and adjustment in the new ThomsonONE.com.
Recently, we have received feedback from our users that keeping the both Thomson ONE Banker and ThomsonONE.com in the Library’s Database list is rather confusing. We have reviewed Thomson ONE Banker again and have found the platform tired looking and slow performing. With advice from academic staff in Manchester Business School, we have therefore decided to withdraw Thomson ONE Banker from the Library’s Database list from 1 May, 2015.
Please note, ThomsonONE.com requires Internet Explorer 9. If you are using IE 10 or later, you must use Compatibility View. See our earlier post Thomson ONE.com Browser Compatibility for more details.