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…
Get a head start on referencing and plagiarism
We offer a module on Referencing And Avoiding Plagiarism which you can find on your Canvas dashboard. It explains the role and importance of citing references and how to incorporate the work of other authors ...
New students can book a tour of Kings Norton Library
To help new students find their way around Kings Norton Library, staff will be offering lunchtime tours at 12.15pm every weekday, 2-6 October. Tours will also be offered every Tuesday and Thursday throughout the rest ...
What opportunities are offered by vehicle connectivity and automation on highway?
Over the past decade, the number of road vehicles connected with the outside world has been growing rapidly, in response to the need for real-time navigation data, the introduction of eCall requirements, the practicality ...
Download the Library app!
You can use it to: Check what we have in our print collection (and a selection of our eBooks too!) Borrow items directly with the app instead of using a self-service machine* Reserve and renew ...
Why I chose Cranfield
After completing an undergraduate degree in Internet of Things Engineering, Zhen Sun was working with Siemens and looking for an area to give his focus to. He seized the opportunity to upgrade his skillset ...
Bloomberg basics
Accessible in SOM Library from 12 dedicated terminals, Bloomberg provides access to the real world of finance through the same platform as used by the world’s leading banks, corporations and government agencies. Bloomberg provides real-time ...