I have recently conducting a research on the determinant of securities offering. And I have about 1500 companies at different announcement dates (From 2000- 2018). However, I need to collect financial information for compaines prior to their annoucement.
For example, if a firm annouced to issue convertible bond at June 1st 2012, it does not make sense to use financial information after that. I have seen little references to deal with this issue in the literatures. My question is, how to I solve this issue without manually going through all 1500 companies. Thanks for your help !