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…
Preparing your work for Turnitin submission
Before submitting your work into Turnitin for similarity checking, if you have used referencing software then you may need to take some important steps first. Mendeley and Zotero integrate with MS Word by embedding field ...
The fast track to supercar engineering: My Cranfield journey
It’s been a dream come true to work on some of the world’s most prestigious supercars – the Aston Martin Valhalla, McLaren 750 & Artura, the GMA T.33. But every successful ...
Automotive Engineering: From student to hypercar innovation at Rimac
We sat down with recent graduate Thomas Perrin, to discuss how his year on the MSc in Automotive Engineering at Cranfield University propelled him from the lecture hall directly into the ...
What this year at Cranfield really meant to me
Every Cranfield journey is unique. In this alumni reflection, Zachea Scicluna shares what her year at Cranfield truly meant, from facing uncertainty to gaining hands-on experience in industry-backed projects. I’ve been reflecting (and delaying) ...
Preparing for assignments and exams?
Sorry! We know it seems a bit mean to mention the exams in January rather than looking forward to the break before it! However, we know many of you will be thinking about your forthcoming ...
Screening for FTSE 100 companies on Bloomberg
So you’re researching an index and need some data on its constituent companies? Bloomberg’s Equity Screening tool makes light work of this, not just for the FTSE, but for indices, exchanges and sectors worldwide. Type EQS ...