These are tricky, even if you are familiar with CRSP/Compustat. As always, when variable-hunting, you should experiment on data you know to be correct, like 10-K data, or perhaps published data from Google or Yahoo, and try and zero in on the correct variables. And, when possible, do not make your own formulas, you should use Compustat, e.g., for EPS I would use EPXPX, or possible EPSPI, but not try and calculate from Net Income ($M)/Shares (M). Note that PE is EPS/Common Shares, and you were calculating EPS. So you would need to use Price/EPSPX, or better, find a PE already calculated.
Previous | Back to STAT 486/686 Assignments FAQ | Next |