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.