Hi there,


I need the stockprice of the last day from the year before the announcementdate

I have all the stock-data and the announcement dates

For example:

The announcement date is 20-01-2010
Then I need the stockprice from the last day from the prior year

My dataset contains of multiple announcement days



Who could help me out?