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…
Earth’s silent hero: Why soil is finally stepping into the spotlight
As a Soil Scientist, the start of December is always an exciting time of year, specifically World Soil Day (5 December). This year, it’s doubly special, because we are also celebrating the 75th Anniversary ...
How do I reference social media… in the NLM style?
Although it’s not considered to be scholarly material, you may find information on social media useful for a piece of academic work. It may be that a particular post on X or Facebook illustrates or ...
Want to improve your reading skills?
Are you starting to read through the mountains of journals, books or articles for your project or on your course reading list? Let’s start with a few myths about the reading process: You need to ...
Introducing… Bloomberg Spreadsheet Analysis (BSA)
Want to take your Bloomberg data skills in Microsoft Excel to the next level? The new Bloomberg Spreadsheet Analysis (BSA) certification is designed to help you do just that. Created by Bloomberg, BSA is an ...
Bridging Science and Supply: My Journey at the GCSG European Knowledge Forum 2025
Earlier this year, I had the honour of being selected as one of the 2025 Global Clinical Supplies Group (GCSG) European Scholarship Winners, an opportunity that took me to Budapest, Hungary, for the GCSG ...
Engineering a Greener Tomorrow: The Future of Sustainable Manufacturing
Across the world, engineers are facing one of the greatest challenges of our time: how to manufacture more while consuming less. As industries race toward net-zero targets, sustainability has become the driving force behind ...