Dear Statalist,

I would really apreciate any help/tips members have to offer on this topic.

I am working on pre-FOMC announcement drift and I am running an event study using Princeton guide : https://dss.princeton.edu/online_hel...ydataprep.html. However, the instruction are for a single event whereas in this case I am looking at abnormal excess returns around the FOMC announcements that happen 8 times a year. Therefore, I would need to count one day before the announcement day for each stock for 8 dates. My question is, is there any way to calculate it?

Also, I have two datasets : one is with the stock prices and dates of the prices, the second one is with FOMC announcement dates. Hence, FOMC dataset will be much smaller and I am still do not know how to merge these two in one dataset.

This is the screenshot of my dataset: first four columns arethe dates and dummy variables for FOMC dates and the rest are the stock prices and industry id.
Array



Thank you very much in advance.