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…
Setting up a private group on Mendeley to support your group project
Many of our students are busy working on their group projects. Our top tip is to set up a private group on Mendeley. You can use it to store all your references, and to share ...
Tell us what you think of Library Services!
We want our students to have a great experience during their time at Cranfield. Each month, the University runs a short “Topic of the month” survey to focus on one service or facility and find ...
Air Transport Management alumni stories: SangHo (Henry) Han, Strategic Planning Manager in South Korea
SangHo (Henry) Han is a strategic planning manager at Air Premia in South Korea. He graduated from Cranfield University with an MSc in Air Transport Management in 2018. Here, Henry talks about his passion for ...
Life on campus and studying an Advanced Water Management MSc at Cranfield
After a year of working in the water, sanitation, and hygiene sector, I started to look for opportunities to further my knowledge about water resources. Researching water organisations on LinkedIn led me to find ...
Sign up to our ‘Making your research open access’ webinar – 9 February
Do you know your green from your gold? What are publisher deals, and how can they help you? My paper acknowledges UKRI funding, do I need to do anything special? What does an author accepted ...
How the Executive Logistics and Supply Chain Management MSc improved my career outlook
Hear from Harrison Jnr Ilodiwe, Executive Logistics and Supply Chain Management MSc, on his student experience at Cranfield. Why did you choose to study the Executive Logistics and Supply Chain Management MSc at Cranfield ...