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…
About to start your journey at Cranfield? We’re here to help!
Congratulations on accepting your offer to study at Cranfield! If you’re keen to get a head start before your course begins, our Library Services team is here to support you every step of the way. ...
Bank holiday hours for Library Services: Monday 31 August
Library Services staff will be taking a break on Monday 31 August for the bank holiday. You will still be able to access all the resources and help you need via our library website. The 24/7 ...
The real cost of studying in the UK – what international students need to budget for
Moving overseas to pursue a postgraduate degree is one of the most exciting investments you can make in your future. It's also one of the most significant financial commitments you and your family will ...
Seven things you should definitely prepare for before studying at Cranfield University
You're thinking about Cranfield. Maybe you've done the virtual tour, read through the course pages, spoken to the course director or attended a webinar. Now, you're trying to figure out what life here is ...
From insurance to aerospace: why I chose to study a PhD with Cranfield
My path to studying for a PhD wasn't exactly a straight line. I had just graduated with an MEng in Aerospace Engineering from the University of Surrey and, like a lot of people, wasn't ...
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 ...
Comments are closed.