Data Item returning NaN.

luis22

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'})

Jirapongse

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

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

The result is: