Welcome to Business Research Plus

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

A quick look at local and world market indices in Datastream

6 October 2015 Leave a comment

With a wealth of information and functions available, it is easy to miss a few potentially useful commands in Thomson Reuters Datastream. Here are some examples relating to local equity indices and global ones. (This post assumes you are familiar with the basics of Datastream; please see the getting started guides or other posts for more.)

Local market index (LI and INDXL)

Datastream Local Market Index

Some examples of using the datatypes LI and INDXL.

Given a list of companies (equities), it is possible to get time series data for the index which each company is listed on locally, specifically the price index (PI). The data type Local Market Index (LI) (green box in the image above) acts as a short cut to the following process for the equities Tesco PLC (TSCO) and Apple Inc (@AAPL).

  • Identify the entity’s local index through the static datatype Assoc Market Index – Local (INDXL) (see the orange box in the image above).
  • For each index, select the Price Index (PI) for the date range required (see the blue box above).

Care should be taken with using the datatype Assoc Market Index – Local; see this excellent summary on the EDSC blog.

World Market Index (TOTMKWD and others)

On a related but different note, it is possible to use many international and global equity indices that have been constructed in Datastream. One such index is the top level World-Datastream Market (TOTMKWD), covering over 6,000 active constituent entities.

World-Datastream Market in the Navigator

“World-Datastream Market” in the Navigator

There is a systematic set of codes for various countries, blocs and combinations, for all or selected sectors. They are also findable in the Navigator (see image above) and usable as any other Equity Index. The first five characters represent the sector, the last two digits represent part of the world, so you could use combinations such as the following.

  • For the World market index at level 1 use: TOTMKWD
  • For the French financials industry index at level 2 use: FINANFR
  • For the Europe banks sector at level 6 use: BANKSER

For full details, go to the Datastream Extranet (via the Datastream Desktop application) and search for “Global Equity Indices User Guide”.

Using business databases with Microsoft Edge on Windows 10

31 July 2015 1 comment
Windows 10 desktop showing two browsers

Microsoft Edge is the new, default browser in Windows 10 (top) but Internet Explorer 11 is still available (bottom).

The newly released Windows 10 is a currently a free upgrade from Windows 7 and Windows 8.x. It claims to “transform the way you work and play” amongst other things. It also marks the launch of a new web browser Microsoft Edge, replacing the 20-year old Internet Explorer (IE). Edge is a great move forward for web developers and hopefully will be preferred by end users but, as always, change comes at a cost; the many legacy web-based platforms that were built for IE 6 or later may not work. Fortunately, IE 11 is still available for the sake of compatibility, but is using Windows 10 and multiple web browsers a smooth ride?

How compatible are our business databases with Windows 10?

Some of the specialist financial and business databases that The University of Manchester subscribes to have been tested below.

Search Windows 10

The desktop search in Windows 10 looks for applications, files, on the web and more.

Not compatible with Microsoft Edge:

ThomsonONE.com and Thomson Research

These two reputable products are widely used but they are built on old technology (old by web development standards). They were already limited to work on Internet Explorer only in Windows XP, Vista, 7, 8 and 8.1.

ThomsonONE.com shows a blank screen if loaded in Microsoft Edge.

Thomson Research will load but some of the dialog windows do not work in Microsoft Edge.

Solution: Click in the new Search box next to the Start button (bottom left of the screen), type “Internet Explorer” and open the old browser. From here, go to the Library website and find ThomsonONE.com in the usual way. (Note, if you try the option to “Open with Internet Explorer” from within Edge may not work for this website.)

Compatible with Microsoft Edge:

So far, I have found that all out other web-based specialist databases are compatible with Microsoft Edge.

Please comment below this post if you find otherwise! I will update this post as necessary.


A later post on Business Research Plus will explore databases that use Microsoft Office 2016 and Windows 10.

Where can I find a company’s date of incorporation or year founded?

For UK companies

In Fame, the date of incorporation in the Company report, under the Legal & accounts information section.

For US companies

Use Field-Ritter Dataset of Company Founding Dates (Firms going public in the US 1975-2014, last updated 14 April 2014)

For companies in any country

In Datastream, Use a Static Request and the Worldscope datatypes:

  • WC18272 – Date Company Founded
  • WC18273 – Date of Incorporation

Finding working papers

There are many relevant sources for working papers, including:

Getting data on all UK companies except one sector in Datastream

