Archive

Archive for the ‘Updates’ Category

New online guides: Using specialist business databases

25 February 2019 Leave a comment

You may not have seen many updates on Business Research Plus lately. That’s because we have been busy working on a new set of online resources…

keys banner purple

The Using specialist business database guides are written to help students and researchers to make effective and accurate use of the specialist financial and business databases available at The University of Manchester. They are designed to help you to help yourselves, where possible. The guides titled “Getting help in [name of database]” will direct you to the training and support that is offered by the provider of that database. The other guides offer tips, research skills and common pitfalls to avoid. Some of our workshop handouts are here too.

If you find that these guides are not enough, you may wish to search our blog Business Research Plus for older posts that go into much more detail.

How are the guides organised?

Visit the guides homepage for a list of all the guides. They are organised into the following topics.

Advertisements
Categories: Updates

WRDS website and access (updated October 2015)

21 October 2015 2 comments

(This post is a new version of WRDS website and access, July 2010)

WRDS (Wharton Research Data Service) is not really a database itself. It is a system designed to give researchers access to a range of financial databases (CRSP, Compustat, CCM, Compustat Execucomp, LSPD) though a common interface, and with integrated support.

Access to WRDS is via a username and password. Some taught modules provide students with a “class account” (such as Advanced Empirical Finance). MSc students, PhD students and academic staff can apply for their own username and password by following the instructions below. (Choosing the account type as PhD or Faculty provides extra capabilities for running SAS programs on the WRDS system.)

WRDS homepage 2015

Creating a WRDS account (postgraduate students)

For instructions to apply for your own username and password, please see the following guide.

  1. Go to WRDS start page.
  2. Under the login boxes, click on link Register for a WRDS Account.
  3. Fill in the details as follows:
    1. Institution: University of Manchester
    2. Affiliation With Institution: Masters Student | Ph.D. Student
    3. First Name: your first name
    4. Last Name: your last name
    5. Email: must be your University email address
    6. Department: your school and division name
    7. Desired Username: University username mxxxxxxx is recommended
    8. When Do You Expect Your Degree?: End date from your library card
  4. Press Submit.
  5. An email will be sent to our library admin staff who should activate your account within 24 hours.
  6. You will receive an email explaining that your account has been activated. It will include a default password that you can change.

Creating a WRDS account (staff)

In Step 3.2 Affiliation With Institution, choose Faculty, Staff (IT/Librarian) or Research Assistant. If you are a ‘Research Assistant’, please also provide the name and email address of your supervisor. Lecturers and professors should choose ‘Faculty’; PSS, Library and IT staff should choose ‘Staff’.

Creating a WRDS account (undergraduate students)

In order for undergraduate students to have access to WRDS, a ‘Class’ account must be created by a lecturer for the subject your are undertaking. Ask your lecturer if you think you need this; they will need to follow the same steps as above except choose ‘Class’ in Step 3.2 and provide the course code.

 

 

Where can I find a company’s date of incorporation or year founded?

For UK companies

In Fame, the date of incorporation in the Company report, under the Legal & accounts information section.

For US companies

Use Field-Ritter Dataset of Company Founding Dates (Firms going public in the US 1975-2014, last updated 14 April 2014)

For companies in any country

In Datastream, Use a Static Request and the Worldscope datatypes:

  • WC18272 – Date Company Founded
  • WC18273 – Date of Incorporation

Finding working papers

There are many relevant sources for working papers, including:

Insider trading

16 July 2015 Leave a comment

Definition of Insider Trading (from Investopedia):

The buying or selling of a security by someone who has access to material, nonpublic information about the security.

Companies in any country

Use ThomsonONE.com

  • Search for the company you want.
  • Click on the Company Analysis > Ownership folder, and select Insider Holdings or Insider Transactions report.
  • Click “Click here for full history” for historic holdings (older than 24 months).

Use Capital IQ

  • Search for the company you want.
  • On the long menu down the left, choose Investors > Public Ownership, then the Insider Trading tab.
  • Only the last 12 months are available.

Use Bloomberg (available in the Finance Zone and Precinct Library)

  • Try Bloomberg function PHDC for a specific company (e.g. VOD LN <F8> PHDC <GO>) and select Insiders, sorted by size.
  • You can also look up the biographies of executies/directors (BIO) and then choose Reported Holdings.
  • For stocks that have experienced the most purchases and sales by insiders, type: INSD and hit Go. Use the fields at the top of the screen to select country, time period, type of transaction. Click on a stock to display a graph of its historical prices with date of insider transactions.
  • For more info, type: insider and hit the green Help key <F1>.

Companies in the U.S. only

Use WRDS

  • Choose Thomson Reuters database, and then Insiders Data. Search by company ticker. Check the variables you want in your report.

Others

  • Insider filings with the U.S. SEC are available through Edgar. Enter your company name or ticker symbol or CIK and Include Ownership forms.
  • Insider transactions are available by issuer and reporting owner. Take a look at the website SecForm4.Com

Current and historical company annual reports

Company websites

For current annual reports, a company’s website is often the quickest and easiest option.

Databases that The University of Manchester subscribes to:

  • PI Navigator: Include Annuals / 10K / 20-F (Company Reports and Accounts) in search criteria or select Perfect Filings tab and include Document Type UK Annual Reports or similar depending on your search.
  • Mergent Archives: Select Search Mergent Achives for annual report search
  • Thomson Research: Quick Company Search: and Content Profile, Filings
  • Thomson ONE.com: Annual reports are under Filings tab

Annual reports websites

Try EDGAR for reports filed with US SEC.

Intraday quotes for equities and indices

Global source

Use Bloomberg.

For Equities and Indices:

Type the stock’s ticker symbol then hit [EQUITY] and hit <GO>

Choose: GIP – Intraday Price Graph

You can change the date and the time interval.

or

Type the index symbol then hit [INDEX], and then type GIP or GIT and hit <GO>

For example, to get intraday price intervals for the S&P 500:

SPX [INDEX] GIT and hit <GO>

Note: limited historical intraday data is available approx 900 trading days for GIP and 50 trading days for GIT.

Other sources

For US stocks, go to Wharton Research Data Services (WRDS) TAQ (New York Stock Exchange Trade and Quote, or NYSE TAQ.

For historical (1983-1992) NYSE and AMEX tick-by-tick data and for historical NASDAQ (1987-1992) tick-by-tick data, click on ISSM – Institute for the Study of Security Markets

TICKDATA provides a commercial service offering intraday data from the UK and other exchanges.

Finally, Thomson Reuters Tick History database offers global intra-day Time and Sales, Time and Quotes and Market Depth content from the 1st January 1996 for an extensive range of Equities, including their derivatives. Access to this resource is limited; please contact us.