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…
Using your Mendeley library after you have left Cranfield
So you have spent the whole year (or more) lovingly collecting references around the topics that matter to you and now you have a large, personalised library in Mendeley Reference Manager containing all that information. ...
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 ...
Finding part-time work whilst studying at Cranfield – is it right for you?
We know that the cost of living in the UK is a real and ongoing challenge for many students. Whether you are still considering postgraduate study or already preparing for life at university, you ...
Leaving Cranfield soon? Have you heard about Alumni Library Online?
We are proud to offer one of the UK’s leading university library services for alumni. Alumni Library Online gives you instant access to thousands of top quality journal articles and the latest thinking to support ...
Want to know more about research methods?
Research methods are the strategies and tools used to gather, analyse and interpret data or evidence to uncover new information or create better understanding of a topic. Research methodology is the theory, justification and assumptions ...
Come for Cranfield, stay for Milton Keynes: how Bucks, Beds and the OxCam region are just getting started
Heard the one about the entry-level job that needed three years of experience? Sadly we all have, and that’s why in a jobs market where practical, hands-on experience is so important, study where collaboration ...