Database and Data Management

This is the course website for Database and Data Management.

Note

This is still under development and changes will be made.

• Class01
  • Introduction to WRDS
    • History
    • Development
    • WRDS access
  • Introduction to Python
    • Install Anaconda
    • Python editors
      • Jupyter Notebook
      • VSCode
      • Other editors
    • Retrieve WRDS data
• Class02
  • CRSP overview
    • Web access
    • Identifiers
    • Stock exchange code
    • Share code
    • Stock price
    • Market value
    • Volume
  • Python
  • Stata
• Class03
  • Compustat North America overview
    • Web access
    • Industry Format
    • Identifiers
    • Datadate vs fiscal year
    • Stock exchange code
  • Python
  • Stata
• Class04
  • Datastream
    • Overview
    • Access
      • Where to find Eikon terminal
      • How to login
    • Company list
      • How to screen company list
      • Company list from other database
    • Static data
    • Time series data
    • Data format
  • Python
  • Stata
• Class05
  • Execucomp overview
    • Web access
    • Identifiers
    • Important variables
  • Python
  • Stata
• Class06
  • Compustat Global overview
    • Web access
    • Identifiers
    • Primary share
    • Issue type code
    • Country code
    • Stock price
  • Python
  • Stata
• Class07
  • Regression
  • Python
  • Stata