I Graduated!! Can I use the Library Databases?

Featured

Congratulations to the Class of 2016!!!

“Why can’t I get access to the Library’s databases?” is the perennial question of the recent Penn graduate.

graduation_celebration-hands-throwing-caps-in-ai2r

Unfortunately, the library’s subscription databases are only available to current students, faculty, and staff members of the University of Pennsylvania. Once the school switches a student’s status from student to alumni – usually mid-August – access to the Library’s electronic resources ends. Below is a summary of the Penn Libraries resources that you can access as an alumni, both remotely and on-campus. We also have a few tips for finding business resources at your local public library or on the Web.

Alumni Services provides information on visiting the Library, Library Events and E-resources that are accessible remotely using your PennKey information.

Alumni also have access to some business databases on campus as shown in this list: Alumni Business Database Access on Campus.

Other options for Alumni include the local public library.  Many public libraries provide access to selected databases for members.  Check your library to find out what is available to you.   New York City’s Science Industry and Business Library, (SIBL) rivals many college libraries. The Free Library of Philadelphia also has a large collection of business resources.

There are also many useful freely available web resources.  Here are a few tips on locating and finding reliable information.  First, check our Library Research Guides.  Many guides include web sites carefully vetted by subject Librarians.

libguides_cropped_marked2

Many Universities, such as Penn, provide Scholarly Commons where research by faculty and students are readily available.

Use Google filters.  For instance, when you are researching topics such as foreign trade or exporting, limit your search to government sites.  To search for trade regulations in Brazil, use this search:

TRADE REGULATIONS BRAZIL SITE:.GOV

You will retrieve resources about trade with Brazil from U.S. government sites only.

To search for information from associations or organizations use the filter SITE:.ORG.  Many organizations such as the World Bank provide free information. One great resource from the World Bank is the annual “Doing Business In survey of the ease of doing business in countries across the Globe.  The World Bank also provides detailed information on each country including business regulations and historical macroeconomic data.

Google Scholar contains many scholarly publications from around the world.  Many are accessible via the web.  This can also be used as a way to build a bibliography that can be used at the local library.

google scholar

 

 

 

 

 

The Library of Congress lists many resources, print and online in the Business Reference Services website.  Check out the Bibliographies & Guides as well as recommended Internet Resources.

Large consulting companies often provide free reports. PricewaterhouseCoopers provides industry overviews and research and insights.  Real estate firms such as CBRE provide quarterly international market research reports.

An easy way to access government data is through American Factfinder.  Select your topic of interest such as demographics, economics or housing.

CensusMap

FRED, the Federal Reserve Bank, St. Louis, is another depository of economic statistics and research.  This covers a range of countries as well as the United States.

The Thomas Register is the largest directory of suppliers in the the U.S.  Many companies include brochures.taking-your-biz-to-the-top2

 

The Pew Research Center is a nonpartisan fact tank providing information about the issues, attitudes and trends shaping America.

Financial Data is also accessible on the web.  Yahoo Finance and Bloomberg provide data on stocks, bonds and other financial instruments as well as providing current news.

Yahoo-Finance-Logo

 

 

 

 

Edgar provides free access to company filings with the Securities and Exchange Commission (SEC).  It also includes information about the usage for various filings.

This is a sampling of sites that are available on the web.  Good luck going forward!!

For more detailed information about the Library’s business databases available to alums, please look at our blog post Library Database Access for Penn Alumni.

 

 

 

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’s Your Company’s RQ™ (Research Quotient)?

Research and Development (R&D) expenditure is the amount of money a company spends on developing new products and services each year.  Academic business researchers have intensively investigated the relationship between a company’s R&D and its market value, and have searched for ways to derive a firm’s optimal R&D spending.  A recent innovation in the analysis and measurement of a firm’s R&D has been the development of the concept of Research Quotient (RQ).

A company’s Research Quotient is the percentage increase in the company’s revenue from a 1% increase in its R&D. RQ is a measure of a firm’s ability to generate revenue from its R&D expenditures.  RQ is calculated from a formula that combines a company’s measure of capital, labor and R&D. For more details concerning RQ calculation, click on Manuals and Overviews from the WRDS Research Quotient database.

RQ can be used:

  • To Link R&D spending to firm growth
  • Link R&D spending to market value
  • Derive a firm’s optimal R&D spending

The WRDS RQ database includes RQ measures for all companies in the COMPUSTAT database that report R&D expenditures. The data covers 1972 to 2010 and is updated annually.  The file allows searching by 4 digit SIC and by GV Key (COMPUSTAT’s unique company identifier).

Table 1 is an example of the output showing some of the default variables.

TableOne

  • “Raw RQ” is the “Research Quotient” that identifies the ability of a firm to generate revenue from its R&D expenditures. The higher the RQ the greater the revenue generated.
  • “RSTAR” is a calculation of optimal R&D expenditure.
  • “RD Ratio” is the ratio of R&D expenditure to Revenue.

In Table 2, for clarification, I have supplied tickers and names of companies together with a measure of “RQ” that I calculated from the “Raw RQ” supplied by WRDS. This RQ is analogous to the human IQ measure with a mean of 100 and a standard deviation of 15. An RQ with a mean of 100 is often used by academic writers as a way of making the RQ measure more intuitive.

Table 2 ranks the first 20 companies in the U.S. by their RQ in 2010.

Table2improved

There are more than 260 four digit SIC codes represented in the 2010 files, but only 10 codes have more than 35 companies. Table 3 collapses the codes into 2 digits, and ranks the average RQ of the largest 15 industry groups.

Table3Formatted

About 78% of the companies in the 2010 file were based in the U.S.  Figure 1 graphs the countries with 3 or more companies in 2010 by average R&D expenditures and average RQ.

Figure1Formatted

The principal developer of the RQ concept is Anne Marie Knott, Professor of Business at Washington University, St. Louis. In a 2012 article in Harvard Business Review, she estimateds that if the 20 largest US firms had optimized their R&D expenditure in 2010, they would increase their aggregate market capitalization by $1 trillion. (Knott, Anne Marie. “The Trillion-Dollar R&D Fix.” Harvard Business Review (90:5) 2012, pp. 76-82.) This article can be accessed using Business Source Complete.

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.

Lippincott Library Seminar Room – Open for Business

OFB-Open-Sign-Red-White

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.

LippincottInfoDesk

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.

Lippincott242

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  lippinco@wharton.upenn.edu 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