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…
Tell us what you think of Library Services!
We want our students to have a great experience during their time at Cranfield. Each month, the University runs a short “Topic of the month” survey to focus on one service or facility and find ...
Air Transport Management alumni stories: SangHo (Henry) Han, Strategic Planning Manager in South Korea
SangHo (Henry) Han is a strategic planning manager at Air Premia in South Korea. He graduated from Cranfield University with an MSc in Air Transport Management in 2018. Here, Henry talks about his passion for ...
Life on campus and studying an Advanced Water Management MSc at Cranfield
After a year of working in the water, sanitation, and hygiene sector, I started to look for opportunities to further my knowledge about water resources. Researching water organisations on LinkedIn led me to find ...
Sign up to our ‘Making your research open access’ webinar – 9 February
Do you know your green from your gold? What are publisher deals, and how can they help you? My paper acknowledges UKRI funding, do I need to do anything special? What does an author accepted ...
How the Executive Logistics and Supply Chain Management MSc improved my career outlook
Hear from Harrison Jnr Ilodiwe, Executive Logistics and Supply Chain Management MSc, on his student experience at Cranfield. Why did you choose to study the Executive Logistics and Supply Chain Management MSc at Cranfield ...
Engineering problem to solve? Let Knovel help you find a solution
Did you know that Knovel provides you with more than just eBooks? Knovel is a key database for many engineering, mechanical and materials courses here at Cranfield University, and contains content from an extensive range ...