Consulting Skills Frameworks - BUSI554H: WRDS & More Data Sources

Detailed audit information on over 1,200 accounting firms and 15,000 publicly registered companies. Data taken from public company disclosures. Determine who is auditing whom and how much they are paying for what services. Create reports by auditor, fees, location, industry, client revenue, market capital, changes in auditors, and more.

In addition to audits, the data in Audit Analytics also covers information related to compliance, governance, corporate actions, and federal litigation. 2001-present.

Data on boards of directors of publicly-listed companies around the world. Includes 2 million corporate executives & board members from over 2.2 million organizations. Biographical data includes details such as age, gender, positions held, educational qualifications, compensation and stock holdings, as well as insights into the executive’s professional network.

Coverage varies by data set. Some starts in 1999.

Link CRSP market and corporate action data with Compustat fundamental data; search by Permno, Permco (CRSP), and or GVKEY identifiers (Compustat). Search CRSP and COMPUSTAT time series data on companies and securities side by side, regardless of CUSIP or ticker changes.

Annual and quarterly of data for hundreds of data items, ratios and concepts covering thousands of publicly-traded companies in over 80 countries, including coverage of over 96% of European market capitalization and 88% of Asian market capitalization. Data for both current and inactive companies. 1987-present.

Information on the global commercial loan market. Contains comprehensive historical information on loan pricing and contracts details, terms, and conditions. Includes terms and conditions on over 200,000 loan transactions, which finance M&A activity, working capital needs, and other general corporate purposes for loan participants worldwide. Sources include regulatory filings, bank submissions, and journalist contributions.

Conduct event studies, such as a change in CEO or when a new tax regulation or other regulation was announced or took effect. Perform event studies using data read directly from CRSP stock databases or pre-extracted from other sources.

Includes utility programs to convert calendar dates to CRSP trading day numbers, convert CUSIP identifiers to CRSP permanent identification numbers, and extract event study cumulative or compounded abnormal returns for cross-sectional analysis.

Historical earnings estimate database containing analyst estimates for over 20 forecast measures – including EPS (earnings per share), revenue, price targets, EBITDA and pre-tax profits. These measures are available on both consensus and detailed levels, covering both U.S. and international companies. Also includes buy-hold-sell recommendations. I/B/E/S = Institutional Brokers’ Estimate System.

Designed to capture all insider activity as reported on SEC forms 3, 4, 5, and 144. Data is from Jan. 1986-present unless noted. Includes:

Table One: Table 1 non-derivative transaction and holdings information filed on Forms 3, 4, 5.
Table Two: Table 2 derivative transaction and holdings information filed on Form 3, 4, 5. Includes open market derivatives transactions as well as information on the award, exercise, and expiration of stock options.
Form 144: File contains the Proposed Sale file is derived from Form 144. This data includes the expected data of sale, the number of securities to be sold, the estimated market value of the proposed sales, and the name of the executing broker.
Average Returns: Info. relating to how a stock has historically performed following an insider’s transactions. Includes average 3-month and 6-month buy and sell returns as well as the number of historic buy and sell decisions for each individual insider.
Amendment Concordance: Links an amended filing to its original filing by way of DCN. This prevents double counting by allowing users to see which original filing is being replaced. The amendment concordance file is a full refresh every day. Please note: not all amended filings are included in this file, only those that meet our concordance criteria. Covers Oct. 2002-present.

Data from Thomson Financial.

Stock holdings and transactions by more than 4,300 Institutional Money Managers and money management companies. The Institutional Holdings data source is the actual 13f form filed with the SEC on a quarterly basis by money managers/management companies. The 13f data is aggregated to a manager level. Coverage is from 1980 to the present. (formerly known as CDA/Spectrum)

Includes historical option price, underlying security information, implied volatility, and sensitivity information for U.S. equity and index options markets.

Designed for empirical research. Data can be downloaded into a variety of statistical software packages allowing for analysis on all aspects of options investments including backtesting, trading strategies and evaluating risk models. 1996-present.

Issue details on over 140,000 corporate, corporate MTN (medium term note), supranational, U.S. Agency, and U.S. Treasury debt securities and includes more than 550 data items. Provides details on debt issues and the issuers, as well as transactions by insurance companies. Useful to research market trends, deal structures, issuer capital structures and other areas of fixed income debt research.

Offers tick-by-tick trade and quote data of all activity within the U.S. National Market System. Transaction information at the intraday level (to the microsecond) covering over 10,000 stock issues listed on 16 major American exchanges, including the New York Stock Exchange (NYSE), American Stock Exchange (AMEX), and Nasdaq.
See also: Trade and Quote – “Monthly Product”. 1993 – 2014

Sentiment analysis and event data focused on business and financial applications. Data includes news and social media content. Millions of analytical data points for articles on thousands of entities. These data points can be used to perform a wide variety of analysis on how entities are presented or covered by various Dow Jones News services.

Identify and assess environmental social and governance (ESG) risk incidents in a systematic way.
Includes 250,000+ listed and non-listed companies —15,000+ public companies and 235,000+ private companies. Offers risk metrics and underlying scores to assess and benchmark the risk exposure and business conduct of companies. Includes 101 ESG risk factors mapped to all companies. 2007-present, updated annually in October.