Søren Madsen
Tlf.: | 3815 3721 |
E-mail: | sm.lib@cbs.dk |
An excellent guide to the Bloomberg Excel add-in can be found here: Advanced support for using the Bloomberg Excel add-in.
The Bloomberg Excel add-in (API) allows you to pull data from Bloomberg through Excel rather than from the regular Bloomberg terminal interface. This is very helpful for pulling large sets of data or comparing companies on a variety of factors.
Open Excel and follows these steps:
The Bloomberg Excel add-in works on all seven Bloomberg terminals at the CBS Library Data Lab. It is installed as default. If the add-in is missing in the toolbar (see text above), try this:
1/ If there is an error installing it, run Start > All Programs > Bloomberg > Bloomberg API Diagnostics > Start & Repair. Read more in the guide (link below).
2/ Still not working, try to manually install the Bloomberg Excel add-In. First close all Excel spreadsheets and follow this path: Start > All Programs > Bloomberg > Install Excel Add-In.
You can access Bloomberg data via the Bloomberg API. You may access and use this data ONLY on the PC you use to access the BLOOMBERG PROFESSIONAl service and to download the data.You may not remove data downloaded using the Bloomberg API from this PC. You and your company’s use of the BLOOMBERG PROFESSIONAL service, the Bloomberg API and Bloomberg data is subject to the Bloomberg Agreement and Datafeed Addendum signed by your company.