Welcome to Lippincott Library Fall 2016

Welcome to the Fall 2016 semester and the Lippincott Library!!    The Lippincott Library supports the academic and research needs of the Wharton School.  Visit our website, contact us, chat with us, email lippinco@wharton.upenn.edu or stop by and see us.

Here’s a few tips to help get you started.

xmarksthespot

X marks the spot!!  Lippincott is located at 3420 Walnut Street.  Just look for the statue of “Broken Button“, located on Locust Walk at the entrance to the Van Pelt Library Building.  Lippincott is located on the 2nd floor, west wing of the building.

Use our Lippincott Services Guide to learn about all of our services.

yablon3

The Yablon Financial Resources Lab, located at the library, includes Bloomberg and Capital IQ terminals.  This space is available to Wharton students only whenever the building is open.

 

 

 

datapoints-forlipphome

Read  Datapoints, Lippincott’s blog,  to find out about business databases including content coverage and search tips. Posts also cover Workshops, such as Bloomberg 101 and other Library happenings.

 

Search the Business FAQ to locate the best resources to answer your research question.

 

tweet

 

 

Follow us on Twitter@LippincottLib

 

 

 

Book our group study rooms to practice presentations, hold meetings, and create content as a group.  These include 4 small study spaces, 2 group meeting rooms and a larger Seminar Room.

Join friends for a snack in Mark’s Café

1060_Marks-Cafe-5

Weigle2

 

Make use of all of the equipment and programs available at the Weigle Information Commons .

 

 

Sign up for workshops including Bloomberg 101, Entrepreneurship,  and Job Interview Prep.

Bloomberg FX functions part 2: Charting features

In addition to the basic FX functions reviewed in our post on Bloomberg FX functions, Bloomberg also offers its robust charting features for FX functions. These functions are great if you would like a more visual representation of the FX data than the tables provided in the basic functions. Below, we have detailed five different charting functions that are particularly useful for generating charts for FX functions.

Most charting screens are divided into three areas – the control area at the top, the side panel, and the chart itself. The control area and side panel allow you to edit the chart information and add items to the display, such as news events or other additional studies or scenarios.

Line chart

LINE CHART

The GP function produces a line chart that is excellent for visualizing trends for a specific currency pair over time. The default view is one year for the selected currency pair (ex: EURUSD [CURNCY] GP [GO]) If you just type in [CURNCY] GP [GO] the system will automatically default to the last currency pair you were looking at in any currency function.

The line graph displays trading information, as well as an adjustable line chart showing you the historical price information at a glance. The default display is one year of last price information, but you can also choose to display information for the last day or month, year-to-date, along with several other pre-selected options or a custom range. You can also display ask price, bid price, or inverse market price as opposed to the last price. Graphs and their accompanying data cannot be exported to Excel, but can be exported as an image or vector by clicking on Actions. Also, under actions, can view pricing info as a chart. You can also overlay additional currencies by clicking on “Security/Study”, or mark specific events, such as major news affecting one of the countries or regions, by clicking on “Event.” Custom charts can also be saved for future use.

GIP – Line chart for intraday pricing

GIP is another line chart that provides the ability to visualize trends for a currency, specifically for viewing intraday pricing over time. Where the GP only lets you see the last price (or ask price, bid price, etc.) by day, the GIP function let’s you view a currency’s intraday pricing over time up for up to 240 days in the past for a time series alanaysis that allows you to examine security performance.

INTRADAY PRICE CHART

GPC – Candle Chart

GPC displays the candle chart view of the GP (line chart for pricing) function. You can use this to examine trends in intraday pricing over longer periods of time than you can in the regular GP function. This function can be accessed by typing GPC [GO] or select “candle” from the control area in the regular GP function.

 

 

CANDLE CHART2

 

GPO -Bar Chart

GPO is a bar chart that, similar to the candle chart, allows you to examine trends in intraday pricing over longer periods of time. This function can be accessed by typing GPO [GO] or select “bar” from the control area in the regular GP function.

EURUSD BAR CHART

Document Delivery now available to Wharton undergraduate students!

Attention,Wharton undergraduates!    Did you know that we recently made one of our most 3-11-2016 4-40-13 PMpopular services for faculty, PhDs, and MBAs available to you? That’s right, you are now able to take advantage of our Document Delivery service! If you need an article or book chapter for your research, we will assist you in obtaining it.  We’ll scan and send PDFs to you via email. Note that we cannot supply course material, including bulkpack items or chapters from textbooks, but we can scan chapters of non-textbook print items that we have in our collection. (Please keep in mind that we must adhere to US copyright laws, including Fair Use, so there may be limits the amount that we can scan from within a single journal issue or book.)

Send an email to docdel@wharton.upenn.edu with the article’s citation  information to get started!

Introduction to Bloomberg FX Functions

If you are interested in foreign exchange rates or other information on world currencies, Bloomberg is an excellent resource for that data. In this blog post, we will go over some of the basic FX functions that are available in Bloomberg.

To get started, hit the yellow [CURNCY] market sector key, and then hit the green [GO] key. This will display a menu of the main currency functions, giving you an overview of some of the options available to you when you are looking for currency and FX data.

One of the main FX functions is FXIP, the FX information portal.

1 - FXIP Screenshot

If you type in FXIP [GO], you will be taken to the FX markets overview screen. FXIP gives you a detailed overview of FX information, enabling you to get a quick snapshot of pricing information for various currency baskets. This is a great starting point for FX overview information before navigating to different screens for more detailed information, some of which are detailed below. The default currency for the FXIP screen is USD, but you are able to change that by typing in a different base currency at the amber box near the top of the screen. You can click on the different gray tabs for additional market overview information.

Continue reading

What did they say? Resources for transcripts and audios of Earnings Calls.

Earnings calls are conference calls or webcasts at which a public company’s management team discusses the company’s financial performance from the previous reporting period (usually a quarter). Participants include investors, financial analysts, and others, including shareholders. Reading transcripts from these earnings calls and listening to audio recordings can be a great way to glean information about a company’s performance and plans for its future directly from the company leaders themselves.

Presentation

While archival transcripts of calls can be easy to find, audio broadcasts of earnings calls can sometimes be more challenging to find. Often, companies will only make them available for a limited amount of time following the actual earnings call. If you wish to listen to the broadcast, you will need to keep track of when a particular company’s earnings calls are and how long they make their broadcasts available after the call. For example, Apple only makes their broadcasts available for two weeks after the call. While archives of audio recordings will not be as extensive as those for the written transcripts, you can often find at least the recordings for the last call or two for a given company.

The Lippincott Library has a number of resources where you can access these materials.

Continue reading

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.

BloombergMonitor

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.

Once in Bloomberg, just type BMC<GO> or BESS<GO> to get started.

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

Thomson2

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

capiqlogo

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.

graduationyear

  • 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.

rptgeneration

  • 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.

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

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