Obtaining Effective From and To Date Times for firms' former names

Options
JonasNp
JonasNp Newcomer
edited July 24 in Refinitiv Data Platform Libraries

Hi,

I am using the python module lseg-data to retrieve the former names of certain firms by using the following formula:

import lseg.data as ld

df = ld.get_data(universe=['4295904307'], fields=['TR.FormerlyKnownAsName'])

While this code downloads the list of names, I was wondering if there is some way to access the 'Effective From Date Time' and 'Effective To Date Time' metadata, which seems to be available when browsing the field TR.FormerlyKnownAsName for a certain PermID in the Data Item Browser.

I have tried using a Definition object to see whether I could get a rawer response, but the dates do not seem to be there either.

Does anyone know how to retrieve that information?

Many thanks in advance.

Tagged:

Best Answer

  • Gurpreet
    Gurpreet admin
    Answer ✓

    Hello @JonasNp

    You can specify the output parameters as the part of field to get additional information. These parameters can also be seen in the Data Item Browser.

    Try this - 

    ld.get_data(universe=['4295904307'], 
            fields=['TR.FormerlyKnownAsName', 'TR.FormerlyKnownAsName.effectiveFromDateTime', 
                    'TR.FormerlyKnownAsName.effectiveToDateTime', 'TR.FormerlyKnownAsName.code',
                    'TR.FormerlyKnownAsName.rank'])
    image.png

Answers

Categories