Skip to main content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

Bloomberg: Excel add-in/API

Contact:

Jette Jorsal

E-mail: jejo@bib.sdu.dk
    
   

Line Kronqvist Jensen

E-mail: likj@bib.sdu.dk
   
   

Guide to the Bloomberg Excel add-in

An excellent guide to the Bloomberg Excel add-in can be found here: Advanced support for using the Bloomberg Excel add-in.

The Excel add-in/API

What is the 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.

How to use Bloomberg in Excel

Open Excel and follows these steps:

  1. Choose Bloomberg tab
  2. Choose Spreadsheet Builder
  3. Choose the right type of table
  4. Choose Next

Troubleshooting - missing Excel add-in

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.

Regulation for use of Bloomberg API data

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.

Syddansk Universitetsbibliotek
Campusvej 55
Odense M - DK-5230
Telefon: +45 6550 2611
Email: sdub@bib.sdu.dk

Se bibliotekets betjeningstider.