Introducing… the Bloomberg API
08/06/2016
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.
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.
As always, if you would like further help on Bloomberg and its functions please contact the Library.
Categories & Tags:
Leave a comment on this post:
You might also like…
Building more than research: Reflections from the ECRn Symposium 2026
There’s something quietly powerful about a room full of early career researchers. Not just the ideas, although there were plenty of those—but the conversations, the curiosity, and the sense that everyone is figuring things ...
Library services over Easter, 3-6 April
Kings Norton Library will remain open for study 24/7. You will need your University ID card to enter the building and can use the self-service machines to borrow and return items as usual. Barrington Library ...
How do I access the full-text of Harvard Business Review (HBR)?
This is a frequently asked question, and it's worth knowing how to access this key management journal. So, how do you access HBR in full-text? The short answer is via our eJournals finder. You can find ...
Engineering problem to solve? Let Knovel help you find a solution
Did you know that Knovel provides you with more than just eBooks? Knovel is a key database for many engineering, mechanical and materials courses here at Cranfield University, and contains content from an extensive range ...
What happens when female scholars meet influential leaders?
On the 5 March 2026, our British Council Women in STEM Scholars had the privilege of sitting down with two excellent role models of industry and academia: Professor Dame Karen Holford, ...
From MSc to CEO: Igniting a research revolution
For many, a master’s degree is achieving a big milestone. Kilyan Ocampo, Computational Fluid Dynamics alumni shares how studying at Cranfield helped launch his career in the energy sector. Today, Kilyan ...