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…
Frameworks to help you critically evaluate your sources
With so much information available, it can be challenging to identify reliable sources. Not all information is trustworthy, so it is important to critically evaluate what you find. Library Search and our subscription databases can ...
Mastering the art of revising your writing
You’ve done the research and written your first draft. Now it’s time for one of the most crucial jobs as a writer - revising your writing to ensure your reader does not have to work ...
Using AI tools for your literature review
There are a proliferation of AI tools that can help you organise your life, work and study. This post focuses on academic or scholarly tools that have been developed to enhance the literature searching process, whether for independent research, an assignment or thesis. Bear in mind that these predominantly relate to finding journal/research papers, and not technical, business or trade sources such as standards, market research, industry reports or financial data. So ...
Finding successful past Cranfield theses
It’s always a good idea to look at examples of theses before you start work on your own. You may find them valuable for reading previous research, and for looking at structure, style and methodology. ...
On‑campus or off‑campus? How Cranfield students found their home away from home
Finding the right place to live is one of the biggest decisions you’ll make as you begin your student journey. Whether you’re looking for the convenience and community of living on-campus or the independence ...
Avoiding common referencing errors
As librarians, we get to see the full spectrum of reference lists in student work —from exemplary to … well, let’s just say, works still very much in progress! We are experts in spotting mistakes ...