Hi everyone,
I am trying to measure firm's industry stock beta following the methodology used in the JFE paper "The influence of product market dynamics on a firm’s cash holdings and hedging behavior" by
David Haushalter, Sandy Klasa and William F. Maxwell (2007). I am quoting their methodology here,
"To measure how firms’ growth opportunities co-vary with those of their industry rivals, we calculate the correlation of firm stock returns with industry stock returns. The methodology used to calculate our correlation measure is similar to that in Parrino (1997). Using monthly stock return data from 1993 to 2001, we regress a firm’s monthly stock return on the monthly Center for Research in Security Prices (CRSP) equally weighted market return and the monthly equally weighted return for the index of firms sharing the same Compustat two-digit Standard Industrial Classification (SIC) code as the firm. The regression coefficient on the industry return index is then used as the proxy for the correlation between the firm’s stock returns with industry stock returns. To calculate these correlation measures we require that CRSP has at least 24 months of returns data for a firm."
I have collected the CRSP data on stock price, SIC code and equally weighted market return. I know it's a long process but will really appreciate it if someone can guide me towards the proper coding to get this beta!
Thanks in advance!
Related Posts with How to measure firm's industry stock beta?
I need help to create a lagged variableI am currently working on a dataset (monthly flows of tourists between each pair of regions (O-D) du…
Non-linear term in a Cox ModelHello, I am currently working on a project that seeks to understand the relationship between socioe…
How do i drop earliest date for specific ID variablesI have a dataset where patientes have specific ID-numbers. They also have one specific ID for every …
Creating WeightsI am trying to create a weighted wage, using employment and wage. I tried the following command, but…
How do i drop all dates, except the earliest date for specific ID variablesI have a dataset where patients have specific ID-numbers. They also have one specific ID for every t…
Subscribe to:
Post Comments (Atom)
0 Response to How to measure firm's industry stock beta?
Post a Comment