Discover our blogs

Aerospace | Cranfield University


Agrifood | Cranfield University


Alumni | Cranfield University


Careers | Cranfield University


Careers | Cranfield University

Defence and Security

Design | Cranfield University


Energy and Power | Cranfield University

Energy and Sustainability

Environment | Cranfield University


Forensics | Cranfield University


Libraries | Cranfield University


Libraries | Cranfield University

Manufacturing and Materials

Libraries | Cranfield University

School of Management

Libraries | Cranfield University

Transport Systems

Water | Cranfield University


Homepage / Introducing… the Bloomberg API

Introducing… the Bloomberg API


Did you know that, just like Datastream, it is possible to access Bloomberg data via Excel?

The Bloomberg API, as it is better known, delivers Bloomberg data into Excel for your own custom analysis and calculations. Help is on hand with Bloomberg Data Wizards which make it easy to download data by generating the appropriate functions for you, or, if you would like more flexibility to be able to customise the data in your spreadsheet, you can construct your very own formulae.  An array of templates are also available via the Template Library to help you find and retrieve data on a wide range of areas. These can also be adapted to suit your needs.

Excel addin1

To get started, you first need to install the Excel Add-In to your profile on the Bloomberg terminal you are using. You can check out how to install the Excel Add-In in our previous post. This will enable you to see the Bloomberg tab in your Excel toolbar.

For a full walkthrough of how to use the Bloomberg API, type HELP DAPI into Bloomberg.

Excel addin2

As always, if you would like further help on Bloomberg and its functions please contact MIRC.

Written By: Tracey Nunn

A Business Librarian since 2006, Tracey leads support for taught MSc courses in the School of Management Library.

Categories & Tags:

Leave a comment on this post:

Sign up for more information about studying master’s and research degrees at Cranfield

Sign up now
Go to Top