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…
Company codes – CUSIP, SEDOL, ISIN…. What do they mean and how can you use them in our Library resources?
As you use our many finance resources, you will probably notice unique company identifiers which may be codes or symbols. It is worth spending some time getting to know what these are and which resources ...
Supporting careers in defence through specialist education
As a materials engineer by background, I have always been drawn to fields where technical expertise directly shapes real‑world outcomes. Few sectors exemplify this better than defence. Engineering careers in defence sit at the ...
What being a woman in STEM means to me
STEM is both a way of thinking and a practical toolkit. It sharpens reasoning and equips us to turn ideas into solutions with measurable impact. For me, STEM has never been only about acquiring ...
A woman’s experience in environmental science within defence
When I stepped into the gates of the Defence Academy it was the 30th September 2019. I did not know at the time that this would be the beginning of a long journey as ...
Working on your group project? We can help!
When undertaking a group project, typically you'll need to investigate a topic, decide on a methodology for your investigation, gather and collate information and data, share your findings with each other, and then formally report ...
From passion to purpose: My journey at the Pinnacle of Aviation
By: Sultana Yassin Abdi MSc Air Transport Management, Current Student Born and raised in the vibrant landscape of the UAE, with roots stretching back to Somalia, my life has always been ...