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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
16 1 1 3

Sometimes suffvolmoneyness return data and sometimes not

Hi,

Sometimes I get data and sometimes I do not when using this function (found on the pages). Any ideas?

df, err = ek.get_data(RIC,["TR.SurfVolMoneyness.tenor","TR.SurfVolMoneyness.range", "TR.SurfVolMoneyness"],{"Range":"50;200", "Tenor":"1M;12M", "VolType":"MID"})

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythondata
icon clock
10 |1500

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

Upvotes
Accepted
39.2k 75 11 27

Add raw_output=True parameter as follows:

ek.get_data([".FTSE"],["TR.SurfVolMoneyness.tenor","TR.SurfVolMoneyness.range", "TR.SurfVolMoneyness"],{"Range":"50;200", "Tenor":"1M;12M", "VolType":"MID"},raw_output=True)

With raw_output=True get_data method returns raw JSON from the Web service providing the data as opposed to a tuple containing pandas dataframe and error when raw_output=False or omitted.
What does get_data method return with raw_output=True?

icon clock
10 |1500

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

Upvotes
39.2k 75 11 27

Do you see any patterns for when you get and don't get the data requested? Is it the same RIC every time? When you don't get the data, do you get any error messages? Is anything returned into err variable? Is an exception raised? What exactly are the symptoms you experience?

icon clock
10 |1500

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

Upvotes
16 1 1 3

Hi

Content of err: [{'code': 412, 'col': 1, 'message': 'Unable to resolve all requested identifiers.', 'row': 0}, {'code': 412, 'col': 2, 'message': 'Unable to resolve all requested identifiers.', 'row': 0}, {'code': 412, 'col': 3, 'message': 'Unable to resolve all requested identifiers.', 'row': 0}]

icon clock
10 |1500

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

This error message indicates that the RIC in the request is invalid.

Upvotes
16 1 1 3

Worked last night for RIC=.ftse, Doesn't work this morning for .ftse and ERR=''

icon clock
10 |1500

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

Did you mean to include the error message? If you did, the error message didn't post. I'm not reproducing on my end any problem retrieving this data for RIC=".FTSE". Are you able to retrieve the same data in Excel using =TR(".FTSE","TR.SurfVolMoneyness.tenor;TR.SurfVolMoneyness.range;TR.SurfVolMoneyness","Range=50;200 Tenor=1M;12M VolType=MID") worksheet function?

Upvotes
16 1 1 3

There was no error message. Yes, it works in Excel (Windows) but not in Python (Mac).

icon clock
10 |1500

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

I'm confused. If there was no error message, what symptoms did you see?

Upvotes
16 1 1 3

No data and no error message is what I see.

icon clock
10 |1500

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

Click below to post an Idea Post Idea