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…
The straw that might break the camel’s back?
The straw that might break the camel’s back? Lots of emphasis is placed on the importance of SMEs to the UK economy. Rightly so, given that they make up, according to UK government figures, 99.2% ...
Re-introducing Boardex for research on company boards and directors
Recently there have been some changes to the BoardEx service so here is a short reminder of what kinds of information the service holds. What is BoardEx? BoardEx provides global board and senior management information ...
Resource trial: SAGE Skills
Library Services staff have set up trial access to SAGE Skills until 2 October. The SAGE Skills suite of products is designed to support students to develop the academic and professional skills necessary to succeed in ...
Welcome to MIRC, the Management Information and Resource Centre
Welcome to all our new students! MIRC is located on the first floor in the School of Management's main Building 111. Please visit us and explore the services that MIRC has to offer. We are ...
Is it time to “call time” on talking sustainability?
Let me paint you a picture. You’re in the pub and you ask people around you what ‘sustainability’ means to them. It depends on the crowd, but you’d probably be met a combination of with ...
Research support webinar: Study skills – saving time with Mendeley
Mendeley is a free reference management software package that enables you to: store and organize your references; create reference lists and in-text citations; read, highlight and annotate PDFs. During this webinar you will be provided ...