Skip to Main Content

Bloomberg

Basic instructions for the Bloomberg database

Printing from Bloomberg

You can print or export screen shots from Bloomberg. Click the "export" icon at the top right for a list of options.

If you choose to print, you will get a pop-up window asking for your PacePortal credentials. 

Exporting to Excel

The Bloomberg Data API, or DAPI, allows you to export market data into an Excel spreadsheet. Open Microsoft Excel on the Bloomberg terminal. Click the "Bloomberg" tab on the toolbar at the top of the page.

Click the "Data Navigation" button to bring up the data wizard. The data wizard allows you to search for and download securities data within Excel. Simply type in the ticker for the security you are interested in.

On the toolbar ,

  • Use the "settings" button to adjust your data parameters.
  • Use the "Drag into Excel" button to export your data into Excel.
  • Use the 'View All" button to view the data in a larger screen.

There are many more ways to import and analyze Bloomberg data in Excel. For more information, watch the Bloomberg API training video or check out the help guide on this page.

Bloomberg Excel Help

Keep in mind: The Bloomberg "API Essentials" video as well as the cheat sheet were created for older versions of Excel. There are slight differences in the way the ribbon is laid out in Excel 2013. However, the essential functionality has not changed. 

Video help:

  • BU<GO>
  • Select "Online Training"
  • Select "API Essentials"