Why does Eikon Python API return empty fields on certain names?

Question

Question by winnie · Dec 16, 2019 at 09:26 PM · eikon eikon-data-api workspace workspace-data-api refinitiv-dataplatform-eikon python derivatives volatility

Why does Eikon Python API return empty fields on certain names?

I use the function eikon.get_data() from Eikon Python API to retrieve option data. The fields I use are 'TR.OPWAskImpliedVolatility' and 'TR.OPWBidImpliedVolatility'. Sometimes I got empty data while I am able to see the numbers in the DIB window in Eikon API. For example, I can see the values of these two fields for the Ford Motors options by clicking on the fields in Eikon DIB, while the Python API is returning empty data.

0 Show 2

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.

REFINITIV

zoya faberov ♦♦ · Dec 16, 2019 at 09:36 PM 0

Share

Hello @winnie,

Please include the request you are issuing, that is populated in DIB but not via Eikon Data API, and we will take a look on our side.

winnie zoya faberov ♦♦ · Dec 16, 2019 at 09:42 PM 0

Share

The request I pull is eikon.get_data('FL201900950.U', ['TR.OPWAskImpliedVolatility', 'TR.OPWBidImpliedVolatility'])

Answer 1 · 2019-12-17T06:23:50Z

REFINITIV

Best Answer

Answer by Jirapongse · Dec 17, 2019 at 06:23 AM

@winnie

It is because of this RIC <FF192000900.U>. If I removed this RIC, the data can be retrieved properly.

I also got the error when using Eikon Excel. It returned "Unable to collect data for all requested fields." Because the problem also happens with Eikon Excel, you can contact the Eikon support team to verify the problem.

1576563558401.png (48.7 KiB)

0 · 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 · 2019-12-16T21:53:27Z

REFINITIV

Answer by zoya faberov · Dec 16, 2019 at 09:53 PM

Hello @winnie,

I see the result on the same request, please retry on your side:

capture.gif (12.2 KiB)

0 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.

winnie · Dec 16, 2019 at 10:44 PM 0

Share

Thanks for the reply. I tried again and found that I could get data for this single ticker, while with a list of tickers it's returning empty data:

opt_list = ['FL201900950.U', 'FX201900950.U', 'FA172000900.U', 'FM172000900.U', 'FC202000900.U', 'FO202000900.U', 'FF192000900.U', 'FR192000900.U', 'FA152101000.U', 'FM152101000.U', 'FA212201000.U', 'FM212201000.U']

eikon.get_data(opt_list, ['BID', 'ASK', 'TR.OPWAskImpliedVolatility', 'TR.OPWBidImpliedVolatility'])[0]

reuters-check.png (15.5 KiB)

Why does Eikon Python API return empty fields on certain names?

2 Replies

Watch this question

Related Questions