Posts Tagged ‘GMID’

Oil Price – historical data (update)

16 October 2014 1 comment

The oil price is often in the financial news as a key economic indicator so it is not surprising that many researchers are interested in historical oil price data.

Crude oil is traded worldwide but there is not a single oil price. The Financial Times world markets summary includes two crude oil benchmarks: WTI (West Texas Intermediate) and Brent. Historic data is available for these from several sources. One of the most convenient is Quandl (see Quandl – a search engine for time-series datasets for more information)

The screenshot below shows a oil price chart for “Brent Crude Oil Spot Price, Sullomn Voe, Scotland” from Quandl’s crude oil prices.

Brent crude oil price from  Quandl

Brent crude oil price from Quandl

Historical oil prices are also available from several databases:

Bloomberg Professional has the greatest detail of commodity trading and related news. Most of the trading of oil on financial markets deals with oil future (paying now for oil to be delivered at a specific date in the future) rather than the spot (current) price. Benchmarks include Brent Crude (EUCRBRDT) and WTI (USCRWTIC)

Datastream from Thomson Reuters includes numerous historical time series of oil prices among its commodity category. Benchmarks from Thomson Reuters include Brent (OILBRDT) and WTI (OILWTIN) crude oil.

Global Financial Database (GFD) also have these benchmark oil prices. (GFD) has historical prices for Brent and WTI crude oil (select GFDatabase and series type Commodity Prices). GFD has data for Brent going back to 1957 and WTI going back to 1860.

passport-oil-pricePassport (formerly GMID) from Euromonitor also has crude oil prices for Brent and WTI Cushing. However, these are only annual prices – if you want monthly or daily prices then the databases above are better.

In many circumstances it is acceptable to use any of these sources for historical crude oil prices but your text or references should make your choice clear. If you are getting other research data from Bloomberg or Datastream it makes sense to get your oil prices from the same source.

Oil Price chart from DatastreamThe previous oil price post (January 2011) included this oil price chart showing that Brent and WTI have been almost identical. On closer inspection the two series chosen are from different sources: OILBRNP (Brent) is from ICIS Pricing while OILWTIN (WTI) is from Thomson Reuters themselves.

(There are sometimes small differences in data from alternative sources – which is why Thomson Reuters make these available to their Datastream customers. For researchers the key questions are usually the time-span and frequency of historical data, and whether our Datastream subscription includes access.)

This previous post also prompted comments about getting historical data for TAPIS (Malaysian) crude. This is available on Bloomberg (APCRTAPI) from December 1986 and Datastream (OILTPMY) from January 1991. See

Consumer Prices Index (CPI) on Passport (GMID)

21 November 2013 Leave a comment

Passport (formerly GMID) from Euromonitor International is an great source of global market, industry and country data. This includes macroeconomic data such as the consumer prices index for different countries.

On Passport the variable is named “Index of Consumer Prices” so just searching for “CPI” does not find it.

To get the forecast values for future years you need to select Change Time Series from the left-hand side menu and add the additional years that you want. The forecast values appear in italics as in the screenshot below.

G8 - Consumer Prices Index from Passport (GMID) (click to expand)

G8 – Consumer Prices Index from Passport (GMID) (click to expand)

At the foot of the table you have links that will take you to the definition of “Index of Consumer Prices” used in Passport, and a note to say that the value is calculated by “Euromonitor International from national statistics/Eurostat/UN/OECD”

Alternative sources

Passport (formerly GMID) from Euromonitor International is by no means the only database that provides CPI and other macroeconomic data. Other sources include Bloomberg, Datastream, and Global Financial Database. Consumer prices indices are calculated by various providers e.g. national sources (United Kingdom Office for National Statistics), OECD, IMF, and the World Bank. Quandl is one easy way of searching these free online sources.

Categories: Economic data Tags:

Industry Overview reports from Passport (GMID)

9 October 2013 2 comments

