Are You Certified??? Certification Programs for Bloomberg or Thomson One!!!

Many students and potential employees like certifications for Bloomberg or Thomson One. This demonstrates that the student has an understanding of how to use these expensive programs before coming on board.  The learning curve for using these products on the job is greatly reduced.


Bloomberg, available at Lippincott Library or Huntman Hall, currently offers two certificates.

Bloomberg Market Concepts (BMC) is a self- paced, 8 hour introduction to finance using 70 Bloomberg terminal functions.  This provides a good foundation for undergraduates or people new to finance.  It covers four topics:  Economic Indicators, Currencies, Fixed Income and Equities. The format is interactive video sessions. There is no cost for this certificate if you use the Library Bloomberg terminals.  You can sign up for a web-based session at a discounted price of $149.00.

BESS is also self-paced and is recommended for individuals with more experience in Finance and Bloomberg.  Again, there is no cost when using the Library Bloomberg terminals.  Sessions are based on written materials.

Both classes require that you take quizzes in order to get the certificate.


Thomson One Investment Bank also offers a certificate program.  Click here for general information.  Once you have viewed the materials for the modules, request a token to take the exam.  The exam comprises 30 questions.  You have 60 minutes to complete the test.  If you don’t pass the first time, you are allowed to take the test a second time.  It is encouraged that you use Thomson One while taking the test.  This is free to students at Universities which subscribe to Thomson.

Remember that Thomson One only works with IE.  Please refer to these postings for further information.

Thomson One and Compatibility:  Internet Explorer Issues 

Thomson One Compatibility and Chrome or Firefox.

Using Capital IQ to screen for company executives and board members


S&P Capital IQ is a premier financial database that is available for the use of Wharton students in the Yablon Financial Resources Lab here in the Lippincott Library, or through MBA Career Management for MBA students during the academic year. One great feature of Capital IQ is the Screenings tool, with which you can generate a list of companies, equities, transactions, or people based on a specific set of criteria that you identify.

Once you create your screening, you are able to export it to Excel. This is particularly useful for the People Screening function if you are looking to download a structured data set on a group of executives that meet specific criteria. There are not many resources that allow you to do this for individual people as opposed to companies or equities as a whole.

However, Capital IQ’s screening tools are not the most intuitive, so finding the specific criteria you want to include in your screening can sometimes be a challenge. Here, we will show you how to pull structured data on executive compensation history for a set of companies. These techniques can be applied to a wide variety of screenings in Capital IQ.

  • To get started, hover over “Screening” in the ribbon at the top of the page and select “People.”

Cap IQ screenshot 1a

  • For the purposes of this blog post, let’s say that you want to screen for executives from companies in the S&P 500 index. In the first column of links on the Person Screening screen, click on “Indices” in the “Equity Details” box.

Cap IQ screenshot 2b

  • Select “S&P 500 Index” from the list of options.

Cap IQ screenshot 3crop

  • If you would like to screen for current professionals at these companies, ensure the drop-down is set to “Current Professional.” If you would like to screen for prior professionals, ensure that the drop-down menu is changed to “Prior Professional.” Click “Add Criteria.”

Cap IQ screenshot 3b

  • In the 3rd column of criteria on the page, there is an “Employment/Board” window. Click on “Professional Job Functions” in that window to specify which job functions you would like to evaluate in this screening.

Cap IQ screenshot 4

  • Choose the desired job functions from the “Available Items” window. To screen for current professionals, make sure that the “Limit to current job functions only” box is checked, and the drop-down is set to “Current Professionals.” If you are screening for prior (previously employed) professionals, make sure the drop-down menu is changed to “Prior Professionals.” Click “Add Criteria.”

Cap IQ screenshot 5b

  • If you would like to screen for board members as opposed to employees, click on “Board Job Functions” in the “Employment/Board” window instead of “Professional Job Functions.” Choose the desired board functions from the “Available Items” window. To screen for current board members, make sure that the “Limit to current job functions only” box is checked, and the drop-down is set to “Current Professionals.” If you are screening for prior board members, make sure the drop-down menu is changed to “Prior Professionals.” Click “Add Criteria.”
  • IMPORTANT: If you want to look at compensation information for current AND prior employees or board members, you will need to run separate screenings for each set of criteria and then combine them in Excel later. For example, if you were interested in looking at data for current and prior executives and board members, you would need to run FOUR separate screenings: current executives, prior executives, current board members, and prior board members.
  • Once you have selected all of your desired criteria, click on the “Customize Display Columns” tab. This is where you are able to select the information you wish to view about each executive who fits your screening criteria.

Cap IQ Screenshot 7bmarked

  • To display compensation for each executive, click on “Compensation” under “Person Details” in the fourth column. To display available salary information, make sure “Salary” is highlighted. Under time frame, select either “Latest Annual” or the fiscal year of your choice. Click “Add Columns.”
  • To display additional compensation information, such as bonuses, repeat the same steps for each individual criteria.
  • To view options information, click on “Options” under “Person Details” in the fourth column and add  your desired criteria.
  • If you are interested in viewing available education information for the executives in your screening, click on “Education” under “Person Details” in the fourth column. Select your desired criteria, and click “Add Columns”. Repeat for each remaining desired criteria. Note that not all education information is available, and depends on whether it was made public by the executive or the company.


  • Once you have added all of your desired criteria and column information, click the “View Results” button. This will generate a list of executives meeting your screening criteria. To export the list to Microsoft Excel, make sure that Excel is selected near the top of the screening results and click “Go.” This will generate an Excel spreadsheet for your results.


  • You can adjust your screening as necessary by clicking “Edit” next to the criteria you would like to adjust. Once you have made the necessary adjustments, click “View Results” again to update the screening. You will need to export the results to Excel again if you haven’t already done so.
  • Your screening is complete! You will be able to use this information to analyze executive compensation for your project.

