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…
Referencing the use of generative AI in your work
We recognise that Artificial Intelligence (AI) has, and will increasingly, become a part of our everyday lives and that we need to adapt to it. Hopefully you will have already seen the guidance for staff ...
When AI gets it wrong, who answers? Bridging the ‘confidence gap’ for tech-enabled transformation
Ask AI why it exists and it will tell you it was developed to enable machines to perform ‘human-like intellectual tasks’ including reasoning, learning and problem-solving. We seek out AI to help find answers: ...
Reducing your costs as an international student (without missing out)
Moving to another country to study is exciting, and it's also a big financial step. The good news is that budgeting doesn't have to mean missing out. We asked Dr Lakshmy Subramanian, Course Director ...
Need some help settling in? Wobble Week 2026
Whether you’re finding it hard to settle into your course or accommodation, you arrived late and are struggling to catch up, you feel overwhelmed or you can’t remember everything you’ve already been told, we can ...
Moving to the UK to study? How to plan for banking, exchange rates and transfers
Currency and banking are two of the most practical parts of financial planning for international students. They are also often the most overlooked. We asked Dr Lakshmy Subramanian, Course Director for Cranfield University's Banking, ...
Cranfield: an environment where innovation thrives
The latest Knowledge Exchange Framework rankings from UK Research and Innovation (UKRI) gives an insight into the real and meaningful impact that UK universities have. The seven categories that make up KEF6 cover everything ...
Comments are closed.