Passport (formerly GMID) from Euromonitor International is an excellent source of industry overview reports. The Passport Industrial Market Reports collection has over 3,000 reports covering 18 countries, including all the G8 countries, Brazil, Russia, India and China.

Passport Industry overview report (click to expand)

Passport Industry overview report (click to expand)

This screenshot shows a section of “Sugar in United Kingdom: ISIC 1542 – Industry Overview, 15 Jan 2013”.

The report includes: market trends, competitive landscape, prospects, industry overview, import and export, and industry attractiveness index. It also includes supply chain information – buyers and suppliers at the industry level.

To search the industry overview reports in Passport (GMID) – login and select Industries then Industrial.

For information information on the reports available browse the Euromonitor International Industrial Markets Research page.

The following video from Chad Boeninger of Ohio University Library is one of several giving advice on using Passport GMID.

Ohio University have a slightly different subscription to Passport GMID so things may be slightly different for University of Manchester users.

Further tips

Chad Boeninger’s tips on using Passport GMID (Ohio University Business Blog)

Other Passport GMID tips (from this blog)

Best business and management databases

27 September 2013 Leave a comment

The Cambridge Judge Business School (CJBS) Library recently published a blog post “Top 5 best databases” to highlight their most popular premium databases. It is a great list if you are interested in exploring key University of Manchester database with just a little adjustment to account for differing subscriptions.

For a fuller list of databases available at University of Manchester browse the business and management pages (LibGuides).


You might also be interested in our getting started guides.

[Medal image:]

GSK sells Ribena and Lucozade for £1.35bn

14 September 2013 1 comment

Ribena and Lucozade (image from BBC News)

It was recently reported that GlaxoSmithKline (GSK) have sold the Lucozade and Ribena drinks brands to Japanese firm Suntory for £1.35bn.

GSK chose to get rid of the well-known UK brands after deciding to focus on its core pharmaceuticals business.

from Lucozade and Ribena sold to Suntory for £1.35bn (BBC Business News, 9 September 2013).

For background information on the soft drinks market.

KeyNote has

Soft Drinks (Carbonated and Concentrated) Market Update 2012 (19th Edition October 2012, Edited by Leah Tutt)

Note. All KeyNote market research reports are for the UK market.

Passport (formerly GMID) from Euromonitor has a number of report (see screenshot below) including

GlaxoSmithLinke Plc in Soft Drinks (United Kingdom), Local Company Profile 14 Jun 2013

Purchase of Lucozade Takes Suntory Holdings a Step Closer to Becoming A Truly Global Company, CAMI Article 09 Sep 2013

Passport - Ribena related reports (click to expand)

Passport – Ribena related reports (click to expand)

I choose “Ribena” for my searches – as a child I was a big fan

For more information on the deal between GSK and Suntory – search:

GMID now Passport

12 February 2013 1 comment

Global Market Information Database (GMID) from Euromonitor has now been renamed Passport.

At the moment you access Passport (formerly GMID) as before, e.g. from the University of Manchester Library business and management databases page or the databases A to Z list.

Passport from Eurominitor welcome page (click to expand)

Passport from Eurominitor welcome page (click to expand)

When you login you will get this welcome page.
(after confirming acceptance of the terms of use)

Passport is an excellent source of consumer market research reports and data, industry report and general macro economic data.

The most recent enquiry was for the “Retailing in Morocco Euromonitor 2012 report”.

For a quick search you can use the Enter keywords search box at the top right – “retail morocco” gave the results below.

Selecting the title Retailing in Morocco gives direct access to this June 2012 Euromonitor industry overview report – you can convert to a PDF file (25 pages) to download.

For more Passport (formerly GMID) tips:

Passport from Euromonitor - search results (click to expand)

Passport from Euromonitor – search results (click to expand)

Puttin’ on the Ritz – Sources for Data on Wealth

GUEST post – This is a slightly edited version of Michael Halperin’s post “Puttin’ on the Ritz …” on the Datapoints blog.

