Using the Bloomberg Excel Add-in
12/11/2018

In an earlier post we explained how to install the Bloomberg Office add-in which allows data to be exported from the Bloomberg terminal to Excel.
Within Excel, the Bloomberg add-in toolbar has various tools you can use to draw data from the Bloomberg terminal directly into Excel.
One of the tools, the Template library, provides predefined templates covering different financial areas to allow you to pull relevant data from Bloomberg. Highlight any template name to get a description of what it covers.
Another useful tool is the Import Data option. This uses a Bloomberg Data Wizard to guide you through several steps where you specify the security, the data you need and the dates you need it for. This is the easiest way to extract data from Bloomberg as it writes the Bloomberg API formulas for you.
However if you need more flexibility than the wizards allow, you can write your own formulas.
The detailed help function <HELP DAPI> guides you through this:
When creating a formula, you need to specify the security (ticker, market sector), e.g. IBM US Equity; and the field (datatype), e.g. PX_LAST and a field. You can use the Field search tool (<FLDS>) on the Bloomberg tab to find the field mnemonic by category or keyword.
Depending on the type of data you want to download, you can use one of the following:
BDP (Bloomberg Data Point) – This returns data to a single cell. It contains only one ticker and one field.
= BDP (Security, Field) e.g. =BDP(“IBM US Equity”, “Px_Last”) retrieves the price of the last trade on IBM stock.
BDH (Bloomberg Data History) – This formula returns the historical data for a selected security.
=BDH (Security, Field, Start Date, End Date) e.g. =BDH (“IBM US Equity”, “Px_Last”,”01/01/01″, “12/31/01”) retrieves the closing prices for IBM from the first to the last day of 2001.
BDS (Bloomberg Data Set) – This formula returns multi-cell descriptive data.
=BDS(Security, Field) e.g. =BDS (“IBM US Equity”, “CIE_DES_BULK”) retrieves IBM’s company business description.
As always, if you need any assistance with Bloomberg, please contact the MIRC team.
Categories & Tags:
Leave a comment on this post:
You might also like…
How do I cite…. items with multiple authors in APA7?
This post follows on from our post on using 'et al' in citations but has a slightly different focus - do read them both! As you may know, in-text citations can be written either as ...
The British Library Business and IP Centre
Did you know that the Business and IP Centre at the British Library, on the Euston Road in London, has a variety of events and resources to support entrepreneurs and small businesses? If you register ...
Getting started on your Master’s thesis
Please note: This post is intended to provide advice to all students undertaking a thesis in the Faculty of Engineering and Applied Sciences. There is separate advice for School of Management students. Choosing your thesis ...
A key strength of the Management MSc: Thesis-linked Internships for all students
What drew me to Cranfield was not just its reputation, but the practical, real-world approach embedded in the curriculum. The course offers the chance to work on live case studies with companies and even ...
Register for a British Library Reader’s Pass
The British Library (Euston, London) is open to students and researchers who wish to use its world-class collections and resources. To do this, you need to register for a reader's pass. Begin by reading the ...
Unlock your full searching potential with a personal account in EBSCO or ProQuest
Some of our journal-searching resources include features that are only available when you have registered for an individual account. These features can help you to: Save time Document your work Keep up to date. Sound ...