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…
Setting your research on the right course: Four questions every researcher should ask
Whether you are just beginning your doctoral journey or are already well into your research career, successful research rarely happens by accident. Like any successful mission, it depends on good planning, informed decisions, and getting ...
5 budgeting mistakes students make (and how to avoid them)
Good financial planning isn't about how much money you have. It's about the habits you build. We asked Dr Lakshmy Subramanian, Course Director for the Banking, Economics and Finance MSc, about the budgeting mistakes ...
Finding your reading materials
Use Library Search Library Search is the first place to start when you are trying to find academic sources for your work. This is the search box on the library website homepage. It allows you ...
Formula 1 was the dream and Cranfield was the conduit
I still remember the exact moment Formula 1 (F1) got its hooks into me. I was in my first year of an aerospace undergraduate engineering degree when I watched a video about the sport ...
Introducing Barrington Library
Welcome to all our new students! Barrington Library supports all the students and staff at Cranfield Defence and Security on the Shrivenham site. We are looking forward to meeting you all soon, in person or ...
About to start your journey at Cranfield? We’re here to help!
Congratulations on accepting your offer to study at Cranfield! If you’re keen to get a head start before your course begins, our Library Services team is here to support you every step of the way. ...
Comments are closed.