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…
My journey to Cranfield as an FIA Motorsport Engineering Scholar
"You don’t need to fit a stereotype to succeed in engineering or motorsport. You need curiosity. Resilience. And the confidence to take up space." In this blog, Sanya Jain, current MSc student and FIA ...
‘Getting started with Bloomberg’ training – discover the power of Bloomberg terminals
Perhaps you've heard people talking about Bloomberg or heard it mentioned in the news and are wondering what all the fuss is about? Why not come along and find out at our Getting started with ...
Commonwealth Scholarships play a critical role in developing sustainability and leadership in Africa
Q&A with Evah Mosetlhane, Sustainability MSc, Commonwealth Distance Learning Scholar What inspired you to pursue the Sustainability MSc at Cranfield? I was inspired to pursue the Sustainability MSc at Cranfield because of the university’s ...
How do I reference a thesis… in the NLM style?
You may be including theses within your research. When you do so you need to treat them in the same way as content taken from any other source, by providing both a citation and a ...
Introducing… Bloomberg Trade Flows
Are you interested in world trade flows? Would it be useful to know which nations are your country's major trading partners? If so, the Bloomberg terminal has a rather nifty function where you can view ...
Cranfield alumni voyage to the International Space Station
Seeing our alumni reach the International Space Station (ISS) has a ripple effect that extends far beyond the space sector. For school students questioning whether science is “for them”, for undergraduates weighing their next ...