For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
12 2 3 5

Eikon API - multiple duplicate index when ric is expired

When I query a ric that is expired I obtain a time series with multiple duplicate indexes.

Do you know how to fix this?


Example:


import eikon as ek

result = ek.get_timeseries( 'LCON2' )



example.png




eikon-data-api
example.png (179.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvote
Accepted
5.1k 8 5 8

hi @davide.costanzo ,

First, to get the expired RIC, get_data can be used to find the RIC of expired instrument

df, err = ek.get_data(['LCON2'], [ 'TR.RIC'])
df

1655958404897.png

The RIC is LCON2^2, then use get_timeseries to retrieve the data. Please see the code and output below

result = ek.get_timeseries( 'LCON2^2')
result

1655958501968.png

Hope this helps


1655958404897.png (9.1 KiB)
1655958501968.png (19.7 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.