Skip to main content Freeman School of Business Freeman School of Business Library Tulane University Homepage

Bloomberg @ Turchin Library

Guide to using the Bloomberg Financial system.

Access to Bloomberg

The Financial Analysis Lab at the  A.B. Freeman School of Business is temporarily located on the 1st floor of Goldring/Woldenberg Hall I, Room 120.  The lab provides 12 Bloomberg terminals with dual monitors as well as printer access.

The Lab is Splash card accessible 24 hours a day, 7 days a week to current Freeman students and faculty.  The terminals are available on a walk-up first-come/first served basis.  In addition to Bloomberg, the the following programs are also available: Capital IQ, Datastream, SDC Platinum, and Morningstar Direct.

There is one Bloomberg terminal located in the Research Commons in Turchin Library, and this terminal is also available on a first-come, first-served basis.

What is the Excel API?

The Bloomberg Excel API  (application programming interface) 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 Access the Excel API

To access Bloomberg directly from Excel, open Excel on the desktop, choose Bloomberg > Import Data. The Bloomberg Data Wizard will walk you through the process. It is one of the easiest ways to import data.

You can search for static data and data sets using the Market, Reference, Analytical, or Data Sets option; for time series data use the Historical End of Day option; and for intraday data use the Historical Intraday option.

For help in Excel,  select Bloomberg>Help from the top menu bar within Excel.

Excel Add-In

From the start menu, click on Bloomberg, and then on Install Excel Add-In. 

See the 'How to Install BLOOMBERG Add-In for Excel' guide.

Note:  If you already have Excel open, remember to close before installing the Add-In.  Once the Add-In is installed correctly, there will be a Bloomberg tab in Excel on the right at the top of the screen.