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…
Screening for FTSE 100 companies on Bloomberg
So you’re researching an index and need some data on its constituent companies? Bloomberg’s Equity Screening tool makes light work of this, not just for the FTSE, but for indices, exchanges and sectors worldwide. Type EQS ...
Accelerating my future: How Cranfield put me on the fast track to automotive safety innovation
Hello! I’m Michaela Kaiser, and I’m thrilled to share my journey studying abroad. I’m from Calgary, Canada, and I recently graduated from Cranfield’s MSc Automotive Engineering course. My path to Cranfield ...
From Myanmar to Cranfield: My path to Renewable Energy
As someone who is passionate about sustainability, my career goal is to build a path in the renewable energy sector. My aspirations comes from the benefits of developing sustainable energy sources and ensuring energy ...
From lifelong dream to circular economy leader: Q&A with Himesha Randeni on the Environmental Management for Business MSc
What does it take to turn a lifelong passion for the planet into a fulfilling and impactful career? For Himesha Randeni, the answer was the Environmental Management for Business MSc at ...
Library services over the Christmas period
Kings Norton Library will be open 24/7 throughout the holiday period as a study space. Library staff will work until 6pm on Friday 19 December and will resume their normal working hours from 9am on ...
From the control tower to Cranfield: My journey to shaping the future of airports
Hi, I’m Karima Lakouz, and this is the new me! I’m a Moroccan full-time student, aiming to graduate in 2026 with an MSc in Airport Planning and Management from Cranfield University. ...