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 MIRC.
Categories & Tags:
Leave a comment on this post:
You might also like…
How do I reference… analysts’ reports in the APA7 style?
Brokers' and analysts' reports can be invaluable sources if you are researching a company or industry. If you are are using any in your work, you will need to cite and reference them, just as ...
Keen to develop your study skills?
Make sure you have the skills you need to study effectively and make the most of your learning experience at Cranfield. You can use the Study Skills Hub in Canvas to learn transferable life skills ...
Meet Mendeley: a powerful referencing tool that does the hard work for you!
Are you looking for a way to manage your references and create reference lists for your assignments or thesis? If so, you may wish to consider using Mendeley. What is it? Mendeley is a free ...
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 ...
Researching IPOs on Workspace (SDC)
If you need data on IPOs and share issues, our best source would be SDC Platinum via Workspace. SDC contains data going back to the 1960s and is one of the most comprehensive resources covering ...
The benefits of studying a Level 7 banking apprenticeship
Q&A with Maciej Gasiorowski IT Governance and Control Analyst at TSB Bank Current apprentice on the Senior Investment and Commercial Banking Professional Apprenticeship Can you provide a brief description of your role? I work ...