Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by isanchez · Jan 18 at 11:13 PM · eikondataapi

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

People who like this

0 Show 1
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
isanchez · Jan 18 at 11:14 PM 0
Share

I forgot add this image

1611011679781.png (45.8 KiB)

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by chavalit.jintamalit · Jan 18 at 11:57 PM

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)
Comment
isanchez

People who like this

1 Show 2 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
isanchez · Jan 19 at 06:37 PM 0
Share

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

avatar image
REFINITIV
jirapongse.phuriphanvichai ♦♦ isanchez · Jan 27 at 04:31 AM 0
Share

@isanchez

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
8 People are following this question.

Related Questions

Eikon Data API: Error code 500

Offline Installation for Eikon API error

Bug in exception handling in Eikon python package

Price data missing for several RIC's using ek.get_timeseries in python API

Leavers/Joiners on Index constituents.

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges