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.


Contact Us

Liaison Librarians for Management and Business

Dawn McKinnon & Amanda Wheatley

*Please select either one librarian to email or message both Dawn and Amanda together in order to ensure the best possible response to your query.

Snapchat code for buslibmcgill      

Need help from a business librarian? Send us your questions over Snapchat or Instagram!

Username: buslibmcgill

Chat in Teams!

Click to Chat with Amanda in Microsoft TeamsChat with Amanda

Statement on the Educational Use of Databases

The use of McGill Library's professional business databases is limited to academic purposes. These databases are not to be used on behalf of external organizations or for commercial reasons.

Students completing internships may not access resources and reports on behalf of their employers.

Please refer to the McGill Library policy on electronic resources or to the licensing and conditions of use for further information.

Common Bloomberg Functions

Broad Market Screens Functions

WEI World Equities Indices
ECST Economic Statistics by Country
MA Merger/Acquisition Database
FXC Currency Rates Matrix
WB World Bond Markets
MMR Money Market/LIBOR Rates
CDR Markets Calendar
MOV Index & Industry Group Movers


Market Performance

BI Bloomberg Intelligence
MOST Most Active Securities
FPC Mutual Fund Ranked Returns
ECDR IPO Calendar


Company Screens

DES Corporate Description
CN Company News
MGMT Executives & Board Directors
ISSD Financial Overview


Fundamentals & Earnings

FA Financial Analysis Templates
DVD Dividends
GE P/E Graph - Valuation
ANR Analyst Recommendations
YA Yield Analysis
EE Earnings Estimates
OMON Options


Comparative & Historical Analysis

RV Competitor Relative Value
TRA Total Return
HP Historical Price Table
SI Short Interest
COMP Comparative Total Return


Chart and Graph Functionality


CHAR Charts Homepage
G Charts Library
Historical Charts
GP Line Chart
GPO Bar Chart
GF Graph Fundaentals
GC Curve Charts
HS Historical Spreads
GR Historical Ratio Chart
Quantitative Analysis
RG Relative Graphs
PC Peer Correlation
GV Volatility Graph
Data Visualization
WT World Trends
GS Scatterplot


Excel Add-In Instructions


  1. Open Excel from the desktop icon.
  2. On the computer task bar select Start > All Programs > Bloomberg > Install Office Add-In.
  3. Click Install, a small confirmation box will appear.
  4. Once the install is finished, close Excel
  5. Open Excel again from the desktop icon. The Bloomberg tab will now appear on the taskbar.

Note, if Bloomberg does not launch in Excel after these steps, please continue with the following

  1. On the computer task bar select Start > All Programs > Bloomberg > API Diagnostic Environment.
  2. Click Start.
  3. Click Repair.
  4. Close the diagnostic menu and reopen Excel.

Excel toolbar, including the Bloomberg Add-In.


Exporting Data via Bloomberg

Sample data exporting into Excel from Bloomberg.

  1. On the Bloomberg terminal in the function display, select Output. 
  2. Select Excel, if available.
  3. Excel will launch automatically with the desired dataset.* 

*This will only work properly if the add-in has been installed.


Exporting Data via Excel

To download data from Bloomberg while in Excel, use the Spreadsheet Builder.

  1. Select the Bloomberg tab on the Excel spreadsheet.
  2. Choose the Spreadsheet Builder. 
  3. Use your mouse to hover over the data type icons to display a description of what is available.
  4. Click on the icon for the data type you want to use.
  5. Follow the instructions as they appear in the builder.

Excel Template Library

The Bloomberg Excel Template Library XLTP<GO> consists of more than 325 unique Excel templates. Each template is grouped to allow for easy discoverability and custom analysis. 

  • Search by most popular files.
  • Receive recommended templates.
  • Quick and easy access.

Navigate XLTP

Start by entering XLTP<GO> into the command line, Bloomberg will evaluate all the Excel files and retrieve the ones best suited to your preferences.

The function is split into two different viewing browsers: Cover View and List View. Cover View allows you to browse using filters, List View allows you to browse an index of available files based on popularity ranking.

Select the Read More button (or the spreadsheet name) to open the Template View. This will provide you with detailed information regarding the spreadsheet's analytical capabilities. As well, you will have access to screen grabs of the template in use, links to related content and insight as to how the template works.



McGill LibraryQuestions? Ask us!
Privacy notice