Overlapping listed period for `TT.US Equity` and `VAL.US Equity`

Alphathon
#1

df is the table returned by getTickersSP500().


df[df["ticker"]=="TT.US Equity"] shows “TT.US Equity” corresponds to two companies:

  1. “Trane Inc.” listed from 2002-05-10 to 2008-06-5
  2. "Trane Techonologies plc" listed from 1970-01-01 to 2009-06-29 and 2010-11-16 to now

Similarly, df[df["ticker"]=="VAL.US Equity"] shows “VAL.US Equity” corresponds to two companies

  1. Ensco plc listed from 1970-0101 to 2009-12-21 and 2012-07-30 to 2016-03-28
  2. Valaris plc listed from 2007-01-03 to now

I believe in either case a same ticker corresponds to two DIFFERENT companies since there is unexpected overlapping listed periods. Can anyone explain this? Is this an error of the table or my misunderstanding of data?


Thank you in advance for answering!


#2

+1 for this

#3

Without entering too much into details, the 2 cases you mention are actually legit: Trane and Trane technologies are the same company; same for Ensco and Valaris (after some consolidations / merger activities / rebranding).

We’ll though correct date ranges so that overlaps don’t happen.

#4

Hi Herve,


Thank you for the timely explanation!


Cheers!

#5

Hi Lutaodai,


We have checked and corrected the dates.


Thank you!

#6

Hi Reiyun,


Thank you for the prompt response. That’s very helpful!