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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
16 2 3 5

the formula must contain contain at least one field or function Eikon API

Hi, we have some fields to retreive data with python, this fields are for balanceSheet, IncomeSheet and CashFlow Data.

p = {

'Period': 'FY0'

, 'reportingState':'Orig'

, 'curn': currency

, 'Scale':'6'

, 'SORTA':'LISeq'

, 'CH':'Fd'

, 'IncludeOldYE' :'No'

, 'ReportType':'Latest'

, 'Edate' : '-10FY'

, 'FRQ':'FY'

, 'transpose':'y'

, 'Sdate' : '0FY'

, 'FXRate' : 'PeriodEnd'

, 'NULL' : 'blank'

}

df, err = ek.get_data(['BAP.LM'], ['TR.F.BalanceSheet.fieldName','TR.F.BalanceSheet.fielddescription', 'TR.F.BalanceSheet.date','TR.F.BalanceSheet'], parameters = p )


We handle the translate for the all fields, so we obtain the name of the field in english to build this json Example:

{

"key": "TR.F.AssetParticipFactorIssue ",t

"lang": {

"es": "Factor de participación de activos: tema específico ",

"en": "Asset Participation Factor - Issue Specific"

}

}


but for the followings fields ge got The formula must contain at least one field or function vía excel.

TR.F.PPEExclROUTangCapLeaseNet

TR.F.PPEExclROUTangCapLeaseGross

TR.F.PPEExclROUTangCapLeaseAccumDepr

TR.F.TotOpLeaseLiab

TR.F.FinOpLeaseLiabTot

TR.F.DebtInclFinOpLeaseLiab

TR.F.InterestEarnLiabAvg


I wondering if there is a way to obtain at least the name of the fields even if the field does not have data.


Thanks

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
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 forgot add this image

1611011679781.png (45.8 KiB)

1 Answer

Upvote
Accepted
18k 21 12 20

Hi @isanchez

I think these fields are invalid fields.

TR.F.PPEExclROUTangCapLeaseNet

TR.F.PPEExclROUTangCapLeaseGross

TR.F.PPEExclROUTangCapLeaseAccumDepr

TR.F.TotOpLeaseLiab

TR.F.FinOpLeaseLiabTot

TR.F.DebtInclFinOpLeaseLiab

TR.F.InterestEarnLiabAvg


I try adding TR.ZXCVB as an invalid field.


Then I add at least a valid field and all the invalid fields are omitted in the result.


ahs1.png (46.3 KiB)
ahs2.png (25.4 KiB)
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.

Hello @chavalit.jintamalit

When you said that maybe the field are invalid, this is invalid for the current ric or is invalid for any ric

Thanks

@isanchez

You can directly contact the Eikon support team via MyRefinitiv to verify the usage and scope of those fields.

Click below to post an Idea Post Idea