Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
clangevin avatar image
39 ●3 ●7 ●4

call to get_data returns either open interest data or other fields data but not all at the same time

I need to retrieve the following options fields for all days in 2020.

The following call to get_data either returns open interests data with NaN in all other columns OR the value of all columns except Open Interst.

Could you please point what I'm doing wrong?

data_temp, err = ek.get_data(instruments = '/TFMB1900N1', \
                             fields = ['DSPLY_NAME',\
                                       'PUTCALLIND',\
                                       'STRIKE_PRC',\
                                       'CF_CLOSE',\
                                       'TR.OPENINTEREST',\
                                       'TR.OPENINTEREST.Date',\
                                       'IMP_VOLT',\
                                       'EXPIR_DATE'], 
                             parameters = {'SDate':'2020-01-01','EDate':'2020-10-14'})
eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apifutures
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.

wasin.w avatar image   wasin.w

Hello @clangevin

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.

Thanks,


AHS

Jirapongse avatar image   Jirapongse

@clangevin

Hi,

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

3 Answers

· Write an Answer
Upvotes
Accepted
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

Hi @clangevin

You can easily use "Data Item Browser" to confirm that the fields do not support timeseries on get_data() API call.

I capture 3 fields for your example:

DSPLY_NAME, PUTCALLIND = do not support timeseries

TR.OPENINTEREST = support time series


ahs.png (191.5 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.

clangevin avatar image clangevin

Thanks, my point was that the nature of the data isn't realtime, why Refinitiv implements it that way is another discussion...

I'll try to see what I can get using 'TR.OPENINTEREST(-1d)' calls.

clangevin avatar image clangevin

@ chavalit.jintamalit

Running the call to get_data below, as of today (16/10/2020):

data_temp, err = ek.get_data(instruments = 'TFMB1900N1', \
                             fields = ['DSPLY_NAME',\
                                       'PUTCALLIND',\
                                       'STRIKE_PRC',\
                                       'CF_CLOSE',\
                                       'TR.OPENINTEREST(-1m)',\
                                       'TR.OPENINTEREST(-1m).Date',\
                                       'EXPIR_DATE'])

Returns:

Why is the date 31/08/2020? That doesn't see to be 1 month ago.

How should I edit the call to get-data above to retrieve open interest for that RIC as of a month ago?

Thanks

1602848061264.png (44.6 KiB)
clangevin avatar image clangevin

Actually even the -1d call doesn't return yesterday's value:

data_temp, err = ek.get_data(instruments = 'TFMB1900N1', \
                             fields = ['DSPLY_NAME',\
                                       'PUTCALLIND',\
                                       'STRIKE_PRC',\
                                       'CF_CLOSE',\
                                       'TR.OPENINTEREST(-1d)',\
                                       'TR.OPENINTEREST(-1d).Date',\
                                       'EXPIR_DATE'])

Why does it return the 14th of October instead of the 15th?

1602849038981.png (19.5 KiB)
chavalit-jintamalit avatar image chavalit-jintamalit

Hi @clangevin

For the -1m, I think the parameter effects the field to be in monthly period.


For -1d, I cannot answer the content behavior related question as I am not a content expert.

If you wish to clarify a specific field with its parameters behavior, you can open a ticket to Refinitiv Content Helpdesk at https://my.refinitiv.com/

The helpdesk can use Eikon Excel to retrieve the same field with parameters and clarify your question.

ahs1.png (27.6 KiB)
ahs2.png (15.5 KiB)
Upvotes
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

Hi @clangevin


DSPLY_NAME, PUTCALLIND, STRIKE_PRC, CF_CLOSE, IMP_VOLT and EXPIR_DATE fields are from realtime database. They do no support timeseries data.


TR.OPENINTEREST and TR.OPENINTEREST.Date support timeseries data.



ahs.png (37.2 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.

Upvotes
clangevin avatar image
39 ●3 ●7 ●4

@ chavalit.jintamalit Can you check with your colleagues? It makes no sense that

DSPLY_NAME, PUTCALLIND, STRIKE_PRC, CF_CLOSE, IMP_VOLT and EXPIR_DATE

come from realtime data as those are not realtime data by nature.

I should be able to display all of the above along with the open interest data at close each day.

I'm certain this is possible, could you please check further?

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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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