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.
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 (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.
The 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 https://bizlib247.wordpress.com/2011/01/05/oil-price-historical-data/#comments
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.
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”
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.
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.
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.
Chad Boeninger’s tips on using Passport GMID (Ohio University Business Blog)
Other Passport GMID tips (from this blog)
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.
- EBSCO Business Source Complete – We have Business Source Premier our largest business journals database with articles covering all aspects of business and management.
* EBSCO Business Source Premier tips *
- Capital IQ – We have a trial access to Capital IQ (one user access) – [Update June 2014 – Following the successful trial we now have Capital IQ.] There are a range of other databases for researching company and financial market information – see Researching Financial Markets for a summary from a research perspective.
- Factiva – from Dow Jones, Factiva is a great choice for business news – covers the most important newspapers worldwide and a large number of trade journals.
* Factiva tips *
- Passport (from Euromonitor) – used to be called GMID (Global Market Information Database) then Passport GMID – a great source of global market, industry and country data with an emphasis on consumer goods.
* Passport (GMID) tips *
- Investext – Investment analysts (brokers) reports available in Thomson ONE.com or Thomson Research (from Thomson Reuters) – both of these only work in Internet Explorer (see Thomson ONE.com – browser compatibility or Thomson Research only fully works with IE)
* Thomson ONE.com Research tips * * Thomson Research tips *
For a fuller list of databases available at University of Manchester browse the business and management pages (LibGuides).
- Resources – Journal articles – Business Source Premier and alternatives
- Resources – Databases – International Companies and Databases – UK Companies – Thomson Research and other company information databases
- Resources – Databases – Business news – Factiva and alternatives
- Resources – Databases – Markets and Sectors – Passport GMID and alternatives
You might also be interested in our getting started guides.
[Medal image: http://www.flickr.com/photos/danjc003/1876117737/]
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.
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
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:
Global Market Information Database (GMID) from Euromonitor has now been renamed Passport.
When you login you will get this welcome page.
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:
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?”
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.]
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.
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.
[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.