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…
How to build a business that keeps growing
Ask any business owner about their ambitions and "growth" will almost certainly feature near the top of the list. More customers, higher revenues, larger teams and new markets are often seen as signs of ...
Three practical ways SMEs can build resilience in a challenging business environment
Economic uncertainty, shifting customer expectations and rapid technological change have become part of everyday business. While no organisation can predict every challenge, small and medium-sized enterprises (SMEs) can improve their resilience by focusing on ...
Six reasons students fall in love with Cranfield University
If you ask a Cranfield student what makes the University special, you won’t just get the usual “great teaching” answer. You’ll hear stories about industry projects that feel like real jobs, friendships built with ...
Boosting flight safety: Cranfield’s icing wind tunnel in action
The icing wind tunnel (IWT) was established at Cranfield University in 2003. The facility is capable of producing impact ice on models mounted within a range of different test sections. At present, the Cranfield ...
Getting ready to hand in your thesis?
You are nearly there! Many of our students are now starting to think about finishing their theses. If you are one of them, then you might find this post useful as you write up your ...
Frameworks to help you critically evaluate your sources
With so much information available, it can be challenging to identify reliable sources. Not all information is trustworthy, so it is important to critically evaluate what you find. Library Search and our subscription databases can ...
Comments are closed.