# Main Content

Classroom Tools by WRDS is a teaching and learning toolkit designed specifically for faculty who are introducing finance and business concepts in the classroom.

Instructors can use Classroom Tools by WRDS as a core component of their curriculum, as stand-alone lessons, or as assignments. With a class account, you have a single user name and password which gives WRDS access to all your students.

**Topics:**

**Using the IBES CRSP Linking Table**

Researchers can easily merge IBES estimates with CRSP stock return data using a proprietary linking table that matches entities between the two. Researchers will learn:

- The methodology behind the IBES CRSP Linking Table
- How to run a web query to match CRSP PERMNOS with IBES Tickers

**SAS Visual Analytics**

SAS Visual Analytics provides a complete platform for information visualization, enabling users to identify patterns and relationships in complex data sets.

- Interactive, self-service business intelligence reporting
- Quickly derive insights from business data
- Customize your own reports

**Accounting and Accountability**

This teaching tool illustrates the nature of financial disclosure and accountability. Students will learn about corporate 10-Q and 10-K filings and the role of third-party auditing.

- Use proprietary WRDS SEC Analytics Suite
- Search over 3.5 million SEC filings
- Understand the role of the auditor

**Mechanics of Diversification**

How does diversification work? Developed in conjunction with Wharton Professor, Donald Keim, this application introduces the mechanics of diversification in an engaging format using three interactive tools:

- Variance-covariance matrix
- Two-asset opportunity set
- Limits of diversification graph

**Portfolio Diversification**

Using a series of visualizations, students will see the progressive impact of diversification on portfolio return and volatility.

- Understand the effects of diversification
- Generate and interpret graphs of the efficient frontier
- Understand concepts of returns, standard deviations and correlations

**Fama-French Three-Factor Analysis**

In this teaching tool, students are introduced to the Fama-French three-factor model. Extending the CAPM, Fama-French adds both size and value factors in this sophisticated asset pricing model.

- Fama-French factors explained
- Step-by-step multiple regression
- Practical Excel skills

**Backtester**

Developed in collaboration with award-winning Wharton Professor of Finance Robert Stambaugh, this application enables students to design and test their own investment strategies.

- Set up a backtest to test an investment strategy
- Run tests against a wealth of archived data
- Review and assess the outcome

**Reinvestment Risk: Bonds**

What happens when the cash flows from an investment cannot be reinvested at the original rate of return? Callable bonds and fluctuating interest rates, for example, both present potential reinvestment risk.

- Compare yield to maturity with realized compound yield
- Investigate exposure to reinvestment risk

**Sentiment Analysis Lexicons**

Many sentiment analysis tools rely on sentiment lexicons—lists of words scored for positive and negative connotations. Students learn different approaches to creating these lexicons.

- Demonstrates six sample sentiment lexicons
- Introduces domain-specific sentiment analyses of financial statements

**Named-Entity Recognition**

Named-entity recognition (NER)—the process of finding and classifying named entities such as people, locations, and organizations in text—is central to many other natural language processing tasks. Students learn basic concepts and evaluate three approaches to NER:

- Rule-based
- Machine learning
- Neural network

**Unsupervised Machine Learning: Clustering**

Learn about clustering as an unsupervised machine learning task and become familiar with how the k-means algorithm works for text classification.

- Customize input parameters, such as number of clusters
- Compare k-means cluster results with human-annotated results

**Getting Started**

In this exercise, students will log into WRDS for the first time, and run a very simple data query. They will use the CRSP Monthly Stock file to retrieve one year of monthly prices for three securities. Assignment instructions for students are found in the accompanying PowerPoint deck.

*Requires a CRSP subscription.*

**What Data is in WRDS?**

Students are re-introduced to WRDS, taught how information is organized, and then shown a full list of available data sets in WRDS. Explore how data is categorized in WRDS and introduce students to the most commonly used databases.

**Finding the Data You Want**

The objective of this case is to be able to locate specific data on the WRDS platform. Students should be able to differentiate between data vendors and categories, and understand specific vendor products and update frequency. They should also be able to locate documentation and find specific data items.

**Understanding Identifiers**

Students will learn about the different types of identifiers, including header and historical identifiers, issue and company specific identifiers, as well as relevant date ranges for certain identifiers. Additionally, students will gain knowledge of and understand the distinction between universal and proprietary identifiers.

