Thomson ONE only works with full functionality in Internet Explorer (IE), and within that, it only works properly in versions IE8 and below. For those of you familiar with this resource, this isn’t anything you haven’t heard before. Compatibility issues continue with Thomson ONE in the latest iteration of the Windows browser, Microsoft Edge. As has been the case before, there is a work around which you can find detailed below.
Hello, Wharton students! Welcome to Lippincott Library and a new academic year. Find us online, chat with us during the day, email us after hours, call us at 215-898-5924 or head up to the second floor of Van Pelt-Dietrich Library and say hello! We’re here to support your research and academic needs. We offer a number of library services to do that.
RESEARCH TO GO. Have a question between classes? Visit us in Huntsman Hall! We hold office hours every Monday through Thursday 12:30 – 1:30 in JMHH 251. Drop in and get quick answers for your job search or research questions.
Our Business FAQ is your 24/7 librarian. Search by keyword or concept to find resources on topics such as market research, company financials, analyst reports and more.
DOCUMENT DELIVERY. Available to undergraduate students, MBAs, PhD candidates and Wharton faculty. Email firstname.lastname@example.org to request articles and book chapters. Include the full citation for the fastest reply.
BUSINESS NEWS. Put away your wallet! Lippincott Library subscribes to major newspapers like the Wall Street Journal, the Financial Times, the New York Times, and many other business periodicals such as the Harvard Business Review and The Economist. You can read them in print in the library or online through several of our databases. You also now have access to WSJ Pro through Factiva. To limit your results to articles from WSJ Pro, click “Search” and then click “Source” below the “Free Text Search” box. Type WSJ Pro in the “Source” search bar and select any WSJ Pro sections of interest.
GROUP STUDY ROOMS. Have a team project or group presentation? Reserve a room for your meeting. We have smaller study rooms for 4-5 people and two larger rooms that accommodate 10-12 people.
YABLON FINANCIAL RESOURCES LAB. Your one-stop-shop for access to Bloomberg and Capital IQ. Yablon is open to Wharton students only whenever Lippincott Library is open, and our librarians are happy to help you with these resources.
WORKSHOPS. On Wednesdays we talk about Bloomberg. Each week we offer Bloomberg training from 3:30 – 4:30 in Yablon Financial Resources Lab. It’s hands-on so be sure to come a few minutes early to create your own Bloomberg account. Register for this and other business workshops here.
TEXT BOOKS. We have library copies of textbooks for many Wharton courses on reserve at the Lippincott Services Desk. Most textbooks can be checked out for three hours and used in the library. Check if we have your textbook in Franklin’s Course Reserves catalog.
DATAPOINTS is Lippincott Library’s blog. Follow us for tips and tricks about library databases, new resources we’ve added to our collection, and more. And follow us on Twitter @LippincottLib for business news, library workshops, and more.
We hope to see you in Lippincott Library soon!
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 email@example.com or stop by and see us.
Here’s a few tips to help get you started.
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.
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.
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.
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é
Make use of all of the equipment and programs available at the Weigle Information Commons .
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.
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.
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.
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.
Attention,Wharton undergraduates! Did you know that we recently made one of our most popular 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 firstname.lastname@example.org with the article’s citation information to get started!
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.
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.
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.
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.
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.
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.
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.
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.”
- 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.
- Select “S&P 500 Index” from the list of options.
- 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.”
- 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.
- 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.”
- 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.
- 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.