In the U.S. there is an increasing concentration of assets in the hands of the wealthy. This trend has given rise to phrases such as the “1%” and the “99%”.  Here are some data sources to help us answer such questions as “Who are the richest people?”, “How many of them are there?”, “How rich are they?”, and “How do they spend their money?”

Richest Lists

Forbes has a number of “richest people” lists in its magazine including Forbes World’s Billionaires and Forbes 400 The Richest People in America. In addition to names, photos, and net worth, the lists have information on residence, age, and source of income.  Using Forbes’ data, Wikipedia has compiled a convenient list of the Top 10 Richest People in the world by year from 2000 on.

[Bloomberg command RICH gives the Bloomberg Billionaires Index covering 100 people.]

Rich Demographics

Capgemini and RBC Wealth Management’s 2012 World Wealth Report is a freely available annual survey of “High Net Worth Individuals” (HNWI) from 70 countries. HNWI are defined as those with financial assets, excluding residence, of more than 1 million US dollars. Capgemini also discusses “Ultra HNWIs” individuals with financial assets of more than 30 million dollars. The report includes statistics on type of financial assets and a ranking of high wealth individuals by geographic area and country.

Two additional standard sources of information about the rich are the Luxury Institute and the Ipsos Mendelsohn Group.

Ipsos Mendelsohn does an annual U.S. study of 14,000 adults living in households with at least $100,000 in annual income. Although the University of Manchester Library, like the Penn Libraries, does not have access to their surveys of the affluent, you can often find data from these surveys cited in articles within the Business Source Premier or ABI/Inform databases. Try searching for luxury institute or mendelsohn affluent survey and search within the full-text.

The U.S. IRS Tax Stats Personal Wealth Statistics is published every three years.

[Table US Personal Wealth 2007 omitted – to view see original Puttin’ on the Ritz – Sources for Data on Wealth post on the Datapoints blog.]

[The UK National Statistics Publication Hub gives access to several wealth reports: Personal Wealth from HM Revenue and Customs, Wealth in Great Britain from Office for National Statistics and Wealth in Great Britain Wave 2 from Office for National Statistics.]

Marketing to the Rich

Marketing research publications are the obvious choice to answer questions about affluent marketing. Two good sources of information are [edited for University of Manchester resources]:


Affluent Investing (UK 2012); Consumer Attitudes Towards Luxury Brands (UK 2011), and Luxury Holidays (UK 2010). 

GMID (Global Market Information Database)

Luxury Travel: Experiencing the Best (2012) and Luxury Alcohol in the BRICS: How the BRICs are Reshaping the Luxury Alcohol Industry (2012).

The Datapoints blog includes a related post on resources for income distribution: I Dream of Gini – Measuring Income Distributions (Datapoints blog)

GUEST post – This is a slightly edited version of Michael Halperin’s post “Puttin’ on the Ritz …” on the Datapoints blog.

Researching companies for your career

17 September 2012 1 comment

remember nothing impresses an employer more in the job interview than hearing a candidate speak knowledgeably about their company (cjbsinfo, 2011)

At the welcome presentations today, it was clear students should start thinking about their career plan as early as possible. A good opportunity then to mention how library company information resources can help.

Company profile – for example use Business Source Premier and the Company Profile link.

Business News – for example use Factiva to find about recent press items about specific companies.

Market Research – for example use Keynote (UK cos) or GMID (Global Market Information Database) to research key market developments.

For more detail: Careers help online (Apr 2012), How to target and research potential employers (Jun 2011), from Careers category.

Refer to the shiny new University of Manchester Careers Blog – a great place to start learning about the support available from the University Careers Service like the Finance Business and Management Fair on 18th Oct 2012.


cjbsinfo (2011) “Pre-interview database checklist” University of Cambridge, Judge Business School, Information and Library Services blog. Available at: [Accessed 17 Sept. 2012]

Economic Observer: Essential Country Comparisons

Euromonitor International has recently launched two new and innovative database additions to complement the award winning Passport GMID database.

