I would like to find companies who left or joined an index within an specific timestamp but I'm not sure I'm getting at it correctly.
I've tried this on Excel (assuming it also works in Python):
And I get an outcome, but only for a single company.
However, if I play with the date range of the TR formula, I get NULL values.
If I wanted to get the joiners/leavers for, let's say 5 years, how I would need to do so?
Thanks in advance for any help.