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 Library.
Categories & Tags:
Leave a comment on this post:
You might also like…
How do I reference…when delivering a presentation?
Just as you cite and reference sources in written work, you should also acknowledge the sources you use or quote in oral presentations. Citing your sources in presentations provides your audience with information about the ...
How do I reference a blog post… in the NLM style?
Whilst blog posts do not fall into the scholarly material category, they can be useful for providing personal insights into a particular area. For example, there may be a high-profile member of an industry who ...
From nature walks to neural networks: My journey in Applied AI at Cranfield
Hi, I’m Ebru K and choosing a postgraduate degree is about more than just picking a subject; it’s about choosing where your future begins. As an international student from Turkey, I ...
Leading With Heart: My Journey as Cranfield Student Association President by Summer Yan
When I first arrived at Cranfield, I had no idea that one year later I would be standing at the heart of our student community, serving as President of the Cranfield Student Association (CSA). ...
Creating and using constituent lists in Datastream
Whether you're analysing industry performance, or comparing company financials, Datastream is a powerful tool. One of its most useful features is the ability to work with constituent lists — collections of companies grouped by index, ...
Landing at Cranfield: First-term experiences and life beyond the classroom
Starting a postgraduate course can feel daunting, especially if you’re new to the aviation industry. In this blog series, Adit Shah shares his journey on the Air Transport Management MSc at Cranfield. From first-term ...