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 do I write a secondary reference … in the NLM style?
Secondary referencing is used when you’re reading a work which includes a quotation from another author, and you – the researcher – can’t obtain the original source. We always advise, where possible, to try to ...
Reaching new heights: How a Global Excellence Scholarship fuelled my aerospace dreams
Leaving my home in India to pursue an MSc in Aerospace Dynamics at Cranfield University was a leap of faith. Hi, I’m Oliza Kachroo and as an international student, the transition ...
How do I reference…when delivering a presentation?
Just as you cite and reference sources in written work, you should also acknowledge the sources you use or quote in oral presentations. Citing your sources in presentations provides your audience with information about the ...
How do I reference a blog post… in the NLM style?
Whilst blog posts do not fall into the scholarly material category, they can be useful for providing personal insights into a particular area. For example, there may be a high-profile member of an industry who ...
From nature walks to neural networks: My journey in Applied AI at Cranfield
Hi, I’m Ebru K and choosing a postgraduate degree is about more than just picking a subject; it’s about choosing where your future begins. As an international student from Turkey, I ...
Leading With Heart: My Journey as Cranfield Student Association President by Summer Yan
When I first arrived at Cranfield, I had no idea that one year later I would be standing at the heart of our student community, serving as President of the Cranfield Student Association (CSA). ...