Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
isanchez avatar image
16 ●4 ●9 ●10

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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
icon clock
10 |1500

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

isanchez avatar image isanchez

I forgot add this image

1611011679781.png (45.8 KiB)
Jirapongse avatar image   Jirapongse

@isanchez

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question? If yes please click the 'Accept' text next to the reply.

If you know an answer, please share your answer, and then accept it. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

1 Answer

· Write an Answer
Upvote
Accepted
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

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 512.0 KiB each and 1.0 MiB total.

isanchez avatar 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 avatar image Jirapongse isanchez

@isanchez

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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