**Using the CRSP/Compustat Merged (CCM) Database**

When conducting financial research, it is often necessary to match security-level data in the CRSP database with company-level data in the Compustat database. The CRSP/Compustat Merged Database is a CRSP product that contains Compustat data items. The database is structured so that Compustat items can be accessed using CRSP's PERMNO/PERMCO identifiers and Compustat's GVKEY identifiers. After being introduced to CCM, students complete an assignment using CRSP PERMNOs to access Compustat data—specifically, earnings per share.

*Requires a subscription to CRSP and Compustat.*

**Using the IBES CRSP Linking Table**

When conducting financial research, you may be required to combine estimates information from IBES with equity returns from CRSP. This lesson is designed for researchers who wish to link data between the IBES and CRSP databases using WRDS’ familiar web query format.

*The IBES CRSP Linking Table requires subscriptions to both the IBES and CRSP databases.*

**Using SAS Studio**

Students will be introduced to SAS and SAS Studio and will learn the following upon completion of the exercise:

• Accessing WRDS data through SAS Studio

• Using the table view to filter data

• Write and read a basic data step in SAS Studio

• Export a table in SAS Studio

**Using PC-SAS on Windows**

The objective of this exercise is to introduce students to the basics of connecting to WRDS using PC-SAS for Windows. Students will learn how to sign on to SAS remotely and build a query to download stock price data. After being taught the details of the SAS data step within the query, students will export the newly retrieved data to Excel.

**SAS Visual Analytics**

Using source data from CRSP, WRDS has prepared an interactive demonstration using SAS Visual Analytics. Students are introduced to features of SAS Visual Analytics and taught how to edit a report by replacing variables and reviewing interactions across data objects. Students also learn how to create hierarchies to add drill-down functionality to reports.

*Requires a CRSP annual stock subscription.*

**Introduction to Financial Statements**

Students will become conversant in executing web queries to download financial data. They will also validate important components of the balance sheet, income statement, and statement of cash flows for a company of their choosing.

**Income Statement**

Students will become conversant in executing web queries to download financial data. They will also become familiar with the basic components of a company's income statement.

**Balance Sheet**

Students will become conversant in executing web queries to download financial data. They will also validate the balance of assets and liabilities/equity in a company's balance sheet.

**Statement of Cash Flows**

Students will become conversant in executing web queries to download financial data. They will also become familiar with key components of a company's statement of cash flows.

**Linking Financial Statements**

Publicly traded companies disclose their financial information in the form of a balance sheet, income statement, and statement of cash flows. How exactly are these financial statements related to each other? This teaching tool guides students through a basic exercise with a real company to discover just how the statements are interrelated.

**Financial Ratios Visualization**

Using the interactive application, students will learn how to generate and compare financial ratios to one another and to baseline industry measures. They will be introduced to ratios in the following categories: valuation, profitability, capitalization, financial soundness, solvency, liquidity, and efficiency. Students can select individual companies or entire industries from the S&P 500 universe.

**Firm Liquidity Ratios**

Students will learn about four financial ratios used to determine liquidity: (1) the cash conversion cycle; (2) cash ratio; (3) current ratio; and (4) quick ratio (acid-test). While comparing ratios between companies from different industry sectors, students consider how different factors influence the analysis. The tool makes visual comparisons easy, as students use detailed graphs to consider ratios in the context of relevant industry sectors.

**Accounting and Accountability**

Companies whose stocks trade on U.S. exchanges are required to disclose their financial condition via 10-Q and 10-K filings. To help ensure accuracy and integrity, financial statements are audited by professional firms. This teaching tool introduces students to the concept of financial accountability and guides them through an exercise in detecting an issue related to proper disclosure.

* Requires a subscription to the WRDS SEC Analytics Suite.*

**Three Levers of Performance**

This exercise will acquaint students with the different methods that companies use to deliver financial performance to their shareholders. One of the most popular metrics for performance is ROE, which is a measure of how much the company earns per share invested.

**Beta Visualization**

Two important and related measures that arise from the Capital Asset Pricing Model are beta and R^{2}. In this teaching tool, students conduct an exercise using the Beta Visualization application to examine, compare, and interpret these important measures of equity risk.

