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…
From nature walks to neural networks: My journey in Applied AI at Cranfield
Hi, I’m Ebru K and choosing a postgraduate degree is about more than just picking a subject; it’s about choosing where your future begins. As an international student from Turkey, I ...
Leading With Heart: My Journey as Cranfield Student Association President by Summer Yan
When I first arrived at Cranfield, I had no idea that one year later I would be standing at the heart of our student community, serving as President of the Cranfield Student Association (CSA). ...
Creating and using constituent lists in Datastream
Whether you're analysing industry performance, or comparing company financials, Datastream is a powerful tool. One of its most useful features is the ability to work with constituent lists — collections of companies grouped by index, ...
Landing at Cranfield: First-term experiences and life beyond the classroom
Starting a postgraduate course can feel daunting, especially if you’re new to the aviation industry. In this blog series, Adit Shah shares his journey on the Air Transport Management MSc at Cranfield. From first-term ...
Accelerating ambition: How Amelie Rohan engineered her future at Cranfield
In the world of high-performance automotive engineering, the gap between being a “fan” and being a professional is measured in more than just miles. It is measured in technical precision, hands-on ...
Study better and smarter in 2026
Happy new year! Now is the perfect time to reflect on your studies so far, thinking about what you’re doing well and where you need to focus a bit more attention. Getting back into ‘study ...