RGEN event not returning - why?

mjg
mjg Explorer
in Eikon Data APIs

hi, thosands of rows come back from this query:

but ticker RGEN, which has an event, that is in the Eikon database, is not in there- why?

import eikon as ek

# initialize eikon here successfully

events_df, err = ek.get_data(
    instruments=['0#.NDX',  '0#.NYA'],
    fields=[
        'TR.EventStartDate',
        'TR.EventType',
        'TR.EventTitle',
        'TR.EventStatus',
        'TR.EventCountry',
        'TR.EventLastUpdate',
        'TR.EventStartTime',
        'TR.EventEndDate',
        'TR.EventEndTime',
        'TR.EventStartQualifier',
        'TR.EventEndQualifier'
    ],
    parameters={
        'SDate': '2022-9-12',
        'EDate': '2022-10-12',
        'EventType': 'ALL'
        }
    )

print (events_df)
Tagged:

Best Answer

  • zoya faberov
    zoya faberov ✭✭✭✭✭
    Answer ✓

    Hello @mjg ,

    As mentioned by @jason.ramchandani01, it seems the core of the matter is that RGEN.O or RGEN.OQ are not a member of indices .NDX and .NIA.

    ek.get_data('RGEN.O',['TR.MemberIndexRic','TR.MemberIndexName'])

    Results in 63 different indices, but not these two:

    indices.gif

    As a separate requested item, RGEN.O or RGEN.OQ both capture one, the same, event in the result:

    events_df, err = ek.get_data(
        instruments=['RGEN.O','RGEN.OQ'],
        fields=[
            'TR.EventStartDate',
            'TR.EventType',
            'TR.EventTitle',
            'TR.EventStatus',
            'TR.EventCountry',
            'TR.EventLastUpdate',
            'TR.EventStartTime',
            'TR.EventEndDate',
            'TR.EventEndTime',
            'TR.EventStartQualifier',
            'TR.EventEndQualifier'
        ],
        parameters={
            'SDate': '2022-9-12',
            'EDate': '2022-10-12',
            'EventType': 'ALL'
            }
        )

    print (events_df)

    Getting back:

    events.gif

    And as I have noticed from the first result, that RGEN is part of .DZO index, also have tested:

    events_df, err = ek.get_data(
        instruments=['0#.DZO'],
        fields=[
            'TR.EventStartDate',
            'TR.EventType',
            'TR.EventTitle',
            'TR.EventStatus',
            'TR.EventCountry',
            'TR.EventLastUpdate',
            'TR.EventStartTime',
            'TR.EventEndDate',
            'TR.EventEndTime',
            'TR.EventStartQualifier',
            'TR.EventEndQualifier'
        ],
        parameters={
            'SDate': '2022-9-12',
            'EDate': '2022-10-12',
            'EventType': 'ALL'
            }
        )

    print (events_df)

    The result includes RGEN.OQ event that is the same event on 9-20. So by selecting one of the indices that RGEN is part of,, we could expect the events in their results.




Categories