Watch the video for a guided tour.

**Market and Firm-Specific Risk**

This teaching tool extends the Beta Visualization tool by focusing on alpha as defined in the Capital Asset Pricing Model. Students will learn how to interpret alpha and beta in the context of firm-specific and market risk. They will also become acquainted with R^{2} and the importance of model fit. The assignment guides students through the process of locating stocks with high/low alphas, and then interpreting the results.

**Porfolio Risk Over Time**

Students will learn how to use returns and a measure of risk such as standard deviation to execute a stock-selection strategy. They will become conversant in building and executing WRDS web queries, and validating the output. Excel skills are also developed, as students are challenged to manage their data from a raw format to a more structured and presentable one.

**Mechanics of Diversification**

This teaching tool includes three different activities designed to teach students about asset variance, covariance and the significance of positive and negative correlation. For example, students visualize a stock portfolio's total risk as they increase the number of stocks.

**Portfolio Diversification**

Students will understand how diversification works and the necessary steps required for achieving a diversified portfolio. They will learn concepts such as return, variance, standard deviation, and correlation. Students will also develop knowledge of the portfolio efficient frontier. Finally, they will develop skills in handling data, writing basic functions, and producing graphs in Excel.

**CAPM Equity Valuation**

Students will gain a working knowledge and understanding of the Capital Asset Pricing Model (CAPM). They will also develop intermediate Excel skills by building a regression model in the software. Students can select to use either stock or Exchange-Traded Fund (ETF) returns. Both slide decks provide step-by-step instructions for running the regression using Excel.

**Fama-French Three-Factor Analysis**

Students learn how to perform a multiple linear regression using exchange-traded fund (ETF) returns and the Fama-French market, size, and value factors. Detailed instructions are provided to guide students through the process in Excel. Examining the data, students analyze how well fund excess returns are explained by the Fama-French factors.

**Estimating Volatility**

In this exercise, students will learn to do the following:

- Identify volatility clustering using appropriate measures and graphs.
- Estimate the econometric model using MATLAB.
- Interpret model coefficients and graphs.
- Run statistical tests on the return series to investigate how well the model fits the data.

**Mutual Fund Turnover**

The objective of this exercise is to understand mutual fund turnover and its tax implications by conducting an Excel-based assignment.

**Efficient Frontier**

Using the interactive platform, students will learn how risk and return characteristics change as stocks are added and removed from a hypothetical portfolio. They will be introduced to such concepts as the efficient frontier, capital market line, and indifference curve.

**Backtester**

Depending on a course’s pedagogical goals, students have the ability to control different aspects of their backtests, including start and end dates, number of securities per portfolio, investment style, weights and rebalancing frequency.

- Multiple graphs and tables for deciphering results
- Summary recaps the test’s parameters, displaying investment performance

*Requires a subscription to CRSP.*

**OTIS Trading Simulator**

OTIS is a multifaceted trading simulation platform used to apply the concepts of investments and portfolio management. Teach students the nuances of portfolio management by experiencing the impact of market fluctuations on a virtual portfolio.

Created by faculty of The Wharton School, OTIS offers invaluable practice for students learning about investments. Packed with features to enhance the instructor's syllabus, OTIS introduces students to the competitive world of investing.

*Additional subscription required.*

**Event Study**

Students will learn how to identify an event and create the necessary input file. They will then configure the input parameters and execute the query. Finally, students will be tasked with analyzing and interpreting the event study output.

*Requires a subscription to the WRDS Event Study Suite.*

**Futures Contracts**

Students are introduced to important futures trading concepts, such as contract size, tick size, contract value, and margin requirements. In the assignment, students use the interactive tool to calculate their potential profit or loss on a futures trade after specifying the necessary parameters.

**Time Value of Money: Compound Interest**

Students will understand the distinction between simple and compound interest, as well as how time, rates, and compounding frequency affect the future value of an investment.

**Time Value of Money: Present and Future Value**

Students understand the relationship between present value and future value and learn to compare cash flows at different points in time.

**Bond Valuation**

