Am not using ‘CIK’ for search.

Can someone tell me what this error is and how I can fix this?

]]>I am calculating book leverage ratio in COMPUSTAT. There are some firm-year have missing value of debt. I understand that sometimes COMPUSTAT documents missing value of debt even the liabilities are non-zero. In those cases, it’s better to replace the missing debt value as zero. But I have trouble to find the corresponding COMPUSTAT items for debt and liabilities to do this conversion.

Can someone please tell me what COMPUSTAT data itmes should I use, and is there a better way to treat the missing debt value?

Best,

Bo

I am looking for annual industry sales (i.e., annual sales per SIC number) for both global and US regions.

When entering a SIC code for the global firms, Compustat gives me a list of all firms and the sales for each firm. Given the different currencies these are reported in, these cannot be simply aggregated in order to get the aggregated industry sales. Is there any way to directly obtain the sales per SIC code without converting all the local currencies one-by-one to US dollars?

Thanks in advance,

Mare

I have a question about global stock exchange information in wrds. For example, Some firms are in NYSE or NASDAQ, and some are in Euronext… Where can I find the stock exchange information in wrds?

Thanks for help!

L

]]>How can i find in how many segments a firm is operating??

I did found the segments name sometimes differ per company, but than they still have the same SIC code (or missing SIC).

I need this to calculate the entropy measure of diversification.

thank you in advance, Eva

]]>could you please help me in finding the variable for cash and cash equivalents in Compustat? I need it to calculate an adjusted enterprise value. Is it CHE—Cash and Short-Term Investments?

Thanks in advance!

]]>I am currently trying to compute the total Enterprise value, which has been calculated as total assets less book value of equity plus product of price per common share and number of common shares outstanding.

While I find total assets (AT) in Compustat, I cannot find book value of equity. There is only Book Value of Equity per Share (BKVLPS). Could you please help me in finding the book value of equity?

Thanks in advance!

]]>I need the ratios Foreign Sales to Total Sales and foreign Assets to Total assets of some S&P 500 companies.

How can I get the foreign Sales / foreign assets data in compustat?

Thanks a lot, your help is greatly appreciated.

Ferdinand

]]>