Archive

Posts Tagged ‘Thomson One Banker’

ThomsonONE.com has replaced Thomson ONE Banker

17 March 2015 Leave a comment
T1com-Amazon

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.

Thomson ONE.com

28 November 2013 4 comments

Thomson ONE.com (or T1.com) 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, T1.com also provides access to deep content sets such as Ownership, Deals, Private Equity, plus Company Events.

For researching public (quoted) companies Thomson ONE.com 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, T1.com 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 ONE.com.

Thomson ONE.com company overview (click to expand)

Thomson ONE.com company overview (click to expand)

Thomson ONE.com 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 T1.com 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 ONE.com is (or T1.com) 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 ONE.com is (or T1.com) 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,

Forbes.com (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 ONE.com is (or T1.com) 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 ONE.com is (or T1.com) 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.