When you search for IPOs in the Deals Analysis module of Thomson One Banker, and request the ISIN and/or SEDOL-code (to be able to retrieve additional stock data from Datastream or annual report data from Thomson One Banker) you’ll see that a lot of codes seem to be missing.
This is caused by the fact that the Equity module of Deals Analysis also includes announced, rumoured, postponed and cancelled IPOs. If you add the search criterium Transaction Status = Live, you’ll see that most IPOs will have at least a ISIN or a SEDOL-code. You can also include the Transaction Status to your report, to filter for Live IPOs afterwards.
Need to know more about searching for IPOs? Check the manual.