There are a multitude of additional screenings you can run in Capital IQ, whether you are screening for companies, people, key developments, or transactions. We will focus on other types of screenings you can do in Capital IQ in a future blog post.

Lippincott Library Seminar Room – Open for Business


Lippincott’s new seminar room and information desk are open for business! Please join us on Tuesday, September 22 in room 242 from 2:30-3:30 for an informal open house to check out the new space. The seminar room and desk area are the first things you will see upon walking through our main entrance on the second floor of the Van Pelt Dietrich Library Center.


The Lippincott Library Seminar Room (room 242) will function as a space for classes, workshops and meetings. It seats up to 28 people with a flexible and configurable seating arrangement, ranging from seminar-style seating to small group clusters for collaborative work. Several glass whiteboards allow for an ample amount of writable surface.


The seminar room includes a full high-definition projection system with ceiling embedded speakers for audio playback. It has a permanently installed Windows PC as well as two sets of laptop inputs supporting both HDMI and VGA connections to the video projector. Wireless presentations are possible through the use of Mersive Solstice software installed on the resident PC. The room supports video and audio conferencing and has a microphone array permanently installed in the ceiling and a high-definition pan/tilt/zoom camera installed next to the projection screen in the front. Skype and Bluejeans are both installed on the resident PC. USB inputs connected to the resident PC are available in the front and back of the room and allow for the connection of auxiliary peripherals to the system such as cameras and visualizers.

We welcome single-use and recurring reservations for classes and academic support activities. To book the room, please see our reservation form. Contact us at with questions.

We look forward to seeing you at the Open House on Tuesday, September 22 from 2:30-3:30 in Room 242!!

Wharton Students and Faculty: Lippincott Library has the Business Sources You Need!!

Welcome!!  Lippincott Library provides many resources to help you with all of your business research needs. We can help you to :

  • Prepare successful business plans
  • Prep for interviews
  • Screen for investments
  • Win case competitions
  • Write a research paper
  • Much more

Continue reading

Lippincott Library Seminar Room Construction

If you have visited Lippincott Library in the past few weeks, you have undoubtedly noticed some major changes. As you enter the library, you will immediately encounter the “great wall of Lippincott” – a large barrier that has been constructed around what was once our reference and reserve services desk.


Thanks to the generosity of the Snyder family, we are building a 28-seat seminar room this summer. The new room will be located just inside Lippincott’s main entrance. It will have a flexible furniture configuration, allowing it to be used seminar-style, lecture-style or to be set up for smaller groups. This project also gives us the opportunity to completely restructure our service desk and build a new staff work room which uses space more efficiently. An interior “behind the wall” shot is below.


Since we do not have a service desk during the construction period, we are operating a service room out of Room 248 (Class of 1955 Consultation Room). We will continue to provide reserve services from this room, as well as on-call access to reference librarians.

Construction will continue over the summer, but we anticipate the room and new service desk will be open and ready for business at the start of the Fall 2015 semester. We will be posting updates on its progress.

Screening for Alumni-Company Links

Job seekers are often interested in identifying companies that employ alumni from their schools. Here are brief descriptions of four databases that  uncover alumni-company links. The databases report on different although overlapping populations, and vary in the number and type of screening variables they provide. The biographical information given typically includes contact data, employment history, and, if publicly available, compensation.
Continue reading

Stock Price Archeology

April often brings us a spate of income tax related questions about the price of a stock on a particular date. The questions are usually from people who want to establish the cost basis of a stock for tax purposes.  Many standard financial databases can supply daily prices (high, low, close and volume) at least for the companies on the New York Stock Exchange as far back as the early 1960’s.

Table 1.


Here are the earliest dates available for daily prices of General Electric Company (GE) on several financial files.

Continue reading

Create Your Own Industry-Specific League Tables

The Lippincott Library has several great resources for finding league tables. However, the majority of these pre-populated league tables are typically geared towards specific geographies and companies rather than industry-specific information. What happens if you would like to look at a league table for a specific industry? You are going to have to construct your own. Fortunately, we have a resource that will enable you to do just that. Continue reading

Exploring EMIS Intelligence

EMIS Intelligence, formerly ISI Emerging Markets, has traditionally been a great resource for exploring emerging markets. Produced by Euromoney Institutional Investor, it aggregates news, reports, statistics and company information from a wide range of providers. While the focus remains primarily on emerging markets, their recent redesign allows researchers to more easily examine world or global markets, as well as giving them the ability to find information on developed markets. While one still has the option to drill into a specific country, choosing a specific country is no longer required, making it easier to search across multiple countries and regions of interest.


The EMIS Intelligence Search page can be somewhat overwhelming because there are so many options to limit and refine your search. This example shows looking for material on armored vehicles, and limiting the results to research reports using the Publication Type filter.


Once you have run the search, you can also use the Filter options on the left-hand side of the results page to further limit by country, language and more.  In the example below, two filters,  Country and Publication were used to narrow search results..











Alternatively, you can use the Reports tab to explore the reports that are available. When you select the Reports tab, you will note that Analysis/Research, Ratings Analysis, News Analysis, and Analytical Commentary are automatically checked under the Publication Types list in the Filter By column.


Use the Publications Tab to find reports by a specific provider. For example, to find EIU (Economist Intelligence Unit) Industry Reports covering the automotive, energy, healthcare, consumer goods, financial services and telecom sectors, select EIU Industry Reports from the publications list.

These reports cover both developing and developed markets, and include tables that are exportable to Excel, as shown in this example of telecom data from Austria.