Hi there,

Im currently working on a project in which i have to compute the marketcap of an acquirer 11 days before the announcement date (t-11). But Per acquirer I have got multiple acquisitions, which means multiple announcements dates.

If I want to compute the marketcap of the acquirer 11 days before the announcement date, stata does not recognize the fact that i ve got multiple transactions per acquirer...
Every acquirer has a Unique code (cusip6)

This is the code Im running, but it is wrong...:




"bysort dateannounced: gen marketcap_acquirer = (share_outstanding * price) if t== -11 "



What am I doing wrong?
Could anyone help me out?

Thanks in advance

Noud