To search for delisted companies open Excel and click on the Datastream tab at the top. Click on Datastream Formula, then select Find Series. Scroll down the left-hand menu to the Activity category and choose Dead.
Datastream is available in the Financial Room of IESE’s Barcelona Library as well as at the Madrid Library, through LSEG Workspace (formerly Refinitiv Workspace).