How can I sum a field within a chain RIC?

Question

Question by michael.t.smith · Jul 31, 2020 at 07:27 PM · timeseries eikondataapi option chain openinterest sum

How can I sum a field within a chain RIC?

Looking to get the sum of OPINT_1 for an options chain RIC (0#KODK*.U) by puts and calls. I separated out the puts and calls into different lists. But I cannot find any instruction on how to now sum these values. As you can tell, I'm a beginner here. My goal is to look at the summed data in a time series.

fields = ['PUTCALLIND', 'STRIKE_PRC', 'OPINT_1']

kodk = ek.get_data('0#KODK*.U' , fields=fields)[0]

kodkputs = kodk[kodk['PUTCALLIND'] == 'PUT ']

kodkcalls = kodk[kodk['PUTCALLIND'] == 'CALL']

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2020-07-31T21:03:11Z

REFINITIV

Best Answer

Answer by Alex Putkov. · Jul 31, 2020 at 09:03 PM

Use the "sum" method on pandas series:

op_int_puts = kodkputs['OPINT_1'].sum()

1 · Share

10 |1500 characters needed characters left characters exceeded

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

Answer 2 · 2020-07-31T20:34:22Z

REFINITIV

Answer by chavalit.jintamalit · Jul 31, 2020 at 08:34 PM

Hi @michael.t.smith

If you would like to know how to sum() the data on a dataframe.

Here is the dataframe document.

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.sum.html

Here is the sample code:

kodkcalls['STRIKE_PRC'].sum()

1 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

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

michael.t.smith · Aug 01, 2020 at 11:21 AM 0

Share

thanks for the link to help. It will be very useful going forward.

How can I sum a field within a chain RIC?

2 Replies

Watch this question

Related Questions