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…
Mendeley: a powerful tool to organise and manage your references
Are you looking for a way to manage your references, create in-text citations and reference lists for your assignments or thesis? If so, you may wish to consider using Mendeley. What is it? Mendeley is ...
Keen to develop your study skills?
Alongside the technical skills and academic knowledge that you will gain on your course, as a Cranfield student you have the opportunity to develop a range of other skills that can enhance your learning experience. ...
The V-conomy: powering the sixth wave of global economic growth
The world could be on the verge of a major surge in economic growth and development, driven by the convergence of AI and clean energy technology. Waiting to ride the K-wave The Russian ...
Need help using the Python programming language?
We know some of our students are currently trying to learn Python, so we wanted to make you aware of some great LinkedIn Learning videos that can help. But don't you have to pay for ...
What does it really take to become a Chevening Scholar?
Say “Turkmenistan” to most people and you’ll get a blank look. That was true when I left Ashgabat for the UK to study an MSc in Logistics and Supply Chain Management at Cranfield University ...
Get a head start on referencing and plagiarism
We offer a module on Referencing And Avoiding Plagiarism which you can find on your Canvas dashboard. It explains the role and importance of citing references and how to incorporate the work of other authors ...

Comments are closed.