Data Item returning NaN.

Question

Question by luis22 · Sep 03, 2018 at 10:04 AM · eikon python eikon-data-api workspace refinitiv-dataplatform-eikon workspace-data-api data-item-browser

Data Item returning NaN.

Hello, I am using the python eikon API, and the Data Item browser to get the code to do my queries, although when requesting the following TR I am getting NaN as a return, which is weird because I can see the value on the Data Item Browser but when making the request from python I get NaN.

Example of my code (all the values returned here are NaN):

debt_cy_minus1 = "TR.TotalDebtOutstanding(Period=FY-1,Curn=GBP)"
debt_cy = "TR.TotalDebtOutstanding(Period=FY0,Curn=GBP)"
cash_cy_minus1 = "TR.CashAndSTInvestments(Period=FY-1,Curn=GBP)"
cash_cy = "TR.CashAndSTInvestments(Period=FY0,Curn=GBP)"
enterprise_value_cy1 = "TR.EVMean(Period=FY1,Curn=GBP)"
revenue_cy_minus1 = "TR.Revenue(Period=FY-1,Curn=GBP)"
ebitda_cy_minus1 = "TR.EBITDA(Period=FY-1,Curn=GBP)"

queries = [debt_cy_minus1, debt_cy, cash_cy_minus1, cash_cy, enterprise_value_cy1, revenue_cy_minus1, ebitda_cy_minus1]

market = ek.get_data("LLOY.L", queries, {"SDate": '20180831', "EDate": '20180831'})

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 · 2018-09-04T05:29:35Z

REFINITIV

Best Answer

Answer by jirapongse.phuriphanvichai · Sep 04, 2018 at 05:29 AM

Please remove {"SDate": '20180831', "EDate": '20180831'} from the query.

...
market = ek.get_data("LLOY.L", queries, {})

The result is:

result.png (6.6 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.

Data Item returning NaN.

1 Reply

Watch this question

Related Questions