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…
From Cranfield to CEO: an Emirati innovator’s lean journey
From the sands of Abu Dhabi to the lecture rooms of Cranfield University, one Emirati graduate has carved a remarkable path, blending academic rigour with entrepreneurial spirit. This is the story ...
Cranfield alumni hits 2 million views milestone with accessible archaeology YouTube channel
Cranfield alumni Rosie Crawford’s journey is nothing short of inspiring. While pursuing her undergraduate studies, Rosie created 'JustALittleRoo,' a free online access and outreach platform across YouTube, Instagram, and TikTok to share her experience as ...
From lean principles to lasting love: A Cranfield PhD journey
From the bustling streets of Turkey to Cranfield University, one graduate’s journey embodies the power of academic pursuit, industry connection, and unexpected life events. This is the story of Zehra Canan, ...
Finding economic data on Passport
One of the quickest and easiest ways to find global economic statistical data from a range of authoritative sources is to use Passport. Passport, a Euromonitor product, has both quarterly and annual historical data going ...
Level 7 apprenticeships support social mobility and address skills gaps
A recent article in The Times painted a misleading picture of Level 7 apprenticeships, accusing companies of sending senior executives on management courses, and diverting levy funding away from entry-level apprenticeships. The story fails ...
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 ...