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…
Introducing… Scopus
Scopus is one of the largest and most trusted academic databases, indexing millions of peer‑reviewed articles, conference papers, books, and preprints across every major discipline. Scopus contains more than 100 million records and over 30,000 ...
Do you know what makes a Technical Report special?
Writing a technical report is a little different to writing a lab report or an essay for your tutors, requiring a different approach, communication skills and format. What are technical reports? Technical reports are formal, ...
Norman C. T. Liu scholarships providing the next generation of opportunities to succeed in Air Transport Management
Cranfield University is proud to work with global industry leaders who believe in investing in the next generation of aviation professionals. One of those leaders, Norman C. T. Liu, has personally committed to supporting ...
Designing the future of space: My group design project experience at Cranfield
For three years, I worked at Tata Consultancy Services (TCS) in India. While my time in the IT sector provided me with a strong analytical foundation, my true passion had always been anchored in ...
How do I reference lecture notes… in the NLM style?
If your course material contains original content that you want to use in your work, it will need to be referenced as follows: What information do you need in the reference? Author – surname initials e.g. ...
From Nigeria to Cranfield: My journey into Future Food Sustainability
My name is Jolaosho Eniola, and I’m studying the MSc in Future Food Sustainability. I’m originally from Nigeria, and I’m passionate about food systems, food sustainability, food supply chain and creating solutions that improve ...