Skip to content

Aggregating across permnos within a permco #167

@chenandrewy

Description

@chenandrewy

@ralphkoijen made me realize that we may not be aggregating market equity across permnos with a permco 🤦‍♂️

It seems like this is becoming more of a problem. Among stocks with B/M, multi-permno issues affect only about 1% of permnos, but they now affect about 4% of total market cap:

Image

I say about, because this was a pretty quick calculation that relies on intermediate outputs of our code here.

Then, valuation ratios for this 4% of market cap may be way off. For example, the market value of permno 90319 is $827b, but the total market cap of the company (Google) is roughly double that:

Image

We should check and fix this. From looking at the code this morning, I did not see any aggregation across permnos.

All of the market cap values used in signals seem to come from https://github.com/OpenSourceAP/CrossSection/blob/1aa9f0e27e7f89882d8664547031edef0e4ef9ec/Signals/Code/DataDownloads/I_CRSPmonthly.do

All it does to calculate mve_c is

gen mve_c = (shrout * abs(prc)) // Common shares outstanding * Price

and it seems like all the signals use mve_c as market equity.

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions