Posts Tagged ‘Thomson One Banker’ has replaced Thomson ONE Banker

17 March 2015 Leave a comment

Example screen of

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, 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

Recently, we have received feedback from our users that keeping the both Thomson ONE Banker and 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 Please visit Getting Started Guides in the Library’s Business and Management Subject Guide pages.

Please note, requires Internet Explorer 9. If you are using IE 10 or later, you must use Compatibility View. See our earlier post Thomson Browser Compatibility for more details.


28 November 2013 4 comments

Thomson (or is Thomson Reuters replacement product for Thomson One Banker. It covers financial data on over 70,000 active and inactive public quoted companies globally – including key ratios, capital structure, latest deals, top holders and events. Thomson ReutersMarket awareness pages provide quick access to world indices, currencies and key exchange metrics like new highs and new lows, LIBOR, Benchmark bond yields and Treasury rates. Like Thomson One Banker, also provides access to deep content sets such as Ownership, Deals, Private Equity, plus Company Events.

For researching public (quoted) companies Thomson is one the best international company databases available to current staff and students at the University of Manchester. Other databases like Bloomberg or Thomson Reuters Datastream are only available on specific PCs in the library.

If you have used Thomson One Banker before, gives you an improved interface, additional market awareness and news, and convenient access to analysts’ reports that we previously accessed through Thomson Research. All the Business Research Plus tips for Thomson One Banker and Thomson Research will be relevant to Thomson

Thomson company overview (click to expand)

Thomson company overview (click to expand)

Thomson is only compatible with Internet Explorer versions 7, 8 and 9. In IE 10, set to compatibility mode IE 9. For all versions, allow IE to accept pop-ups. Unfortunately Thomson Reuters corporate clients are not pressing the company to make it available on more recent versions of IE. If you fail to allow pop-ups you will get returned to the home page and have to redo any searching you had started.

Researchers collecting data on large numbers of companies, or over a long time period, may prefer Thomson Reuters more research oriented database Datastream. Similarly, some researchers looking for deals (e.g. mergers and acquisitions) prefer SDC Platinum (also from Thomson Reuters). For a bit more detail see Researching Financial Markets … (June, 2012)

News and deals (Dell and Virgin media)

8 February 2013 1 comment

There were two stories on the BBC Business News recently that provided a reminder of how deals generate news because they result from companies’ strategic decisions.

TOB Deals example (click to expand)

TOB Deals example (click to expand)

Dell computers to be bought back by founder Michael Dell

This news story covers a company going from Public to Private, and therefore delisting from a stock exchange, the reverse of an IPO (Initial Public Offering).

This illustrates why databases like Thomson One Banker and Bloomberg Professional track deals from when they are rumoured or announced (not just when they become effective). In Dell’s case there has been significant news coverage about the company’s strategic options now that PCs are seen to be in decline.

[Update June 2014 – Thomson is (or is Thomson Reuters replacement product for Thomson One Banker.]

Liberty Global to buy Virgin Media for $23.3bn

This news story covers an acquisition. The surprise for me was that this is one US company taking over another. Although when I checked on Bloomberg Professional Virgin Media has 100% of its turnover in the UK, it has chosen to be a US company Virgin Media Inc, listed on the NASDAQ exchange.

Using the FAME database of UK companies you can check that Virgin Media Limited (registered no 02591237) is a subsidiary of Virgin Media Inc.

Bloomberg‘s Mergers & Acquistions (MA) function highlights the current largest deals – on 20 Feb 2013 these are HJ Heinz Co, Virgin Media Inc, and Dell Inc. Bloomberg Industries (BI) can be used to investigate industry trends including the expected impact of large deals, e.g. BI CATVE (Cable and Satellite Europe) has the Feb 05 news item “Liberty Fortifying in Europe May Boost Broadband, TV Competition” and a range of related industry data.

Related posts:

HP acquisition of Autonomy and a $8.8billion write off

9 January 2013 1 comment

On 20 Nov 2012 Hewlett Packard (HP) announced that it was taking a write off of $8.8 billion of the $11.1 billion that it paid to acquire Autonomy in  October 2010. At the time Automony was a member of the FTSE 100 and seen as a UK technology success story.

There has been lots in the UK financial press since then as HP’s key argument is that they overpaid for Autonomy because of accounting manipulation. This is strongly denied by Automony founder Mike Lynch.

News stories:

Breaking down a 8.8$ million write off – from Musings on Markets blog (click to expand)

Aswath Damodaran’s Musings on Markets blog makes a strong case that even if HP is right this only accounts for $2.45 billion of the $8.8 billion write off – see HP’s Deal from Hell: The mark-it-up and write-it-down two-step.

The write off raises issues about the acquisition in terms of corporate strategy, leadership, corporate governance as well as the accuracy of Autonomy’s accounts.

Resources for more information:

Thomson One Banker – a deals module search will provide details of the deal: announced 18 Aug 2011, effective 3 Oct 2011, “UK – Hewlett-Packard Vision BV of the Netherlands, a unit of by Hewlett-Packard Co (HP),  completed the tender offer to acquire the entire share capital of Autonomy Corp PLC (Autonomy), a
Cambridge-based developer of infrastructure and information management software, for GBP 25.5 (USD 42.09)” [SDC deal number 2337968040]

[Update June 2014 – Thomson is (or is Thomson Reuters replacement product for Thomson One Banker.]

Thomson Research – analysts reports – For example, on 23 Aug 2011 Marc Geall of Deutsche Bank published a report on Autonomy Corp plc. This reported a change of recommendation to sell, since the shares were GDP 24.86 almost fully valuing the HP offer, and substantially higher that Deutsche Bank’s fundamental target price of GBP 17.50.

Business Source Premier (EBSCO): – several trade journals with articles on the HP aquisition of Autonomy. For example, (2012) ‘With Autonomy, H-P Bought An Old-Fashioned Accounting Scandal. Here’s How It Worked’ Forbes.Com, (November 20, 2012):p. 39, Business Source Premier, EBSCOhost, viewed 11 January 2013.

See also those posts with the mergers_and_aquistions tag.

Thomson One Banker – Dissertation Research

29 October 2012 1 comment

Thomson ReutersThomson One Banker (Thomson Reuters) is a Specialist Financial Database.

[Update June 2014 – Thomson is (or is Thomson Reuters replacement product for Thomson One Banker.]

As part of Dissertation Research students often need to obtain large numbers of companies to analyse. This list of companies is then used in another database to do further research.

Thomson One Banker (Excel Add-In version) allows a large number of results from one database search to be imported into an Excel sheet using the ISIN (International Security Identification Number) company identifier code.

Copy and paste the list of ISINs into an Excel sheet and click on the ‘Upload Portfolio’ icon at the top left of the screen – hover the pointer over the icons on the screen to get a description of their function. Next, an ‘Upload Portfolio’ dialogue box appears – click on ‘Browse’ and type in a filename you wish to represent this list (portfolio) of companies and click ‘OK’ and ‘OK’ again at the next dialogue box. This Portfolio of companies is then available to use in a Report wizard search.

Select the ‘Report’ wizard icon at the top of the screen to begin a search.

Step 1   Select Items:   Click on ‘Add/Edit Items’ button to identify a Data item. There is a useful search box which allows Keyword searches…for example, ‘Price’ to get a list of results, including ‘PriceClose’. Double click on this item to select it and click ‘OK’.

Step 2  Select Entities:   Click on the ‘Add Entities’ and ‘Download’ buttons. Scroll down to locate the filename. Click on the filename to select it and click ‘OK’  to enter the companies into the ‘Selected’ pane and click ‘OK’ to insert into the ‘Selected Entities’ pane within Step 2 of the wizard search.

Step 3  Select Dates:   Start and end period and frequency (e.g. monthly), then click on the ‘Next’ button.

Step 4  Set Worksheet Options:   That is, set layout format of results in the sheet. It is only necessary to modify the default settings if you have many columns to ensure data is displayed in an effective manner.

Click  Finish and ‘No’ when requested to save your search. Results then appear in an Excel sheet.

Note:  If you get a ‘Thomson One Banker’ error message saying ‘Unable to retrieve Project Tracking information for the current user’, this means you have not logged in. Click on the padlock icon (top left) to do so.

Further tips – see Thomson One Banker Excel add-in (July 2010)

Company ownership data

28 August 2012 1 comment

There have been several recent articles in the financial press on the impact of the Qatari stake in Xstrata on the outcome of the proposed merger of Glencore and Xstrata.

Bloomberg ownership example

Top 3 current holders for Xstrata from Bloomberg (click to expand)

The main sources are: Bloomberg Professional, Thomson One Banker – ownership, Orbis, FAME (UK cos) and WRDS – Thomson Reuters (US cos).

While some shareholder information is publicly available, since large shareholders and directors have to declare dealings to the markets it is not easily available in a research-friendly format.

The commercial providers of ownership data tend to provide data for users who are interested in the current ownership of a single company or a small portfolio. They also collect data from as many sources as possible: large shareholders who have to report their holdings, institutional owners who report the largest holdings in their funds, and director dealings that can be large or small. (The exception if the Thomson Reuters database in WRDS (Wharton Research Data Services) – this is more research-friendly but only covers US companies.)

With ownership data researchers need to carefully check what is available and how easily it can be collected.

Researching Financial Markets – equities, indicies, …

28 June 2012 4 comments

A quick list of our five most-used financial market databases, which I hope will make a little clearer the strengths of each from a research perspective.

WRDS – WRDS (Wharton Research Data Services) is the premier research database for business school academics worldwide. It provides a Web-query interface that is designed by researchers for researchers. At the University of Manchester, our subscriptions include: Compustat (North America), CRSP (stocks, indices, treasuries), CRSP/Compustat Merged (CCM), IBES (US and International), Thomson Reuters US Ownership (mutual funds, institutional-13f, insiders). For a fuller list see – Which databases are available through WRDS? In summary, if you are researching the US financial market then WRDS is well worth a look.

Datastream – Datastream from Thomson Reuters covers financial markets world wide. It is the most used database for quantitative research on UK equities. Licence and software restrictions mean that it is only available on specific PCs. Datastream’s coverage includes equities, equity indices, constituent lists, interest rates, economics. It includes Worldscope for company accounts, and IBES summary data.

Thomson One Banker – Thomson One Banker, also from Thomson Reuters, is a database that is aimed at financial market professionals rather than researchers. Compared with Datastream there is significant overlap, including Worldscope and IBES summary data, but  it does not provide as much historical data, does not include most inactive (dead) companies, and does not cover interest rates and economics. However, it does have a Web-interface and this gives access to modules – Deals Analysis, Ownership and Private Equity – that are not part of Datastream.

[Update June 2014 – Thomson is (or is Thomson Reuters replacement product for Thomson One Banker.]

SDC Platinum – SDC Platinum, again from Thomson Reuters is a database that covers deals: mergers, acquisitions, IPOs (initial public offerings), secondary offerings. Thomson ReutersThere is significant overlap between SDC Platinum and the Deals Analysis module in Thomson One Banker, but researchers often prefer SDC Platuinum because it doe not have the same restrictions on downloading data. See SDC Platinum and TOB deals for more detail.

Bloomberg - World Equity Indices

Bloomberg – Bloomberg Professional, from Bloomberg, covers financial markets worldwide. It is also aimed at financial market professionals – providing lots of functions that give users an overview of the current state of the market. Like Datastream Bloomberg is only available on specific PCs. Bloomberg provides descriptive information, research and financial statistics on public companies worldwide; financial market information on currencies, commodities, bonds, indices, interest rates, derivatives; economic statistics; and over 3,000 business news stories per day. Bloomberg does not provide as much historical data as more research-oriented databases like WRDS and Datastream.

Professional development perspective

If you are interesting in getting a job in the city then your priorities are different from a researcher- you would probably choose to look at Bloomberg first, then Thomson One Banker, Datastream, WRDS and SDC Platinum.

Facebook IPO

Today is the Facebook IPO (Initial Public Offering) on the US NASDAQ exchange. Facebook has gone from being a private to a public company offering 421.23 Million shares at $38.00 each.

BloombergInformation available on Bloomberg includes:

  • FB US Equity – Bloomberg Ticker, US30303M1027 – ISIN, 30303M102 – CUSIP, B7TL820 US – SEDOL1, company identifiers from DES (Description)
  • GIP (Tick Price Chart) – intra day price chart (at time of writing high $45.00, low $38.00, and average $39.93)
  • SEC Form S-1 (Registration Statement) filed 1 Feb 2012 and other filings with the SEC (regulator) – Bloomberg function CF (Company Filings)
  • Analysts research (BRC) and estimates (EE)
  • and lots and lots of news on Facebook and its IPO

The Bloomberg IPO function shows that Facebook as by far the largest IPO this year.

If you want details of Mark Zuckerberg’s Facebook shares you need to look at the class-B shares – use Bloomberg’s MSH (Multiple Share Holdings) function.

Thomson ReutersThomson Research has 11 analysts reports on Facebook. (See Thompson Research Tips )

Thomson One Banker has details of the Facebook IPO in its deals module (see Deals information from Thomson One Banker ) and financials and financial market info in its company analysis module. [FB-O -TOB Ticker, C901820175- TOB key, 30303M102 – CUSIP, B7TL820 – SEDOL]

ValuationFor  informed comment on the valuation of Facebook see Facebook and “Field of Dreams”: Hoodies, Hubris and Hoopla from Aswath Damodaran’s Musings on Markets blog.

Executive pay

Executive pay has been much in the news recently. For example, Robert Peston’s blog post – Is it curtains for big executive pay (8 May 2012).

Public companies provide details of their director’s pay in their annual reports, but this is not available in all databases providing company accounts data. Two of our specialist databases that do include information on executive pay are Thomson One Banker and Bloomberg.

Using the Thomson One Banker web interface, select the Thomson Overview report in the Company Analysis module.

Thomson One Banker – executive information (click to expand)

Selecting the Key Executives link in the Thomson Overview Report will give a fuller list of executives with more detailed information.

Executives example (click to expand)

Select an individual to get more detail including compensation  (basic pay/salary, bonus, long-term incentives)

In Bloomberg the function MGMT will give you details of your selected companies management structure. Selecting one of the tabs (Executives, Board, Committees, Changes) and then selecting an individual will give their details including compensation (pay).

In Bloomberg you can also use the BIO function to search for an executive by name.

Overall Bloomberg has a better user interface for finding and browsing information about executives, but you do need to be at one of the Bloomberg PCs in the Eddie Davies Library or the Precinct Library.

Regulatory News Announcement from Carnival

At 07.00 AM on Mon 16th Jan 2012 Carnival Corporation and plc issued a “Required Announcement on Financial Impact of Costa Cordia“.

“At this time, our priority is the safety of our passengers and crew,” said
Micky Arison, Carnival Corporation & plc chairman and CEO. “We are deeply
saddened by this tragic event and our hearts go out to everyone affected by the
grounding of the Costa Concordia and especially to the families and loved ones
of those who lost their lives. They will remain in our thoughts and prayers,”

The announcement then provided information in accordance with financial disclosure regulations. The full text of the announcement is available on Bloomberg and several other business databases.

”]Carnival Price Graph 16 Jan 2010Bloomberg
If on Monday 16th you want to see how the market reacts to the Costa Concordia tragedy, then Bloomberg is the best database. It provides an integrated view covering the news and the Carnival share price (price down and an increase in trading volumes), and the news is the most read story of the day.

If you don’t have access to Bloomberg the announcement is also available on the business news database Factiva. Select Companies/Markets, lookup company Carnival Plc, and the select Press Releases from the news options. (You can also do a Factiva text search, but you either have to read through many results of spend some time constructing an effective search. Company = Carnival Plc AND Source = Publication: Wires AND Free Text = “announcement” worked for me.)

Thomson One Banker
Thomson One Banker has lots of financial market information but almost all numbers (at least in our subscription). However you can get the regulatory announcement so long as you know to lookup Carnival and  goto Recent News at the foot of the Thomson Overview Report- see screencast

PI Navigator
PI Navigator is the easiest database for going straight to the regulatory annoncement. You just lookup Carnival Plc and search. However, because PI Navigator only covers the regulatory news and regulatory filings of companies, you have to use another database for additional news or financial market information.

Previous post on business news: How Business News can enhance your Research