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…
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 ...
Accelerating my future: How Cranfield put me on the fast track to automotive safety innovation
Hello! I’m Michaela Kaiser, and I’m thrilled to share my journey studying abroad. I’m from Calgary, Canada, and I recently graduated from Cranfield’s MSc Automotive Engineering course. My path to Cranfield ...
From Myanmar to Cranfield: My path to Renewable Energy
As someone who is passionate about sustainability, my career goal is to build a path in the renewable energy sector. My aspirations comes from the benefits of developing sustainable energy sources and ensuring energy ...
From lifelong dream to circular economy leader: Q&A with Himesha Randeni on the Environmental Management for Business MSc
What does it take to turn a lifelong passion for the planet into a fulfilling and impactful career? For Himesha Randeni, the answer was the Environmental Management for Business MSc at ...
Library services over the Christmas period
Kings Norton Library will be open 24/7 throughout the holiday period as a study space. Library staff will work until 6pm on Friday 19 December and will resume their normal working hours from 9am on ...
From the control tower to Cranfield: My journey to shaping the future of airports
Hi, I’m Karima Lakouz, and this is the new me! I’m a Moroccan full-time student, aiming to graduate in 2026 with an MSc in Airport Planning and Management from Cranfield University. ...