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 MIRC.
Categories & Tags:
Leave a comment on this post:
You might also like…
A Journey in Manufacturing: From Egypt to Cranfield
Hi, my name is Karim Atteya, and I recently completed my MSc in Engineering and Management of Manufacturing Systems at Cranfield University. I’m originally from Egypt, and I chose Cranfield for ...
How do I reference… a foreign language item in the APA7 style?
Students sometimes ask if it is permissible to include non-English language items in their work and references. The answer is yes. You can include sources written in a language other than English provided that they ...
Inside the Thermal Power and Propulsion MSc with Dr Uyioghosa Igie
In our recent conversation with Dr. Uyioghosa Igie, Programme Director for the Thermal Power and Propulsion MSc at Cranfield University, we uncovered what makes this course such an exciting and valuable path for ...
Borrow fiction online – for free!
Everybody needs a break from work, and if you fancy reading or listening to some fiction or non-academic books, we have the app for you! Use the Libby app to borrow a host of online books ...
Researching IPOs in Bloomberg
Are you researching IPOs? Do you want to find IPOs on a specific index (eg S&P 500, or UK AIM Index) for specific dates? Then Bloomberg is where you should be looking. If you haven’t ...
Meet the Cranfield alumna named among sustainability’s brightest rising stars
For Julia Anukam, working in sustainability is about being part of the solution. A conscious consumer and long-time vegan, she found her true calling after a re-evaluation of her career priorities during the Covid-19 ...