Skip to Main Content
Chat With Us

Bloomberg Guide

:

Exporting, Downloading & Saving Screenshots

This is a general guide on Bloomberg basic features and functions.

Exporting & Printing

Exporting & Downloading
There are two ways to get Bloomberg data into Excel 

  1. Search directly from the  Excel that is loaded on the workstation. Open up Excel first, click on Bloomberg, then import data. A new screen will open where you enter your data selections.
  2. Export from Bloomberg into Excel. This exporting capability is limited to certain data elements within Bloomberg. Not all data can be exported. When this function is available it will be listed under OPTIONS not export! Click on options, then download to Excel.

How to copy and paste tables from Bloomberg to Excel

  1. Place cursor at the corner of table in Bloomberg.
  2. Click and drag the data you would like to copy.  Bloomberg will copy text/data automatically without Ctrl + C.
  3. In Excel, press Ctrl + V to paste the data.
  4. Click on Data menu from the top in the Excel screen and select "Text to Columns..."
  5. Select "Fixed width-general."

Printing
Bloomberg prints to the O'Neill Library BC printers. Use the green PRINT key to print the information page by page. The PRINT KEY prints only the screen you are currently on, unless you type in the # of pages to print  first( # of pages available from top right hand corner) then hit the print key. 

Download Limit

Please be aware that academic accounts have a limit on the number of datapoints that can be downloaded per month.

Screenshots

Saving Screenshots
To save a screen go to Export,  click on Grab Screen. Not all screens can be saved.  You can also type GRAB <GO>