Welcome to Business Research Plus

July 27, 2011 1 comment

Business Research Plus header 2015

From specialist databases to business literature, Business Research Plus provides advice and tips based on the MBS library service resources and expertise.  See our About page for more details.

  • 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 

(MBS Library Service is part of The University of Manchester Library. )

Writing multiple requests to a single sheet with Datastream Request Table

June 25, 2015 Leave a comment

Thomson Reuters logoOnce 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.

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
AA. 20/06/2014 23/06/2014  Sheet1!$A$1
SAGA 22/05/2014 26/05/2014  Sheet2!$A$1
SSPG 09/07/2014 12/07/2014  Sheet3!$A$1
PETS 11/03/2014 15/03/2014  Sheet4!$A$1
TSB 19/06/2014 23/06/2014  Sheet5!$A$1

The Data Destination field will fill in automatically if left blank. Running this request table will look like this:

Request table default destinations

Using a Datastream Request Table and leaving the Data Destination fields blank will the results of each line into a separate new sheet.

Custom destination

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.

  1. Create a new sheet, re-name it “All”.
  2. For the first line, edit the Data Destination to “All!$A$1″.
  3. For the second line, edit the Data Destination to “All!$A$3″ — gives two lines for the previous response (since 1+2=3).
  4. 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.
  5. Now the destination row numbers are 1, 3, 5, 7, 9, run the table again.
Request table custom destinations

Using Excel to auto-fill a sequence, cell references in the same sheet can be given as a destination for each request line. This assumes the same number of rows/columns are used for each request line.

Series Lookup Start Date End Date Data Destination
AA. 20/06/2014 23/06/2014  All!$A$1
SAGA 22/05/2014 26/05/2014  All!$A$3
SSPG 09/07/2014 12/07/2014  All!$A$5
PETS 11/03/2014 15/03/2014  All!$A$7
TSB 19/06/2014 23/06/2014  All!$A$9

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.
Categories: Business Databases Tags:

Combine a static request into a time series request in Datastream

June 8, 2015 Leave a comment

Thomson Reuters logoOne 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).

Datastream combined request 01What 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.

Datastream combined request 02

Steps 1 and 2: start a time series request with custom header.

Datastream combined request 03

Steps 3 and 4: select static datatypes for the custom header.

  1. 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).
  2. In the Options panel, choose the option “Display Headings” and “Display Custom Header” then click the “Edit” button next to the latter.
  3. 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.
  4. Remember to click the plus “+” button to add this selection of static datatypes to the “Selector” box. Click “OK”, then click “Submit”.
  5. The results should look like this (below).
Datastream combined request 04

A time series Datastream request with a custom header including static datatypes.

What to do if the “Datatypes” button is disabled in Datastream

May 22, 2015 Leave a comment

Datastream Desktop top

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).

Datastream request typeReason 1: Static request or report

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 Datastream Navigator button in static request.

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.

  1. Tick the “Expert” tick box
  2. Untick the “Expert” tick box
  3. Now you can untick the “No datatype” box

The new and improved Bloomberg keyboard has landed

May 18, 2015 Leave a comment
Bloomberg keyboard 4 UK

Bloomberg keyboard model 4 “Starboard” (UK layout)

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.

See also: Bloomberg Professional documentation website

FAQ closing; content migrating to this blog

Manchester Business Answers 24/7 screenshotAvid 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.

Changes to MBS Library facilities

March 19, 2015 1 comment
Illustration of new MBS Library

Illustration of new MBS Library

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
    • 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 libdesk@mbs.ac.uk or telephone 0161 306 3200.

MBS and University Library Twitter followers can also track key updates using the hashtag #MBSchanges.

ThomsonONE.com has replaced Thomson ONE Banker

March 17, 2015 Leave a comment

Example screen of ThomsonONE.com

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.

Thomson ONE Guide

A short hand-out guide is available for those new to ThomsonONE.com. Please visit Getting Started Guides in the Library’s Business and Management Subject Guide pages.

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.


Get every new post delivered to your Inbox.

Join 1,114 other followers