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 Guide: Exporting Data

Bloomberg Instruction and Reference Guides

Excel API

API stands for application progamming interface. The Bloomberg Desktop API (the “API”) is a part of the BLOOMBERG PROFESSIONAL® service (the “Terminal”). It allows users to download the same high quality, timely data they rely on within the Terminal environment for use with desktop applications on their local PC. 

*** The API service must be installed individually for each account created, as such if you are a new user and want to export data into excel you will need to follow the steps below.

If the Bloomberg ribbon or menu does not automatically appear in Microsoft® Excel, you can install the BLOOMBERG PROFESSIONAL® service Add-In using the Bloomberg API Diagnostics tool.
Steps:

1. Close all Microsoft® Office applications.

2. From the Start menu of your PC, select All Programs > Bloomberg > API Environment Diagnostics.
Note: If the Bloomberg folder or the API Environment Diagnostics application does not appear, see Downloading the Add-In.
The Bloomberg API Diagnostics window appears.

3. In the upper left corner of the Bloomberg API Diagnostics window, click the Start button.

  • The diagnostic tool checks your system, displaying a progress bar at the top of the window. The process can take up to a minute to complete. When the process completes, a confirmation window appears.

4. Click the OK button.

  • The results of the diagnostics tool appear in the System Attributes section, displaying each category of system attributes.
    For more information on the colors that appear, see Result Colors.
5. In the upper left corner of the window, if the Repair button is enabled, click the Repair button.
  • The diagnostics tool attempts to install the software. A confirmation window appears.

6. Click the OK button.

  • The results of the repair appear in the System Attributes section.

7. Open Excel and look for the Bloomberg ribbon or menu at the top of the window.

If the Bloomberg API Diagnostics tool fails to install the Add-In ribbon or menu, you can download the Add-In software from Bloomberg and install it.
To download and install the Add-In software:
  1. Close all Microsoft® Office applications.
  2. In your web browser, go to http://www.bloomberg.com/professional/downloads/ .
    The Client Downloads web page appears.
  3. In the Shortcuts Client Downloads section, click Office Tools.
    The Office Tools Client Downloads options appear.
  4. Click Bloomberg Office Tools.
    The Bloomberg Office Tools window appears.
  5. Click the Download .Exe button.
    The .exe file downloads to your system.
  6. Run the .exe file.
    The installation wizard appears.
  7. Follow the steps in the installation wizard to install the files.
  8. Open Excel and look for the Bloomberg ribbon or menu at the top of the window.

In Bloomberg: 

  • BU < GO >  Bloomberg University where you can watch online tutorials of how to use the Excel API.
  • BBXL < GO > Cheatsheets, pre-programmed spreadsheets, demo-spreadsheets, and explanation of error messages.
  • DOCS < GO > - Bloomberg documents
  • EASY < GO > - Tips & Shortcuts
  • IPCB < GO > - Cheatsheets/Brochures
  • MANU < GO > - Online manuals

 

Other sources:

Cornell University provides examples of Fundamental analysis, Historical Data, Intraday Data, Scenario Builder, and Static data and data sets.

Screenshots

To download screens as images to incorporate into your Word documents.

Save Screen to file

  • Right-click with the mouse in the screen,
  • Click Save Screen,
  • Type in a filename and choose a location to save the file.

Email Screen

  • Type GRAB
  • Email the image to yourself as a GIF file.

The image can be inserted into Word, Powerpoint, or other compatible software programs.

Downloading

Use the Bloomberg's API wizards to dowload data into Excel applications.

Open Excel and use the Bloomberg toolbar or drop-down menu:

  • Table Wizard: Download current data ranging from ticker symbols and stock prices to complex calculations such as duration and risk.
  • History Wizard: Retrieve historical prices and fundamentals or create charts.
  • Bulk Wizard: Download blocks of data, such as the members of an index, the cashflows of a bond, or the dividend history for a stock.

Printing

Print Page: Use the green PRINT key to print information page by page.

Print All Pages: Type # PRINT, where # is the number of pages available (top right hand corner)