This introduction to bond valuation begins by describing the features of fixed rate coupon bonds, and provides step-by-step instructions for computing the fair price of a bond. Students complete an assignment using an interactive tool that enables them to change key input variables and examine their effect upon the bond’s price. The tool also introduces the concept of Macaulay duration.

**Reinvestment Risk: Bonds**

When a significant portion of a bond investor’s revenue is dependent upon reinvesting coupon payments, it becomes essential to understand and assess reinvestment risk. Students explore the difference between yield to maturity and realized compound yield in this introduction to reinvestment risk.

**Aggregate Demand and Aggregate Supply**

Given a list of possible scenarios, students learn how each macroeconomic event shifts the aggregate-demand and aggregate-supply curves. Students are also asked to consider the effects of the changing equilibrium.

**Purchasing Power Parity (PPP) GDP**

Students will learn the theory of purchasing power parity (PPP) and why economists use PPP GDP to compare GDP across countries. After completion of an assignment, they will also become familiar with some of the macroeconomic data available in the Penn World Table.

**Fiscal Policy: Multiplier Effect**

The Multiplier Effect tool depicts how the government-induced chain of spending accumulates and results in an amplified change in GDP. Students will learn how the multiplier is calculated and how it works over time. They will also understand how the marginal propensity to consume (MPC) relates to the multiplier, and how the government spending multiplier differs from the tax multiplier.

**Treasury Yield Curve**

How is the U.S. Treasury yield curve used as a benchmarking and forecasting tool? Through the course of this assignment, students will learn to recognize different yield curve shapes and how these shapes may be viewed as indicators of macroeconomic conditions.

**Foreign Exchange Rates**

Upon completing the assignment, students will:

- Understand factors that can affect the value of a currency’s exchange rate
- Learn how to interpret foreign exchange charts to better understand the mechanics of currency exchange rates

**SEC Analytics Suite**

WRDS' proprietary SEC research platform is used in such disciplines as corporate due diligence, forensic accounting, disclosure research, and investment management. After completing the slide deck, researchers will have an understanding of the different components of the Suite.

*Requires a subscription to the WRDS SEC Analytics Suite.*

**SEC Filings Search**

WRDS' proprietary SEC research platform is used in such disciplines as corporate due diligence, forensic accounting, disclosure research, and investment management. After completing the slide deck, students will have an understanding of the different components of the Suite.

*Requires a subscription to the WRDS SEC Analytics Suite.*

**SEC Filings Search Forward Looking Statements**

In this case students execute a keyword search to identify forward-looking statements that anticipate the release of an economically significant product release from the Coca-Cola Company.

*Requires a subscription to the WRDS SEC Analytics Suite.*

**Introduction to Text Analysis**

Designed to introduce basic concepts of text analysis, this teaching tool generates a word cloud as a visualization of word frequency distribution. Students learn about commonly used methods for preparing digital text for analysis by selecting different options on the interactive tool and seeing what happens to the word cloud as different text processing methods are applied.

**Introduction to Sentiment Analysis**

How does sentiment analysis work? What criteria are used to determine text polarity? In an engaging exercise using song lyrics, students participate in a demonstration of how text can be classified as positive, negative or neutral.

**Sentiment Analysis Lexicons**

While there are many advanced approaches to sentiment analysis, a basic understanding of the creation and use of sentiment lexicons is important foundational knowledge in the field. Students are asked to use an interactive application to investigate how selecting different sentiment lexicons changes the sentiment analysis of the sample text.

**Named-Entity Recognition**

In this teaching tool, students learn what NER is, as well as some of its applications. Students will be introduced to some of the features that NER systems use in the decision making process, such as wordshape, part-of-speech (POS) tagging, and the use of neighboring words. Students will also be asked to consider some of the challenges faced in the NER process.

**Machine Learning: Text Classification**

An overview of supervised machine learning is presented, followed by a step-by-step explanation of how a naïve Bayes classifier works for text classification. Topics covered include some of the parameters used for evaluating classifiers, as well as the tf-idf weighting strategy commonly used in text analysis.

**Unsupervised Machine Learning: Clustering**

The k-means clustering algorithm is one of the most popular methods used today in unsupervised machine learning. Students are taken through a step-by-step explanation of how the k-means clustering algorithm works. Then, using an interactive tool, students investigate how well the k-means clustering algorithm performs in a text classification task using business articles.