17 July 2015 Leave a comment

A common request in Thomson Reuters Datastream is to get all the companies in a particular country except for a few sectors. Previously, the Criteria Search function provided an easy way to this. Since Criteria Search is being phased out (it is not compatible with Internet Explorer 11), we have been looking at alternative approaches to some of these data requests. This example shows you one.

New request table

Launch Excel with the Datastream tab and click the New Request Table button. (Request tables are covered in other posts.)

Datastream Request table for all UK companies

Datastream request table of a time series request for a list with Custom Header containing static datatypes.

In this example, I have chosen the list WSCOPEUK which is a contituent list of all active, dead and delisted UK companies (over 5,000 in size). You may wish to try this approach out with something smaller first, such as LFTSE100 for the constituents of the FTSE 100 index.

The Request Type is TSL (time series for a list) and the Datatype is WC04225 (Extraordinary Items), from 01/01/2013 to 01/01/2015. The trick here is to choose Transpose and to include a custom header of the static datatype INDM4, which is the Level 4 Industry Name, with DS Code and Name as optional extras (so Format is HRCTF:INDM4,DSCD,NAME).

Custom headers were introduced in a previous post. Again, try this out with a small date range before you are happy with the output format.

Insert Excel table

Select the output results worksheet Sheet1.

Datastream output filtered in an Excel table

The results of a Datastream request after applying an Excel table, showing blanks and errors for lines where no data was present in the selected time period.

Assuming you used Transpose in the Datastream request, there will be a row containing the headers such as Name, Industry Level 4 Name, DS Code and each date period (2013, 2014 and 2015 in this case). You can filter out certain rows by selecting the data from this row to the last row with content and choosing Insert > Table from the Excel menu (and tick “My table has headers”). Here, I selected cells A4 to G5331.

A filter icon appears at the top-right of every column. Click it in the industry column and untick the industry you wish to exclude (e.g. Financial Services(4)). Assuming you have the DS Code variable, you can now select cells from that column to create a new list and continue your research.


Datastream has a Worldscope constituent list for companies (equities) in most countries except the United States (which would be too large a list to use). These can be found in the Datastream Navigator by typing WSCOPE in the simple search box. A different industry classification may be required for some countries.

Insider trading

16 July 2015 Leave a comment

Definition of Insider Trading (from Investopedia):

The buying or selling of a security by someone who has access to material, nonpublic information about the security.

Companies in any country

Use ThomsonONE.com

  • Search for the company you want.
  • Click on the Company Analysis > Ownership folder, and select Insider Holdings or Insider Transactions report.
  • Click “Click here for full history” for historic holdings (older than 24 months).

Use Capital IQ

  • Search for the company you want.
  • On the long menu down the left, choose Investors > Public Ownership, then the Insider Trading tab.
  • Only the last 12 months are available.

Use Bloomberg (available in the Finance Zone and Precinct Library)

  • Try Bloomberg function PHDC for a specific company (e.g. VOD LN <F8> PHDC <GO>) and select Insiders, sorted by size.
  • You can also look up the biographies of executies/directors (BIO) and then choose Reported Holdings.
  • For stocks that have experienced the most purchases and sales by insiders, type: INSD and hit Go. Use the fields at the top of the screen to select country, time period, type of transaction. Click on a stock to display a graph of its historical prices with date of insider transactions.
  • For more info, type: insider and hit the green Help key <F1>.

Companies in the U.S. only


  • Choose Thomson Reuters database, and then Insiders Data. Search by company ticker. Check the variables you want in your report.


  • Insider filings with the U.S. SEC are available through Edgar. Enter your company name or ticker symbol or CIK and Include Ownership forms.
  • Insider transactions are available by issuer and reporting owner. Take a look at the website SecForm4.Com

Current and historical company annual reports

Company websites

For current annual reports, a company’s website is often the quickest and easiest option.

Databases that The University of Manchester subscribes to:

  • PI Navigator: Include Annuals / 10K / 20-F (Company Reports and Accounts) in search criteria or select Perfect Filings tab and include Document Type UK Annual Reports or similar depending on your search.
  • Mergent Archives: Select Search Mergent Achives for annual report search
  • Thomson Research: Quick Company Search: and Content Profile, Filings
  • Thomson ONE.com: Annual reports are under Filings tab

Annual reports websites

Try EDGAR for reports filed with US SEC.


Get every new post delivered to your Inbox.

Join 1,136 other followers