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…
Gear up for the future of vehicle design: Introducing the MSc in Virtual Prototyping for Vehicle Structures (VPVS)
The automotive and motorsport industries are in a constant state of evolution. Light weighting, electrification, and ever-stringent safety regulations are driving a revolution in vehicle design. But this innovation requires a ...
Finding industry profiles in Library resources
When researching an industry; its size, value and performance; competitors, brands and trends in the market etc., we recommend having a look at the following services. These can all be accessed via the SOM Library's ...
Setting up a shared group folder in a reference manager
Many of our students are now busy working on their group projects. One easy way to share references amongst a group is to set up group folders in a reference manager like Mendeley or Zotero. ...
Where are they now? From a Women in STEM scholar to a Sustainability Senior Professional
We recently caught up with Karoline, a previous Women in STEM scholar to find out where her scholarship and Cranfield master’s has taken her. How has Cranfield impacted your career? Studying at Cranfield University ...
Alan Harrison Half-Fee Scholarship 2024/2025 Recipient: A transition from working life back to student life, filled with learning, challenges, and rewarding moments
My first term at Cranfield has been filled with learning, new challenges and rewarding moments. Coming in with only a basic understanding of procurement and supply chain management, I knew the first term would ...
Moving with the times: The ‘new-look’ Cranfield Management MSc
For more than a decade, the Cranfield Management MSc has been at the forefront of management education worldwide. Ranked best Management MSc in the UK for value for money and international student experience by ...