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…
Getting started on your Master’s thesis
Please note: This post is intended to provide advice to all students undertaking a thesis in engineering or applied sciences. There is separate advice for business and management students. Choosing your thesis topic Your course ...
Systematic literature review – Identifying your search terms and constructing your search strings
Our previous posts on the systematic review have looked at getting started and selecting your sources. In this post we will look at the next fundamental stage: Identifying your search terms and constructing your search ...
The importance of metadiscourse in academic writing
Metadiscourse (or ‘metatext’) is a key feature of academic writing. Hyland (2019) describes it as the writer's “interpersonal communication” and it refers to the parts of your text that talk about your argument in order ...
Systematic literature review – Selecting your sources
In our previous systematic literature review post we identified some background reading for getting started, explained how to find other systematic literature reviews to help you understand what is required, and how reviews should be structured and written ...
Systematic literature review – Where do I begin?
Undertaking a systematic literature review can seem a bit daunting so breaking it down into separate stages is a good way to begin. In this blog post we’re going to identify some background reading and ...
Bank holiday hours for Library Services: Monday 4 May
Library Services staff will be taking a break on Monday 4 May for the early May bank holiday. You will still be able to access all the online resources and help you need via our ...