The two databases are called Passport Industrial and the Economic Observer.

The University now has access to these additions via Passport GMID.

In this second feature we will highlight the Economic Observer addition.

The Economic Observer dashboard provides up-to-date monthly and quarterly economic data across 55 countries and 42 macro-indicators allowing users to monitor anything from changing consumer confidence, short-term economic performance, trends and developments as well as fluctuating consumer prices and exchange rates all in real time.

Use Economic Observer to:

  • Track changes in the business cycle as soon as they happen
  • Feed into PEST analysis
  • Identify trends affecting consumer behaviour
  • Create your own forecasts from economic data
  • Understand trade patterns
  • Monitor changing interest rates
  • Track changes in prices and Fluctuations in exchange rates
  • Benchmark a company’s performance against overall economic growth
  • Spot potential production bases

To access the site select E-Resources on the MBS Library page:

Opt for Databases and next Countries and Regions. To access the Economic Observer dashboard please go to the ECONOMY, FINANCE AND TRADE homepage within the main drop menu of COUNTRIES AND CONSUMERS. On the homepage you will find the Economic Observer dashboard on the right hand side which can be activated by clicking on LAUNCH.

Please note there is a “?” icon at the top of the page which covers FAQs on how to use the system, the definitions, methodology and much more.

Economic Observer works well on your Tablet device too. Using Passport GMID via the MBS Library Service page enables access when on the move or when information is needed quickly for that all important research.

Remember to add the MBS Library Icon to your Tablet Home Screen, simply select the “arrow” option at the top of the screen next to your URL and opt for the “Add to Home Screen” option, then give your “app” a name and your task is complete.

A Detailed Resource Guide examining the key Features and Benefits of Passport GMID is available via our How to Research Guides page.

Euromonitor – Passport Industrial: A Unique 360 Degree view of Industry

28 September 2011 1 comment

Euromonitor International has recently launched two new and innovative database additions to complement their Passport GMID database. 

The two databases are called Passport Industrial and the Economic Observer.

The University now has access to these additions via Passport GMID.

This first feature will highlight the ground breaking Passport Industrial.

Passport Industrial is an economic research solution that analyses the industrial makeup of the 13 largest economies in the World – Australia , Brazil, Canada, China, France, Germany, India, Italy, Japan, Russia, Spain, UK and USA providing a strategic assessment of each industry and explaining the complex relationships between them. Use Passport Industrial to:

  • Gain insight into the structure and performance of each economy
  • Compare relative industry attractiveness in stable and challenging economic conditions
  • Identify and assess key client industries and spot bargaining opportunities
  • Examine the entire supply chain and how industries respond to changes
  • Benchmark industry performance, cost structure and profitability
  • Analyse import/export trends and their effect on domestic industries 

Access Passport Industrial

Opt  for Databases then Countries and Regions. Connect to Passport Industrial via the “industries” drop down menu where you will find a brand new industry option called “industrial”. On this homepage you can access all the reports by going to the “Quick Analysis Finder” tab on the left-hand side and access the “Country Reports” option. From the results page you can filter reports by country and category.

Screencast – – finding report on “Accounting and Auditing in the UK”

On the homepage you will also be able to access all the statistics by going via the “Search tree” menu on the left-hand side of the page which will allow you to then access the main menu tree. From here you can select multiple categories and then of course select multiple countries by clicking on “Choose Geographies”. Upon selecting “View Data Now” you will be able to view your own unique dataset.

Passport Industrial works well on your Tablet device too. Using Passport GMID via the MBS Library Service pages still allows for a user friendly experience.

Remember to add the MBS Library  Icon to your Tablet Home Screen, simply select the “arrow” option at the top of the screen next to your URL and opt for the “Add to Home Screen” option, then give your “app” a name and your task is complete. Good functionality and design makes this an ideal addition to an iPad desktop.

A Detailed Resource Guide examining the key Features and Benefits of Passport GMID is available via our How to Research Guides page.