The Financial Analysis Lab at the A.B. Freeman School of Business is temporarily located on the 3rd floor of the Goldring Woldenberg Business Complex, Room 340. 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, Room 331, and this terminal is also available on a first-come, first-served basis.
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.
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.
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.