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

isanchez

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

chavalit-jintamalit

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.

isanchez

I forgot add this image

isanchez

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

Jirapongse

@isanchez

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