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…
Come to a virtual study session in May
What are virtual study sessions? These are online study sessions facilitated by Library staff, where you can study independently alongside other students via Teams. They are a great way for you to dedicate specific time ...
Getting started on your School of Management thesis
Writing a thesis, business plan, internship project or company project can be a daunting task, and you might have some uncertainty or questions around how to get started. This post will share some ideas and ...
Sustainability by royal request: Managing an event fit for a King
The Coronation of King Charles III on May 6th 2023, was watched by millions of people around the world with tens of thousands of people travelling to Central London to witness the pageantry firsthand. ...
Getting started on your Master’s thesis
Please note: This post is intended to provide advice to all students undertaking a thesis in the Schools of Aerospace, Transport and Manufacturing; Water, Energy and Environment, and Defence and Security. There is separate advice ...
Finding your tribe: “Joining the sustainability community was the best decision”
For students on Cranfield’s Sustainability Business Specialist Apprenticeship, community and camaraderie is a vital component for success. Designed in consultation with industry, the part-time Level 7 apprenticeship aims to deepen participants’ knowledge of the ...
“My sustainability studies gave me the confidence to take on Amazon”
Not everyone would have the confidence to challenge a big global power like Amazon but, for Colin Featherstone, Senior Technology Manager and Tech Sustainability Lead at Morrisons, his Cranfield studies equipped him with the ...