Using the Bloomberg Excel Add-in
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…
Working on your internship report
Instead of producing a traditional thesis, as covered in our earlier post, some students in the School of Management - and perhaps some in other Cranfield Schools too - will embark upon on an internship ...
Embracing a Marketing and Leadership MSc Apprenticeship.
A Q&A with Faizah Azeem. Why did you decide to undertake a postgraduate apprenticeship in Marketing and Leadership? Cranfield delivers a unique programme that sits well with professionals wanting to develop themselves into expert ...
What is ‘Digital Forensic Science’?
Despite being a fundamental tool for many organisations and criminal justice systems around the world, arguably digital forensic science as a discipline does not always get the recognition it deserves in media broadcasts. Therefore, public ...
Pandemic PhD to prospects PhD
Hello, my name is Danni and I’m a third-year PhD student in the School of Water, Energy, and Environment specifically within the Soil, Agrifood and Biosciences department. My PhD focuses on how biostimulants (seaweeds, ...
Connected and Autonomous Vehicle Engineering (Automotive) MSc alumnus Sohan Pookolayil Varghese on Cranfield, his career path, and why the automotive industry is such an exciting place to be
Sohan Pookolayil Varghese completed the Connected and Autonomous Vehicle Engineering (Automotive) MSc in 2022. Here, he talks about his lifelong love of cars, why he chose Cranfield, and his career at Jaguar Land Rover where ...
Design as a Tool for Change
Design as a Tool for Change: Exploring Circular Economy and Sustainability through a visit to the Design Museum Design has become increasingly important in creating sustainable solutions for a better future. At the forefront ...